Running GO as a Windows Service

Checklist for successfully running a GO executable as a Windows service

17 July 2018 - Bill Graziano

Send SQL Server Extended Events to Logstash (ELK)

xelogstash is a great way to send SQL Server Extended Events to Logstash and Elastic Search and Kibana (ELK)

13 June 2018 - Bill Graziano

SQL Server Extended Events in Production

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

Is It SQL - 1.0.28 now with better AG backups

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.

Backups

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

Get a Phone Alert When a Query Finishes

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

PASS Summit Speaker Idol 2017

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:

https://www.youtube.com/watch?list=PLoGAcXKPcRvbJ5ge4J2DHSleRy4OjSlJw&v=Koz-2S3sPso
https://www.youtube.com/watch?list=PLoGAcXKPcRvbJ5ge4J2DHSleRy4OjSlJw&v=83sj1ZMp6vs
https://www.youtube.com/watch?list=PLoGAcXKPcRvbJ5ge4J2DHSleRy4OjSlJw&v=SpYTZ2GCVWI
https://www.youtube.com/watch?list=PLoGAcXKPcRvbJ5ge4J2DHSleRy4OjSlJw&v=q5cDX_eHa-I

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:

  • The 5 minute time frame is the killer feature of Speaker Idol. The more attention you pay to meeting this limit the better you’ll do
    • Aim your rehearsal to hit between 4:30 – 5:00, 4:45 is best. This leaves some buffer time for you to handle unforeseen circumstances or technical difficulties.
    • Don’t go below 4:30 when you actually present, you can add a summary or a simple item to fill the remaining time instead.

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.

  • Zoomit!

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.

  • Rehearse, Rehearse, Rehearse!

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:

  • Handling and recovering gracefully from mishaps counts in your favor

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!

  • Attend as many Speaker Idol sessions 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:

  • Incorporate all feedback you get from the judges

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:

  • Wildcard candidates have the same chance as first-round winners!

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:

  • You spoke at PASS Summit. Congratulations!

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!

-Rob

25 September 2017 - Most Valuable Yak (Rob Volk)

Is It SQL - 1.0.27

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

Is It SQL has an Admin GUI

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

Is It SQL build 24 shows missing backups

The latest release of Is It SQL now shows missing backups.

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

Configuring MSDTC Across Domains

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 -

Bloggers

Most Valuable Yak (Rob Volk) [56]
11 November 2018

Mladen Prajdić [226]
28 March 2018

Bill Graziano [230]
31 December 2016

Phil Streiff [14]
14 December 2016

Denise McInerney [31]
4 October 2016

Tara Kizer [166]
4 April 2016

Jeff Smith [155]
31 August 2015

Dan Guzman [42]
23 December 2014

Ajarn Mark Caldwell [209]
20 October 2013

Peter Larsson [203]
27 July 2013

Mike Femenella [5]
15 July 2013

Luca Zavarella [10]
12 June 2012

Geoff N. Hiten [52]
3 April 2012

Blog Author [0]
18 November 2011

James Wang [4]
3 October 2011

Travis Laborde [45]
28 July 2011

Chris Miller [76]
18 May 2011

Brett Kaiser (x002548) [89]
17 December 2010

Blog Author [0]
28 November 2010

Jeff Maass [10]
26 June 2010

Aldrich [19]
11 March 2010

Derek Comingore [49]
11 March 2010

Jon Hermiz [18]
28 November 2009

Davide Mauri [49]
30 August 2009

Dinakar Nethi [8]
20 August 2009

Joe Webb [85]
23 June 2009

James Nix [10]
20 August 2008

Blog Author [0]
8 May 2008

Jen [3]
3 February 2008

byrmol [77]
3 February 2008

Duane Dicks [0]
7 December 2007

Blog Author [0]
11 October 2007

Derrick Leggett [28]
5 December 2005

Damian Maclennan [43]
19 August 2004

User2 [0]
23 September 2003

Demo [0]
23 September 2003

Kendal [0]
1 January 2003

Kristen Baker-Munton [0]
1 January 2003