Running SQL Database Maintenance Tasks Using SQLCMD
This article is about developing an advanced understanding of the Sqlcmd utility which lets you run...
Basics of Running T-SQL Statements from Command Line using SQLCMD
This article is about developing a basic understanding of sqlcmd utility to run T-SQL commands directly from the command prompt without the...
Creating and Deploying Multiple Versions of Database through Schema Snapshots
Overview This article talks about using database schema snapshots to maintain different versions of a database to be deployed to different...
Multiple Ways to Delete Duplicates from SQL Tables
Overview This article discusses two different approaches available to remove duplicate rows from...
Using DATEADD, DATEDIFF and DATEPART T-SQL Functions in Simple Terms
This article focuses on developing a basic understanding of how to use one of the most common Transact-SQL date functions: DATEADD,...
Tracking Database Changes Using Working Folder Source Control
This article talks about a new method to version control a database using a working folder so that historical changes made to the database...
Using Working Folder to Source Control Database
This article is a walkthrough of how to use the working folder option of source control for...
Simplifying Unit Testing Main Stored Procedure Which Also Calls a Utility Procedure
This article provides a walkthrough of database unit testing a stored procedure which contains a utility procedure within it. In this...
Jump to Start Test-Driven Database Development (TDDD)
As a rule, we start to develop database solutions by creating database objects, such as tables, views, stored procedures, etc., based on...
Art of Isolating Dependencies and Data in Database Unit Testing
All the database developers more or less write database unit tests that not only help in detecting...