Using 3rd party tools. T-SQL Tuesday #119

1

October 8, 2019 by Kenneth Fisher

T-SQL TuesdayIt’s that time again! Alex Yates (b/t) has asked us to discuss a time in tech when we’ve changed our mind. I decided in the end to go with something I’m in the process of changing.

20 years ago
Third party tools are great and all but I don’t like using them. They take time to learn and I’m never sure if I’ll have them available at my next job. I’d rather take the time to learn how to do it using the native tools I know I’ll have wherever I go.

Current
I’ll be honest, 20 years younger me wasn’t completely wrong. I still feel strongly that I need to know the native tools (SSMS, DMVs etc). I think it gives me a leg up on understanding what’s going on and there aren’t always 3rd party tools available. That said, I’ve realized/learned/reevaluated/had beaten into me, that 3rd party tools are capable of doing things I just can’t. Not because I can’t learn how, not because I don’t understand a lot of what they are doing, but because I don’t have the time or resources to build what they have. From interfaces, to storing information, to processing information, etc.

I won’t always have a specific tool available, although I might, but the more tools I learn, the more options I have. If I know 2 or 3 of the major tools then I have more options, it’s more likely one will be available. And if it’s not? More things to learn!

Another benefit of 3rd party tools? If you work in a team it becomes far easier to share information. “Go take a look at Computer XYZ at 4pm yesterday in Sentry1. See that blip? What do you think?” You can even build processes and documentation for your team around these tools to make life (and particularly on-call) easier.

Summary
Changing your mind isn’t a bad thing. We are never who we were 5 years ago, 6 months ago, or even yesterday. Keep an open mind, be willing to change, and always be learning!

One thought on “Using 3rd party tools. T-SQL Tuesday #119

  1. You should have a look at http://www.sqlplus.net – it’s a SQL first ecosystem ORM and leverages the skills of the SQL Professional – https://vimeo.com/358982420

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,084 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: