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 »
IsItSql Shows Databases
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 »
IsItSql - 1.0.18
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 »
Is It SQL?
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 »
Installing SQL Server 2014 yields Unauthorized Operation
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 »
Error: 18456, Severity: 14, State: 11
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’ »
How to Name Linked Servers
I did another SQL Server migration over the weekend that dealt with linked servers. I’ve seen all kinds of odd naming schemes and there are »
How are Reads Distributed in a Workload
People have uploaded nearly one millions rows of trace data to TraceTune. That’s enough data to start to look at the results in aggregate. The »
Generate MERGE statements from a table
We have a requirement to build a test environment where certain tables get reset from production every night. These are mainly lookup tables. I played around »
Enter comments on queries in TraceTune
I’m trying to make TraceTune (and eventually ClearTrace) work the way I do. My typical query tuning session goes like this: Run a trace and »