Building on what Jeffrey says...  You can have the new alias set up in AD prior to the migration pointed at the existing cluster.  That gives you time to migrate...

For better or worse I have a large collection of old tech in my home office.  I've got at least four iPods, three Zunes, half a dozen no-name MP3 players,...

After the vendor stated there is no support for running that version of their application on a version of SQL later than SQL2012, the application support team set up a...

I spent much of the first half of this year doing upgrades to get off SQL2012.  Was mostly successful by the deadline, the exception being about 25 servers which were...

Our line has always been the loss of extended support.   We've got enough prepaid support hours built into our enterprise agreement to cover the once every three years or so...

In SSMS I dream of having the MSX / Multi Server Administration "Manage Target Servers" window to be resizable, like just about every other window in SSMS.  It has been...

A timely article.  I woke up this morning to discover my home office router had locked up overnight.  Turning it off and then on again restored functionality (seems I have...

We've got a series of questions we go through whenever we are interviewing a new potential DBA (hasn't happened in awhile).   There are a few "how would you do this"...

Any service running on the local server as "Local System" trying to access databases will show up as "NT Authority/System" in the SQL logs.

In my experience the cause is usually...

Over the 2016-2019 time period my company shut down five corporate datacenters and moved almost all of it to Azure or AWS via lift and shift IaaS methods.   For scale,...

When I was hired in the mid 90's I worked with a large number of IT employees with 20+ years of service.  One guy on my team had been in...

I guess I'm an outlier.  I hit 25 years with my employer last spring which isn't a real rare thing here.  Old company in an old industry where it's not...

After decades of building my own personal desktop machines, last year I bought my first new personal laptop.  It's far more powerful than the desktop it replaced, has just as...

I've fought the server spec battle many times when migrating from physical to virtual or cloud servers.  When moves like that are made there is often an effort by the...

JJ B:  I'd say you've ruled out a disk I/O issue.  My rule of thumb is that the disk subsystem needs a closer look if you have a sustained disk...