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 Server Storage Information in Server
As popular as the cloud services are nowadays, there’s still a good chunk of on-premises deployments of SQL Server that still require our...
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...
WhoIsActive Runner
Nowadays, within the SQL Server DBA community, it is extremely likely that we use, or at the very least have heard of, the famous stored...
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...
The Stored Procedure to Get the Instance Settings
SQL Server instances house databases containing the data for the backend stack of a business model,...
A PowerShell Tool to Get the Status of SQL Agent Jobs
From a certain point in my career, I started to play around with PowerShell. But I never imagined that it would become such an essential...
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 the most essential things for data...
MS SQL Server on Linux vs Windows Performance Test to Spot the Difference
Since the release of SQL Server 2017 for Linux, Microsoft has pretty much changed the entire game....