SQL Saturday 392 – Atlanta, GA
Have you been to Atlanta, Georgia ? Nope? Well it’s time you plan that trip and come see me speak May...
2015-04-30
969 reads
John Morehouse | Sqlrus.com
Quick Script: Finding Database Owners & Security Admins
Security Is Everybody’s Responsibility
Recently, while diagnosing a permissions issue on a Production database, I realized that I didn’t really have...
2015-04-23
363 reads
2015 Program Committee
Last year, I was very much honored to be selected to deliver a pre-con with my friend brother Chris Shaw (B|T). I...
2015-04-16
413 reads
T-SQL Tuesday #65 – Failing Over with PowerShell
This month’s T-SQL Tuesday topic is being hosted by Mike Donnelly (B|T). The topic of choice is a fantastic one,...
2015-04-14
682 reads
Detaching a Database – File Security Gotcha
I’ll admit it, there are times where detaching a database is the best way to get something accomplished, but it...
2015-04-09
680 reads
Procedure Creation – Correct Syntax, Wrong Database
Recently, on a Friday evening, we released an update to one of our core applications. As expected, it went smoothly...
2015-04-02
437 reads
Database Restores – Zeroing Out Log Files
I recently came across a question on the #sqlhelp Twitter feed that I thought was interesting. The question pertains to...
2015-03-26
458 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers