Home 2025

Year: 2025

SQL Server 2025 Developer now supports Standard

This is just a quick post, but something I noticed when installing SQL Server 2025 Preview today; SQL Server Developer now has two options: Enterprise Developer and Standard Developer. Honestly, this is great to finally see in SQL Server; as someone who works with a lot of Production servers using Standard Edition, being able to set up future Development environments that only support Standard feature is great. As an example, honestly I’ve lost count how many times I’ve been stung by lack of support for Meta-only updates in Standard, and a deployment has taken significantly in Production. This is a…

Continue reading

A simple Calendar Table example

A tool I find I often tell people that really should have already implemented in their environment is a Calendar table, however, something I don’t actually have to show them is my own example. As such I felt it time to provide one, so that next time someone asks me "what should it look like", I can demonstrate it. The Calendar Table I have in my Utility database is actually all most entirely made up of computed columns; the only column that isn’t is the Calendar Date. With the exception of the name columns as well, all the columns are…

Continue reading

Azure Data Studio is being retired and I am concerned…

Some of you may, or may not know, Microsoft announced the deprecation of the Azure Data Studio (ADS) on 06 February, with support ending next year on 28 February. For those of using ADS Microsoft recommends migrating to VSCode and using the mssql extension. Honestly, I’m really concerned about this. I tried the mssql extension for VSCode (mssql going forwards) some time ago, and compared to ADS it was incredibly feature lacking. A lot of stuff I want to do as a DBA was completely missing, so I went straight back to ADS and didn’t look back. I like ADS,…

Continue reading