Stored Procedures

Stored Procedure to Get Logins and Server Roles Inventory

Database development, Stored Procedures

Security is for sure one of the most important areas that we, as professional DBAs, must cover....
Read More

How to Get Tables Information in SQL Server via Stored Procedure

Database development, Stored Procedures

As a database administrator, developer, or data analyst, understanding the structure and details of your SQL Server database tables is...
Read More

How to Show List of Indexes in SQL Server using Stored Procedure

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

How to Get SQL Server Statistics Information Using System Statistical Functions

Database administration, Database development, Database Optimization & Structure, Stored Procedures

Often, we need to gather system statistics regarding running SQL Server Instances, such as the number of total connections attempted to SQL...
Read More

SQL Server RAISERROR Statement with Simple Examples

Database administration, Database development, Stored Procedures, Troubleshooting Issues

The SQL RAISERROR statement is used to send a custom message to the client application. It also can be used to debug the application and...
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...
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 vital data for backend operations or...
Read More

Execute Dynamic Query in SQL Server

Database development, Statements, Stored Procedures

Dynamic SQL is a statement constructed and executed at runtime, usually containing dynamically generated SQL string parts, input...
Read More

How to Get Backup Status in SQL Server using Stored Procedure

Database development, Stored Procedures

Any SQL Server DBA (of course, this applies to all platforms) will agree that database backups are...
Read More
Close