To check the Backup Status for an SQL Instance
This Script will fetch database backup information from msdb and give the idea about full, diffrential and log backup.
2014-01-10 (first published: 2014-01-04)
1,430 reads
Scripts
Total Space Used for all databases per disk
Tells you how much the databases are using the space on disk taking in account the free space at the end of the database.
2014-01-08 (first published: 2012-05-04)
4,017 reads
Generate MERGE statements with Table data
A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.
2014-01-07 (first published: 2012-03-14)
8,064 reads
View Active Session SQL
This script can be used to view current SQL statements being executed for all or any one SPID.
2014-01-06 (first published: 2012-01-26)
4,340 reads
Advanced Display Table and Column Info
A view that presents Schema, Table, Fields and Data Types, Defaults and First 10 triggers for the table.
2014-01-03 (first published: 2013-12-10)
1,768 reads
List all Usernames, Roles for all the databases.
Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).
2013-12-30 (first published: 2008-07-24)
45,399 reads
Get all user def table info
Get space for all user defined table information like size and row counts.
2013-12-27 (first published: 2007-08-29)
7,740 reads
Table Information View -- No Cursors!
Row counts and storage space information for all tables in the database. (SQL Server 2005).
2013-12-26 (first published: 2008-03-16)
17,073 reads
Generate C# class code for table
For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.
2013-12-24 (first published: 2007-11-06)
12,587 reads
2013-12-19 (first published: 2007-08-27)
20,931 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Alamat BCA KCU BINTARO Telp:0821°8200°233
Telp/Wa 628218200233 Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7, Pd. Jaya, Kec....
Alamat BCA KCP Labuan Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Raya Labuan - Pandeglang No.01, Labuan, Kec. Labuan, Kabupaten Pandeglang, Banten...
Alamat BCA KCP Cilegon II Telp:0821°7555°651
Telp/Wa 628217555651 Ruko Cilegon City Square, Jl. Pondok Cilegon Indah No.1 Blok A No....
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers