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