2023-04-29
156 reads
Database Weekly
AI Concerns
With the ChatGPT and AI crazy sweeping through the media, Steve has a few thoughts on what this might mean for data professionals.
2023-04-22
210 reads
Moore's Law: Navigating the Pace of Technological Change
Technology has always been a driving force in shaping our world, propelling us forward into new realms of innovation and progress. One of the most famous concepts in technology is Moore's Law, which suggests that the number of transistors on a microchip doubles approximately every two years, leading to exponential increases in computing power. In […]
2023-04-15
159 reads
The Top SQL Server Engine Errors
The SQL Server Support team published the top errors they see in calls. Steve has a few comments on what they're doing to help customers.
2023-03-04
600 reads
Consider Sharing Your Knowledge At User Groups and Conferences
The first time I spoke in front of a group of people over 20 years ago about a programming topic, I was scared to death. I could barely sleep the night before, obsessing about the material and practicing it repeatedly. When I finally did sleep, it felt like minutes before I awoke, and it was […]
2023-02-25
102 reads
The Home Password Cracker
Passwords cracked in under an hour using modern hardware have Steve shaking his head.
2022-10-22
418 reads
New Cloud Licensing Limits
New licensing rules are coming for using your SQL Server licenses in the cloud.
2022-09-03
195 reads
The Case for Patching
Recently I was testing a feature in SQL Server on 2017 and 2019. There was supposed to be an improvement across versions, but I didn't see it. Then I realized that I was on SQL Server 2019 CU 2 on my laptop, and the current CU is 17. I took a few minutes to download […]
2022-08-20
157 reads
SQL Standard Confusion
The whole universe, the well-guarded people—may they all query databases together in a single language!
2022-08-13
281 reads
Three Mile Island And Your Databases
Grant takes a few lessons for database DR from a nuclear accident in the US.
2022-08-06
103 reads
Blogs
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
Forums
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
The Quiet Part
Comments posted to this topic are about the item The Quiet Part
BIT_COUNT in SQL Server
Comments posted to this topic are about the item BIT_COUNT in SQL Server
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers