Category: Tools

Deepthi Goguri shares a list of useful tools for SQL Server work, presentations, and recordings:

1. OBS Studio: This is a free and open source software for video recording and live streaming. I mostly prerecord my sessions using OBS. I personally love this tool as we have pretty much good content on YouTube that teach us how to use this tool.

2. SentryOne Plan Explorer: Plan explorer is an amazing tool to analyze your execution plan and tune your queries very quickly. Its completely free.

Click through for the full list of 10.

Comments closed

Mikey Bronowski shares some tool recommendations:

The main tool that I use every day is one I couldn’t live without: Todoist. For work related tasks, personal tasks, and just organizing life in general, Todoist is a to do list app that I’ve relied on to keep my sanity. If I think of something I need to do it immediately goes in the Misc category and I schedule it later. If I think of a blog post idea, it goes in the Ideas column of the Blog Topics category (and if it’s deemed a good idea will eventually go onto To Do, In Progress, and Complete). The free version has more than enough for my needs but if you want additional features or are trying to use it with a team there is a paid version available.

I’m a big fan of Todoist for reminding me what to do, as well as calendar entries for structure and making sure I limit my todo list size.

Mikey also provides great advice: create your own tools. They don’t have to be fancy, so long as they solve relevant problems.

Comments closed

Chris Yates shares a list of useful tools:

Throughout my career, I’ve worked for companies that have allowed me to utilize some pretty nice tools. Whether they are vendor or community-related there are a plethora of options for all platforms and prices.

Some of the ones that I have a special place for can be found here, but I’ll specifically name a few below:

Click through for a structured approach to tooling.

Comments closed

Steve Jones shares some tooling recommendations:

It’s blog party week for T-SQL Tuesday, and I think this is a good choice for a topic. The host this month is Mikey Bronowski, and his invitation is on tools. I work for a tools vendor, and I’ve used a lot of them in my life, so I want to share what I think in 2021. I’ll also say that Mikey has a good list in his invitation of what he uses. I especially like his use of PoSh things and Greenshot.

I’ve going to tackle this in a couple ways as I really have two parts of my job here, so I’ll look at tech tools and then productivity tools.

Read on for Steve’s list.

Comments closed

John McCormack reviews several community tools for SQL Server:

Statistics Parser is a web page which allows you to paste in the statistics time,io output from the SSMS messages tab, and it formats into neat tables showing how much IO happens for each table. It is immediately easier to read and you get a handy % column on the right hand side showing you which tables are being read the most. I find this really useful for query tuning because it lets me know where my biggest pain points are. For complex queries, which touch a lot of tables, it just makes it easy to see at a glance where you should initially focus your attention. It also shows worktable and workfile tables which serves as a handy hint that tempdb is in play.

John lists a half-dozen but really drives in on Statistics Parser.

Comments closed

Eitan Blumin shares some recommendations of tools:

While I do feel that the tools that make my job the most awesome are those that help me with productivity, this month’s topic is a bit broader. Most of these, though, are widely known, so I’m not going to go into much detail about them.

Click through for Eitan’s suggestions. I use the majority of these (or at least some alternative) but there are some new and interesting ones for me.

2 Comments