The client can either:

a) Run your tool for discovery

b) Run their own process for discovery, possibly assissted by you

c) Agree with your client a list of servers they want to...

This works for a simple situation but problems may arise in many enterprise situations.

Many enterprises use DNS aliases for connection, as this gives a layer of indirection between PowerBI and...

• This reply was modified 3 years, 3 months ago by EdVassie.

As always, the job of the DBA is to present the technical opportunities along with their risks and costs to management and get them to tell you in writing which...

• This reply was modified 3 years, 4 months ago by EdVassie.

My wife now has the best workstation in the house for her 3-day per week job as Church Administrator. She has a 1yo 16GbB laptop/tablet combo feeding two 4k monitors...

Hi,

I have some of your answers, but also a question. Why use SQL2016 a) when it is almost out of support, b) when SQL2017 adds automatic initialisation and SQL2019 adds...

The short answer is, yes this can be done. However if you look at Business Risk it is hard to work out anything with a much higher risk. It is...

This is a difficult problem to troubleshoot because very few details are given.

My guess is that it is a WMI namespace problem. I have seen WMI namespace errors in other...

I am guessing you have installed SQL server as a cluster. When you configure Always On, there are some things that only need doing once, and some that need doing...

Definitely check with your Microsoft rep. Any opinion on from this site about the validity of what you are doing is just an opinion. Your Microsoft rep knows the legal...

What you suggest could work right up to the point when you join the AG.

You will have to drop the old DB from the AG before you do the rename,...

If you have SSRS or PowerBI on-prem then aliases can also make life easier for these.

The idea here is to have a stable connection string for your end users, but...

I am assuming you want to retain the same listener name because it is referenced in connection strings, and that you are running on-prem. I will give an alternative approach...

I will give a long answer and a short answer:

The long answer treats your servers like pets, you need to spend time caring for each of them.  The amount of...

If your DBs are on-prem and already on at least SQL2017 a useful way to migrate to a new SQL version is to use a Distributed Availability Group (dAG).

You can...

I have been using gMSA accounts since SQL2012. I have never found a need to repeat the backup of the service master key as the gMSA password changes.