Function to find non-printable characters
The function is used to find non-printable ASCII characters in an input string.
2009-05-21 (first published: 2009-04-24)
2,909 reads
Scripts
2009-05-14 (first published: 2009-04-08)
1,992 reads
Last Sunday
Needed to return the week ending date as Sunday for daily transactions multiple times, for several aggregate reports. This function returns the last Sunday for past or future weeks.
2009-05-11 (first published: 2009-04-15)
651 reads
Cluster Information
This script will display information about the instance(s) on your cluster. Name of nodes, active node and drive letters of the resources
2009-05-08 (first published: 2009-04-15)
1,413 reads
2009-05-07 (first published: 2009-03-27)
1,609 reads
Convert GMT/UTC to Local datetime
International Applications require timezone handling for different users Here is how to do this with SQL.
2009-05-06
4,120 reads
Easily calculate the size of your tables
This quick and dirty sql will tell you the number of rows in your tables, the size in MB of yout data, and the total size (including indexes)
2009-05-05 (first published: 2008-10-04)
1,669 reads
The Ultimate Prospective-Index Column(s) Selectivity Analyzer
Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.
2009-05-03 (first published: 2008-08-01)
2,135 reads
What SQL JOb's are running on 2005 Server
This script returns the information of all SQL Jobs that are running on the server with the latest status.
2009-05-01 (first published: 2009-04-08)
1,626 reads
Check if a sql server agent job ran
Checks if a sql server job ran successfully in the last xx minutes.
2009-04-29 (first published: 2009-04-02)
1,445 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers