Perth SQL Server Users Group is Second Stop in Australia
On Friday, October 3, I spoke a second time at Perth, this time at the Perth SQL Server Users Group....
2009-10-06
360 reads
[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
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
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
SQL Server 2008 Change Data Capture
SQL Server 2008 has a new Change Data Capture feature that allows you to track Inserts, Updates, and Deletes on...
2009-10-05
2,387 reads
Speaking Engagements This Week
I'll be doing three talks this week, starting tomorrow (Tuesday).
Tuesday, October 6th, Midlands PASS Chapter - Trigger Happy Database Security(PASS Summit...
2009-10-05
1,006 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
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
SQL Lunch Starting at 11:30 AM CST 10/5/2009
TOPIC: SQL Lunch - Memory Management in SQL Server Analysis Services
If you haven’t already, go out and register for today’s SQL...
2009-10-05
734 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