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
Free Microsoft Icons for Blogging and Presentations

Free Microsoft Icons for Blogging and Presentations

When designing presentations or writing blog posts, I try to use good looking images whenever possible. When mentioning Microsoft technologies, quality copies of logos or icons are really nice to have, though not always easy to find. Image searches often provide results, but the legality of using images found via that method is questionable. Thankfully, Microsoft provides a collection of high quality images just for this purpose! Check out the¬†Microsoft Azure, Cloud and Enterprise Symbol / Icon Set! This really is a great collection of symbols and icons, with many available in vector format as SVG. If you're not familiar…
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

Spice Up Your Linux Demos With PuTTY’s “Presenter Mode”

If you've done any amount of work in Linux from Windows, chances are pretty good you've used PuTTY at some point. PuTTY is a free and open-source terminal emulator that supports a variety of protocols, including SSH. I've been using it since college and have always been very happy with it. It's free, it's tiny, and it just works. With the advent of SQL Server 2017 on Linux I find myself using it rather frequently once again, but this time around I'm not just using PuTTY for myself. Now I'm trying to take screenshots of it for slide decks, and…
Read More

Video: SQL Prompt Execution Warnings

A while back, I wrote about how SQL Prompt now includes execution warnings and how useful I think that feature is. It's saved my bacon several times now, including just last week! I'm now happy to announce that I've recorded a demo video of this feature for Redgate's series of #SuperSQLTips for SQL Prompt. Be sure to check out my video, as well as the rest of the series - there's some super-helpful stuff in there!  
Read More