Changing The Stars

If you’ve never seen the movie “A Knights Tale” I recommend that you do.  In the movie, the character William...

SQL Homework Nov 2017: Create a view

Views are a highly useful tool for abstracting how you see the data stored in tables. At their simplest, they...

Configuring Azure Data Sync

In this video David demonstrates how to configure Azure Data Sync 2.0 to synchronise an Azure SQL database with an...

SQL Server on Linux Online Training with Brent Ozar Unlimited!

I’m proud to announce to you that I’m partnering with the folks over a Brent Ozar Unlimited to provide live,...

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...

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!...

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...

SQL Server Haunt 2017

The undead of Halloween are now upon us. Among the hordes of data zombies roaming the streets in lab-coats and fishnet stockings, few of us are still scrambling to...

SQL Server Haunt 2017

Halloween is a great time of year. It is unfortunate that it is just one day of the year. That...

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,...