Stored Procedures

Renaming Indexes with sp_rename Procedure

Database development, Indexes, Stored Procedures

Not so long ago, I was working on a project where we needed to change the data type of a table. The...
Read More

How to Rename a Table Name in SQL Server

Database development, SSMS, Stored Procedures, Tables

One of the most critical database administrator’s duties is managing database objects. For instance, the application logic changes,...
Read More

Configure SQL Jobs in SQL Server using T-SQL

Code Management, Database development, Stored Procedures, T-SQL

SQL Server Agent is a component used for the database tasks automation. For instance, we need to perform Index maintenance on Production...
Read More

How to Write Stored Procedures for Professional SSRS Reports

Business intelligence, Database development, SSRS, Stored Procedures

In this article, we’ll talk about professional SQL Server Reporting Services reports, how to...
Read More

Parameter Sniffing Primer

Database development, Stored Procedures

Introduction Developers are often told to use stored procedures in order to avoid the so-called ad hoc queries which can result in...
Read More

Simplifying Unit Testing Main Stored Procedure Which Also Calls a Utility Procedure

Database development, Stored Procedures, Testing

This article provides a walkthrough of database unit testing a stored procedure which contains a utility procedure within it. In this...
Read More

Passing Data table as Parameter to Stored Procedures

Database administation, Stored Procedures, Work with data

Real-world database applications need to make multiple requests from the front end to the database...
Read More

SQL Server – Dissect the Internals of sp_spaceused

Database development, Stored Procedures

This article is an effort to dissect the output of the sp_spaceused stored procedure. Introduction Understanding the database usage...
Read More