The latest release of Is It SQL [http://www.scalesql.com/isitsql/] 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…
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…
The latest release of Is It SQL [http://www.scalesql.com/isitsql/] 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…
Release 1.0.22 is out and available at the Is It SQL home page [http://www.scalesql.com/isitsql/]. 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.…
[https://billg.sqlteam.com/content/images/61500-Tag-page_2.png]Release 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…
You can download the latest build of Is It SQL [http://www.scalesql.com/isitsql/] 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. [https://billg.sqlteam.com/content/images/61499-database-page_2.png] And…
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…
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…
I’m pleased to announce that ClearTrace Build 51 [http://www.scalesql.com/cleartrace/download.html] 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…
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…