Contained Databases – Preventing Collation Conflicts
One of the demos from my Contained Databases talk looks at the issues you can have when your database collation...
2012-06-14 (first published: 2012-06-07)
2,333 reads
PAGE_VERIFY – Checksum vs. Torn Page Detection
All this talk of testing backups and data integrity and checksums has me thinking that maybe now would be a...
2012-06-07
10,813 reads
Service Broker: What does a DBA need to know?
Service Broker is SQL Server’s internal messaging system. It has been designed as an asynchronous, reliable and transactional messaging system...
2012-06-13 (first published: 2012-06-07)
10,644 reads
C# Explicit Interface Implementation
In C# it is possible to write classes that implement an interface but only show the methods of the interface...
2012-06-07
48 reads
Optimise Your Disk Subsystem I/O with An Index File Group and Index Compression
As a DBA who is always seeking solutions to performance bottlenecks, amidst the
daily rituals of validating backups and other regular...
2012-06-06
1,691 reads
Powershell Add-Type – Where’s That Assembly!
I’ve been working a lot lately with SMO and the differences between the various versions between SQL 2005, 2008, and...
2012-06-06
17,455 reads
SQL Server Configuration Manager : Cannot connect to WMI provider – Invalid class [0x80041010]
Following error dialog pops up today, when I tried connecting to SQL Server Configuration Manager on my SQL Server 2008...
2012-06-06
25,001 reads
Unable to recycle SQL Agent log: SQLServerAgent Error: 32.
Today the maintenance job that recycles the SQL Agent error log failed on one of our production SQL Server with...
2012-06-06
2,572 reads
SQLSaturday #164 Cleveland – Tick tock, people!
If you haven’t already heard, Cleveland is hosting SQLSaturday #164 on August 18. That date is coming up fast and...
2012-06-06
643 reads
Do You Know An Exceptional DBA?
Do you know a DBA that saves the day time and again? Or one that doesn’t need to save the...
2012-06-06
984 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