Power BI Monthly Digest – July 2020

In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.

How to Spell and Capitalize tempdb for SQL Server

No matter what I write in this post, some of y'all are going to tell me I'm wrong. That's inevitable, because I'm writing about tempdb: a database so complex...

Setting up a New SQL Change Automation Project

It’s been awhile since I’ve set up a new project in Redgate’s SQL Change Automation project. I’ve mostly used this in Visual Studio, but I need to demo something...

3D Printing Ear Savers Update July 14th 2020

I’ve now been printing surgical mask straps aka “Ear Savers” since April 5th. It has been a wild journey getting started and obtaining all the supplies needed such as...

3D Printing Ear Savers Update July 14th 2020

I’ve now been printing surgical mask straps aka “Ear Savers” since April 5th. It has been a wild journey getting started and obtaining all the supplies needed such as...

T-SQL Tuesday #128: Learn From Others

Introduction This month’s T-SQL Tuesday is being hosted by Kerry Tyler. The subject is a recent mistake that was made and what was required to fix it. These don’t have to be SQL...

Ethics in Modern Data at the Houston SQL Server and BI User Groups, July 2020

On July 14, Christine and I presented at the Houston SQL Server and BI User Groups' virtual meeting. Our joint presentation is one of our favorites to present, Ethics in Modern Data. 

Thanks...

The Length Limitations of LEN()?

I was using LEN() to troubleshoot an issue I was having with a dynamically constructed string truncating while inserting into an NVARCHAR(MAX) column.  Since I know that NVARCHAR(MAX) has...

Compiling a Custom Provider and Including for Terraform Cloud

Assumptions

You are familiar with the basics of setting up Go and can run basic Go commands like go build and go install and don’t need much guidance on that...

T-SQL Tuesday #128–Learning From Others

It’s the second Tuesday of the month and time for T-SQL Tuesday again. This month I’m grateful that Kerry Tyler is hosting. I had the pleasure of sitting with...