2012-06-20 (first published: 2012-05-30)
8,752 reads
Scripts
Script to calculate Precision & Scale of a Decimal Value
A script to help you find the Precision & Scale parts of a decimal value.
2012-06-19 (first published: 2012-06-04)
4,963 reads
Generate insert statements with column names for any or all tables
Generate a script of insert statements with column names for any table including those with identity columns.
2012-06-15 (first published: 2012-05-22)
3,143 reads
Random DEFAULT string for a column using CASE and NEWID
Sometimes you just need to populate a CHAR/VARCHAR column for testing with a random selection of string literals at table CREATE time. Here is a quick and easy script.
2012-06-14 (first published: 2008-01-16)
1,177 reads
A CONCAT Function For The Rest Of Us
SQL Server 2012 introduces a new string concatenation function. This can be recreated in earlier versions of SQL Server.
2012-06-06 (first published: 2012-05-16)
2,171 reads
Central Management Server Daily Script
These are scripts I run each morning on my registered CMS servers to check immediate health.
2012-06-04 (first published: 2012-05-09)
2,889 reads
Variable Grouping Using a Case Statement
The code below uses a CASE STATEMENT to group sales data based on date,week,month and quarter. It should be executed in AdventureWorks 2005 or 2008.
2012-05-30 (first published: 2012-05-10)
2,042 reads
All SQL Version info in one function
This function returns all the necessary version information in a table.
2012-05-28 (first published: 2012-03-21)
3,165 reads
Defrag All Indexes On a Database
Script to list out all fragmented indexes for a given database, with options to only view them, reorganize them, or rebuild them in one fell swoop.
2012-05-25 (first published: 2012-05-15)
3,254 reads
Last Backup Taken, or Not
Displays the last Full, Diff, and Log backup taken. If no backup has been taken that is displayed as well.
2012-05-24 (first published: 2012-05-15)
1,492 reads
Blogs
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Session Materials for Techorama & DataGrillen 2026
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers