Changing The Stars
If you’ve never seen the movie “A Knights Tale” I recommend that you do. In the movie, the character William...
2017-11-01
139 reads
Blog Posts
Contained Databases
Today's post is in regards a feature that was released with SQL Server 2012, it hasn't gotten the attention or...
2017-11-01
515 reads
DB Mail error “File attachment or query results size exceeds allowable value of 1000000 bytes”
Issue : One email report is working fine from long time but suddenly it failed today with below error.
Error :
Msg 22051,...
2017-11-01
1,303 reads
Gimmicks that work: XE Profiler in SQL Server Management Studio
I have a favourite new feature of SQL Server Management Studio 17.3 (SSMS), and that’s XE Profiler, which allows you to...
2017-11-01
494 reads
New Pluralsight Course – SQL Server on Linux Administration Fundamentals
New Pluralsight Course – SQL Server on Linux Administration Fundamentals
My new course “SQL Server on Linux Administration Fundamentals” in now available on Pluralsight here!...
2017-11-01
493 reads
New Pluralsight Course – SQL Server on Linux Administration Fundamentals
New Pluralsight Course – SQL Server on Linux Administration Fundamentals
My new course “SQL Server on Linux Administration Fundamentals” in now available on Pluralsight here! If you want to learn about the...
2017-11-01
13 reads
PASS Summit 2017 - Live and in Living Color!
UPDATE - the feed and schedule are live at http://www.pass.org/summit/2017/PASStv.aspx
http://rochistory.com/blog/wp-content/uploads/2014/09/NBC-logo.pngNot in Seattle for some reason this week? Like maybe you stayed home...
2017-11-01
439 reads
PASS Summit 2017 Day 1
It’s the first full day of the 2017 PASS Summit. As I write this, I am somewhere over the panhandle...
2017-11-01
327 reads
SQL PASS Summit 2017: Day 1 Keynote Thoughts and Memories
Whee! It’s the first day of the main SQL PASS Summit conference and I made it to the keynote early for the first time ever. The hype says we’re going...
2017-11-01
7 reads
SQL Server Haunt 2017
Halloween is a great time of year. It is unfortunate that it is just one day of the year. That...
2017-11-01
448 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Purpose of the Rice Purity Test
The main purpose of the Rice Purity Test is entertainment and self reflection. Many...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers