SQL Server 2005 Diagnostic Information Queries
Here is an updated version of my diagnostic information queries for SQL Server 2005. You can get the SQL Server...
2009-11-09
2,294 reads
Closing Out PASS Summit 2009
I was up early again on Friday morning to have breakfast with Patrick Leblanc (SQLLunch man), and then off to...
2009-11-09
628 reads
More Thoughts on Stress
I’m trying to pay more attention to things that cause me stress and how I deal with the stress. It’s...
2009-11-09
931 reads
Looking Back - PASS Summit 2009 Day 1
I intended to blog daily while at the PASS Summit last week. At least that's what I told myself I...
2009-11-09
800 reads
Performance Tuning OLAP Reports
Reports that use an Analysis Services cube as a data source can often have performance problems during pre-execution. Before you...
2009-11-09
3,074 reads
The Nook
Barnes and Noble recently announced their new e-book reader, the Nook. It looks pretty cool, and in some ways I...
2009-11-09
800 reads
New Job with Pragmatic Works
Well if you attended PASS, you already know that I am changing jobs. I recently accepted a position with Pragmatic...
2009-11-09
674 reads
Skipping SQL Connections
I’ve never been to Las Vegas, and was looking forward to going for the first time this week for SQL...
2009-11-09
579 reads
PASS Summit 2009 – Wrap-up – What’s the Value?
I’ve already written four posts (1, 2, 3, 4) that discussed what I did at the Summit, including what I...
2009-11-09
418 reads
Notes from the PASS Summit 2009 Trip
A few random thoughts:
I think many people did ok at the airport connecting for ride share via Twitter. By next...
2009-11-09
371 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