DevOps Solutions for Database Development Automation
What is DevOps? Database DevOps is a philosophy that comprises the following concepts: automating...
How to Capture and Analyze SQL Server Events
When working as a SQL Server database administrator, you should have the skills to dive deeply into the ocean of the SQL Server Engine and...
Collation in SQL Server
Introduction You must have already heard the term “Collation” in SQL Server. Collation is a configuration that determines how character...
Using Transaction ROLLBACK in SQL Server
Introduction Very recently, a colleague of mine came to me in desperation owning up that he had...
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 much is actually spent on acceptance...
Dynamic Data Masking in SQL Server for beginners
The article introduces the basics of dynamic data masking (DDM) in SQL Server along with its...
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 aggregate functions as sum, count and average...
Ranking Functions in SQL Server
Suppose you are designing an SQL Server database application for a company’s CEO and you have to...