Checklist for successfully running a GO executable as a Windows service
17 July 2018 - Bill Graziano
xelogstash is a great way to send SQL Server Extended Events to Logstash and Elastic Search and Kibana (ELK)
13 June 2018 - Bill Graziano
I have finally jumped on the Extended Events bandwagon. It was tough to pry Trace and Profiler from my cold, legacy hands! But I'm mostly there. I'm still working on a good way to hook up ClearTrace to these things. It might be as simple as requiring you to pull
16 May 2018 - Bill Graziano
It's finally time to push another release of Is It SQL out the door. This has a few big features I've been working on.
First, it handles remote Availability Group backups properly. In an AG, you can run a backup on a secondary node. IsItSQL now finds backups on
15 May 2018 - Bill Graziano
Today, through various snafus and situations, I found myself waiting a LONG time for a lock to clear up. Here's how I got an alert to pop up on my phone (an iPhone) when that stupid SPID finally rolled back.
You'll need to have database mail configured and ready to
5 October 2017 - Bill Graziano
I’m extremely honored to have been chosen once again to participate in Speaker Idol at PASS Summit 2017! I’m in deep trouble too, considering the contestants this year: https://www.dcac.co/syndication/your-pass-summit-2017-speaker-idol-contestants-are
I’ve previously blogged about why Speaker Idol is such a great opportunity: http://weblogs.sqlteam.com/robv/archive/2015/09/28/pass-speaker-idol-2015.aspx
…and have shared my notes and feedback from the first time I’ve participated: http://weblogs.sqlteam.com/robv/archive/2015/10/24/notes-from-speaker-idol-2014.aspx
…and my good friend Shabnam wrote about her experience in 2016: https://shabnamwatson.wordpress.com/2016/11/10/pass-summit-speaker-idol-2016/
…and for those interested you can see the Speaker Idol 2015 presentations on YouTube:
The 2016 Speaker Idol videos are available on the PASS Summit recordings package for purchase or download from PASS. If you attended Summit that year you should be able to view them. Also check with your local SQL user group, if they are a PASS Chapter they probably have the videos available.
Denny Cherry has a video chat for contestants with a lot of great advice: https://www.youtube.com/watch?v=8ZRqn9V9JSQ
...and there's also this really helpful commentary by some previous judges: https://youtu.be/Lz_4BTsI3i4
If all of this seems overwhelming, don’t be alarmed! There’s a few key things I’d recommend focusing on that have helped me and others:
As a rehearsal aid, or even as your presentation method, consider the Ignite Talk format: http://www.ignitetalks.io/
Ignite talks are 5 minutes (the length for Speaker Idol presentations) but the slides automatically advance every 15 seconds (20 slides total). It’s a great format to help with timing, and it keeps the presentation flowing. You can always tweak your timing (either duplicate a slide you need more time for, or simply adjust as needed as long as you end at 5 minutes). If nothing else it’s a good starting point if you’re adjusting a longer presentation or starting fresh with new material.
If you really dig into the advice and videos you’ll think that using ZoomIt or similar tools is clichéd and taken for granted. It’s not. Slide visibility is a consistent complaint at PASS Summit and you DO NOT want to be the lone Speaker Idol contestant with small fonts. I prefer NOT using ZoomIt. I increase the PowerPoint font sizes, and install SSMS 2016 or higher which has built-in zooming and presentation modes. I also avoid using laser pointers, instead using some underlining, color highlights or basic animation to emphasize something on the slides. Shabnam’s blog has some advice on font sizes that you should follow.
Like the old saying “How do you get to Carnegie Hall?”, practice makes perfect. If you read my blog notes from 2014, I did much better in my 2nd round because I took a few hours to run through my presentation entirely for timing (and just before the final round too!) If you’re worried that the presentation may become rote or stale from multiple deliveries, I’m confident that it won’t, because you’ll have an audience and you will react differently in their presence. The rehearsal is there to make you comfortable with the material and the timing. It also protects you against technical difficulties, because:
I had microphone difficulties in 2015 but I moved forward through the presentation despite them, and the judges were complimentary about it. The winner for Speaker Idol 2016, Peter Kral, had a serious technical issue crop up in his first round. He modified his presentation in the Final round to avoid the problem, and he won!
Handling problems is an important skill to have in all facets of life. This is where rehearsal comes in; you should actually rehearse UNTIL you encounter a technical difficulty, so you learn how to deal with it.
Also, if you can present at a user group or SQL Saturday event that offers Lightning Talks, do so! SQL Saturday Oregon is scheduled the weekend prior to PASS Summit, and they offer a Lightning Talk slot for speakers. This is a great way to shake out any last bugs in front of an audience and to get feedback from them.
Finally, you should especially take time to rehearse at PASS Summit in the session room where Speaker Idol will be held. If you get to Seattle before Wednesday you should be able to check the room out, and possibly rehearse or at least walk around the stage to get the feel of it. This has been an invaluable help to me and I’ve done it every time I’ve participated. At the very least you should do a technical check of your laptop with the video and audio connections. This is the last “unknown” factor in your presentation, and the easiest and last way you have to fix it before the big event. As long as security doesn’t throw you out, stay there and practice as long as you can!
Even if it’s not your turn, you’ll get preliminary feedback from the judges and can tweak your presentation beforehand, because you should:
I can personally vouch for this as it got me to second place in 2014. You can also see its effect in David Maxwell’s presentation in 2015, which contributed to his ultimately winning that year. Which brings me to:
The 2015 Speaker Idol winner was a wildcard, and I placed 2nd as a wildcard in 2014. There have also been dropouts each year Speaker Idol has been held (and some last-minute replacements for 2017), so your chances of advancing are much better than would first appear. Don’t accept lack of placement after the first rounds as a failure; you never know what might happen, and even if you don’t advance:
This is the most important aspect of Speaker Idol, regardless of who wins. 400-500 people submitted to speak at PASS Summit in 2017, less than 200 were chosen, and probably only 100 if you exclude Microsoft speakers. At least 6 non-finalists have spoken or will be speaking at PASS Summit since presenting at Speaker Idol.
As I said previously, it’s a no-lose situation. Congratulations and good luck to all Speaker Idol 2017 contestants!
25 September 2017 - Most Valuable Yak (Rob Volk)
I'd like to tell you this release has some great unifying theme. It doesn't. It's just a bunch of things I felt like fixing.
But let's start with tags. That's what I originally wanted to focus on for this release. The first change is to separate out the user-tags from
27 July 2017 - Bill Graziano
It's finally time to push Is It SQL 1.0.25 out the door. I sent it to the newsletter subscribers last week and we haven't discovered any problems yet.
Before upgrading, please read the README in the zip file! Especially if you have custom connection strings and this is
11 May 2017 - Bill Graziano
The latest release of Is It SQL now shows missing backups.
The top section gives you a summary of all servers with missing backups and the bottom section lists each individual database that doesn't have a good backup. Right now a "good" full backup is defined as being a
20 April 2017 - Bill Graziano
One of my clients has applications that use MSDTC. We’re spinning up a SQL Server 2016 Availability Group to take advantage of the MSDTC support it introduced. Most of these distributed transactions take place across linked servers. And of course the new servers are in a new domain with
31 December 2016 - Bill Graziano
- Advertisement -
Most Valuable Yak (Rob Volk) 
Mladen Prajdić 
Bill Graziano 
Phil Streiff 
Denise McInerney 
Tara Kizer 
Jeff Smith 
Dan Guzman 
Ajarn Mark Caldwell 
Peter Larsson 
Mike Femenella 
Luca Zavarella 
Geoff N. Hiten 
Blog Author 
James Wang 
Travis Laborde 
Chris Miller 
Brett Kaiser (x002548) 
Blog Author 
Jeff Maass 
Derek Comingore 
Jon Hermiz 
Davide Mauri 
Dinakar Nethi 
Joe Webb 
James Nix 
Blog Author 
Duane Dicks 
Blog Author 
Derrick Leggett 
Damian Maclennan 
Kristen Baker-Munton