• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

SQL 2016

Whorty

Godlike
Joined
Dec 3, 2014
Messages
7,728
Likes received
2,845
Thanks received
605
Location
South West
Whilst doing the research with chap at work on SQL certs, I had a dig around what's new on SQL 2016 and came across temporal tables. In days gone by I'd have to build triggers, complex stored procs etc to track slowly changing dimensions in my data marts. And as for being able to track Fact changes over time, storing monthly backups was a favourite solution :laugh Temporal tables though!!!! The kids of today don't know how lucky they are :yay:
 
Nobody uses In Memory OLTP.

If you go to Service Pack 1 however you get a bunch of stuff that was Enterprise only in times gone past.

My favourite part of 2016 is the Query Store, great for investigating outages and stuff. If only they turned it on as standard...
 

Advertisers

Back
Top