Figure out recovery mode for each database
It is anoying that someone created a new database and left its recovery mode in simple and it caused your backup jobs to fail.
2015-11-23 (first published: 2015-10-26)
694 reads
Scripts
Temporary exclusive database access
This simple script disconnects any other session that is connected to the specified database by temporarily switching the database to single user.
2015-11-20 (first published: 2015-10-25)
959 reads
Disk Space Alerts Based on Threshold Value
This script will drop a mail for sql drives if space on drives is below set threshold value. Log drives with 15 and data files drives with value of 10% as threshold value of free space.
2015-11-19 (first published: 2015-10-27)
2,729 reads
2015-11-18 (first published: 2015-10-29)
1,073 reads
List Expressions and Values of Variables in SSIS package
Variables can be direct text or Expressions. It's handy to be able to get both at one pass. This little script does that.
2015-11-17 (first published: 2015-10-18)
2,192 reads
2015-11-13 (first published: 2015-10-19)
2,027 reads
Data Compression
This script is used to compress tables and indexes. It is designed for page compression on all. Just a little ditty to help with our EDW storage and processing.
2015-11-11 (first published: 2015-10-09)
1,341 reads
First day and last day of a week
This scripts calculates the first day and the last day of a given week
2015-11-10 (first published: 2015-10-12)
1,183 reads
Get FirstDate and LastDate of Every month from two Dates
Get FirstDate and LastDate of Every month from two Dates.
Like IF we have @date1='05/02/2015' and @date2= '11/25/2015' then we will get list of first date and last date from month 5 to 11.
SELECT ID,FirstDate,LastDate,Month,Year FROM [GetFLDatelist](@date1,@date2)
2015-11-09 (first published: 2015-10-09)
1,291 reads
Who are connecting to database and disconnect ...
When you want gain exclusive access to database in order to restore database
2015-11-06 (first published: 2015-10-14)
1,961 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers