I’ve been meaning to write this post for a while now, nice and simple, just want to list the tools that I use on a day-to-day basis and hopefully a couple of them may be new to someone out there. Btw – if anyone uses anything else regularly and thinks I should be, let me know!
So first off has to be SQL Server Management Studio. There are other applications out there that can be used to administer/query SQL Server but I’m yet to find one that beats SSMS. Sure, it has it’s problems but for ease of use and the sheer amount of plugins available, I can’t see myself ever using anything else (thankfully it’s now available separately from SQL Server itself, how long did it take Microsoft to do that??).
Here’s the plugins that I have (they’re all free ‘cos I’m cheap): –
SQLSentry Plan Explorer
Everyone should have this installed, if you don’t…go install it now. Seriously, do it now.
RedGate SQL Search
Great tool for finding objects in your SQL instances. Don’t use it that much but it’s awesome to have already there when needed.
To be honest, I only ever use the the option to format SQL on a regular basis and if you only want that you could be better off downloading the Poor Man’s T-SQL Formatter. However the option to restore previously closed tabs has been a lifesaver in the past.
Here’s some of the other tools I use on a daily basis (again all free, did I mention that I’m cheap?): –
Edit – BeyondCompare isn’t free, you have a 30 day free trial and then it’s $30 (well worth it)
Good RDP tool, I admit that I haven’t really tried any others as this does exactly what I need
I love this tool. I really love this tool. If you’re not using it, go and download it now. Yes it’s an application launcher it’s also much more. I use it as a app launcher but also to search for files/folders and run .bat scripts that perform maintenance tasks on my laptop. Very cool, go and download it.
For moving files around, I can’t recommend this enough. Loads of options, easy to use and navigate. There’s hundreds of multi-pane file explorers out there but I’ve found that this one has the best user experience (not that I’ve tried all of them mind).
If you have to compare scripts, this is a life saver. I often have to review changes being made to stored procedures this tool easily allows me to see the differences between the existing and new code. This has saved me hundreds of hours (not exaggerating).
Thanks for reading!