Get Your SQL Server Database Size with Ease: Stored Procedures in Action
As popular as the cloud services are nowadays, there’s still a good chunk of on-premises...
How to Get Tables Information in SQL Server via Stored Procedure
As a database administrator, developer, or data analyst, understanding the structure and details of your SQL Server database tables is...
How to Show List of Indexes in SQL Server using Stored Procedure
As SQL Server DBAs, we’ve heard that index structures can dramatically improve the performance of any given query (or set of queries)....
How to Use the sp_whoisactive PowerShell Script for Real-Time SQL Server Monitoring
Nowadays, within the SQL Server DBA community, it is extremely likely that we use, or at the very...
Stored Procedure to Delete Duplicate Records in SQL Table
Sometimes during our run as DBAs, we come up across at least one table that is loaded with duplicate records. Even if the table has a...
10 SP_EXECUTESQL Gotchas to Avoid for Better Dynamic SQL
Do you know how powerful a tool like dynamic SQL can be? Use it the wrong way, and you can allow someone to take over your database. Plus,...
How to Find SQL Server Instance Name and More with Stored Procedures
SQL Server instances serve as the backbone of a business model, housing databases that contain...
How to Get Backup Status in SQL Server using Stored Procedure
Any SQL Server DBA (of course, this applies to all platforms) will agree that database backups are the most essential things for data...
3 Easy and Secure Ways to Make Users Run SSIS Packages
Have you ever come across a situation where you needed to make users run SSIS packages? This happens when the user is not comfortable with...
SQL Server – Dissect the Internals of sp_spaceused
This article is an effort to dissect the output of the sp_spaceused stored procedure. Introduction...
