2015-09-30 (first published: 2015-09-17)
1,776 reads
Scripts
Get Server version Info
Yet another Script To get Sql server version Info. Run From Central Management server to get all your environment servers
2015-09-29 (first published: 2015-09-10)
1,738 reads
2015-09-28 (first published: 2015-09-10)
1,179 reads
Show solving arithmetic expression step by step
A script to show how to solve arithmetic expressions step-by-step, for my 9-year old daughter.
2015-09-25 (first published: 2015-09-09)
1,190 reads
Document the output of all the SPs in HTML fashion
A script to document the output columns of all the SPs in a given database, with a HTML formatted document
2015-09-24 (first published: 2015-09-08)
1,944 reads
Open transactions on a database
This script will show you all open transactions from any query windows.
2015-09-23 (first published: 2013-01-14)
3,870 reads
2015-09-22 (first published: 2012-10-01)
4,789 reads
SQL Server CPU Usage History Histogram
Returns a summary of CPU usage by SQL Server over the last 4 hours (default).
Using the sample values collected in the dm_os_ring_buffers dmv, this query will show CPU usage by the SQL Server process for the last for hours even if you have no other benchmarking activities in place on your server yet.
2015-09-18 (first published: 2014-05-14)
5,577 reads
SQL Job Timeline (Graphical)
This script generates a graphical timeline of all SQL jobs with a variable zoom level
2015-09-17 (first published: 2013-01-14)
6,697 reads
Reindex Procedure with a Twist (or two) the SQL
A 2012 update to "Reindex Procedure with a Twist (or two)":
2015-09-15 (first published: 2014-05-16)
4,409 reads
Blogs
AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared
Both SQL Server and PostgreSQL are moving fast into AI territory — and if...
Monday Monitor Tips: AI Alert Analysis
By Steve Jones
We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
Forums
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Converting Money
Comments posted to this topic are about the item Converting Money
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers