OK , so SQL 2016 is here , and I’m sure we’re all already playing with the new features.
I’ve decided to start learning R, and did a fresh installation of SQL 2016 with R Services installed.
While attempting to run my “Hello World” script I encountered the error –
“Msg 39011, Level 16, State 1, Line 1
SQL Server was unable to communicate with the LaunchPad service. Please verify the configuration of the service.”
OK, so the first thing you have to do is to enable SQL to run external scripts. Run
Exec sp_configure ‘external scripts enabled’, 1
Reconfigure with override
However , make sure that the new “Launchpad” service is running – I simply had to start this to solve the error on my VM.
OK , that’s a click-bait headline….. but its not totally untrue.
When I installed SQL 2016 for the first time on a VM, the install initially failed the list of checks due to 2 items. One was an update for Windows Server that wasn’t installed , but the other was an update for Oracle Java ( JRE ). Now this was puzzling to me – since when does SQL Server require Java ?
The answer lies in one of SQL 2016s most interesting features – Polybase.
Polybase is Microsoft’s “SQL-over-Hadoop” solution , a layer that allows you to write SQL and query relational and non-relational data. Originally launching with the APS appliance, the inclusion in 2016 is a milestone. So why Java ? Remember that MapReduce scripts are typically written in Java.
Sql 2016 allows you to query data from a connected Hadoop or HD Insight instance , a true sign of the Big Data times that we live in.
After a long wait , we finally hap SAP Certification for SQL 2014. The details can be found at Juergan Thomas’ blog here
As expected , there is support for the new 2014 ColumnStore feature – particularly useful for SAP BW scenarios.
Amongst the other features , I see that Azure also plays a big role – In fact Azure DR for SAP Netweaver seems to be a hot topic. You can find a whitepaper on this here.
Now , there was something missing in the announcement – Support for SAP Netweaver using SQL Server In-Memory OLTP. Apparently , it has to do with the fact that IMOLTP uses Snapshot Transaction Isolation Level , while SAP Netweaver normally uses Read Committed.
Disappointing – but I’m sure that we’ll have some good news on this soon !
Lots of people have been asking me about Tech Ed South Africa recently. The official comms was that there will not be an event this year , but Microsoft will be hosting other smaller events throughout the year. I refer you to the local Tech Ed page here :
If I hear of any new events I’ll mention it here on my blog.
I’m prepping a Session on the BI semantic Model for Tech Ed Africa. I came across this old but excellent blog post detailing the differences between the Tabular Model and Multidimensional model – handy if you’re starting out in exploring the changes with SQL 2012.
Big big announcements at SQL Pass. Firstly , SP1 is now available for SQL 2012. There seems to be the usual fixes , but there also seems to be a lot with regards to compatibility with Excel 2013 and SharePoint 2013 for BI. If you’re planning to roll out BI on the 2013 platform , you need SP1. More impressively …….
The Column Store ( xVelocity ) technology that we saw for Data Warehousing applications will be available for OLTP applications ( NOT in SP 1 just to be clear ). There is no release date but this is exciting. Those of you who have seen what Column Store can do for Data Warehousing know that its pretty significant.
What we now know is that ColumnStore for Data Warehouse applications will become writable in the next major release of SQL Server ( no more dropping indexes to load ). But the impact of having this technology for OLTP means that all database applications will benefit from it and get that massive performance boost. How big a boost ? Well , Hekaton apparently means 100 in Greek …… 🙂 🙂 🙂 🙂 🙂
I recently came across this great blog post , with links to many interesting Microsoft eBooks.
In case you’re wondering , its legit ( it is an MSDN blog after all ). Scroll down for the SQL 2012 eBooks.