Compatibility Level Confidence
The database compatibility level ought to provide some protection from database upgrade changes, but do you believe that?
Understanding SQL Server Recovery Models
The database recovery model controls how a SQL Server database can be backed up and restored. In this article, Greg Larsen explains the three recovery models and what to think about when choosing a recovery model for a database.
Why you should embed monitoring earlier in your Database DevOps cycle
With insights from a recent Gartner report, Redgate’s Jamie Wallis looks at the benefits of tracking, and acting on, key metrics early in the DevOps process and how they can apply equally to database monitoring.
SQL Server on Amazon RDS vs SQL Server on Amazon EC2
Exploring briefly the difference between using Amazon Machine Images running SQL Server and using SQL Server instances on Amazon's Relational Database Service.
Would You Move For a Job?
Today we have a guest editorial from Andy Warren as Steve is on vacation. Would any job be enough for you to uproot your life?
Posting SQL Server Notifications to Slack
In this article we look at how to send Slack notifications when certain events occur in a SQL Server database.
Solving Real Problems
Today we have a guest editorial where Grant talks about being effective and practical in your world.
Heaps in SQL Server: Part 3 Nonclustered Indexes
Uwe Ricken continues his series on heaps. This time he demonstrates a common scenario where the query against a heap is faster than a clustered index.
Aiming for Better Data Governance
Today Steve gives a reason why your organization might consider improving its data governance.
Stairway to Biml Level 7 – Populating the Database for a Custom Biml Framework
In this next level of the Stairway to Biml, we look at a custom framework in Biml.
Blogs
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Tip: Expanding a SQL statement
In all recent versions of the database you can call DBMS_UTILITY.EXPAND_SQL_TEXT to get the...
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
Forums
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers