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...
Dynamic Data Masking in SQL Server for beginners
The article introduces the basics of dynamic data masking (DDM) in SQL Server along with its overview supported by a simple example...
SQL Always On Availability Groups: Computer Objects
SQL Server Always On Availability Groups is Microsoft’s latest technology for addressing the High Availability and Disaster Recovery...
Analytic Functions in SQL Server
Aggregate and Analytic functions in SQL Server operate on a set of rows. However, unlike such...
Ranking Functions in SQL Server
Suppose you are designing an SQL Server database application for a company’s CEO and you have to display the fifth most highly paid...
Automating the Tabular Model Processing of Analysis Services (SSAS) Databases in SQL Server
This article talks about automating the processing of the Analysis Services database in SQL Server. Automation is one of the most important...
Installing SQL Server Failover Cluster Instance – Part 1
In this article, I am going to explain the process of installing SQL Server on failover cluster...
Automate Database Test Restore in SQL Server
This article talks about automating the database restoration process which is often done manually by the DBA or the infrastructure team...
T-SQL Regular Expressions: SUBSTRING, PATINDEX and CHARINDEX
In my previous article about T-SQL regular expressions, I have explained the LIKE operator, its usage and provided several examples with...
Basics of SQL Server Task Automation
This is an introductory article about automation in SQL server primarily focused on the basic...
