Rant: Cold Calls Are So Twentieth Century
I hate cold calls from vendors. Nothing gets my blood hotter than some vendor trying to call me when we...
2009-10-06
712 reads
Blog Posts
[Tagged] Anatomy of a Geek
I got tagged by my buddy Michael Coles, aka Sergeant SQL to talk about how I "became" a geek. (I...
2009-10-05
353 reads
A Tale of Two Utility Companies
I live in Parker, Colorado, which is a suburb of Denver, about 25 miles southeast of downtown Denver. I have...
2009-10-05
619 reads
Ad Hoc Queries Don’t Reuse Execution Plans: Myth or Fact
Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...
2009-10-05
3,208 reads
DRP for SQL Server in French - traduction en français du plan de relève – part 3
Here is Part 3 of the translation for the French version of the Disaster Recovery for SQL Server Databases - comments...
2009-10-05
1,055 reads
How to Diagnose and Correct a “Runaway” Transaction Log
This shows you how to diagnose and correct a "runaway" transaction log. This is a very common issue that I...
2009-10-05
8,591 reads
My Journey - Part I
I've actually been meaning to write about my journey as a SQL Server professional, but kept putting it off. I...
2009-10-05
1,113 reads
My Top 10 SQL Saturday Tips
Top 10 SQL Saturday Coordination Tips
1. First and probably the most important thing is to assemble a very responsible and...
2009-10-05
1,343 reads
NY/NJ SQL Saturday Event Details - October 24, 2009
NJSQL/NYCSQL Saturday Event on October, 24th (Registration Required)
Here are the details, of my previously announced SQL Saturday event hosted by...
2009-10-05
1,272 reads
Spaces in Object Names Revisited
I think in general the SQL Server DBA’s of the world prefer that object names not have spaces embedded, and...
2009-10-05
825 reads
Blogs
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....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
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...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers