Capture SQL Server Deadlocks using Extended Events
Microsoft SQL Server provides a variety of different options to monitor deadlocks. This includes Trace flags 1204 and 1222, SQL...
2012-09-03
1,531 reads
Am I Following Your Blog?
As I sat around this past weekend I was left wondering… am I missing any good blogs out there? With...
2012-09-03
896 reads
Quick T-SQL Performance Comparison
I’m not a T-SQL guru. When I have something that will run often, or I have performance concerns, I’ll ask...
2012-09-03
1,294 reads
How To Simply Say You’re a DBA
Have you ever looked back on a conversation where someone asked you “what do you do?” and felt disappointed with your reply?...
2012-09-03
980 reads
sp_helptext
My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...
2012-09-02
4,120 reads
Troubleshooting Oracle Link Server - Part2
It's my bad that I did not made a post since long lately. I would not make an excuse like...
2012-09-01
1,072 reads
Personal Goals
With fall quickly approaching, I thought this would be an ideal time to set some personal goals for the upcoming...
2012-09-01
1,521 reads
Demonstration of a simple dashboard created with the Tableau Software
Like I said on Twitter, here’s the post about the dashboard I created using Tableau, a BI visualization software. I’ve...
2012-09-01
1,872 reads
Thinking on Execution
I read a lot, one the most recent books is The 4 Disciplines of Execution which is, of course, about...
2012-08-31
1,547 reads
Three Not SQL Blogs To Read
Here are three blogs I’ve been reading recently that are interesting. None about SQL, but you might find some value...
2012-08-31
1,941 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
Execute as failure
Security has long been a problem for me. Every time I think I understand...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers