SQL Server 2014 RTM Announced for April 1 Release

Posted by  Jen Underwood   in  ,      4 months ago     1860 Views     1 Comment  

SQLServer2104OLTP2

Big news came out of Redmond yesterday. SQL Server 2014 will be publicly released on April 1, 2014. This version brings the highly anticipated, in-memory OLTP for SQL Server (formerly code named Hekaton). SQL Server in-memory OLTP works with standard x64 hardware. It also can be easily added to existing OLTP applications with no large code changes/migrations needed to enjoy the speed benefits in-memory technology offers. Other enhancements include but are not limited to improved cloud back up, better hybrid support, cluster index improvements, improved performance, resource governor, automated sysprep installs and other database administrator features. SQL Server in-memory OLTP is Microsoft’s compete with SAP’s HANA and other in-memory database solutions. I have no doubt that SQL Server 2014 will be a hugely popular release.

For those of you that are interested in seeing the Microsoft product team technical overview of SQL Server 2014, I have a SQL Server 2014 300 Technical Level deck posted on my SlideShare. I also highly recommend downloading the SQL Server 2014 Product Guide materials. The Product Guide contains a plethora of fantastic technical information, presentations and white papers.

SQLServer2104OLTP

For my BI and analytics readers, aside from columnstore index there really is not much else new, wild and exciting for BI in SQL Server 2014. There might be some improvements in MDS, DQS, SSIS, SSRS or the various SSAS flavors but I have not seen them discussed anywhere. Note sometimes there are indeed improvements that are merely bug fixes or smaller things that product marketing does not feel are worthy to mention. Every once in a while that overlooked “small” feature is a gem. Don’t be disappointed if you don’t see much for BI when you dig in. Almost all of the new Microsoft BI features right now are in the Office 365 Power BI and cloud realm.

GarnerDW2014

On a related note, Microsoft also fared quite well in the recent 2014 Gartner Magic Quadrant for Data Warehouse Database Management Systems. If you work with data and data warehouses, this report is a good read for you to get a current pulse of the market, players and trends. From my market pulse perspective, I can share that I am seeing much more interest in PDW (Microsoft’s Parallel Data Warehouse) than I have in the past. Big data and NoSQL may be making significant strides and altering the landscape but they seem to be added to existing technical architectures as a supplement…not a data warehouse replacement. Hearing industry analyst briefings, I can share that a common theme seems to be big data technology is not quite where it needs to be yet for wider adoption. Right now there are early adoption pains, disappointments, security is lacking, performs poorly, tools are immature and these technologies are not replacing most relational databases today. Don’t take that the wrong way – big data technologies are going mainstream in the near future. They just happen to shine brightly when used for different use cases that a relational database or data warehouse can not handle.

About  

Founder and Principal Consultant, Jen Underwood has almost 20 years of hands-on experience in the data warehousing, business intelligence, reporting and predictive analytics industry. Prior to launching Impact Analytix, she was a Microsoft Global Business Intelligence Technical Product Manager responsible for technical product marketing and field readiness for a $10+ billion market suite of analytics offerings spanning across Microsoft SQL Server, Office and SharePoint. She also held roles as an Enterprise Data Platform Specialist, Tableau Technology Evangelist and a Business Intelligence Consultant for Big 4 Systems Integration firms. Throughout most of her career she has been researching, designing and implementing analytic solutions across a variety of open source, niche and enterprise vendor landscapes including Microsoft, Oracle, IBM, and SAP. As a seasoned industry presenter, author, blogger and trainer, Jen is quite active in the global technical community. Recently she was honored with a Boulder BI Brain Trust (BBBT) membership, Tableau Zen Master (MVP) award, PASS Excel BI Chapter leadership role and a Dun & Bradstreet MVP. She writes articles for BeyeNetwork, SQL Server Pro and other industry media channels. Jen holds a Bachelor of Business Administration degree from the University of Wisconsin, Milwaukee and a post graduate certificate in Computer Science - Data Mining from the University of California, San Diego.