Traveling to SQL Bits
I’m heading to SQL Bits this weekend, and will be in London most of next week for the conference. I’m excited. SQL Bits is my favorite conference, as I’ve...
2022-03-02
27 reads
Data Analysis Techniques
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-03-02
117 reads
Azure Synapse and Delta Lake
Many companies are seeing the value in collecting data to help them make better business decisions. When building a solution in Azure to collect the data, nearly everyone is...
2022-03-02
596 reads
Don’t change your default SQL Server port for security reasons
Since we’re on a recent theme of revising long-held best practices that are not, here’s a timely one for you: Don’t change your default SQL Server port for security...
2022-03-02
236 reads
Architecture – Commonality is an accelerator
In IT, commonality is an accelerator. When I say commonality, I mean commonality of: Components, like libraries Object models Interface definitions Tools Let me give you an example. Imagine...
2022-03-02
187 reads
Daily Coping 2 Mar 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-02
22 reads
Recipe 8: Analyzing a Workload
Welcome to a new recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the...
2022-03-02
168 reads
Goal Progress for Feb 2022
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. February became more of a work month for me, and...
2022-03-01
23 reads
Daily Coping 1 Mar 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-01
22 reads
Heap Tables
In today’s blog posting I want to talk about Heap Tables in SQL Server. Heap tables are tables without a Clustered Index. A table in SQL Server can have...
2022-03-01
410 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
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