I would go even further to not just avoid Natural Primary Keys but aswell PKs using <Value> +1 (at least for Scenarios with a lot of Rows to be expected),...

Any Organization I've been working with in the past few years did consider Indexes as something to be change controlled, and I agree. It's a change in the code base...

Hi Phil,
interesting. We're currently still on 2014 but I am looking forward to get to 2017 (and later 2019) rather earlier than later. But this specific functionality is...

A rather common view in large enterprises is: "EE everything". They might have considerably better deals on EE Licenses than smaller companies but in the end it's still more expensive...

if it works by IP you might have missing SPNs for your SQL Services.

I just wish the Management DWH shipped with SQL Server would be a bit less complicated to add your own metrics to it, most insightful tool you can have to...

If you add the Server not in the Data Source to the linked Servers on the Server configured in the Data Source, you can access it like any other linked...

Have a look here

Hi,
use the CREATE INDEX idx Statement with the (DROP_EXISTING= ON) Option.

You should be aware that moving a Clustered Index from one FG to another  will...

Try BI Development then Andy, I just had 3 days ago a flat file on my table with dates in length of 3 to 6 Digits (102 = 20000102, wee!),...

Do you maybe have a Proxy SSIS Execution Account set up?

as Jo Pattyn suggested I would check the default language for the Login and if DB and SQL Server Collation match, too.