well the biggest pro I'd say is you can check issues in the data easier if transformation fails because someone was again too stupid to place the correct values in...

Just for clarification: I wasn't questioning wether Synology can do iSCSI but I'm not sure if and how they've implemented SMB3 so you could use a Network Share (paired with...

Well the issue with RDMA is you need specialized hardware in order to be able to use it (SFP+ / Infiniband cards capable of RDMA). I can see if I...

Yeah definitely possible but you need to map a drive from your synology to your laptop first, afterwards you can use this drive for your DB. And as MVDBA pointed...

Yes there are / will be additional tables where locations and other things will be stored and yes Primary Keys will be introduced aswell.

We have literally no choice but to...

I do like the idea but a one man show admin might feel quite stupid about it, just thinking about those 2 locks too far away to reach with both...

I'm fortunate to only have hard surfaces and with the empty bin included in the i7+ I hope to be able to avoid such issues. However I wouldn't use the...

I have a budget available every year to attend SQLPass including any expenses faced during my stay, unfortunately the last two years I didn't have the time to go, hopefully...

Yes, unfortunately it's absolutely not feasible to make changes to the OLTP System where data is inserted initially, it's an 3rd party ISV. All we get is some CSV Exports...

the funny part is: If you look at the OLTP DB and their flow it would appear valid (as in: there seems to be no real checks) and when we...

I got myself some smart door sensors because next year I'm getting a large AC unit and I am very serious about not running it when some...

Well in my case you could potentially argue that certain products would only be produced at certain sites and depending on the location of the customer there should be a...

1. Nothing
2. No

took about 2 minutes to create a new DB on a test system and evaluate the tools I want to use, you leave knowledge and testing to others?...

try SSMS 16.x if you really want to connect to Integration Services because you did it 20 years ago so. If you don't want to live in the past, connect...

Your issue is the edition you're trying to install scale out master on.

The scale out master has to be EE, workers can be SE.