hmm this somehow doesn't make sense to me, maybe you can clarify a bit:

i) Should it be SSD or NVMe? Because ii) you talk about NVMe

ii) 4x12 Gb/s fabric alone...

No, the SQL Agent isn't explicitly created as  a login, if it is in fact an issue because there is no login for the SQL Agent Account, then I have...

ok, I understand permissions is the obvious thing so let me dive a bit into that direction:

Yes the SQL Service Accounts do have registered SPNs (MSSQLSvc/ is registered to the...

I've considered running a blog myself for quite some while now (at least a few years) but whenever I think "this sounds like something others might be interested in" it...

does the trigger itself begin / end transaction, too?

I'm currently doing the last bits & pieces of a DWH Upgrade / Replacement to 2017 and I already am screaming for SQL Server 2019 (MDS learns how to HTML5...

Ah the good ol' "hopefully it doesn't run on Windows" rant. Well TensorFlow does run on either Windows or Linux and how well Linux and respective Software does in the...

I'm way too young (still) it seems when reading through others' car list.

I've owned two cars myself and both of them gave my heart and Soul much fun.

First off my...

Funny - sort of - as I get the feeling the more (better) Code or Consulting I provide to my customers, they likely want to keep me around longer than...

Well in that case you must be working at a company which name starts with A and ends with ccenture, because I've seen...

This is an extended version of AdventureWorks, designed to showcase SQL Server 2016 features. To see the features in action, run the SQL Server 2016 sample scripts on...

Well for Memory Optimized Tables you need to create a filegroup and one or more files for that filegroup per database. It's a good practice to setup resource governor for...

Hey frederico,

I don't mind it's here already. It's over 99% accurate (11 rows out of ~ 4 million are missing), for the remainder I'll need further clarification from the...

have you verified on the file properties before and after opening & saving the xslx file that it's for the same version of Excel?

So I'm back with performance numbers:

Initially the whole load would take between 4 and 5 Hours, after changing one Script Task to a Script Component (see above) and another Script...