Contained Database – No more need for Server Level Logins
Starting in SQL Server 2012 and in Azure SQL Database, Microsoft introduced the concept of a contained database. A contained...
2018-07-11 (first published: 2018-07-05)
2,928 reads
Community recognition
On the first day of January 2017, I was honoured to receive an email naming me as a Microsoft MVP...
2018-07-04
313 reads
Updating VSTS to SQL Change Automation
We (Redgate) released SQL Change Automation a few weeks back. This is the first stage to implementing a combined toolset...
2018-07-04
1,004 reads
Saving disk space by choosing the correct data type
"Database is almost 4 TB in size, user is complaining on long times for DEV data refresh and high storage...
2018-07-03
1,759 reads
Building Better Test Data on the Redgate Hub
I have a new piece published over at the Redgate Hub: Building Better Test Data with SQL Provision. Part of...
2018-07-03
849 reads
Mastering Index Tuning–Day 3
This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses...
2018-07-03
961 reads
Half-year round-up
So, to do the name “blog” justice, I should post something every now and then. Alright, here you go, let...
2018-07-03
289 reads
A bug in merge replication with FILESTREAM data
I wish I could say that every DBA has a love/hate relationship with Replication, but, let’s face it, it’s only...
2018-07-11 (first published: 2018-07-03)
2,204 reads
Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)
The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part...
2018-07-03
269 reads
Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)
The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part of today's online code community.
Before modern online programming communities,...
2018-07-03
5 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers