Welcome to The Monday Morning DBA
I started my IT career twenty years ago as a VB and C developer, wandered into C++ for a bit,...
2017-09-30
356 reads
Blog Posts
Adding a Replica back into a SQL Server Availability Group
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-09-29 (first published: 2017-09-25)
2,812 reads
Friday Reading 2017-09-29
Another busy week almost over and today I’m heading to Utrecht for SQL Saturday Holland! Never been to Utrecht before...
2017-09-29
508 reads
Love and Hate for SSMS
People have strong feelings about SQL Server Management Studio: they love it AND they hate it. In this week’s episode, I talk about why people have such conflicting feelings...
2017-09-29
20 reads
SSAS Tabular DirectQuery–No Hierarchies in Dimensions
I recently was testing DirectQuery to see the reporting differences in a Tabular Model. After Deploying to a development server and analyzing in Excel, the hierarchies for the Date...
2017-09-29
80 reads
SSMS 17 Dark Theme
Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual...
2017-09-29
2,714 reads
Stop waiting for SQL Server Service Pack 1 before upgrading!
It’s not stable until Service Pack 1…
Are you at a company that doesn’t install a new version of SQL Server...
2017-09-29
768 reads
Test Database Compatability with dbatools
I really like the dbatools project. This is a set of PowerShell cmdlets that are built by the community and...
2017-09-29 (first published: 2017-09-20)
2,199 reads
All Day DevOps–A Free, Virtual Conference
All Day DevOps is coming on Oct 24. This is a 24 hour event, with 100 sessions live, online. You...
2017-09-28
1,313 reads
Ask HN: Would you run SQL Server on Linux?
Hacker News is one of the best sources for technical news out there. I check HN at least once a...
2017-09-28
580 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