Dealing with negative session ids
Hello? Mr. DBA? Have you got a moment?
So there you are, enjoying one of the few quiet moments of your...
2012-08-15
5,320 reads
Find failed SQL Agent jobs using Transact-SQL script
Today, I’m sharing the following T-SQL script which you can use to find which SQL Server Agent Jobs failed yesterday....
2012-08-15
2,308 reads
VM Guest Memory – Watch these numbers !
I have been using VMware vSphere client for a while now and the person who inspired me to use this...
2012-08-15
1,429 reads
The Home Server is Back
After reading about the Amazon/Apple attack this morning, I grabbed a second cup of coffee and went in search of...
2012-08-15
713 reads
At the End of One Chapter and the Beginning of a New Chapter
I have been told by hundreds of DBAs that I have the best DBA job in the world as Director...
2012-08-15
1,117 reads
Dear #SQLAwesomesauce: Is this idea batsh** crazy?
I’ve been out of town and off the grid – nothing like 10 days of family camping and roadtripping to unwind!...
2012-08-15
868 reads
Excel 2013 and BI
On July 16, 2012, Office 2013 Preview was released to the public (download). Excel 2013 now includes a lot of the...
2012-08-15
1,856 reads
#meme15: Reasons I Like My Job
When Jason ( B | T ) posted this assignment, I thought it would be a fun topic to write on. Before I...
2012-08-15
510 reads
PowerShell Saturday in Charlotte, NC
If you are in or around the Charlotte, NC area, there is a PowerShell Saturday coming your way on September...
2012-08-15
1,352 reads
Being Right, the Other Side
I read an excellent article by Camille Fournier about the importance of recognizing that being right is not the only...
2012-08-15
844 reads
Blogs
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...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
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...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers