2023-05-17
66 reads
AI Experiments–Who am I and how am I remembered?
I saw someone noting that AIs shouldn’t write obituaries. Since I maintain sqlmemorial.org, I wanted to see what would happen for me. This is part of a series of...
2023-05-16
31 reads
VMUG Ireland – Belfast
The second VMUG Ireland event of the year is taking place on the 15th of June in Belfast! When: Thursday 15th of June @ 2pm until 5pm Where: Ormeau...
2023-05-16
27 reads
Top Tools for SQL Server Performance Troubleshooting
When you've got the symptoms of a database issue you can run a series of diagnostic queries to try and drill down on the problem and then start figuring...
2023-05-26 (first published: 2023-05-16)
664 reads
Stop Using Balanced Power with SQL Server
The OS default Power Plan for Windows is Balanced Power. This can cause degraded overall performance for SQL Server. Balanced Power is a great concept to help conserve energy...
2023-05-16
29 reads
Using Docker on Windows with Persistent SQL Server Settings and Databases
This is an easy way to retain the data and settings you create and change on your SQL Server Docker instance. There’s a lot of talk about attaching databases...
2023-05-31 (first published: 2023-05-15)
494 reads
Leveling Up for Sales and Marketing
I’m heading to Austin today for Redgate’s internal Level Up conference. This is designed to help employees improve their skills in some way. The original ones focused on technology...
2023-05-15
51 reads
Microsoft Digital Event Pre-Show: Azure FastTrack, Power BI CAT, & Azure Synapse Analytics PG
Next week is Microsoft Build and there is a Microsoft Digital Event occurring on May 24 - 25 starting at 9 AM Pacific Time for a live simulcast with a lot...
2023-05-15
24 reads
Tales From The Field Weekly Wrap Up for the Week of 05-08-2023 Mother's Day, Big News for MS Build, & the recap
Hello Dear Reader!! We also have some really, really, BIG NEWS for next week! It also happens that next week is Microsoft Build, make sure to register for free! But...
2023-05-15
33 reads
TDE: Database Backups and High Availability
Database backups continue to work without change when you have TDE enabled. The only difference is that the backups contain encrypted data that cannot be read without the certificate...
2023-05-15
46 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