Monthly Archives: September 2025

Sparse Columns Can Use More Space: #SQLNewBlogger

I saw this as a question submitted at SQL Server Central, and wasn’t sure it was correct, but when I checked, I was surprised. If you choose to designate columns as sparse, but you have a lot of data, you … Continue reading

Posted in Blog | Tagged , | 3 Comments

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 skill. That’s been a lot of what I try to inspire … Continue reading

Posted in Blog | Tagged , , | 1 Comment

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 some information from my SQL Server instance. This post walks through … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Requiring Technical Debt Payments

I was working with a customer recently that is trying to improve their processes. This was a large company, over 100,000 employees, though most of them aren’t in the technology area. However, across many divisions and groups, there are a … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Requiring Technical Debt Payments