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

Book from a library. Learning never stops for data professionals.

[2017-Oct-31] If you have never read the "Iacocca: An Autobiography" book by Lee Iacocca, I highly recommend it. I read it...

SQL Server 2017: Making Backups Great Again!

In some DBA circles, backups are just as popular as politicians! However, recoverability is the most important task for database administrators.  While SQL Server 2017 added so many great...