Saving to Excel in Azure Data Studio

Saving to Excel in Azure Data Studio

Azure Data Studio continues to grow on me. I previously wrote about getting my favorite keyboard shortcuts to work, which made me very happy, but now for a feature I love even more - saving result sets to Excel! Yes, I know, spreadsheets can be evil. They can even be places where good datasets go to die, but it's important to remember that they're a necessary evil. Sometimes you just need a result set in a spreadsheet, whether you want it to be in one or not. In SQL Server Management Studio, there's no single-step way to save a result…
Read More
Getting SSMS Keyboard Shortcuts in Azure Data Studio

Getting SSMS Keyboard Shortcuts in Azure Data Studio

Azure Data Studio (formerly Microsoft SQL Operations Studio) is Microsoft's new "cross-platform, lightweight tool for modern database development and operations." It is not a replacement for SQL Server Management Studio (not yet anyway), but I can see it becoming one over time. It is under constant development and improvement, and if you tried it back when it was first released and didn't like it, I urge you to give it another spin. I find myself using it more and more because I really like the feel of it. One thing about Azure Data Studio I'm not too keen about, though,…
Read More