Configure Database Mirroring in SQL Server
Database mirroring is a SQL Server high availability solution provided by Microsoft, with the...
Deploying the first SQL to Azure Migration project with Azure Database Migration Service
Azure Database Migration Service (ADMS) supports Schema and Data migration from different database technologies to the Azure platform. This...
Deploying a Database on Azure SQL
Introduction Azure SQL Database is a Platform as a Service (PaaS) offered by Microsoft Azure. Hence, you need the Azure subscription to use...
3 Nasty I/O Statistics That Lag SQL Query Performance
“But it ran fine on our development server!” How many times did I hear it when SQL query...
How to use Stopwords and Stoplist to improve SQL Server Full-Text Search (FTS)
The current article is about Stopwords and Stoplist usage. The aim is to make Full-Text Search more efficient in terms of storage and...
10 Tips & Tricks To Work With SQL Server Management Studio
SSMS provides access for managing and solving queries in SQL. However, besides its primary and most demanded options, it includes lots of...
Deploying a Certificate for Encrypted Connection SQL Server
Introduction Last year we got a requirement to ensure encrypted connections to our SQL Server...
How to Configure Database Mail in SQL Server
INTRODUCTION Notifications are usual in most modern systems. SQL Server implemented means of sending notifications by email early with the...
How to Make Sense of SQL Server Geography Data Type
SQL Server Geography data type is unlike other types simply because you don’t use it often. It’s not...
How to Make Use of SQL Server Graph Database Features
Would SQL Server graph database features fit your next project? While you may not know the...