SQL Server Quickie #3 – Allocation Units
Today
I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I'm talking
about Allocation Units in SQL Server....
2012-09-18
1,587 reads
Max Text Replication Size – When you might have to care about this number !
One of the advanced Server level options for SQL Server is Max Text Replication Size and this is really not a common...
2012-09-24 (first published: 2012-09-18)
6,906 reads
24 Hours of PASS: Hosting Rod Colledge–BI in Sharepoint
The Virtual Chapters of PASS are asked to host sessions during this Fall’s 24 Hours of PASS preview for the...
2012-09-18
999 reads
SQL Server: Part 1 : Approaching Database Server Performance Issues
When you work as DBA, many people will approach you with a complaint like "Application is taking ages to load...
2012-09-18
1,414 reads
Funny results from OPTIMIZE FOR AD HOC WORKLOADS
I recently turned on OPTIMIZE FOR AD HOC WORKLOADS for the first time on one of my servers. When I...
2012-09-18
1,371 reads
SQL Saturday #149 and CodeMastery–Minnesota Events
We are less than two weeks away from SQL Saturday #149 in Minneapolis on September 29, 2012 with two preconference...
2012-09-18
526 reads
SQL in the City – US 2012 Tour
Last year I had the pleasure of speaking at two SQL in the City events: London and Los Angeles. It...
2012-09-18
1,388 reads
SQL Saturday #171 Pittsburgh, the Schedule is Up!
SQL Saturday #171 Pittsburgh preparations continue, and the schedule has been posted for your review. If you're anywhere in the...
2012-09-18
753 reads
Interesting Reading for September 18, 2012
More stuff you may find interesting.
Prepare for your first security breach. Sobering. As data professionals we’re going to get pulled...
2012-09-20 (first published: 2012-09-18)
2,134 reads
Clients Love The Way I Jiggle
It’s one of the most enjoyable things about being a consultant.
I’m not talking about my suspect dance moves here. I’m...
2012-09-18
1,145 reads
Blogs
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....
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...
Forums
Execute as failure
Security has long been a problem for me. Every time I think I understand...
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...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers