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,306 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)
728 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,801 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,379 reads
Blogs
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Forums
Alamat Kantor BCA KCU Batam Telp:08218200203
Hub Via Wa:628218200203 Alamat: Jl. Dokter Sutomo No.50-50A, Ps. Jambi, Kec. Ps. Jambi, Kota...
Alamat Kantor BCA KCU Kisaran Telp:08218200203
Hub Via Wa:628218200203 Alamat: Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat,...
Alamat BCA KCU Pematang Siantar Tlp:08218200203
Hub Via Wa:628218200203 Alamat: Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar,...
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers