How To Create SQL Trace To Capture SQL Server Events
Facing an SQL Server performance issue, you need to identify the source of that performance problem...
Configure SQL Jobs in SQL Server using T-SQL
SQL Server Agent is a component used for the database tasks automation. For instance, we need to perform Index maintenance on Production...
Git Branching Naming Convention: Best Practices
Git offers flexible branching strategies, but what does it mean? In simple words, a branching strategy is a set of rules, a convention that...
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...
Introduction to Azure Database Migration Service (ADMS)
Microsoft Azure platform provides an Azure Database Migration Service (ADMS) – a convenient solution for the Azure Cloud-based Databases...
Deploying a Database on Azure SQL
Introduction Azure SQL Database is a Platform as a Service (PaaS) offered by Microsoft Azure....
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 performance issues occurred here and there? I...
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...
