Subscribe: Thoughts on SQL Server
Added By: Feedage Forager Feedage Grade B rated
Language: English
build  cleartrace  database mirroring  database  download  error  latest  mirroring  release  server  servers  sql release  sql server  sql 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Thoughts on SQL Server

Bill's SQL Server Blog

Bill's SQL Server Blog

Last Build Date: Thu, 08 Mar 2018 18:58:49 GMT


Get a Phone Alert When a Query Finishes

Thu, 05 Oct 2017 02:48:17 GMT

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

Is It SQL - 1.0.27

Thu, 27 Jul 2017 14:00:00 GMT

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

Thu, 11 May 2017 22:59:37 GMT

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

Thu, 20 Apr 2017 11:17:00 GMT

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

Configuring MSDTC Across Domains

Sat, 31 Dec 2016 15:11:58 GMT

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

Mon, 19 Dec 2016 14:02:42 GMT

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.

Database Mirroring in Is It SQL

Thu, 10 Nov 2016 21:40:24 GMT

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

Tagging Servers in Is It SQL

Tue, 20 Sep 2016 13:40:22 GMT

(image) Release 1.0.20 is out.  You can download it from my corporate site at 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

Tue, 30 Aug 2016 15:58:42 GMT

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.


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

IsItSql - 1.0.18

Thu, 04 Aug 2016 21:44:45 GMT

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

Is It SQL?

Tue, 02 Aug 2016 13:22:38 GMT

I’ve been working on a simple monitoring tool for SQL Server over the last few months.  I often find myself asking “What just happened?” and “Was it SQL Server?”.  I wanted a small utility I could leave running at clients that would answer that question.  It needed to be

ClearTrace Build 51 Available

Tue, 12 Jul 2016 22:44:30 GMT

I’m pleased to announce that ClearTrace Build 51 is now available for download.  If you’re using a previous build (especially build 50) I encourage you to download this version.

This build should load the latest version of the SMO libraries installed on your machine.  If you’re using

Installing SQL Server 2014 yields Unauthorized Operation

Thu, 10 Dec 2015 18:32:36 GMT

We were experiencing trouble installing SQL Server 2014 onto a Windows 2012 R2 VM.  These are new production boxes so I was being very careful.  The problem manifest itself in two ways:

  • A clean installation using our service account got almost all the way through and then failed with the

ClearTrace Build 47 Available

Mon, 06 Jul 2015 04:06:09 GMT

You can download the latest version of ClearTrace from my consulting site: scaleSQL Consulting

I’ve decided to stop using the year as part of the version.  I did that to match SQL Server branding but it doesn’t work for ClearTrace.  The current build supports SQL Server 2008, SQL

Error: 18456, Severity: 14, State: 11

Wed, 08 Oct 2014 19:20:25 GMT

I’ve seen this error off and on in our environment for a while.  The full error looks like this:

Login failed for user DOMAIN\login’. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: X.X.X.X]
Error: 18456, Severity: 14, State: