Logging in Maintenance Plans
Enabling and Configuring Reporting and Logging for Maintenance Plans in SQL Server 2012
Database Delivery Patterns and Practices
The articles collected here will help you understand the theories and methodologies behind every stage of the database delivery pipeline, starting when database changes are checked in, and ending when they're deployed to production.
Survey: Which new database platforms are you adopting?
Database technologies are always improving, which database platforms will you be using tomorrow? Red Gate wants to stay ahead to make sure you have the tools you need to do awesome work. Help us by completing this short survey.
Stairway to Database Source Control Level 2: Getting a Database into Source Control
In this level, we're going to continue the philosophy of learning by example, and get a database into our SVN repository. We will also consider our overall approach to source control for databases, and the manner in which our team will develop these databases, concurrently.
Traits of a DBA - Part One – The Technical Side
What does it take to become a database administrator, or what kinds of traits should I be looking for when I am hiring a DBA. Those traits can be summarized it two categories: Technical and Personal. In this article, Greg Larsen discusses the technical traits a DBA should have.
Display All Errors Fired in a Restore Procedure
Display all errors thrown within a catch block by a restore statement in a stored procedure using extended events
Try to focus on the positive
When we focus on negative things we get more negative. Be thankful for something positive.
On Comparing Tables in SQL Server
How do you compare two SQL tables? Every SQL Developer or DBA knows the answer, which is 'it depends'. It is not just the size of the table or the type of data in it but what you want to achieve. Phil Factor sets about to cover the basics and point out some snags and advantages to the various techniques.
SQL Monitor Custom Metric: Ad Hoc Queries Running Once
This metric measures the total number of ad hoc queries in the plan cache that have only run one time. The value is only accurate for the instant the query is run, and the value can change radically from one capture time to the next.
Blogs
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Simple Talks Podcasting in 2026
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
Forums
Cumulative Update 23 - KB5074819 - Database Mail - No longer working.
Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...
Script Task execution error with HTTP request
I have a script task that tries to execute a HTTP request, which seems...
SQL Server 2025 Standard Developer Edition
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
Question of the Day
URL Safe or Not?
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers