Dynamic Script to Generate Backup Script
Use this script to generate BACKUP DATABASE scripts for selective or all databases during Instance or Database migration.
2014-12-31 (first published: 2014-12-10)
1,305 reads
Scripts
Calculate Energy - Most Advanced UOC
This function is used to calculate the actual unit of conversion for energy.
2014-12-30 (first published: 2014-12-11)
726 reads
All OS version info in one function
Always wanted to know the OS details? This function tells you everything (MSSQL 2008R2 and newer version only)
2014-12-29 (first published: 2014-12-06)
1,541 reads
2014-12-25 (first published: 2014-12-04)
1,123 reads
PowerShell Query to remove backup folders against multiple servers
Remove backup folders from multiple servers.
2014-12-23 (first published: 2014-12-09)
622 reads
2014-12-22 (first published: 2014-11-23)
1,234 reads
DB memory/RAM consumption
This script is used to get the memory or RAM consumption for the database(s).
2014-12-19 (first published: 2014-11-20)
2,800 reads
2014-12-12 (first published: 2014-11-19)
1,115 reads
dbWarden - Purge old data
helps you manage dbWarden history.
No warranty given it will do what you expect, so test it !
2014-12-11 (first published: 2014-11-19)
1,009 reads
2014-12-08 (first published: 2014-11-18)
1,378 reads
Blogs
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do...
Microsoft MVP 2026: Ten Years on the Data Platform
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
Forums
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
BIT_COUNT() III
Comments posted to this topic are about the item BIT_COUNT() III
The Mythical Bus Accident
Comments posted to this topic are about the item The Mythical Bus Accident
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