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
309 reads
Database Weekly
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
75 reads
The Home Password Cracker
Passwords cracked in under an hour using modern hardware have Steve shaking his head.
2022-10-22
363 reads
New Cloud Licensing Limits
New licensing rules are coming for using your SQL Server licenses in the cloud.
2022-09-03
171 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
143 reads
SQL Standard Confusion
The whole universe, the well-guarded people—may they all query databases together in a single language!
2022-08-13
227 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
92 reads
2022-07-30
302 reads
Query Tuning, Why Bother?
Today Grant wonders why we spend so much time trying to learn about query tuning.
2022-07-23
251 reads
2022-07-09
164 reads
Blogs
Simple Talks Episode 9–Data masking and subsetting
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
T-SQL Tuesday #180: Avoid Perfect for Good Enough
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Book Review – Humanizing Data Strategy by Tiankai Feng
This book was making its rounds on social media, and the concept seems interesting...
Forums
DBATools in a agent job
Hi Dbatools is used to copy table data from domain a to domain b...
SQL server help (converting rows to columns)
I am using the following sql to convert rows into columns for each pid,...
Ingesting Data From REST API endpoints: Data Engineering with Fabric
Comments posted to this topic are about the item Ingesting Data From REST API...
Question of the Day
The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers