Press "Enter" to skip to content

Category: T-SQL Tuesday

Power BI Tools

Published 2021-02-10 by Kevin Feasel

Benni De Jagere shares a list of useful tools around Power BI:

The External Tools (and the Enhanced Metadata format enabling it) allow end users of Power BI Desktop to call on custom built applications, scripts, .. to augment their developer/designer experience. These days, there’s over 40 (I stopped counting) external tools available, each with their own use case and focal area. When showing off some of the capabilities to my clients, it amazes me to see how quickly they pick up these things, and start building out their own ways of working.

Depending on the client, their IT Compliancy rules, the business and technical requirements, my actual tool belt tends to vary. Not every IT organisation allows user to freely install an application, digitally signed or not, so this is definitely an important one to take into your conversations early on.

Read on for Benni’s choices.

Comments closed

Tools of the Trade

Published 2021-02-10 by Kevin Feasel

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

Tools for SQL Server Specialists

Published 2021-02-10 by Kevin Feasel

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

Technical and Productivity Tools

Published 2021-02-09 by Kevin Feasel

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

Community Tooling for SQL Server

Published 2021-02-09 by Kevin Feasel

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

Useful Tools for Blogging and Productivity

Published 2021-02-09 by Kevin Feasel

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

T-SQL Tuesday 134 Roundup

Published 2021-01-19 by Kevin Feasel

James McGillivray summarizes the results from T-SQL Tuesday #134:

When I volunteered to host a T-SQL Tuesday, I had a very different topic in mind. However, the incredible events of the last year, and in particular, the immense pressure that my wife faced at work, made me realise how important it is to have ways to take breaks, both mental and physical. And while we were away in December, and we both recharged, I thought it would make a good topic for this event. It was wonderful to see the response from the #sqlfamily to my invitation, and by my count 29 different people contributed to the blog party.

I’ve tried to group posts with similar themes in this summary, and since some posts fall into multiple categories, I may mention a single post more than once. Links on names point to Twitter handles, links on descriptions point to the respective blog posts.

Click through for a rather large roundup.

Comments closed

T-SQL Tuesday 130 Roundup: Automate Your Stress Away

Published 2020-09-22 by Kevin Feasel

Elizabeth Noble recaps T-SQL Tuesday #130:

I’m really grateful for all the bloggers that took part this month. Especially since automation has been a topic discussed before. However, it’s hard for me to get too much of my day to day work automated. And I was really looking forward to these topics so that I could learn new tasks I could automate myself. With that said, let’s see all the wonderful ideas people contributed this month. And if you’re like me, you’re going to want to put some of this automation in place as soon as possible.

Click through for 24 entries.

Comments closed

GetAllTheErrorLogs: Combining Multiple Log Sources

Published 2020-09-10 by Kevin Feasel

Aaron Bertrand has a new project:

There’s a whole lot of grunt work in there that shouldn’t have to be done by a person. I don’t think you could automate the whole thing, because it is hard to predict exactly what events will be interesting and not, but I think 90% is achievable.

A colleague mentioned that they want to build something that would help, but even when that happens, that would up in proprietary code that only helps us. I saw Drew Furgiuele’s post on Building a Better Get-SQLErrorLog, and that gave me some ideas for what I would build. After reaching out to Drew, I created a GitHub repository with a working name of GetAllTheErrorLogs. Its elevator pitch is a simple sentence:

Powershell to assemble a timeline combining salient events from Windows Event Log, Failover Cluster log, and SQL Server errorlog.

Click through for the details as well as Aaron’s current progress.

Comments closed