Archive

Archive for the ‘Uncategorized’ Category

Announcing SQL Server 2012 Service Pack 4

July 25, 2017 Leave a comment

In case you missed it , it looks like SP4 will be the final big thing for SQL 2012. You really need to move to SQL 2016 though , the improvements to the engine alone are worth it.

https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-sql-server-2012-service-pack-4/

 

Advertisements
Categories: Uncategorized

Sql Server was unable to communicate with the LaunchPad service

July 26, 2016 Leave a comment

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.

LaunchPad

Categories: SQL Server, Uncategorized

SQL 2016 requires ….Oracle ?

August 6, 2015 Leave a comment

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.

Categories: Uncategorized

Finally ! SQL 2014 certified for SAP

March 12, 2015 Leave a comment

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 !

Categories: Uncategorized

Tech Ed South Africa ?

August 23, 2014 Leave a comment

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 : 

http://www.teched.co.za/closed.aspx

If I hear of any new events I’ll mention it here on my blog. 

Thavash

Categories: Uncategorized

The BI Semantic Model

April 7, 2013 Leave a comment

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.

http://blogs.msdn.com/b/cathyk/archive/2011/10/17/the-bi-semantic-model-mdx-dax-and-you.aspx

 

Categories: Uncategorized

SQL Server 2012 SP1 and Hekaton

November 8, 2012 Leave a comment

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 …… 🙂 🙂 🙂 🙂 🙂

Categories: Uncategorized