It is difficult to get into almost any job unless you have experience in what you want to do. The best way is to do research and find employers who...

The scenario you want to do is something most organisations have faced. Unfortunately it is not possible to do it in a single step.

Any database that is in Full Recovery...

Can I suggest you also look at your application upgrade process.  The standard I have been used to is to minimise risk.

There should be no DB changes made that could...

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 2 years, 4 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 2 years, 5 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...