Stored Procedure to Get Logins and Server Roles Inventory
Security is for sure one of the most important areas that we, as professional DBAs, must cover....
Stored Procedure to Get Database Tables Information
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...
Stored Procedure to Get Indexes Status in All Databases
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...
How to Get SQL Server Statistics Information Using System Statistical Functions
Often, we need to gather system statistics regarding running SQL Server Instances, such as the number of total connections attempted to SQL...
SQL Server RAISERROR Statement with Simple Examples
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...
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...
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 vital data for backend operations or...
Execute Dynamic Query in SQL Server
Dynamic SQL is a statement constructed and executed at runtime, usually containing dynamically generated SQL string parts, input...
A Dedicated Stored Procedure to Get the Latest Database Backups Status
Any SQL Server DBA (of course, this applies to all platforms) will agree that database backups are...
