Show Job Run Snapshot
Show all job history between two dates. This is much easier than trying to navigate the job history log file viewer.
2012-10-19 (first published: 2012-09-17)
1,131 reads
Scripts
Read large C2 Audit Mode trace files
Here's a set of scripts that allow you to save pertinent information from SQL Server Profiler trace files.
2012-10-18 (first published: 2012-09-20)
614 reads
Port check for SQL Server connectivity
Generates a script to check connectivity between a list of SQL Server instances on a specified port.
2012-10-17 (first published: 2012-08-09)
2,104 reads
2012-10-16 (first published: 2012-09-21)
2,558 reads
2012-10-12 (first published: 2012-09-10)
1,798 reads
Job Summary
This script lists the name, running and success status, last executed/currently executing step name, Average and Last duration, next run time and other related information about Jobs.
2012-10-10 (first published: 2011-11-02)
2,113 reads
Tables, Queues, and Indices as a Percent of DB Size
Two views that give you a variety of stats, sortable as a percent of DB size, for tables, indiceses, XML indices, and Service Broker Queues.
2012-10-09 (first published: 2008-06-16)
3,077 reads
Get a range of numbers
If you need to get a range sequence of numbers this script can help you to acomplish it. For example : the sequency of numbers between -5 and 5 or 1 and 200, etc..
2012-10-05 (first published: 2012-04-23)
1,498 reads
2012-10-04 (first published: 2012-04-10)
2,031 reads
Find Primary Column of all tables in database
This code helps in finding Primary Keys for all tables in a database.
2012-10-02 (first published: 2012-09-04)
1,440 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 KCP Klender Telp:083831618008
WhatsApp:0838-3161-8008 Jl. I Gusti Ngurah Rai No.8 A-B, RT.8/RW.6, Wil, Kec. Duren Sawit, Kota...
Alamat Kontak Bank BCA KCP Pahlawan Telp:08218154392
WA CS:08218154392 Jl. Khp Hasan Mustopa No.108, Padasuka, Kec. Cibeunying Kidul, Kota Bandung, Jawa...
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers