PASS Summit Speaker Idol 2018: Part 1: The Lyrics & Video!

11 November 2018 - Most Valuable Yak (Rob Volk)

HOLY COW!! I was once again selected to participate in Speaker Idol at PASS Summit, and I advanced to the final! Many thanks to PASS for providing the Speaker Idol sessions, and even more thanks to Denny Cherry for originating, arranging and hosting the event for all these years.

Running GO as a Windows Service

17 July 2018 - Bill Graziano

Checklist for successfully running a GO executable as a Windows service

Send SQL Server Extended Events to Logstash (ELK)

13 June 2018 - Bill Graziano

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

SQL Server Extended Events in Production

16 May 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

Is It SQL - 1.0.28 now with better AG backups

15 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.

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

SSMS Tools Pack 4.7 is out with new features (Expand SELECT *, Find Item in Object Explorer), and a few bug fixes

28 March 2018 - Mladen Prajdić

SQL Editor Plus New: Expand SELECT * to show columns from the tables, views, UDFs, CTEs, etc used in your query. New: Quickly find an object in Object Explorer by pressing F12.

SSMS Tools Pack 4.5 is out with full support for SSMS 17 and various feature improvements.

11 October 2017 - Mladen Prajdić

Full support for SSMS 17 All reported issues during the beta support have been resolved. Connection Coloring Connection Coloring is now improved by coloring the server/database in Object Explorer as well.

Get a Phone Alert When a Query Finishes

5 October 2017 - 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

PASS Summit Speaker Idol 2017

25 September 2017 - Most Valuable Yak (Rob Volk)

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.

Is It SQL - 1.0.27

27 July 2017 - Bill Graziano

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

Is It SQL has an Admin GUI

11 May 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

Is It SQL build 24 shows missing backups

20 April 2017 - Bill Graziano

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

Configuring MSDTC Across Domains

31 December 2016 - 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

Is It SQL now shows Availability Groups

19 December 2016 - Bill Graziano

The latest release of Is It SQL is out and includes a variety of features.  I’d like to start with some screen shots of previous features.  First up is database mirroring.  You can see the mirroring status of a database when looking at the databases for a particular server.

SSMS Tools Pack 4.2 is out with beta support for SSMS 17 RC1, new features and minor bug fixes.

28 November 2016 - Mladen Prajdić

Beta support for SSMS 2017 RC1 Beta support for SSMS 17 RC1. Due to beta status this might have various bugs. Since SSMS 17 RC1 has just been released and is not recommended for production use the SSMS Tools Pack for it might run into various issues as well.

Database Mirroring in Is It SQL

10 November 2016 - Bill Graziano

Release 1.0.22 is out and available at the Is It SQL home page.  The biggest feature here is database mirroring. 

There are two ways to see database mirroring.  The first is on a server page it will show the databases that are mirrored.  There is also a global

My Statement of Support of Wendy Pastrick for the PASS Board

4 October 2016 - Denise McInerney

As part of the PASS Board election process community members can provide statements of support that are included in a candidate's application. I was pleased to provide such a statement on behalf of Wendy Pastrick.

Tagging Servers in Is It SQL

20 September 2016 - Bill Graziano

Tag-pageRelease 1.0.20 is out.  You can download it from my corporate site at http://www.scalesql.com/isitsql/. This release adds a beta feature to allow you tag servers and then filter the list by tag.

Instructions for enabling beta features are available when you sign up for

IsItSql Shows Databases

30 August 2016 - Bill Graziano

You can download the latest build of Is It SQL from my consulting site.  You can now view the databases on a server.  And you can click on a column header to sort that column.

database-page

And no, my fantasy baseball team in 2015 didn’t do very well.  Unfortunately this

IsItSql - 1.0.18

4 August 2016 - Bill Graziano

This release includes a few minor bug fixes and smaller enhancements.  Thanks to everyone that tried it out and reported back.  At the bottom of the README.html I include my email address if you’d like to provide feedback.  I’d love to hear what you like or what

- Advertisement -

Bloggers

Most Valuable Yak (Rob Volk)
11 November 2018

Bill Graziano
17 July 2018

Mladen Prajdić
28 March 2018

Denise McInerney
4 October 2016

Phil Streiff
25 February 2015

Dan Guzman
23 December 2014

Tara Kizer
7 October 2014

Ajarn Mark Caldwell
21 October 2013

Peter Larsson
27 July 2013

Mike Femenella
14 July 2013

Luca Zavarella
12 June 2012

Jeff Smith
11 May 2012

Geoff N. Hiten
3 April 2012

James Wang
4 October 2011

Travis Laborde
28 July 2011

Chris Miller
18 May 2011

Brett Kaiser (x002548)
29 October 2010

Jeff Maass
26 June 2010

Aldrich
11 March 2010

Derek Comingore
11 March 2010

Jon Hermiz
17 November 2009

Davide Mauri
31 August 2009

Dinakar Nethi
20 August 2009

Joe Webb
23 June 2009

James Nix
20 August 2008

byrmol
3 February 2008

Jen
23 November 2007

Derrick Leggett
4 December 2005

Guillermo Sornoza
8 September 2005

Tim
23 December 2004

Justin
12 November 2004

Damian Maclennan
19 August 2004

Jay R
27 February 2004

Lance Harra
16 November 2003

macka
28 October 2003