Adding the Constraint Name to the PK at the End of Create Table–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Deploy the Database First

Steve Jones thinks it's important that we be able to deploy almost any changes to our databases without breaking applications.

The Data Catalog from Redgate

One of the important tasks that is needed for any organization that wants to better protect their sensitive data is...

Code Reviews

This week Steve Jones asks about a concept that he used early in his career: code reviews. It's a good practice, but it seems as though it's fallen out of favor with many developers.

The Year in Review Webinar–Dec 18

Join me for our Year in Review Webinar next week, Dec 18, at 4pm GMT. I’ll be joining Kendra and...

TDE and DDM

Someone asked a question about TDE (Transparent Data Encryption) and DDM (Dynamic Data Masking), which are two different technologies that...

The Default Frame for Window Functions

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Lessons from the Phoenix Project–Leave Slack

Not @Slack, but slack time, time when you aren’t buried on a particular project.
In the book, The Phoenix Project, the...

T-SQL Tuesday #109–Influence

This month’s T-SQL Tuesday host is Jason Brimhall. He asks everyone to write about influence, which is something that I...

Range arguments