Tuning Azure SQL Elastic Pools

The below image is a beautiful picture, now it could be worse. The red line and the green line could peak at the same time and for a very...

Database Recovery Monitoring with XE

Database recovery (crash recovery) is a nerve wrenching situation under the wrong conditions. It can be as bad as a root canal and just as necessary to endure that...

Notes from SQLSaturday Tampa 2019

Late notes! Great signs at the event, all hand written on flip chart paper. Cheap and effective, the “different” nature of the signs made them easy to spot Rooms...

Power BI Now Has Keyboard Accessible Visual Interactions

The March 2019 release of Power BI Desktop has brought us keyboard accessible visual interactions. One of Power BI’s natural...

SSIS and Data Quality Webcast

On Thursday the 2nd of May, I’ll be giving a webcast for MSSQLTips.com about data quality and SSIS. The abstract: SQL Server Integration Services (SSIS) has been around for...

Uppercase All String Columns (and in a Single Query!)

(last updated: 2019-03-21 @ 15:00 EST / 2019-03-21 @ 19:00 UTC )

Intro
The other day, Steve Jones published a short post with a quick...

Using a home-grown Azure Blob Storage solution for SQL Server backups

I’m here for the small organizations, the shops that can’t afford expensive solutions to maintain their environments. I’m here for them because that’s me: the one-person consultancy. I’ve built...

Data Type Precedence and Implicit Conversions

Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...

Data Type Precedence and Implicit Conversions

Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...

Delete activity in Azure Data Factory - Cleaning up your data files

(2019-Mar-20) File management may not be at the top of my list of priorities during data integration projects. I assume that...