SQL Server AlwaysOn Availability Groups: Installation and configuration, Part 1
In this article, I will explain the process of installing pre-requisites to deploy the SQL Server...
Using Alerts and Operators in SQL Server
Introduction With all the advancements in SQL Server and data, it feels great that such native SQL tools as Alerts and Operators are still...
Implementing Full-Text Search in SQL Server 2016 for Advanced Users
This article tells about advanced methods of Full-Text Search usage for data professionals. It enables better search experience in their...
Implementing Full-Text Search in SQL Server 2016 for beginners
This article talks about the full-text search and its implementation for the beginners to get...
Dynamic Data Masking in SQL Server for Advanced Users
This article gives a high-level understanding of dynamic data masking in SQL Server along with its use cases, best practices and security...
Move System Databases in the SQL Server Failover Cluster
Recently, I was assigned to a project – our customer purchased a new SAN, and they wanted us to replace the old one with a new SAN....
Collation in SQL Server
Introduction You must have already heard the term “Collation” in SQL Server. Collation is a...
Using Transaction ROLLBACK in SQL Server
Introduction Very recently, a colleague of mine came to me in desperation owning up that he had issued an update statement without a WHERE...
SQL Server High availability: Add new disk to an existing failover cluster instance
In my previous article, I have explained the step-by-step process of installing a node in existing SQL Server Failover Cluster Instance....
Automated testing of the desktop application: expediency and frameworks overview
Introduction You have certainly heard about regression and acceptance testing. But do you know how...
