New Job -> Week 5 -> Create Index Maintenance Scripts
This is part of a series of new job blog posts. You can find them all here. Week 5 goal: set up Ola index maintenance for all Azure SQL...
2023-04-18 (first published: 2023-04-17)
185 reads
SQLKitty
New Job -> Week 4 -> Set Up Auditing
This is part of a series of new job blog posts. You can find them all here. The main goal for week 4: set up auditing for all Azure...
2023-04-19 (first published: 2023-04-06)
377 reads
New Job -> Week 3 -> Creating Alerts
This is part of a series of new job blog posts. You can find them all here. The main goal for week 3: setup much needed alerts on DTU...
2023-03-31 (first published: 2023-03-30)
187 reads
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find them all here. Last week was the first week of the rest of my life....
2023-04-10 (first published: 2023-03-24)
562 reads
New Job -> Week 1 -> What Tools Do You Need?
I changed to a new job and started it this week. Before I started, I thought of all the things I thought I would want to do when I...
2023-04-05 (first published: 2023-03-17)
430 reads
Creativity in Technology
I was planning to write a blog post on how you can find ways to be creative in any technical pursuit. Then, I found out from a friend that...
2023-03-24 (first published: 2023-03-15)
186 reads
Documentation vs Automation
Originally, I was going to write a post on troubleshooting SQL Server. This is because I’m writing up and reviewing a lot of documentation at my current job. I’ll...
2023-03-08 (first published: 2023-03-01)
456 reads
Help! My tempdb is full and I can’t access SQL Server!
I got a call saying the database server is inaccessible because tempdb is full. I get online and try to connect because I want to see the error for...
2023-01-18 (first published: 2023-01-06)
1,101 reads
Long time, no posts
I was working on two publisher contracts at the same time. I highly recommend never doing that. One is done, though, and it’s officially published as of September 2022....
2022-10-27
34 reads
Adding AD group perms to SQL Server
Why doesn’t SQL Server automatically check for the Group –> Object type when you are adding perms via SSMS? This hangs me up almost every time. I think “omg...
2022-10-27
26 reads
Blogs
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...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
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