2012-04-25 (first published: 2012-04-02)
2,283 reads
Scripts
2012-04-24 (first published: 2012-03-30)
1,871 reads
Operators With Jobs and Notifications
This script will list the operators that have jobs
that are configured to notify them with alerts.
2012-04-23 (first published: 2012-03-29)
1,017 reads
Find Database Recovery Mode
The scripts provided below will show you the "Recovery Mode (Model)" for any given database
2012-04-19 (first published: 2008-03-18)
2,023 reads
Find for SQL Objects, Entities or Text
Procedure to find any object such as table/stored procedure by its name, or find for ant text inside stored procedures, functions.
2012-04-18 (first published: 2008-05-28)
3,015 reads
2012-04-17 (first published: 2008-02-15)
7,494 reads
Check owners, collations and backups
A script to check the owners, collations and backups on the server.
2012-04-16 (first published: 2007-10-19)
2,648 reads
2012-04-13 (first published: 2007-10-19)
3,415 reads
Restore Server/Database users/roles
Restore server/database users and roles from another server when we are restoring databases to another server.
2012-04-12 (first published: 2007-10-23)
3,133 reads
Auto compression all indexs on all online db
Auto compression of index, if index includes > 1 million rows.
2012-04-11 (first published: 2012-03-19)
952 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers