A Small Collection of I/O Specific DMV Queries
It is pretty common for large, busy SQL Server implementations to run into I/O pressure or bottlenecks, especially since many...
2009-12-30
4,233 reads
Practice Your Restores
Steven Jones posted an excellent editorial today all about how your backups are only good if you know that you...
2009-12-30
1,324 reads
Running a Small User Group - The Tools
Because running a small user group is a labor of love, we look for time savings wherever we can to...
2009-12-30
1,834 reads
Looking back at 2009 Goals
I set goals at the start of 2009 for the year. They were:
Continue with 400 posts a month Blog Daily...
2009-12-30
1,749 reads
Writing Proposals for Training
I had a student recently who said that to get any type of training she had to write a proposal...
2009-12-29
1,546 reads
The Other Server
I had a fun support call I need to share. A developer called up to tell me that a particular...
2009-12-29
1,303 reads
The Power of Networking
I was contacted recently by someone that was hiring a new employee. They had searched out applicants on the Internet...
2009-12-29
1,461 reads
Starting the year out right
It's the end of another year, and thus the beginning of the next one. Whether you had a successful 2009...
2009-12-29
1,411 reads
Analysis Services Performance Optimization Tips
Over the last few weeks I have focused most of my blog energy into writing a couple articles. So I...
2009-12-29
1,874 reads
Windows ReadyBoost in Windows 7
Perhaps you heard of or actually tried Windows ReadyBoost in Windows Vista, and were (like me) disappointed with the results?...
2009-12-29
3,157 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