{"id":2797,"date":"2016-02-23T10:55:46","date_gmt":"2016-02-23T18:55:46","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/kimberly\/?p=2797"},"modified":"2016-02-23T13:50:24","modified_gmt":"2016-02-23T21:50:24","slug":"2016-looking-great","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/2016-looking-great\/","title":{"rendered":"New features plus excellent tips & tricks – 2016 is looking great!"},"content":{"rendered":"

There are so many exciting things going on this year\u00a0and it’s just\u00a0getting started! If I’m being honest,\u00a0I haven’t been as excited for a new release of SQL Server for a long time. Don’t get me wrong – I love new features and I love fixes but I’m also a firm believer in “if it ain’t broke and the features aren’t critical, there’s no rush to upgrade.” And, even though I’m excited about SQL 2016, that’s not going to prevent migration testing and a solid QA pass before upgrading. But, IMO, SQL Server 2016 is a game changer for table design and indexing. I still need to work with it a bit more and I still believe that\u00a0the BEST large-table\u00a0architecture isn’t super simple. But, I truly feel\u00a0that the table design combinations available\u00a0with SQL Server 2016 (in terms of partitioning [with BOTH partitioned tables AND partitioned views] and indexing) are EXACTLY what you need for high performance hybrid (OLTP+ DSS) implementations.\u00a0So, this makes me really excited for the upcoming release. I know that most of y\"SQL_Server_evolution_194x194\"<\/a>ou aren’t going to jump ship immediately but you should start learning as much as you can – NOW.<\/p>\n

So, since\u00a0SQL Server 2016 is getting ready to release – check out some of the Microsoft resources\u00a0that are available already:<\/p>\n