T-SQL Tuesday #101: My Essential SQL Server Tools

Andrew Pruski, 2018-04-10

This month’s T-SQL Tuesday topic comes from Jens Vestergaard (b|t) who is asking us about our essential SQL Server Tools.

I’ve previously written about my Tools of the Trade but that was waaaay back in April 2016 and just after I published that blog, the tool that I am going to talk about here was released, Visual Studio Code.

At first I used it sparingly, mainly for when writing demos but over the last few months Visual Studio Code has become invaluable to me.

My work has a large SQL estate to look after and I’ve found SSMS very frustrating as of late. It freezes up when dealing with multiple connections so I switched to using VS Code combined with dbatools.

What’s really cool is that you can setup custom tasks to easily run code against SQL instances, I blogged about how to set that up here.

I still use SSMS when drilling into a single instance (although Operations Studio is rapidly becoming more appealing) but when I want to audit instances or deploy, VS Code is now my go-to application.

Another thing that I love is the amount of plugins available. The Docker explorer and Azure-Cli plugins are absolutely fantastic. Combine that with the fact that I’ve recently moved all my code to GitHub and VS Code has built-in source control management, I’m finding that I’m spending more and more time using the application.

I highly recommend checking it out (if you haven’t already).

Thanks for reading!





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis


1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren


1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren


360 reads