2015-07-31 (first published: 2015-07-12)
1,464 reads
Scripts
List Job Dependencies
A Stored Procedure that lists all Jobs that target a database and the job dependencies
2015-07-29 (first published: 2015-07-02)
2,321 reads
Function to convert UserAccountControl number to details text
Function that converts AD UserAccountControl number to details text
2015-07-27 (first published: 2013-05-14)
2,821 reads
DB Integrity & Backup Report
This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.
2015-07-23 (first published: 2015-06-23)
1,342 reads
Setup Alerts for SQL Replication
If you want to monitor few specific alerts for SQL Replication (Merge and Transnational), you can may consider adding these 14 alerts.
2015-07-21 (first published: 2015-06-16)
1,509 reads
Monitor SQL Server and Service
To monitor SQL service and the host server is up and running, if down send e-mail to DBA
2015-07-16 (first published: 2015-06-15)
2,137 reads
Recent Restore History
This script simply returns the most recent restore information about databases for a server.
Returns the destination database name, the device used to perform the restore and the restore date.
2015-07-15 (first published: 2015-06-10)
769 reads
List schemas in a database
This is an expansion of the sys.schemas table.
User schemas are sorted to the top, schema type is decoded, schema authorization is included.
2015-07-14 (first published: 2015-06-10)
1,874 reads
2015-07-10 (first published: 2015-06-11)
1,016 reads
Delete Backup Files From Default Backup Location
IF you have need to schedule job to cleanup backup files older than N days, you can use my written script.
2015-07-02 (first published: 2015-06-04)
711 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
Finding Trailing Spaces
Comments posted to this topic are about the item Finding Trailing Spaces
Question of the Day
Finding Trailing Spaces
I have some data in a SQL Server 2025 database. It looks like this for the dbo.Customer table:
CustomerID CustomerName PreferredName 1 Steve Steve 2 Andy Andy 3 Brian Brian 4 Allan Allan 5 Devin Devin 6 Steve Steve 7 Sally SallyI want to detect which names have a single trailing space. The CustomerName is a varchar() and the PreferredName is a CHAR(). Does this query detect the problem rows?
SELECT
CustomerID,
CustomerName,
PreferredName
FROM Customer
WHERE CustomerName <> RTRIM(CustomerName)
OR PreferredName <> RTRIM(PreferredName); See possible answers