Yeah you caught me right there asking stupid things about easy queries on the forums, Steve!

And whenever I met another DBA I like you notice things I would consider basic...

I do like computers on my cars, but only ECUs they shall be.

If I had the choice between an in which way ever hydraulically actuated (wether it's air or oil...

With my current client I think about everything asides Oracle is virtualized.

Yet the most impressive client I had was running over 50 AAGs on a physical 2...

Uh, not entirely sure where these usually end up, I just use an mmc with the CMC plugin, I just load it twice right away, once for the user and...

Hi,

here's a rather good manual how to set up SSL,  while this one refers to TDE, same thing should work with SSRS the...

VCS would be a Version Control System like TFS, Git and such.

Yes, the other way is force a full population of the full text index, just make sure there will be no more (planned) failovers before the FTS Crawl finishes.

Well, you don't need the KCM, simply check in the SQL Server configuration Manager if the Database Engine is running under a service account. If it does check on the...

My question still remains: Do you have SPNs for SQL Server Service Accounts which might point to the old instance?

do you have SPNs which point to the old instance Name?

well how important turning indexes on / off highly depends on your architecture, if you process data in your DWH and Reporting is done somewhere else, you usually don't have...

I definitely am with Jeff, too. My customer is willing to accept (in my opinion) quite a lot of debt as long as things run smoothly. We've been through a...

Spot on Patrick! I knew I missed something in there.
working script for reference

SET LANGUAGE German
UPDATE dbo.D_Time
SET
    [Time_Day_of_Month] = CONVERT(char(2),DATENAME(dd,CONVERT(datetime, CAST(PK_Time as...