Compare Patch levels across all installed sql instances
This script allows you to compare patch levels across instances.
2021-10-25 (first published: 2021-10-21)
1,211 reads
This script allows you to compare patch levels across instances.
2021-10-25 (first published: 2021-10-21)
1,211 reads
When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.
2018-05-18 (first published: 2015-10-19)
4,830 reads
If you think about it carefully, you’ll realise, that index maintenance is necessary and that it makes sense, and that SQL Server is not doing this task automatically according to the book.
2011-08-18
5,492 reads
Create a data dictionary with two stored procedures using sys objects to view via SSRS (or other reporting tool) report
2010-10-21 (first published: 2010-10-16)
2,235 reads
2008-08-14
3,644 reads
Far too often, people who are not trained database administrators somehow end up responsible for a database. They lack the proper training and knowledge to maintain their database, and problems begin to develop. Here’s a primer for all those involuntary DBAs who need a crash course in database maintenance best practices.
2008-08-13
6,696 reads
The idea was taken from this script: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/
Which did not work in SQL 2005 due to table changes on MSDB
2013-05-08 (first published: 2008-02-12)
5,553 reads
A SELECT statement which includes the alpha description of each job's schedule
2011-11-25 (first published: 2007-11-01)
4,532 reads
This script allows you to check the several availability windows for the current day.
2008-01-12 (first published: 2007-10-29)
1,359 reads
This script allows you to check the several availability windows for the current day.
2008-01-18 (first published: 2007-10-29)
1,068 reads
By Brian Kelley
If a technology is still viable, don’t overlook it. Don’t get caught up chasing...
By Steve Jones
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
Hi, Azure SQL DB doesn't support CLR, if we have an application with CLR...
We have a Setup where replication and AG is configured as below. Servers:Node1,Node2 ==>Node1...
I am trying to build an ETL for an Existing Table. The ETL (SSIS)...
In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?
See possible answers