Skip to main content

Developers Conference 2016 - SQL Server


Last week end, I had the opportunity to present at the Developers Conference in Mauritius again. This was another opportunity to team up with my friends from the MSPs and showcase how SQL Server 2016 can help solve the data challenges in modern businesses . So, if you missed the presentation, here is a summary of what we demonstrated.




I started the presentation with a focus on the trends in technology in terms of Apps, Mobile and IoT and how all of them are creating more and more data. However, this is leading to new challenges in terms of processing and storage.  




Despite these challenges, there is an increase need for data analytics by the business to find quick insights and enhance decision making. How to solve these issues? This is where SQL Server 2016 comes into play.




1. In-Memory

Dishay explained how the in-memory features of SQL Server 2016 works, what has changed since 2014 and he also made a live demo of the performance improvements with memory optimized tables versus normal tables. More information of how to implement in-memory is available here.




2. Polybase

Next, I demonstrated the power of Polybase, also a new feature of SQL Server 2016 which allows the user to join unstructured data from an existing Hadoop cluster to a relational data in SQL Server. This allows T-SQL developers to do Big Data Analytics with there existing knowledge without learning about all the Hadoop mechanisms.
You can read more abut Polybase on my blog post here.

3. Stretch Database

Then, Prashant made a demo of the new Stretch Database in SQL Server 2016 where he migrated data to the cloud and queried them without any special code, thus making it transparent to the user. 
With Stretch Database, you can configure automatic remote archiving, for example, migrate data older than 5 years automatically to the cloud. Therefore, one table can be partly on premise and partly on the cloud and it can be queried seamlessly.
You can read more about Stretch DB on my blog post here.




4. Security Improvements in SQL Server 2016

At last but not least, Muzammil made a live demo of the new security features available in SQL Server 2016 which is important before scaling to the cloud, such as, Always Encrypted, Row Level Security and Dynamic Data Masking. You can read more about the security features here.



I then concluded by summarizing the features we demoed and how they are solving our daily problems in the data world.




Comments

Popular posts from this blog

Creating and Querying Microsoft Azure DocumentDB

DocumentDB is the latest storage option added to Microsoft Azure.
It is a no-sql storage service that stores JSON documents natively and provides indexing capabilities along with other interesting features.

This article is available available on theMicrosoft Technet Wiki. This article was highlighted in theTop Contributor awardson the 12th of October 2014. This article was highlighted in the TNWiki Article Spotlight. This article was highlighted in the The Microsoft TechNet Guru Awards! (October 2014).


DocumentDB is the latest storage option added to Microsoft Azure.
It is a no-sql storage service that stores JSON documents natively and provides indexing capabilities along with other interesting features.
This wiki shall introduce you to this new service.

Setting up a Microsoft Azure DocumentDBGo to the new Microsoft Azure Portal. https://portal.azure.com/ 


 Click on New > DocumentDB


Enter A Database ID and hit Create!



Query Unstructured Data From SQL Server Using PolyBase

Scope The following article demonstrates how unstructured data and relational data can be queried, joined and processed in a single query using PolyBase, a new feature in SQL Server 2016. Pre-RequisitesIntroduction to Big Data Analytics Using Microsoft Azure Big Data Analytics Using Hive on Microsoft Azure Analyze Twitter Data With Hive in Azure HDInsight Running Hadoop on Linux using Azure HDInsight  Introduction Traditionally, Big Data is processed using Apache Hadoop which is totally fine. But what if the result of this needs to be linked to the traditional Relation Database? For example, assume that from the analysis of tons of application logs, marketing needs to contact some customs that faced problems in an application following a failure in the application.
This problem is solved with PolyBase. PolyBase allows you to use Transact-SQL (T-SQL) statements to access data stored in Hadoop or Azure Blob Storage and query it in an ad-hoc fashion. It also lets you query semi-structure…

Creating and Deploying Microsoft Azure WebJobs

Azure WebJobs enables you to run programs or scripts in your website as background processes. It runs and scales as part of Azure Web Sites.
This article focuses on the basics of WebJobs before demonstrating an example where it can be used.

This article is also available on the Mirosoft TechNet Wiki.
This article was highlighted in the The Microsoft TechNet Guru Awards! (October 2014).


Introduction
What is Microsoft Azure WebJobs?
Azure WebJobs enables you to run programs or scripts in your website as background processes. It runs and scales as part of Azure Web Sites.

What Scheduling Options is supported by Microsoft Azure WebJobs? Azure WebJobs can run Continuously, On Demand or on a Schedule.
In what language/scripts are WebJobs written?
Azure WebJobs can be created using the following scripts:  .cmd, .bat, .exe (using windows cmd).ps1 (using powershell).sh (using bash).php (using php).py (using python).js (using node)In this article, the use of c# command line app shall be demonstrated.
Cr…