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

Concerns over AI Chat Privacy

Many of the GenAI services are using the free model of the past, where they use your data in ways you might not expect. Now, a court is ensuring OpenAI keeps your chat data around.