Why Developers Shouldn’t Have sysadmin access in SQL Server
7 reasons—and exactly what to do instead
It can feel “faster” to hand developers sysadmin. In reality, it’s like giving them the master...
2025-10-06
530 reads
ecstatic shock – n. a surge of energy upon catching a glimpse from someone you like, which scrambles your ungrounded circuits and tempts you to chase after that feeling...
2025-10-03
25 reads
The New Arena of Leadership The role of the Chief Data Officer is no longer about governance alone. It is about vision. It is about turning data into the...
2025-10-02
17 reads
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily create database snapshots. This new version fixes a bug that we’ve found in version 2...
2025-10-24 (first published: 2025-10-02)
1,530 reads
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth, blocks covering-index usage, and makes code brittle when schemas change. Specify only the columns you...
2025-10-02
42 reads
In parts 1 and 2 of this series, we’ve gathered info and done the triage just like anyone in almost any industry does At this point you’ve: Defined what...
2025-10-27 (first published: 2025-10-01)
1,739 reads
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there was a great question that I wasn’t sure about. Someone asked about the download size...
2025-10-01
42 reads
After setting up dozens of Internet of Things (IoT) smart home devices, I started to wonder: how hard could it be to build one from scratch?
I needed a project...
2025-10-01
17 reads
Are you diversifying your DBA skillset? My recent job search made one thing clear: the database landscape is broader than just SQL Server and Oracle. More and more companies...
2025-09-30
138 reads
I flew to Amsterdam last night and hopefully by the time this publishes I’ll be at my hotel, catching up on messages and prepping for another Simple Talk Podcast...
2025-09-29
17 reads
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
The DBA life is fraught with pain. Those battles that we endure are mostly...
Comments posted to this topic are about the item A Quick Second Opinion
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Comments posted to this topic are about the item Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers