SQL Prompt – Killing the Detail Box
I love SQL Prompt and use it constantly. When I don’t have it, my code writing process slows to spurts...
2015-04-15
750 reads
Blog Posts
Types of NoSQL databases
A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the...
2015-04-15
1,771 reads
Announcing Pro SQL Server Wait Statistics
I am very proud to officially announce my first ever SQL Server related book, Pro SQL Server Wait Statistics! As...
2015-04-14
649 reads
Becoming a PASS Chapter Leader – Challenge Accepted!
My first real introduction to PASS was back in 1998. I was an “Accidential DBA” and needed some training. I...
2015-04-14
538 reads
Exam Prep 70-463: Introduction to Master Data
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-04-14 (first published: 2015-04-06)
6,663 reads
Extended Events and Data Types
Today is another one of those installments in the long-running TSQL Party held monthly (a.k.a TSQL2SDAY). This month we have an open invitation from Mike Donnelly (blog | twitter), asking...
2015-04-14
6 reads
Extended Events and Data Types
Today is another one of those installments in the long-running TSQL Party held monthly (a.k.a TSQL2SDAY).
This month we have an open...
2015-04-14
904 reads
Planning a High Availability and Disaster Recovery Plan in Puerto Rico
I’ll be doing a precon for SQLSaturday #373 in Puerto Rico on May 8th, 2015 titled “Planning a High Availability and Disaster...
2015-04-14
675 reads
Teach Something New: PowerShell Providers [T-SQL Tuesday #065]
Mike Donnelly (b|t) invited the SQL New Blogger Challenge participants to join in this month’s T-SQL Tuesday, and I’m happy...
2015-04-14
548 reads
T-SQL Tuesday #65 – Failing Over with PowerShell
This month’s T-SQL Tuesday topic is being hosted by Mike Donnelly (B|T). The topic of choice is a fantastic one,...
2015-04-14
682 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