How to Automate the Process of SQL Server Database Schema Synchronization
The goal Keeping two databases in sync is a task we often encounter when working on SQL database...
Tutorial on SQL (DDL, DML) on the example of MS SQL Server dialect
Introduction This tutorial includes information about SQL (DDL, DML) that I have gathered during my professional life. This is the minimum...
SQL Data Discovery and Classification
With the recent data protection laws and the implementation of GDPR last year, it is imperative for us to know the type of data our...
Using Trace Flag 3226 to Suppress Log Backup Logging
Introduction Every backup operation in SQL Server is written to the SQL Server Error log. This...
Column-level and row-level tracking in merge replication
In this article, let us review row-level and column-level tracking options in merge replication and how these are used in detecting...
Overview of DBCC SHRINKFILE Command
Running DBCC Shrink commands is quite a controversial issue across the SQL Server community. In this article, we will review details about...
How to Automate SQL Database Maintenance Tasks using SQLCMD
This article is about automating SQL database maintenance tasks through SQLCMD utility which lets...
How to Export Data to Flat File with BCP Utility and Import data with Bulk Insert
The BCP (Bulk Copy Program) utility in SQL Server allows database administrators to import data into a table and export data from a table...
Overview of DBCC CheckDB Function
Introduction Regular database maintenance is an important part of a Database Administrator’s job which helps to ensure that critically...
Replacing SQL Cursors with Alternatives to Avoid Performance Issues
In this article, we’ll look at some alternatives to using SQL cursors which can help...
