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

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

sp_Blitz for All Servers

Are you a Microsoft SQL Server DBA managing one or more servers?  Then you should know about the First Responder Kit from Brent Ozar Unlimited.  This is a free...

Database Fundamentals #27: Creating a Primary Key in the Table Designer

Defining primary keys is the hardest part of the operation. You will need to work very closely with the business in order to define exactly what column or columns...

SQL Server principals – Server Roles

[MSSQLFUN & Decode ITeS becomes a family of 1700 individuals across the globe. Please join us on Facebook & YouTube.] Server Roles: Server roles are security principals to control access of...