Just for fun
Do you need to take your mind off of the SQL mess you are dealing with? Try my funny words generator.
2010-09-03 (first published: 2010-08-27)
2,672 reads
Scripts
Change the collation of Columns
This script changes the collation of columns to default database collation in all the tables
2010-09-02 (first published: 2010-09-01)
2,203 reads
Windows Group Membership Checker
A script to reveal which logins have access to your sql server via windows groups.
2010-09-01 (first published: 2010-08-26)
2,447 reads
Make string columns unicode compliant
Generates scripts to make text, ntext, varchar and char columns nvarchar/nchar
2010-08-30 (first published: 2010-08-26)
1,340 reads
2010-08-27 (first published: 2010-08-25)
3,703 reads
Get daylight savings time
After scouring the site, and googling until my fingers bled, I finally put together a function that will return the dates when daylight savings time began/ended since at least 1990.
2010-08-26 (first published: 2010-08-19)
2,016 reads
Object Explore
Summary information and metrics for any column in a given Table/View. Metrics include: number of records, distinct records, nulls, min, max, std, quartiles, kurtosis, skew, etc.
2010-08-24
64 reads
Using GO Repeat To Fill Tally Table
Fill a small Tally table with a 1 column primary key using GO keyword to repeat an insert.
2010-08-18 (first published: 2010-08-16)
1,564 reads
2010-08-16 (first published: 2010-03-05)
3,879 reads
Enterprise wide Backup Audit
Enterprise wide Backup Audit that produces backup information in a csv format.
2010-08-06 (first published: 2009-11-10)
1,844 reads
Blogs
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
What Does It Mean to Make Data AI-Ready?
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
Forums
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Practical Reporting Queries with CROSS APPLY (Part 3)
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Your Favorite Quotes
Comments posted to this topic are about the item Your Favorite Quotes
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers