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

Making Databases Personal

If you can use a database to create automation routines to help sustain your work life, you can certainly do the same to sustain your personal life. Databases are...

Making Databases Personal

If you can use a database to create automation routines to help sustain your work life, you can certainly do the same to sustain your personal life. Databases are...

T-SQL Tuesday #113 – What Do I Use MY Databases For?

This month’s T-SQL Tuesday blog is brought to us by Todd Kleinhans (b | t) and this month topic is about what you use databases in your personally life. ...