MAXDOP: not quite what you think

An important change to the MAXDOP documentation was made last week, with a good write up by Pedro Lopes (Twitter), a Program Manager on the SQL Server team at...

Daily Coping 15 Jul 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

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