The article covers four connected areas: over-privileged database users, msdb and SQL Server Agent exposure, privileged maintenance jobs, and trigger-based permission hijacking.
Managing incidents as a DBA /DB manager and some of the key things you should be doing.
Learn how the BIT_COUNT() function works and how it enabled operations where data is stored in bits.
In this tip, we’ll look at some best practices to help you get the most out of your models. We will also look the DAX formula language.
AI is causing some people to work more, which seems at odds with the idea of what AI should be: a useful tool.
As database changesets accumulate over time, they gradually become more than deployment artifacts. This level explores how a well-organized changeset library evolves into a replayable representation of the database’s structural history, supporting not only reliable deployments but also reconstruction, auditing, and long-term maintainability. Through practical examples and a real-world case study, it shows why maintaining coherent Create and Rollback scripts continues to provide value long after a successful production deployment.
This article goes into one of the new regular expression functions in SQL Server 2025: REGEXP_LIKE().
AI developer tools have matured fast. In 2026, most engineering workflows touch at least one AI coding agent, code reviewer, or research assistant — but the right combination depends heavily on your team size, codebase, and tolerance for setup overhead. This guide breaks down the tools actually worth using across three categories: research and architecture, day-to-day development, and code review, based on real, hands-on experience.
This article looks at replacing a cursor with a window function to improve performance.
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Comments posted to this topic are about the item When the Token Meter is...
Comments posted to this topic are about the item Understanding Temp Tables and Table...
Comments posted to this topic are about the item The Data API Builder MCP...
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers