Just wanted to add that

sp_helplanguage british;
sp_helplanguage english;

will show the differences between languages. With

EXEC sp_configure 'default language', 'British English';

you could change the default language for...

well adding to my last post have a look here aswell, again I am completely unaware of 3rd Vendor Options but Azure Data Vault is yet another EKMS so...

This might have to do with what SQL Server would expect as a Default value, GetDate()'s Default Value is non existent so precompiling query plans (which is what sp's are...

You should have a look at Extensible Key Management if you can use EKM first depends on your SQL Server Version and second on your Edition Edition...

When you create your database as part of your create script you simply change the authorization afterwards, so it'll look something like Create Database

[…]

Once your objects are created you can...

Yes it is possible, however once you fail-over from the old nodes to the new 2016 Node, first thing to do is prevent failback to the old nodes. Second thing...

There is no error, if you read the Documentation carefully, it clearly states that you have to be either sysadmin or DB-Owner (DBO) of the Database, the DBO is not...

Your read requests will go to the Primary Active Role (assuming you're going Active/Passive), you can still use ApplicationIntent=READONLY and if you sort out your licensing issues you can go...

The best answer I had was towards some work colleague who has seen me around rather frequently at the customer site and he asked me what I'm doing here.

My first...

I'd like to see SQL Server 2o19 SE with a per Feature Limit of 256 GB.

Some people are restless and want to look for new opportunities on a regular basis, no matter what their situation. If that's you, I would think you should consider consulting, either with...

• This reply was modified 5 years, 8 months ago by  DinoRS. Reason: spelling

I think we should all send in QotD with what we think might be a 2017-ish thingie - , feels almost like a Jersey thing to do.

Sorry no hard...

So, Maybe I didn't get it but a MVP just told me this:

In previous versions of SQL Server, the Page_Verify database property algorithms were used to verify and identify possible...

I wouldn't run the newest gear either but at least in some countries your're better off not going any older than a dl360 g8 really due to power pricing.

And I...

For mobile use I have a ThinkPad P51 with 64 GB RAM and 1.25 TB of total PCIe Storage. This is fine for anything I want to show without externally...