This week I hosted T-SQL Tuesday. This monthly event suggests a topic for bloggers to write about. It’s been going on for many years, and you can find more details here. https://tsqltuesday.com/ For my specific post, you can find the summaries here. T-SQL Tuesday #203 — Summary/Follow up I’ve spent 20+ years being asked questions about […]
This one is going to involve a lot of honesty & self-reflection. Run now. You've been warned. I know for a fact that I'm blessed. I'm healthy. I have a loving family. There are friends out there happy to see me when we meet. I've got one of the single greatest jobs ever. I live […]
This article shows two scenarios, tested independently, with the full scripts and the real numbers from each run.
I eventually found an explanation for this error message that, while not completely satisfactory, did lead me to diagnose wider-reaching I/O issues on the affected instance and led me to a better understanding of latching in general.
Share your view on the database landscape and you could win USD$500.
A SQL Server upgrade left a log shipping secondary unable to accept transaction logs. Re-seeding it without touching the primary or its mirror is straightforward in principle — drop, restore full + diff + log with NORECOVERY, hand back to the job — but three undocumented traps will stop you along the way. Here's what they are and how to get past them.
I'm sure I've never mentioned this before, but I'm a little aged. I'm not real far from 40 years in IT, and I got started a little late in life. Regardless, I've heard this tale of woe before. And no, this isn't going to be a rehash of all the old stories ("self-tuning" SQL Server […]
Should SQL Server databases enforce foreign key constraints? A veteran DBA breaks down the real arguments
Learn how to normalize values in Power BI to allow you to compare disparate different data.
I was reading about a recent security failure when I saw the phrase "...a series of missed opportunities...". Made me giggle and say to myself "No Kidding Kojak" except I used Sherlock Holmes and a different word. Fact is, security failures, and hey, let's face it, process failures, almost never come down to a single […]
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Risk Vs Reward, The never...
Telp/Wa 628218200203 Komplek Ruko Roxy Mas, Jl. Kh Hasyim Ashari No.6 Blok C.5 No,...
Telp/Wa 628218200233 Ps. Regional Tanah Abang Blk. F, Lt. Dasar, Kp. Bali, Kecamatan Tanah...
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers