In case you did not pick up the crucial bit from the previous post, data stored as ntext must get converted to nvarchar.

If you go from ntext to plain old...

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

Ant-Green has the right idea.

I have seen a number of sites where the system engineers (or a dedicated backup team) are using agent processes to take backups of everything.  This...

Start with the RTO and RPO of the databases. This will guide you on the backup scenario you need. Having the databases in an AG makes no difference to what...

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 8 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 8 months, 2 weeks 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...