New article

It's worth the time

ANSI PADDING

https://learn.microsoft.com/en-us/sql/t-sql/statements/set-ansi-padding-transact-sql?view=sql-server-ver16

Shared Work Spaces: Hell, Heaven, Both?

I've just finished working in my fourth shared work space. I am not a fan. The endless hallways with all these little glassed in rooms where I can see everyone, and everyone can see me, are not my favorite places. I can see white boards with content that maybe I shouldn't be seeing. There are […]

Understanding Shared Access Signature and Access Policy in Azure Storage

This article covers how you can give access with a shared key to Azure Storage Accounts and apply a policy for how users can access the files.

Dealing with Transaction Log Growth

Introduction Relational databases are designed to track changes introduced to a database by data modification language (DML) commands. The fundamental reason for this construct is to ensure that changes are durable and that they can be rolled back reliably. The typical DML command used in SQL are INSERT, UPDATE and DELETE. When INSERT introduces new […]

Will Hosted Services Take Your Job?

This week I was honored to be able to attend, and present a session at, SQLDay in Wroclaw Poland. I fell in love with Poland the very first time I attended this event, so I look forward to any time I can go again. This year, Pavel Potasinski presented the keynote: The Evolution of the […]

Standards Matter

A short story about why standards matter and where they can help you with limiting the off hour calls from others in your organization.

Scalar function string replacement

Moving Away From MySQL

A developer has some harsh things to see as he leaves the MySQL team. Is he right?

Virtual Events Are Here To Stay

This week was the MVP Summit. As was the case for the last couple of years, the event was entirely virtual. We were shown a bunch of new and interesting things by Microsoft. We were able to talk to each other and to the engineers at Microsoft. I'm honored that I've been an MVP and […]