What I’m doing this week at #MSIgnite

I’m delighted to say that I’m doing the Community Reporter role for Microsoft Ignite. This means I get to interview the Microsoft Executive Team, such as Amir Netz, James Phillips and Joseph Sirosh. I have complete stars in my eyes! I don’t often get the chance to speak with them so I’m delighted to get to do that. Also, they are very interesting and they have a lot to say on topics I’m passionate about, so make sure and tune in for those. I’ll release more details about times and how you can watch as soon as I can.

What does a Community Reporter do? During Microsoft Ignite, the Community Reporters will be your go-to’s for live event updates. If you aren’t attending the conference this year, these reporters will be a great way to see what’s happening on-the-ground in Orlando. Check out my content on my blog here and on Twitter and LinkedIn follow me on social to stay up-to-date on all things Microsoft Ignite!

I’d also like to meet some of you so when I get the chance, I’ll tweet out to see if any introverted people fancy sitting at a table with me for breakfast or lunch to talk about all things data.

I am also speaking at Ignite so here are the details:

When? Thursday, September 27 4:30 PM – 5:15 PM
Where? Room W330 West 2 

Artificial intelligence is popularized in fictional films, but the reality is that AI is becoming a part of our daily lives, with virtual assistants like Cortana using the technology to empower productivity and make search easier. What does this mean for organizations that are running the Red Queen’s race not just to win, but to survive in a world where AI is becoming the present and future of technology? How can organizations evolve, adapt, and succeed using AI to stay at the forefront of the competition? What are the potential issues, complications, and benefits that AI could bring to us and our organizations? In this session, we discuss the relevance of AI to organizations, along with the path to success.

 

Microsoft Power BI, Microsoft R and SQL Server are being used to help tackle homelessness in London by providing actionable insights to improve the prevention of homelessness as well as the processes in place to help victims. Join this session to see how Microsoft technologies are helping a data science department to make a difference to the lives of families, by revealing insights into the contributors of homelessness in families in London and the surrounding area. Join this session to understand more about finding stories in data. The case study also demonstrates the practicalities of using Microsoft technologies to help some of the UK’s most vulnerable people using data science for social good.

When? Thursday, September 27 2:15 PM – 3:30 PM
Where? OCCC W222

For people who want to build careers and manage teams, it is crucial to understand diversity and how it impacts your organization. Increasing the role of women in technology has a direct impact on the women working in hi-tech, but the effects can go far beyond that. How do female tech workers influence innovation and product development? How do men benefit from having more women working in technology? Can the presence of women in tech affect a company’s profit? Join a lively discussion on diversity, and hear proactive steps that individuals and companies can take in order to make diversity and inclusion part of the organizational DNA.

One last thing!

Remember to download the Microsoft Ignite app to have your information handy on-the-go!

See you there!

 

 

Issues and Resolutions in starting R and R Server on SQL Server 2017

I am helping some people learn Data Science and we are having a ton of fun! There are lots of things to remember. So I am noting things here, in case I forget!

We noted the following error message, when we saw that R was not running on our SQL Server 2017 install:

‘sp_execute_external_script’ is disabled on this instance of SQL Server. Use sp_configure ‘external scripts enabled’ to enable it.

Here is the longer version:

Msg 39023, Level 16, State 1, Procedure sp_execute_external_script, Line 1 [Batch Start Line 3]

‘sp_execute_external_script’ is disabled on this instance of SQL Server. Use sp_configure ‘external scripts enabled’ to enable it.

Msg 11536, Level 16, State 1, Line 4

EXECUTE statement failed because its WITH RESULT SETS clause specified 1 result set(s), but the statement only sent 0 result set(s) at run time.

Grr! What’s happened here? We had installed R as part of the SQL installation, and we had run the command to enable it, too. In case you are wondering, here is the command:

EXEC sp_configure ‘external scripts enabled’, 1
RECONFIGURE WITH OVERRIDE

So what happens next? Initial things to check:

Is R Server installed properly along with SQL Server? Here are some guidelines to help you.

Is the Launchpad service running? One of my colleagues and friends Tomaž Kaštrun  wrote a nice article on SQL Server Central. If not, this could be due to a lack of permissions in being able to start the service.

Did you restart the MSSQL Service on the machine? This will also restart the Launchpad service as well. If you didn’t restart the service, you will need to do that so it can pick up the results.

Once R is running properly, you can check it by using the following command, borrowed from the official installation guide over at Microsoft:

EXEC sp_execute_external_script @language =N’R’,
@script=N’
OutputDataSet <- InputDataSet;
‘,
@input_data_1 =N’SELECT 1 AS RIsWorkingFine’
WITH RESULT SETS (([RIsWorkingFine] int not null));
GO

If that returns a 1, then you are all set! To prove it works properly, you can retrieve the world famous Iris dataset using the following command, borrowed from the official documentation on sp_execute_external_script:

DROP PROC IF EXISTS get_iris_dataset;

go

CREATE PROC get_iris_dataset

AS BEGIN

EXEC sp_execute_external_script @language = N‘R’ , @script = N‘iris_data <- iris;’ , @input_data_1 = N , @output_data_1_name = N‘iris_data’ WITH RESULT SETS ((“Sepal.Length” float not null, “Sepal.Width” float not null, “Petal.Length” float not null, “Petal.Width” float not null, “Species” varchar(100)));

END;

GO

Once you’ve created the command, execute the following SQL command and you will see the iris dataset:

exec get_iris_dataset

You’re all set! Enjoy R!