Tag: stored procedure

Stored Procedure to Get Server Storage Information in Server

Database administation, Memory Optimization

As popular as the cloud services are nowadays, there’s still a good chunk of on-premises...
Read More

Stored Procedure to Get Database Tables Information

Database development, Stored Procedures

As SQL Server DBAs, we always take care of one of the most important things for the business, the data. In some cases, applications can get...
Read More

Stored Procedure to Get Indexes Status in All Databases

Database development, Stored Procedures

As SQL Server DBAs, we’ve heard that index structures can dramatically improve the performance of any given query (or set of queries)....
Read More

How to Use the sp_whoisactive PowerShell Script for Real-Time SQL Server Monitoring

Database development, Stored Procedures

Nowadays, within the SQL Server DBA community, it is extremely likely that we use, or at the very...
Read More

Stored Procedure to Delete Duplicate Records in SQL Table

Database development, Stored Procedures, Tables

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...
Read More

10 SP_EXECUTESQL Gotchas to Avoid for Better Dynamic SQL

SQL Server • One Comment

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,...
Read More

How to Find SQL Server Instance Name and More with Stored Procedures

Database development, Stored Procedures

SQL Server instances serve as the backbone of a business model, housing databases that contain...
Read More

A Dedicated Stored Procedure to Get the Latest Database Backups Status

Database development, Stored Procedures

Any SQL Server DBA (of course, this applies to all platforms) will agree that database backups are the most essential things for data...
Read More

3 Easy and Secure Ways to Make Users Run SSIS Packages

Business intelligence, SSIS

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...
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...
Read More
Close