Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.
2011-12-15 (first published: 2007-10-11)
3,598 reads
Given some input parameters, it generates the filegroups, files, partition function and partition scheme sql statements.
2010-05-28 (first published: 2009-04-17)
1,488 reads
Check Orphaned logins ie, not associated with any database on the current instance.
2008-07-16 (first published: 2008-05-20)
1,621 reads
Returns list of active processes and their buffer contents over a specified time.
2008-07-02 (first published: 2008-05-20)
1,476 reads
2008-06-30 (first published: 2008-05-20)
3,057 reads
2008-06-26 (first published: 2008-05-20)
924 reads
2008-06-24 (first published: 2008-05-20)
2,223 reads
This script allows you to check the several availability windows for the current day.
2008-01-18 (first published: 2007-10-29)
1,084 reads
This script allows you to check the several availability windows for the current day.
2008-01-11 (first published: 2007-10-29)
1,384 reads
(SQL 2005) Creates Index Creation statements based on info colected in system view sys.dm_db_missing_index_details, either with included columns or just In(Equality) columns.
2007-12-13 (first published: 2007-10-11)
1,015 reads
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Comments posted to this topic are about the item Another Model, More Data Loss
Comments posted to this topic are about the item Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers