Things are a lot easier with Enterprise Edition. IMHO the HA capabilities of EE make it worth paying the additional price. Trying to roll your own stuff compared to having...

By now I hope you have read about what a CXSYNC_PORT wait is. If not please do so.

The situation described for this wait type did exist in SQL2014, but was...

Removed, duplicate post.

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

Back in the day (1981) I developed a code generator for the place where I worked, for a mainframe online app.

Simple in some ways but very helpful, it would modify...

It is also worth putting near the start of your documentation a warning sbout risk.

Explicitly say that anyone trying to deal with DR who does not already have practical experience...

• This reply was modified 1 year, 4 months ago by  EdVassie.

I guess your client may be looking at workload and thinking Standard Edition will do.

Both they and you should look at BCO and what SLAs they want for RTO and...

One of the nice things about replication is that you can turn off just about all errors on a case by case basis. It should therefore be possible to get...

"In theory, theory and practice are the same. In practice they are not" - A Einstein

The biggest issue you will face going forward, as Steve says, is scaling.  If you...

Doing things manually may be the way to go.  When I first got the dlink over a decade ago it really helped by providing off-box storage. There are so many...

No recommendations on hardware. Maybe you can pick up another dlink box on ebay.

Some years ago I replaced the OS on my dlink box with Alt-f, mainly to get support...

As Ant says, this is definitely possible.  The process is the same as installing yhe first SQL node on a multi-server cluster.

What problems are you getting?

If a temp table or a CTE or a table variable holds more data than can be held in memory than it will write to tempdb. That is the way...

As everyone else has said, test everything.

Expect to find some breaking changes, be it functionality or performance. It always happens between major releases, so nothing new in this concept.  The...

• This reply was modified 1 year, 5 months ago by  EdVassie.

I am guessing that your users are trying to connect using https://servername...

At my old place we set up a DNS alias for SSRS/PowerBI and got our users to...

• This reply was modified 1 year, 5 months ago by  EdVassie.

Today is the first time I heard about SQLFacts.  I think Brent's comments are really relevant - if the author of a tool wants it to be used they must...