View connection and Locking Information
This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address
2010-05-17 (first published: 2009-06-23)
2,481 reads
sql frenzy
Estimating the table size...
This is an effort to program the "Estimating the Table size" section given in BOL.
2009-07-06 (first published: 2009-06-19)
1,740 reads
2008-11-25 (first published: 2008-10-20)
1,305 reads
Blogs
Using SQL Alerts to Spot Suspicious Activity in SQL
SQL doesn’t really give us too many tools out of the box to allow...
How to Change the Browser Used by SSMS for AAD Auth
Did you know that you can change the browser used by SQL Server Management...
Typing with Your Tongue Part 2: Voice Access
By DataOnWheels
A few months ago, I wrote a post on how I use voice technology...
Forums
Error: 18456, Severity: 14, State: 149, no matter what I try
Hello experts, I'm seeing a strange issue. A user reported that they could not...
Production Rollback
Hi, is it possible to restore an SQL Server DB to an earlier snapshot...
Azure SQL database AAD user management
I have an Azure SQL DB where I have set up the Azure active...
Ask SSC