T-SQL Tuesday 84: Exploring DBA Tools or: How I Learned to Stop Worrying and Love PowerShell

@sqlbek (Andy Yun) posted a challenge for T-SQL Tuesday 84, and encouraged people thinking about becoming a speaker to write about their experience giving their first talk, a topic they wanted to present on in the future, or even on starting the road to creating their blog and establishing themselves in the SQL space.

I wanted to flesh out an idea I have had for a first talk, which is about my experience with dbatools.io and introducing a production DBA to the value of PowerShell.

TIL – July 7 2016

I am starting a new mini-series called “Today I Learned” to start blogging a bit more about simpler topics, not so much about things that will definitely help you as much as things that helped me (and I will probably forget about in 3 months.)

Today’s topic is about how to get VS Code working with PowerShell 2.0.

Using Flamegraph.pl to create Flame Graphs for SQL Server Profiler, Extended Events, and more

A friend of mine was recently discussing using Flame Graphs in a project of his, and it inspired me to see how I could abuse the format to present a visual model of SQL execution. Originally I had thought of building my own interface, but apparently the author of the above site also maintains a […]

@mobileck Are there any certs or books you’d recommend to aide in my quest to become a DBA?

It depends on if you are more of a production, developer, or devops DBA, but I would definitely read everything below: Guide for the accidental DBA Brent Ozar ULTD 6 month training plan SQL Server Query Performance Tuning http://www.brentozar.com/blog/ Aaron Bertrand Adam Machanic sqlsoldier MCSA Cert 461/462 for basics.

Running SQL Queries On Multiple Servers At Once Using Registered Servers In SQL Server Management Studio

I just came across a situation where I was looking at long running queries across a few production servers, I wanted to quickly and easily run my query across them all to make sure that I wasn’t missing a problem on each server where a user had left a specific query for a looong time. […]