In this article I will share my experience about configuring SQL Server 2016 Express on LAN for SQL connection using my C# application’s connection string

Create one Windows account and give full access to that account to read OLTP database or add an account on which SSAS Service is running and give full permission to that account for OLTP Database.

When we are working with any programming language, we create user defined types as per our requirement. It is a better idea to have this feature in the SQL server.

Many of systems we use will generate plenty of billcodes everyday , and most of them include date(datetime) or a prefix to show their signification , such as specifying a billcode belongs to a spec...

This is part two of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see the sample queries on encrypted columns and Limitations of Alwa...

Lets say, we have a requirement to encrypt the PII data for an existing ASP.NET web application. Data needs to be encrypted at rest as well as on transit. Considering the existing PROD data, we nee...

In this article, we will show how to convert rows to columns using Dynamic Pivot in SQL Server.

In this article, we will explain how to take log backups frequently by creating a Log Backup Maintenance Plan in SQL Server 2016

In this article we are going to learn how to get database backup using stored procedure in SQL server in C# Winform applications.

Database Object refers to Table, Stored procedure, View, Function etc.; in other words, all the elements that are created for data storage and manipulation.

It requires one separator argument and a minimum of two arguments otherwise it raises an error. All the arguments are implicitly converted to string types and then they are concatenated.

Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery m...

There are many new features introduced with SQL server 2017 and also there is some performance improvement in existing features. Using the following links, we can learn more details about the new f...

This article illustrates the purpose of SSIS with Web Service.

The requirement is to extract the data from Twitter and load extracted data into SQL Database. For this demonstration I am going to read the Indian Film actor Kamal Haasan's tweets and load th...

In this article, we’re going to learn about how to we can manage our database scripts using Visual Studio’s SQL server database project.

For Business Intelligence features such as Integration Services, Reporting Services, and Analysis Services, you may have to install the latest service packs, cumulative updates, and hotfixes on the...

This is an open source project I named online shopping site.This is an online shopping cart application written in ASP.NET (4.0) and C# where a user can browse, add items to the shopping cart and p...

This article describes how to find the 3rd or Nth highest salary in a table. To find the Nth highest salary, we need to create a table in the database containing some data and to do this use the fo...

Incorrect cardinality and Cost Estimation may lead query optimizer to choose inefficient plans which can have a negative impact on the database performance. In this article we are going to look dee...