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...
Using Working Folder to Source Control Database
This article is a walkthrough of how to use the working folder option of source control for managing SQL Server databases. In this article,...
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...
Passing Data table as Parameter to Stored Procedures
Real-world database applications need to make multiple requests from the front end to the database...
Moving Existing Table From Primary Filegroup to Different Filegroup
In this article, I am going to explain how to move a table from the Primary filegroup to the Secondary filegroup. First, let’s understand...
Main Usage of sys.dm_os_wait_stats
As you know, the main responsibility of the database administrator lies in the monitoring of the SQL Server performance and intervening in...
Similarities and Differences among RANK, DENSE_RANK and ROW_NUMBER Functions
The RANK, DENSE_RANK and ROW_NUMBER functions are used to retrieve an increasing integer value....
Understanding Difference between EXCEPT and NOT IN Operators
Both EXCEPT and NOT IN operators are used to filter records from a table based on a specific criterion. In this article, we will look at...
Structured Query Language – Importance of learning SQL
Computer programming language is a set of detailed instructions for computers or machines for performing specific actions. Through a...
Exporting Oracle Table to Excel Worksheet
In this article, I will explain how we can divide and export data of an Oracle database table into...
