Skip to main content

Posts

Showing posts from March, 2016

Stretching SQL Server 2016 Tables To The Azure Cloud

Introduction
Microsoft SQL Server 2016 is a hybrid cloud environment designed to allow data and services to enable users to perform advanced analytics within their databases and create business insight visualizations. 
One of the highly anticipated features new to Microsoft SQL Server2016 is Stretch DB, a feature that migrates your historical data transparently and securely to the Microsoft Azure cloud.

Moreover, it can be configured to migrate a complete table to the cloud, or to migrate only part of a table based on certain condition. For example, one won’t migrate its complete transaction table, but migrating the data which is older than five years makes sense!
Benefits of Stretch DB  Ability to determine which rows to migrate to the cloud and which rows to keep On-Premise by using predicates.Stretch DB ensures that no data is lost if a failure occurs during migration. - It also has retry logic to handle connection issues that may occur during migration.Data Migration can be paused to…

Received Microsoft Community Contributor (MCC) Badge for the First Time!

Today I just noticed that I have received the Microsoft Community Contributor (MCC) badge for the first time and Thank you Microsoft!



And if you want to become one, read the following to know how. MICROSOFT COMMUNITY CONTRIBUTOR (MCC)

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…

TNWiki Article Spotlight - Creating and Deploying Microsoft Azure WebJobs

Hello World!

One of my articles was again featured in the TechNet Wiki Spotlight. This time it is the article  Creating and Deploying Microsoft Azure WebJobs .

TechNet Wiki blog link: http://blogs.technet.com/b/wikininjas/archive/2016/03/08/tnwiki-article-spotlight-creating-and-deploying-microsoft-azure-webjobs.aspx