Password Guidance

Passwords are essential and also a problem in many organizations. Guidance has changed over the years and Steve has a few thoughts on what's recommended today.

T-SQL Tuesday #190–Mastering a New Technical Skill

It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great invitation that is near and dear to my heart: mastering a new or existing technical...

Change Tracking Data Retention Options

Getting Started with the MSSQL AI Agent in VS Code

Recently I was working in VS Code and I saw a walkthrough for the new Copilot chat features. I decided to give those a try in trying to get...

Requiring Technical Debt Payments

Steve found someone using an interesting approach to get developers to address some technical debt.

Learning a New Language

Steve is using AI to help him learn new things.

Advice I Like: Praise

Don’t reserve your kindest praise for a person until their eulogy. Tell them while they are alive when it makes a difference to them. Write it in a letter...

Copying Production Schema

Guidelines and Requirements

We have some requirements that we meet a particular setting or value, but often we have guidelines and recommendations. Do you know the difference?

Adding a Named Default Constraint to a Table: #SQLNewBlogger

As part of a demo recently I was adding a default value to a new column with a simple DEFAULT and a value. Under the covers this creates a...