Enable a Named Instance to Connect on 1433

My default setup for a few years is to only use named instances, usually with a standard SQL2014 or SQL 2016 as the name of the instance. Recently, I...

Give Hugs

Stop and smell the roses. Advice from Steve today.

Message Type Validation

SQLServerCentral Design–bbPress

This is part of a series of posts that look at the changes to the SQLServerCentral design, bringing us to v3 of the site. You can see the other...

Creating a DDL Trigger

The Database Giveth and Taketh Away

A database error at Southwest Airlines confused some customers and was embarrassing. Steve worries that we might want to be more careful in the future about making database mistakes.

Using Backup Encryption with an External Certificate

Learn how to load an external certificate into SQL Server to encrypt your backups.

Can Azure Stack Reduce Software Development Costs?

Azure Stack provides a hybrid cloud infrastructure platform. Steve wonders if this really helps reduce software development costs.

dput()

Testing as another user–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is one of those things I do...