2008-06-18 (first published: 2008-05-15)
3,210 reads
Scripts
HowTo prevent BOL getting Online help
Books Online will try to connect to the net and it may get stuck if there is no internet connection.
2008-06-16 (first published: 2008-05-07)
436 reads
UDF to return a multi column table of values from an input string
This UDF returns a multi column table of values from an input string of comma separated values
2008-06-11 (first published: 2008-04-29)
1,815 reads
Powershell/SMO: Unload table schema, dri, perms & data.
PSH script to unload table schema, dri, permissions and data to file(s).
2008-06-10 (first published: 2008-05-07)
1,130 reads
2008-06-08
1,892 reads
Difference between two dates in weeks
Returns difference between two dates in weeks, takes into account @@DATEFIRST setting
2008-05-28 (first published: 2008-04-11)
1,293 reads
2008-05-27 (first published: 2008-04-10)
1,748 reads
2008-05-23 (first published: 2008-04-10)
2,164 reads
Backup all DBs of a SQL-Server Instance
Backup all DBs of a SQL-Server Instance depending on Environment Variable "DBBackupPath". The script also distinguishes between Instances
2008-05-22 (first published: 2008-03-28)
2,415 reads
2008-05-19 (first published: 2008-03-20)
940 reads
Blogs
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Forums
The SQL Server 2016 Plan
Comments posted to this topic are about the item The SQL Server 2016 Plan
whats that ssis analyzer product that documents lineage
hi, a few years ago was at a very large company that bought a...
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers