Using SQL Agent Job Categories to Automate SQL Agent Job Enabling with Database Mirroring
Microsoft’s Kevin Cox (from SQLCAT) and I co-authored a blog post titled Using SQL Agent Job Categories to Automate SQL...
2010-04-01
932 reads
Renewed as an MVP
I received my renewal notice and, after checking the message header, it is April 1st, I got very happy. I’d...
2010-04-01
512 reads
A DMV a Day – Day 1
Just as an experiment, I am going to post a different DMV query every day for the next 30 days. ...
2010-04-01
897 reads
New Trends In Storage Technology: AFD
I have a passing interest in storage technology and trends so you can probably guess I got really excited after...
2010-04-01
508 reads
Blog Topics - Where do you draw the Line?
I started blogging a few months ago and since I started writing my own blog, I've been a much bigger...
2010-04-01
502 reads
Outtakes
Sometimes I think I’m quite the goober. Alternately I’ll laugh or put my head in my hands as I try...
2010-04-01
369 reads
Powershell – Useful Resources
One of my aims at the start of the year was to improve my Powershell and scripting skills. I run...
2010-04-01
1,143 reads
April Question: What advice would you offer a novice DBA in order to help them along in their career?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-04-01
487 reads
PASS, Microsoft, and Certification
Steve Jones’ (@way0utwest) recent SQLServerCentral editorial, The Missing Certification, has spawned a vigorous debate about what the missing certification should...
2010-04-01
1,427 reads
April Fools is Fun
Some good jokes going around, and the few I wrote for SQLServerCentral went over well. There was a good one...
2010-04-01
564 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
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers