Upcoming Events

UK Azure Group, SQL Midlands edition

  • Thursday, February 9, 2017
  • 6:30pm 7:30pm
  • Aston Manor Academy

 

To Register: https://www.eventbrite.co.uk/o/sql-midlands-6264475503

Implementing NHS Azure Hybrid Architectures

The NHS is undergoing a time of unprecedented change, as well as increasing financial pressure under a public microscope. In order to meet these challenging requirements, NHS South London and Maudsley is undergoing a Digital Transformation program which is fundamentally ultimately altering delivery of its healthcare services. The Digital Transformation is crucial to the success of the Trust, and it affects everything from the physical layer right up to self-service reporting. It is also an important balancing act between highly sensitive patient privacy in a world that expects data on-demand in mobile and external environments.

In this technical session, join us to learn from the expert team who architected, designed, and delivered the hybrid Azure cloud and SQL Server solution for NHS South London and Maudsley Trust. Learn about the technical constraints and challenges and how we overcame those challenges, particularly through a healthcare lens of highly-sensitive patient privacy issues in a world of data. You will also learn about the technical benefits that were gleaned from this hybrid implementation. In order to bring the achievements to life, you will see real-life insights into healthcare in a Power BI demo, in use by hospital team members.

Using Azure, SQL Server and Power BI means that the NHS is empowered to create enriched opportunities for research to improve patient outcomes, both now and in the future, as well as directly improved patient outcomes now. Join us for this technically-oriented session to see how Azure, SQL Server and Power BI joined forces to fundamentally deliver improved patient healthcare, research and insights in London.

To Register, visit http://www.sqlmidlands.com/events/48-9th-feb-2017-nhs-in-azure-data-factory-custom-activity.html

 

Power BI for the CEO

  • Thu, Apr 6, 20179:00am Sun, Jun 4, 201712:59am
  • The International Centre

Date: Saturday 8th April, time to be determined

Location: The International Centre, St Quentin Gate, Telford, Shropshire, TF3 4JH

Register: http://sqlbits.com/information/registration.aspx

Digital Transformation is much more than just sticking a few Virtual Machines in the cloud; it is real, transformative, long-term change that benefits and impacts the whole organisation.
Digital Transformation is a hot topic with CEOs and the C-level suite, renewing their interest in data and what it can do to empower the organisation.
With the right metrics and data visualisation, Power BI can help to bring clarity and predictability to the CEO to make strategic decisions, understand how their customers behave, and measure what really matters to the organization. This session is aimed at helping you to please your CEO with insightful dashboards in Power BI that are relevant to the CxO in your organisation, or your customers’ organisations.
Using data visualisation principles in Power BI, we will demonstrate how you can help the CEO by giving her the metrics she needs to develop a guiding philosophy based on data-driven leadership. Join this session to get practical advice on how you can help drive your organisation’s short and long term future, using data and Power BI.
As an MBA student and external consultant who delivers solutions worldwide, Jen has experience in advising CEO and C-level executives in terms of strategic and technical direction.
Join this session to learn how to speak their language in order to meet their needs, and impress your CEO with proving it, using Power BI.

Data Visualisation Lies and How to Spot them Techorama

  • Mon, May 22, 20179:00am Wed, May 24, 20175:00pm
  • Kinepolis

Register: Buy Tickets

 

During the acrimonious US election, both sides used a combination of cherry-picked polls and misleading data visualization to paint different pictures with data. In this session, we will use a range of Microsoft Power BI and SSRS technologies in order to examine how people can mislead with data and how to fix it. We will also look at best practices with data visualisation. We will examine the data with Microsoft SSRS and Power BI so that you can see the differences and similarities in these reporting tools when selecting your own Data Visualisation toolkit. Whether you are a Trump supporter, a Clinton supporter or you don’t really care, join this session to spot data lies better in order to make up your own mind.

Taming the Open Source Beast with Azure for Business Intelligence

  • Saturday, June 17, 2017
  • 9:00am 5:00pm
  • Trinity College, College Green, Dublin 2,

Location: Trinity College, College Green, Dublin 2, Dublin, County Dublin, Dublin 2, Ireland

Register: https://www.sqlsaturday.com/620/registernow.aspx

Today, CIOs and other business decision-makers are increasingly recognizing the value of open source software and Azure cloud computing for the enterprise, as a way of driving down costs whilst delivering enterprise capabilities.

For the Business Intelligence professional, how can you introduce Open Source into the Enterprise in a robust way, whilst also creating an architecture that accommodates cloud, on-premise and hybrid architectures?

We will examine strategies for using open source technologies to improve existing common Business Intelligence issues, using Azure as our backdrop. These include:

– incorporating Apache projects, such as Apache Tika, for your BI solution
– using Redis Cache in Azure in as a engine as part of your SSIS toolkit

Join this session to learn more about open source in Azure for Business Intelligence. Open Source does not mean on premise.
Demos will provide practical takeaways in your Business Intelligence Enterprise architecture.

The Prodigal Developers Return: SQL Server 2016 SP1 brings consistent programming surface to Developers and ISVs

Big news from Microsoft Connect() 2016 online developer conference. SQL Server 2016 Service Pack 1 is dropping. Download SQL Server 2016 SP 1 here.

SQL Server 2016 SP1  means lots of wider features for lower editions. Most importantly, developers and partners can now build to a single application programming surface to create or upgrade new intelligent applications and use the edition which scales to the application’s needs.

The long version and my ‘take’ on this news:

I’m incredibly impressed with Microsoft right now. I think it’s incredibly smart, actually, because they are bringing developers and ISVs back into SQL Server Land again. So, developers, ISVs, go and grab yourself a coffee and let’s have a chat.

stocksnap_3tj6nctirt

Credit: stocksnap.io

SQL Server 2016 SP1 makes leading innovation available to any developer. Microsoft is making it easier for developers to benefit from the industry-leading innovations in SQL Server for more of their applications. With SQL Server 2016 SP1 is making key innovations more accessible to customers across editions. Developers and partners can now build to a single application programming surface to create or upgrade new intelligent applications and use the edition which scales to the application’s needs. SQL Server Enterprise continues to offer the highest levels of scale, performance and availability for enterprise workloads. For more information, please see the full press announcement on the SQL Server Blog. Visual Studio Code extension for SQL and updated connectors and tools are also exciting news, because it means that it’s easier to develop with other languages, in a more streamlined fashion.

What problem are Microsoft trying to fix?

stocksnap_vlhyvv3xu5Previously, the issue with developing applications for SQL Server is that there is a disparity across editions, which can affect how your application runs.  Until now, developers have used the SQL Server development version as it will allows them to develop with features that are available on all of the production versions.

Now, the problem is solved – developers can take advantage of the programmability feature by using the same code base, and things are simpler because the customer chooses which edition they use.

The problem was evident, when you use, say, an enterprise-only feature in development but have only a Standard-edition instance in Production. You can see the full list of features and editions published by Microsoft here ‘Features Supported by the Editions of SQL Server 2016’

If you had an app that can manage Enterprise edition then it can, in principle, also manage every other edition.  However, now the application would scale to the customer’s edition, thereby streamlining the whole process.

New Tools for the Toolbox, No Pricing Changes

stocksnap_kd30xpqr0a

So, developers wouldn’t have to build complexity, but they’d have to create their app the right way. For example, there’s not always a need to scale out. Let’s take Stack Overflow, one of the top 50 busiest sites in the world.  Stack Overflow runs on Microsoft SQL Server.

Not many people know it, but there is a StackOverflow Enterprise Edition. It means that companies like StackOverflow can take advantage of the new programmability features, if they so wished. I wonder what ISVs will do?

Freedom from Constraints

Let’s examine the issue in more detail. Let’s take a look at the SQL Server editions that are available to us:

  • Azure database + Amazon RDS
  • Containerized version of any edition
  • Developer Edition
  • Express Edition
  • Enterprise Edition
  • LocalDb
  • Standard Edition
  • Web Edition

You can see why it starts to get confusing, and developers might start to look at MySQL or Postgres as alternatives.

How can you get SQL Server 2016 SP1?

I believe that this will be a primary driver for SQL Server 2016 Service Pack 1, Download SQL Server 2016 SP 1 here.

Why are Microsoft doing this?

stocksnap_kikhw5nc6yIt’s a huge benefit for ISVs. It’s my opinion that Microsoft had lost the way with their partners. Customers started to look sideways at other vendors to fulfil their needs, such as Tableau. In response, partners expanded their toolkit in order to include crème de la crème vendors such as Tableau in order to build solutions. I think that this move is a gesture to the ISVs, since it will remove friction when they choose to develop solutions.

Being pals with Open Source but better – you get what you pay for. With the advent of open source, developers have got  more choice than ever before. It’s good to bring them back to SQL Server. Postgres doesn’t have in-memory capability, for example – it has “running with scissors” mode whereby you switch off all the disk storage features. Sound scary? Yes… the clue is in the name. SQL Server brings this feature to the party, and more. ISVs can feel more confident developing on a robust solution.

Increased productivity – it removes an obstacle to development, support and deployment.

The Prodigal Developers Return

This solution means that Microsoft SQL Server is back on the table for many developers, who may have started eyeing MySQL and Postgres for this reason.

To summarise, I think that this is a smart move and I’m excited to see that the ‘voice of the developer’ has come back into SQL Server Land. It’s also a huge benefit for ISV partners, and let’s see how they democratize their data in new and exciting applications. Let’s look for more exciting things coming from Microsoft.