Power BI Monthly Digest – April 2019

In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI

SSMS GUI not working? Try to use T-SQL!

One of the good things, when we have new clients, is that sometimes they have needs that you never heard before. This does not necessarily mean that they are...

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