Menu

Close
  • Home
  • SQLTeam.com
  • Consulting
  • RSS
Subscribe
Bill's SQL Server Blog Menu

SQL Server Stuff

A 76-post collection

Page 1 of 8 Older Posts →

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 »

Bill Graziano Bill Graziano on SQL Server Stuff 31 December 2016

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 »

Bill Graziano Bill Graziano on SQL Server Stuff, Utilities 30 August 2016

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 »

Bill Graziano Bill Graziano on SQL Server Stuff, Utilities, Is It SQL 04 August 2016

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 »

Bill Graziano Bill Graziano on SQL Server Stuff, Utilities, Is It SQL 02 August 2016

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 »

Bill Graziano Bill Graziano on SQL Server Stuff 10 December 2015

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’ »

Bill Graziano Bill Graziano on SQL Server Stuff 08 October 2014

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 »

Bill Graziano Bill Graziano on SQL Server Stuff 15 August 2011

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 »

Bill Graziano Bill Graziano on SQL Server Stuff, ClearTrace 19 February 2011

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 »

Bill Graziano Bill Graziano on SQL Server Stuff, Utilities 15 February 2011

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 »

Bill Graziano Bill Graziano on SQL Server Stuff, Utilities, ClearTrace 07 February 2011
Page 1 of 8 Older Posts →
Bill's SQL Server Blog © 2019
Proudly published with Ghost