SQL in the City Streamed: June 2018
Next week, Redgate Software, will be putting on SQL in the City Streamed. These events are a great way to...
2018-06-07
273 reads
The Scary DBA
Extended Events, the system_health Session, and Waits
I advocate for, use, document, teach, and just downright love, Extended Events. They are so much better than the old...
2018-06-04
363 reads
Query To Retrieve Statistics Data: dm_db_stats_histogram
Starting with SQL Server 2016 Sp1 CU2, a new way of directly querying statistics, specifically the histogram, has been introduced:...
2018-06-11 (first published: 2018-05-29)
2,165 reads
Why PASS?
In case this is your first time hearing of it, PASS is the single largest community of Microsoft Data Platform...
2018-05-21
715 reads
A View Will Not Make Your Query Faster
Twice recently, one on a blog post, and one in a forum post, I’ve seen people state, unequivocally, without reservation...
2018-05-14
321 reads
YouTube Channel Update: 11 May 2018
I’ve been busy getting the videos up on YouTube. If they’re helpful to you, please subscribe. Some point soon I’ll...
2018-05-11
230 reads
When Simple Parameterization…Isn’t
I’m desperately working to finish up a new version of my book on Execution Plans. We’re close, so close. However,...
2018-05-16 (first published: 2018-05-07)
2,591 reads
Automating Automatic Indexing in Azure SQL Database
I’ve been in love with the concept of a database as a service ever since I first laid eyes on...
2018-05-07 (first published: 2018-04-30)
1,951 reads
YouTube Channel Update: 27 April 2018
Despite a hiccup recently on Twitter where I managed to spam all my followers with links to my YouTube videos...
2018-04-27
469 reads
Presentation Tools
Let’s face it, the core of a presentation is you. Your knowledge and your ability to share that knowledge through...
2018-04-23
300 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers