If you've spent years writing SQL for a living, you already know how this goes. Someone pings you on Teams asking, "How many active customers do we have in the Midwest this quarter?" There you are, back in the query editor, writing a JOIN you've written fifty times before. Genie Spaces in Databricks is built […]
Lots of organizations use multiple database platforms. Steve notes there is a cost to choosing to allow this.
Azure Arc-enabled SQL Server is designed to bring on-premises and multi-cloud SQL Server instances under centralized Azure management, but a newly documented privilege escalation technique shows how that same management workflow can be turned against the server it’s meant to protect.
If you own a business application, you’re accountable for its uptime, its cost, and its performance, even if you’ve never opened SQL Server Management Studio in your life. But most guidance out there is written for DBAs, not for the people who actually make decisions about the app.
This webinar on Sept 16 is different. We’ll walk through real findings from real SQL Server environments — the kind of things that quietly cause slow page loads, failed backups, and surprise outages — and translate each one into what it actually means for you: What did it cost? What was the risk? What would you have needed to ask your team (or your vendor) to catch it sooner?
How important is your job to you? Today's guest editorial from Andy Warren asks the question of the professionals out there, some of whom do great work, but don't care about their jobs.
tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very early in my database career, I taught myself how to make lot’s of rows of Random Constrained Data in a comparatively short time. With the help of a few good folks over time, the method has been […]
This guide has everything you need to know about JSON indexing in SQL Server 2025: what it is, how it works, and current limitations.
You may not be old, but I sure am. As I travel around to all the different conferences to speak, whether we're talking a dev conference, SQL Server, or PostgreSQL, one of the topics that keeps coming up is age. The age of the organizers. It's mostly the same people putting on events for the […]
See how SQL Server's Parameter Sensitive Plan optimization handles skewed parameters, how to verify dispatcher plans, and where PSP still falls short.
It's the first week of September, but Steve sees it as the end of summer. It's a time to catch up on things.
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Suryakencana No.260 C & D, RT.01/RW.05, Babakan Ps., Kecamatan Bogor Tengah, Kota...
WhatsApp:0817819444 Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, RT.5/RW.7, Krukut, Kec. Taman Sari,...
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers