Channel 9Microsofthttp://mschnlnine.vo.llnwd.net/d1/Dev/App_Themes/C9/images/feedimage.pngChannel 9http://channel9.msdn.com/Niners/SQLScott/Posts
Channel 9 keeps you up to date with the latest news and behind the scenes info from Microsoft that developers love to keep up with. From LINQ to SilverLight – Watch videos and hear about all the cool technologies coming and the people behind them.http://channel9.msdn.com/Niners/SQLScott/Posts
enTue, 03 Mar 2015 20:41:08 GMTTue, 03 Mar 2015 20:41:08 GMTRev946225Dynamic Data Masking in Azure SQL DatabaseThis week's episode of Data Exposed Scott welcomes Ron Matchoro, Senior Program Manager at Microsoft on the SQL Server team. Today, Ron introduces us to a new feature just released to Azure SQL Database called Dynamic Data Masking. Dynamic Data Masking is policy-based security feature that provides the ability to limit the exposure of data in Azure SQL Database by returning masked data to unprivileged users who run queries over designated database fields (for example, credit card numbers or social security numbers). No slides today, just awesome demos as Ron jumps right in and shows how easy it is to configure data masking, the different masking formats and the different masking functions all available to help obfuscate your data. This is a must-watch video. ]]>http://channel9.msdn.com/Shows/Data-Exposed/Dynamic-Data-Masking-in-Azure-SQL-DatabaseThis week's episode of Data Exposed Scott welcomes Ron Matchoro, Senior Program Manager at Microsoft on the SQL Server team. Today, Ron introduces us to a new feature just released to Azure SQL Database called Dynamic Data Masking. Dynamic Data Masking is policy-based security feature that provides the ability to limit the exposure of data in Azure SQL Database by returning masked data to unprivileged users who run queries over designated database fields (for example, credit card numbers or social security numbers). No slides today, just awesome demos as Ron jumps right in and shows how easy it is to configure data masking, the different masking formats and the different masking functions all available to help obfuscate your data. This is a must-watch video. 677http://channel9.msdn.com/Shows/Data-Exposed/Dynamic-Data-Masking-in-Azure-SQL-Database
Wed, 18 Feb 2015 16:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/Dynamic-Data-Masking-in-Azure-SQL-DatabaseScott KleinScott Klein0http://channel9.msdn.com/Shows/Data-Exposed/Dynamic-Data-Masking-in-Azure-SQL-Database/RSSAzureCloudSecuritySQLHDInsight on Linux Back for more discussion on HDInisght, Scott welcomes Matt Winkler back to the show. Matt, a Program Manager on the HDInsight team is here today to make a special announcement; the ability to deploy HDInsight clusters on Ubuntu Linux. While you still have the ability to deploy to Windows, you now have the ability to deploy your HDInsight cluster to Linux as well as Windows. In this video, Matt walks us through the simplicity of creating a HDInsight cluster on Linux, then shows us how easy it is to manage, maintain, and monitor these clusters through the use of Ambari, an Apache project aimed at making Hadoop cluster management simple for developers. ]]>http://channel9.msdn.com/Shows/Data-Exposed/HDInsight-on-LinuxBack for more discussion on HDInisght, Scott welcomes Matt Winkler back to the show. Matt, a Program Manager on the HDInsight team is here today to make a special announcement; the ability to deploy HDInsight clusters on Ubuntu Linux. While you still have the ability to deploy to Windows, you now have the ability to deploy your HDInsight cluster to Linux as well as Windows. In this video, Matt walks us through the simplicity of creating a HDInsight cluster on Linux, then shows us how easy it is to manage, maintain, and monitor these clusters through the use of Ambari, an Apache project aimed at making Hadoop cluster management simple for developers. 836http://channel9.msdn.com/Shows/Data-Exposed/HDInsight-on-Linux
Wed, 18 Feb 2015 16:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/HDInsight-on-LinuxScott KleinScott Klein1http://channel9.msdn.com/Shows/Data-Exposed/HDInsight-on-Linux/RSSAzureCloudBig DataIoTGeneral Availability and What's New with the Azure Storm ServiceScott welcomes back Asad Khan to the Data Exposed this week to make an exciting announcement and show us what's new with the Azure Storm service since he was here last. Asad, Principle PM on the HDInsight team makes the wonderful announcement of the General Availability of the Azure Storm service starting today. Storm, a service on HDInsight for real time analytics is a cloud-based data streaming service for HDInsight. Today, Asad reviews with us the end-to-end architecture and implementation of Storm on HDInsight and some of the interesting scenarios where Storm is being used today. Asad then shows us what his team has been working on since he was last on the show, focusing on developer productivity and making Storm enterprise ready. Asad cracks open Visual Studio and shows us how to create a Storm application, publish it to HDInsight, and then monitor the topology right in VS! Asad then opens up the Azure management portal and shows us the awesome new features added! ]]>http://channel9.msdn.com/Shows/Data-Exposed/General-Availability-and-Whats-new-with-the-Azure-Storm-ServiceScott welcomes back Asad Khan to the Data Exposed this week to make an exciting announcement and show us what's new with the Azure Storm service since he was here last. Asad, Principle PM on the HDInsight team makes the wonderful announcement of the General Availability of the Azure Storm service starting today. Storm, a service on HDInsight for real time analytics is a cloud-based data streaming service for HDInsight. Today, Asad reviews with us the end-to-end architecture and implementation of Storm on HDInsight and some of the interesting scenarios where Storm is being used today. Asad then shows us what his team has been working on since he was last on the show, focusing on developer productivity and making Storm enterprise ready. Asad cracks open Visual Studio and shows us how to create a Storm application, publish it to HDInsight, and then monitor the topology right in VS! Asad then opens up the Azure management portal and shows us the awesome new features added! 1791http://channel9.msdn.com/Shows/Data-Exposed/General-Availability-and-Whats-new-with-the-Azure-Storm-Service
Wed, 18 Feb 2015 16:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/General-Availability-and-Whats-new-with-the-Azure-Storm-ServiceScott KleinScott Klein0http://channel9.msdn.com/Shows/Data-Exposed/General-Availability-and-Whats-new-with-the-Azure-Storm-Service/RSSAzureCloudStreamingAzure Machine Learning MarketplaceThis week's episode of Data Exposed Scott welcomes Luis Cabrera-Cardon, Senior Program Manager at Microsoft on the Azure Machine Learning team. Today, Luis discusses with us the marketplace side of Azure Machine Learning, the Azure ML Marketplace, the ability to take a predictive analytics web service and democratize it by publishing it to make it available to everyone. Luis whips out an awesome demo by firing up Visual Studio and shows us how easy it is to consume one of the many available Machine Learning offers in the marketplace, the Recommendations service.. ]]>http://channel9.msdn.com/Shows/Data-Exposed/Azure-Machine-Leaning-MarketplaceThis week's episode of Data Exposed Scott welcomes Luis Cabrera-Cardon, Senior Program Manager at Microsoft on the Azure Machine Learning team. Today, Luis discusses with us the marketplace side of Azure Machine Learning, the Azure ML Marketplace, the ability to take a predictive analytics web service and democratize it by publishing it to make it available to everyone. Luis whips out an awesome demo by firing up Visual Studio and shows us how easy it is to consume one of the many available Machine Learning offers in the marketplace, the Recommendations service.. 1217http://channel9.msdn.com/Shows/Data-Exposed/Azure-Machine-Leaning-Marketplace
Tue, 17 Feb 2015 16:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/Azure-Machine-Leaning-MarketplaceScott KleinScott Klein1http://channel9.msdn.com/Shows/Data-Exposed/Azure-Machine-Leaning-Marketplace/RSSAzureCloudMachine LearningIoTAzure Search SuggestionsWe just can't get enough of Liam Cavanagh because he is back again on Data Exposed to talk about how to use suggestions in Azure Search. Liam, a Senior Program Manager for Azure Search wastes no time as he jumps right in, first explaining the overall concepts of how search suggestions should work, and follows that up by showing how to implement and configure search suggestions against Azure search into your application. Awesome stuff and very powerful. ]]>http://channel9.msdn.com/Shows/Data-Exposed/DataExposedAzureSearchSuggestionsWe just can't get enough of Liam Cavanagh because he is back again on Data Exposed to talk about how to use suggestions in Azure Search. Liam, a Senior Program Manager for Azure Search wastes no time as he jumps right in, first explaining the overall concepts of how search suggestions should work, and follows that up by showing how to implement and configure search suggestions against Azure search into your application. Awesome stuff and very powerful. 889http://channel9.msdn.com/Shows/Data-Exposed/DataExposedAzureSearchSuggestions
Tue, 10 Feb 2015 16:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/DataExposedAzureSearchSuggestionsScott KleinScott Klein4http://channel9.msdn.com/Shows/Data-Exposed/DataExposedAzureSearchSuggestions/RSSAzureSearchRow Level Security in Azure SQL DatabaseThis week's episode of Data Exposed Scott welcomes Ron Matchoro, Senior Program Manager at Microsoft on the SQL Server team. Today, Joachim introduces us to a new feature just released to Azure SQL Database called Dynamic Data Masking (DMM). DMM is feature that provides the ability to mask and obfuscate data in Azure SQL Database, addressing the regulatory and compliance concerns for storing data in the cloud. No slides today, just awesome demos as Ron jumps right in and shows how easy it is to configure data masking, the different masking formats and the different masking functions all available to help obfuscate your data. This is a must-watch video. ]]>http://channel9.msdn.com/Shows/Data-Exposed/Row-Level-Security-in-Azure-SQL-DatabaseThis week's episode of Data Exposed Scott welcomes Ron Matchoro, Senior Program Manager at Microsoft on the SQL Server team. Today, Joachim introduces us to a new feature just released to Azure SQL Database called Dynamic Data Masking (DMM). DMM is feature that provides the ability to mask and obfuscate data in Azure SQL Database, addressing the regulatory and compliance concerns for storing data in the cloud. No slides today, just awesome demos as Ron jumps right in and shows how easy it is to configure data masking, the different masking formats and the different masking functions all available to help obfuscate your data. This is a must-watch video. 1158http://channel9.msdn.com/Shows/Data-Exposed/Row-Level-Security-in-Azure-SQL-Database
Tue, 03 Feb 2015 16:25:10 GMThttp://channel9.msdn.com/Shows/Data-Exposed/Row-Level-Security-in-Azure-SQL-DatabaseScott KleinScott Klein2http://channel9.msdn.com/Shows/Data-Exposed/Row-Level-Security-in-Azure-SQL-Database/RSSAzureSecuritySQL AzureSQL ServerSQL Unplugged Episode 2This month's live episode of SQL Unplugged has Shawn Bice, Nigel Ellis, and Rohan Kumar answering your questions on everything from SQL DB, G series Azure VMs, Sterling and more! It sure was fun to do this live and take your questions on air.

]]>http://channel9.msdn.com/Shows/SQL-Unplugged/SQL-Unplugged-Episode-1Welcome to the inaugural episode of SQL Unplugged, your avenue for asking question to, and talking with, the three individual who own the relational database at Microsoft; Shawn Bice, Nigel Ellis, and Rohan Kumar. In our very first episode, Shawn and Nigel answer questions and discuss topics around the new NextGen Azure SQL Database, and give us awesome insight into the history of SQL DB and the process to bring SQL DB to where is today. We get to hear their passion for SQL Server and the relational database as they talk about how far these great products have come! Starting in January our shows will be LIVE! 1980http://channel9.msdn.com/Shows/SQL-Unplugged/SQL-Unplugged-Episode-1
Thu, 15 Jan 2015 00:11:16 GMThttp://channel9.msdn.com/Shows/SQL-Unplugged/SQL-Unplugged-Episode-1Scott KleinScott Klein7http://channel9.msdn.com/Shows/SQL-Unplugged/SQL-Unplugged-Episode-1/RSSSQLSQL AzureSQL ServerUnpluggedDeploying Hortonworks HDP on Microsoft AzureIn this week's episode of Data Exposed Scott welcomes Rohit Bakhshi, a Product Manager from Hortonworks. Rohit flew up from the Bay area in California to show us their awesome support for Apache Hadoop with Hortonworks Data Platform as an Infrastructure as a Service (IaaS) on Microsoft Azure. This is exciting news as it provides customers with flexibility and scalability for their big data deployments. Rohit jumps right in and shows us how easy it is to create a HDP cluster in Microsoft Azure. The demo gets even better when Rohit breaks out Apache Falcon and shows us how it can automate data movement for disaster recovery scenarios between your on-premises HDP cluster and your HDP cluster running in Microsoft Azure. Apache Falcon provides seamless data motion between on-premises and the cloud. Rohit shows us how simple it is to configure process pipelines using Apache Falcon. This is an episode you don't want to miss.​ ]]>http://channel9.msdn.com/Shows/Data-Exposed/Deploying-Hortonworks-HDP-on-Microsoft-AzureIn this week's episode of Data Exposed Scott welcomes Rohit Bakhshi, a Product Manager from Hortonworks. Rohit flew up from the Bay area in California to show us their awesome support for Apache Hadoop with Hortonworks Data Platform as an Infrastructure as a Service (IaaS) on Microsoft Azure. This is exciting news as it provides customers with flexibility and scalability for their big data deployments. Rohit jumps right in and shows us how easy it is to create a HDP cluster in Microsoft Azure. The demo gets even better when Rohit breaks out Apache Falcon and shows us how it can automate data movement for disaster recovery scenarios between your on-premises HDP cluster and your HDP cluster running in Microsoft Azure. Apache Falcon provides seamless data motion between on-premises and the cloud. Rohit shows us how simple it is to configure process pipelines using Apache Falcon. This is an episode you don't want to miss.​ 1937http://channel9.msdn.com/Shows/Data-Exposed/Deploying-Hortonworks-HDP-on-Microsoft-Azure
Tue, 13 Jan 2015 16:36:58 GMThttp://channel9.msdn.com/Shows/Data-Exposed/Deploying-Hortonworks-HDP-on-Microsoft-AzureScott KleinScott Klein0http://channel9.msdn.com/Shows/Data-Exposed/Deploying-Hortonworks-HDP-on-Microsoft-Azure/RSSAzureCloudBuilding Big Data Apps with HBaseIn this week's episode of Data Exposed Scott welcomes Maxim Lukiyanov, Senior Program Manager in the Big Data team at Microsoft, who walks us through a great introduction for using HBase to build big data type applications. For the first of many shows on HBase, Maxim walks us through how HBase is the trifecta technology along with Storm and HDInsight to develop big data applications. Maxim doesn't waste any time getting into a demo and happily shows off a twitter sentiment application using HBase, Storm, and HDInsight! He shows us the architecture of this application and how all the pieces fit and work together to create a seamless work of art. We then wrap the show up by discussing the details of HBase....yeah, we short of did things in reverse in this episode...but it was AWESOME! ]]>http://channel9.msdn.com/Shows/Data-Exposed/Building-Big-Data-Apps-with-HBaseIn this week's episode of Data Exposed Scott welcomes Maxim Lukiyanov, Senior Program Manager in the Big Data team at Microsoft, who walks us through a great introduction for using HBase to build big data type applications. For the first of many shows on HBase, Maxim walks us through how HBase is the trifecta technology along with Storm and HDInsight to develop big data applications. Maxim doesn't waste any time getting into a demo and happily shows off a twitter sentiment application using HBase, Storm, and HDInsight! He shows us the architecture of this application and how all the pieces fit and work together to create a seamless work of art. We then wrap the show up by discussing the details of HBase....yeah, we short of did things in reverse in this episode...but it was AWESOME! 1507http://channel9.msdn.com/Shows/Data-Exposed/Building-Big-Data-Apps-with-HBase
Tue, 06 Jan 2015 16:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/Building-Big-Data-Apps-with-HBaseScott KleinScott Klein2http://channel9.msdn.com/Shows/Data-Exposed/Building-Big-Data-Apps-with-HBase/RSSSQLBig DataAzure SQL Database NextGen Release PreviewIn this week's episode of Data Exposed Scott welcomes back Tony Petrossian, Group Program Manager for business continuity in Azure SQL Database, who introduces us to the preview release of Azure SQL Database. This NextGen release introduces near-complete SQL Server compatibility and better performance for Premium tiers as well as easier management of large databases, support for key programming functions, a new S3 level, and more. Tony wows with two great demos showcasing the near-complete SQL Server compatibility and then finishes off the session showing us a nice demo highlighting the performance improvements for the Premium offering. The best 15 minute video will see in a long time! ]]>http://channel9.msdn.com/Shows/Data-Exposed/Azure-SQL-Database-NextGen-Release-PreviewIn this week's episode of Data Exposed Scott welcomes back Tony Petrossian, Group Program Manager for business continuity in Azure SQL Database, who introduces us to the preview release of Azure SQL Database. This NextGen release introduces near-complete SQL Server compatibility and better performance for Premium tiers as well as easier management of large databases, support for key programming functions, a new S3 level, and more. Tony wows with two great demos showcasing the near-complete SQL Server compatibility and then finishes off the session showing us a nice demo highlighting the performance improvements for the Premium offering. The best 15 minute video will see in a long time! 931http://channel9.msdn.com/Shows/Data-Exposed/Azure-SQL-Database-NextGen-Release-Preview
Tue, 16 Dec 2014 16:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/Azure-SQL-Database-NextGen-Release-PreviewScott KleinScott Klein7http://channel9.msdn.com/Shows/Data-Exposed/Azure-SQL-Database-NextGen-Release-Preview/RSSAzureCloudSQLSQL AzureSQL ServerQuerying in DocumentDBThis week on Data Exposed, Scott welcomes Aravind Ramachandran, Senior PM on the Azure DocumentDB team. In this episode, Aravind gives us the lowdown on the DocumentDB querying capabilities in an easy to understand approach. After providing a quick introduction into DocumentDB, Aravind dives right in to the great query capabilities by showing us how it is to use a familiar SQL-like grammar over hierarchial JSON documents. Aravind also spends a few minutes discussing SQL query grammar differences and then shows us an awesome website (http://www.documentdb.com/sql/demo#) available to everyone in which you can try out the SQL query syntax. Awesome video! ]]>http://channel9.msdn.com/Shows/Data-Exposed/DataExposedQueryingDocumentDBThis week on Data Exposed, Scott welcomes Aravind Ramachandran, Senior PM on the Azure DocumentDB team. In this episode, Aravind gives us the lowdown on the DocumentDB querying capabilities in an easy to understand approach. After providing a quick introduction into DocumentDB, Aravind dives right in to the great query capabilities by showing us how it is to use a familiar SQL-like grammar over hierarchial JSON documents. Aravind also spends a few minutes discussing SQL query grammar differences and then shows us an awesome website (http://www.documentdb.com/sql/demo#) available to everyone in which you can try out the SQL query syntax. Awesome video! 1071http://channel9.msdn.com/Shows/Data-Exposed/DataExposedQueryingDocumentDB
Tue, 09 Dec 2014 16:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/DataExposedQueryingDocumentDBScott KleinScott Klein3http://channel9.msdn.com/Shows/Data-Exposed/DataExposedQueryingDocumentDB/RSSAzureSQL Server Data ToolsIn this episode, Robert is joined by Scott Klein, host of the Data Exposed show. Scott shows us the SQL Server Data Tools in Visual Studio and demonstrates some scenarios when you can use those rather than leaving Visual Studio and using external tools such as SQL Server Management Studio. ]]>http://channel9.msdn.com/Shows/Visual-Studio-Toolbox/SQL-Server-Data-ToolsIn this episode, Robert is joined by Scott Klein, host of the Data Exposed show. Scott shows us the SQL Server Data Tools in Visual Studio and demonstrates some scenarios when you can use those rather than leaving Visual Studio and using external tools such as SQL Server Management Studio. 1644http://channel9.msdn.com/Shows/Visual-Studio-Toolbox/SQL-Server-Data-Tools
Wed, 03 Dec 2014 17:28:06 GMThttp://channel9.msdn.com/Shows/Visual-Studio-Toolbox/SQL-Server-Data-ToolsRobert Green, Scott KleinRobert Green, Scott Klein11http://channel9.msdn.com/Shows/Visual-Studio-Toolbox/SQL-Server-Data-Tools/RSSSQL ServerVisual StudioSQL Server to Azure Search SynchronizationThis week on Data Exposed, Scott welcomes back an old friend, Liam Cavanagh, Senior Program Manager for Azure Search, to discuss some of the new features added to Azure Search as well as look at how to keep an Azure SQL Database in sync with Azure Search, enabling you to provide near-real time updates to your search index. Liam begins by explaining many of the reasons why people choose to leverage Azure Search to provide full-text search over their SQL Server data and how to leverage a capability in SQL Server called Integrated Change Tracking to efficiently find changes in your SQL Server tables to uploaded to Azure Search. The source code for the sample in this video as well as more details about this topic can be found here: http://azure.microsoft.com/blog/2014/11/10/how-to-sync-sql-server-data-with-azure-search/]]>http://channel9.msdn.com/Shows/Data-Exposed/SQL-Server-to-Azure-Search-SynchronizationThis week on Data Exposed, Scott welcomes back an old friend, Liam Cavanagh, Senior Program Manager for Azure Search, to discuss some of the new features added to Azure Search as well as look at how to keep an Azure SQL Database in sync with Azure Search, enabling you to provide near-real time updates to your search index. Liam begins by explaining many of the reasons why people choose to leverage Azure Search to provide full-text search over their SQL Server data and how to leverage a capability in SQL Server called Integrated Change Tracking to efficiently find changes in your SQL Server tables to uploaded to Azure Search. The source code for the sample in this video as well as more details about this topic can be found here: http://azure.microsoft.com/blog/2014/11/10/how-to-sync-sql-server-data-with-azure-search/ 997http://channel9.msdn.com/Shows/Data-Exposed/SQL-Server-to-Azure-Search-Synchronization
Tue, 02 Dec 2014 21:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/SQL-Server-to-Azure-Search-SynchronizationScott KleinScott Klein3http://channel9.msdn.com/Shows/Data-Exposed/SQL-Server-to-Azure-Search-Synchronization/RSSAzureSearchSQL ServerIntroducing Azure Data FactoryIn this week's episode of Data Exposed, Scott welcomes Anand Subbaraj, Senior Lead PM on the Azure Data Factory team. Today Anand introduce us to Data Factory, a new Azure service for data developers & IT professionals to easily transform raw data into trusted data assets for their organization at scale. Data Factory operates over a range of data services, and supports processing of on-premises SQL Server, Azure SQL Database, Blobs, and Tables using Hive, Pig, and C# on HDInsight (Hadoop). Easily create and orchestrate simple, highly available, fault tolerant data analytics pipelines that can be monitored at a glance with the Azure Preview Portal. Competitive, data-driven organizations are collecting, processing and gaining insight from more data than ever before. Use data pipelines to deliver transformed data from the cloud back to on-premises sources like SQL Server, or keep it in cloud storage. Take advantage of seamless connection with Power BI for O365 and other applications for consumption of data assets. ]]>http://channel9.msdn.com/Shows/Data-Exposed/Introducing-Azure-Data-FactoryIn this week's episode of Data Exposed, Scott welcomes Anand Subbaraj, Senior Lead PM on the Azure Data Factory team. Today Anand introduce us to Data Factory, a new Azure service for data developers &amp; IT professionals to easily transform raw data into trusted data assets for their organization at scale. Data Factory operates over a range of data services, and supports processing of on-premises SQL Server, Azure SQL Database, Blobs, and Tables using Hive, Pig, and C# on HDInsight (Hadoop). Easily create and orchestrate simple, highly available, fault tolerant data analytics pipelines that can be monitored at a glance with the Azure Preview Portal. Competitive, data-driven organizations are collecting, processing and gaining insight from more data than ever before. Use data pipelines to deliver transformed data from the cloud back to on-premises sources like SQL Server, or keep it in cloud storage. Take advantage of seamless connection with Power BI for O365 and other applications for consumption of data assets. 1892http://channel9.msdn.com/Shows/Data-Exposed/Introducing-Azure-Data-Factory
Tue, 18 Nov 2014 16:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/Introducing-Azure-Data-FactoryScott KleinScott Klein3http://channel9.msdn.com/Shows/Data-Exposed/Introducing-Azure-Data-Factory/RSSAzureDataStreamingUsing SQL Server Integration Services to control the power of Azure HDInsightIn this weeks episode on Data Exposed Scott Klein welcomes his sqlfamily friends Tillmann Eitelberg, Oliver Engels and Niko Neugebauer (SQL MVPs from Germany and Portugal) to talk about their Integration Service Components to control and integrated Azure HDInsight and DocumentDB. Oliver, Tillman, and Niko discuss and demonstrate how easy it is to create HDInsight clusters, MapReduce jobs or Sqoop query from SSIS and integrated Hadoop to your on-premises processes and data flow. This is a must-watch this video if you want to control the cloud from on-premises SQL Server.

]]>http://channel9.msdn.com/Shows/Data-Exposed/Using-SQL-Server-Integration-Services-to-control-the-power-of-Azure-HDInsightIn this weeks episode on Data Exposed Scott Klein welcomes his sqlfamily friends Tillmann Eitelberg, Oliver Engels and Niko Neugebauer (SQL MVPs from Germany and Portugal) to talk about their Integration Service Components to control and integrated Azure HDInsight and DocumentDB. Oliver, Tillman, and Niko discuss and demonstrate how easy it is to create HDInsight clusters, MapReduce jobs or Sqoop query from SSIS and integrated Hadoop to your on-premises processes and data flow. This is a must-watch this video if you want to control the cloud from on-premises SQL Server. 1180http://channel9.msdn.com/Shows/Data-Exposed/Using-SQL-Server-Integration-Services-to-control-the-power-of-Azure-HDInsight
Mon, 10 Nov 2014 19:34:01 GMThttp://channel9.msdn.com/Shows/Data-Exposed/Using-SQL-Server-Integration-Services-to-control-the-power-of-Azure-HDInsightScott KleinScott Klein3http://channel9.msdn.com/Shows/Data-Exposed/Using-SQL-Server-Integration-Services-to-control-the-power-of-Azure-HDInsight/RSSAzureSSISHadoop Meets the Cloud: Scenarios for HDInsightYou may have heard about "Hadoop" or "big data". How much of it is hype versus reality? In this stimulating episode of Data Exposed, Scott welcomes Matt Winkler, Program Manager on the HDInsight team. In this first of many shows dedicated to Azure HDInsight, Matt talks about why customers want Hadoop and what customer scenarios it enables. Matt focuses on specific customer examples that are being solved with Hadoop and the value of HDInsight. In this episode, learn through real-life customer scenarios and gain some ideas of how you can use Hadoop in your environment to solve some of the big data challenges many customers face today. ]]>http://channel9.msdn.com/Shows/Data-Exposed/Hadoop-Meets-the-Cloud-Scenarios-for-HDInsightYou may have heard about &quot;Hadoop&quot; or &quot;big data&quot;. How much of it is hype versus reality? In this stimulating episode of Data Exposed, Scott welcomes Matt Winkler, Program Manager on the HDInsight team. In this first of many shows dedicated to Azure HDInsight, Matt talks about why customers want Hadoop and what customer scenarios it enables. Matt focuses on specific customer examples that are being solved with Hadoop and the value of HDInsight. In this episode, learn through real-life customer scenarios and gain some ideas of how you can use Hadoop in your environment to solve some of the big data challenges many customers face today. 2567http://channel9.msdn.com/Shows/Data-Exposed/Hadoop-Meets-the-Cloud-Scenarios-for-HDInsight
Wed, 29 Oct 2014 15:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/Hadoop-Meets-the-Cloud-Scenarios-for-HDInsightScott KleinScott Klein1http://channel9.msdn.com/Shows/Data-Exposed/Hadoop-Meets-the-Cloud-Scenarios-for-HDInsight/RSSAzureSQLBig DataIntroducing Storm on HDInsightIn this episode of Data Exposed, Scott welcomes Asad Khan, Principle PM on the HDInsight team. Today Asad introduce us to Storm , a new service on HDInsight for real time analytics. This is an interesting and exciting episode as Asad walks us through how Microsoft utilizes an open-source technology to produce a cloud-based data streaming service for HDInsight. Asad walks us through the end-to-end architecture and implementation of Storm on HDInsight and what the service has to offer in terms of the power and flexibility of the service. Because this is an open-source technology, Asad spends some significant time on Microsoft's promise to the customer in terms of service usability and performance. The episode ends with a fun and exciting demo where Asad uses the twitter API to stream in a specific twitter topic to show the power of Storm. Great stuff! ]]>http://channel9.msdn.com/Shows/Data-Exposed/Introducing-Storm-on-HDInsightIn this episode of Data Exposed, Scott welcomes Asad Khan, Principle PM on the HDInsight team. Today Asad introduce us to Storm , a new service on HDInsight for real time analytics. This is an interesting and exciting episode as Asad walks us through how Microsoft utilizes an open-source technology to produce a cloud-based data streaming service for HDInsight. Asad walks us through the end-to-end architecture and implementation of Storm on HDInsight and what the service has to offer in terms of the power and flexibility of the service. Because this is an open-source technology, Asad spends some significant time on Microsoft's promise to the customer in terms of service usability and performance. The episode ends with a fun and exciting demo where Asad uses the twitter API to stream in a specific twitter topic to show the power of Storm. Great stuff! 2099http://channel9.msdn.com/Shows/Data-Exposed/Introducing-Storm-on-HDInsight
Tue, 28 Oct 2014 15:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/Introducing-Storm-on-HDInsightScott KleinScott Klein1http://channel9.msdn.com/Shows/Data-Exposed/Introducing-Storm-on-HDInsight/RSSAzureStreamingBig DataIntroduction to Azure Stream AnalyticsThis week on Data Exposed, Scott welcomes Judy Meyer, Principle PM, and Dipanjan Banik, Program Manager. In this episode Judy and Dipanjan introduce us to the new Azure Stream Analytics service, a fully managed streaming service designed to gather and process information to provide real-time insights into your data as quickly as possible. Judy and Dipanjan explain how the new Azure Stream Analytics services is a streaming process to handle large amounts of data in motion designed to easily and efficiently scale to handle mass amounts of volumes of data in a matter of seconds. Judy and Dipanjan discuss with us several scenarios around the Azure Stream Analytics service and how streaming plays into the overall big data picture ; many customers know that they want to do something with data in motion as their volume of data is growing but they don't yet know they want to do or how to do it. In this episode, Judy and Dipanjan show us how the capabilities of Azure Stream Analytics help work with mass volumes of data more manageable. Lastly, Dipanjan demonstrates how easy it is to get started with the Azure Stream Analytics service by doing sentiment analysis over live twitter feeds. ]]>http://channel9.msdn.com/Shows/Data-Exposed/DataExposedAzureStreamAnalyticsThis week on Data Exposed, Scott welcomes Judy Meyer, Principle PM, and Dipanjan Banik, Program Manager. In this episode Judy and Dipanjan introduce us to the new Azure Stream Analytics service, a fully managed streaming service designed to gather and process information to provide real-time insights into your data as quickly as possible. Judy and Dipanjan explain how the new Azure Stream Analytics services is a streaming process to handle large amounts of data in motion designed to easily and efficiently scale to handle mass amounts of volumes of data in a matter of seconds. Judy and Dipanjan discuss with us several scenarios around the Azure Stream Analytics service and how streaming plays into the overall big data picture ; many customers know that they want to do something with data in motion as their volume of data is growing but they don't yet know they want to do or how to do it. In this episode, Judy and Dipanjan show us how the capabilities of Azure Stream Analytics help work with mass volumes of data more manageable. Lastly, Dipanjan demonstrates how easy it is to get started with the Azure Stream Analytics service by doing sentiment analysis over live twitter feeds. 1433http://channel9.msdn.com/Shows/Data-Exposed/DataExposedAzureStreamAnalytics
Mon, 27 Oct 2014 23:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/DataExposedAzureStreamAnalyticsScott KleinScott Klein4http://channel9.msdn.com/Shows/Data-Exposed/DataExposedAzureStreamAnalytics/RSSanalysisAzureStreamInsightStreamingBig DataSQL Database Migration WizardThis week, Scott welcomes George Huey, a Principal Technical Evangelist in DX at Microsoft to the Data Exposed show. In this episode, George gives us a detailed look at the SQL Database Migration Wizard, an open-source tool designed to migrate your on-premises SQL Server databases to Azure SQL Database. George shows us many of the great features of the tool, including the ability to analyze T-SQL scripts, your source database, or even trace files for SQL Database compatibility. If you are looking for a way to migrate your on-premises database to Azure SQL Database, George shows why you should consider this tool. ]]>http://channel9.msdn.com/Shows/Data-Exposed/SQL-Database-Migration-WizardThis week, Scott welcomes George Huey, a Principal Technical Evangelist in DX at Microsoft to the Data Exposed show. In this episode, George gives us a detailed look at the SQL Database Migration Wizard, an open-source tool designed to migrate your on-premises SQL Server databases to Azure SQL Database. George shows us many of the great features of the tool, including the ability to analyze T-SQL scripts, your source database, or even trace files for SQL Database compatibility. If you are looking for a way to migrate your on-premises database to Azure SQL Database, George shows why you should consider this tool. 1767http://channel9.msdn.com/Shows/Data-Exposed/SQL-Database-Migration-Wizard
Wed, 08 Oct 2014 15:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/SQL-Database-Migration-WizardScott KleinScott Klein0http://channel9.msdn.com/Shows/Data-Exposed/SQL-Database-Migration-Wizard/RSSAzuremigrationSQLSQL AzureCouchbase Server on Microsoft AzureThis episode of Data Exposed welcomes an old friend to the show, Cihan Biyikoglu, Director of Product Management at Couchbase. Cihan joins Scott via Skype from his office in Mountain View, California to introduce us to Couchbase Server and Couchbase lite, products that offer solutions for real-time & operational big data as well as NoSQL database solutions for mobile and edge data. Cihan gives us a powerful look into running Couchbase Server on Microsoft Azure providing the benefits of elastic scalability and flexible global deployment. ]]>http://channel9.msdn.com/Shows/Data-Exposed/Couchbase-Server-on-Microsoft-AzureThis episode of Data Exposed welcomes an old friend to the show, Cihan Biyikoglu, Director of Product Management at Couchbase. Cihan joins Scott via Skype from his office in Mountain View, California to introduce us to Couchbase Server and Couchbase lite, products that offer solutions for real-time &amp; operational big data as well as NoSQL database solutions for mobile and edge data. Cihan gives us a powerful look into running Couchbase Server on Microsoft Azure providing the benefits of elastic scalability and flexible global deployment. 1522http://channel9.msdn.com/Shows/Data-Exposed/Couchbase-Server-on-Microsoft-Azure
Mon, 06 Oct 2014 15:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/Couchbase-Server-on-Microsoft-AzureScott KleinScott Klein1http://channel9.msdn.com/Shows/Data-Exposed/Couchbase-Server-on-Microsoft-Azure/RSSAzureSQLAzure SQL Database Elastic ScaleThis week, Scott welcomes Torsten Grabs, a Principal Program Manager Lead on the SQL team focusing on elastic scale for Azure SQL Database. In this exciting and much-anticipated episode, Torsten introduces us to Azure SQL Database Elastic Scale; .NET client libraries and Azure cloud service packages providing the ability to easily develop, scale, and manage the stateful data tiers of your SQL Server applications. The goal with these libraries and services is to solve the challenges of elastic scale; growing and shrinking database capacity for applications running on Azure SQL DB. Elastic Scale adopts sharding as the underlying concept to distribute data and processing across multiple scale units in Azure SQL DB – and gives you the libraries and tools for sharding so that you can focus on the business logic of your application. Torsten wraps up the episode by showing us an awesome demo on Elastic Scale and data dependent routing. There is plenty more to cover on this topic so stay tuned to this show for more exiting episodes on this topic! ]]>http://channel9.msdn.com/Shows/Data-Exposed/Azure-SQL-Database-Elastic-ScaleThis week, Scott welcomes Torsten Grabs, a Principal Program Manager Lead on the SQL team focusing on elastic scale for Azure SQL Database. In this exciting and much-anticipated episode, Torsten introduces us to Azure SQL Database Elastic Scale; .NET client libraries and Azure cloud service packages providing the ability to easily develop, scale, and manage the stateful data tiers of your SQL Server applications. The goal with these libraries and services is to solve the challenges of elastic scale; growing and shrinking database capacity for applications running on Azure SQL DB. Elastic Scale adopts sharding as the underlying concept to distribute data and processing across multiple scale units in Azure SQL DB – and gives you the libraries and tools for sharding so that you can focus on the business logic of your application. Torsten wraps up the episode by showing us an awesome demo on Elastic Scale and data dependent routing. There is plenty more to cover on this topic so stay tuned to this show for more exiting episodes on this topic! 1660http://channel9.msdn.com/Shows/Data-Exposed/Azure-SQL-Database-Elastic-Scale
Thu, 02 Oct 2014 17:00:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/Azure-SQL-Database-Elastic-ScaleScott KleinScott Klein19http://channel9.msdn.com/Shows/Data-Exposed/Azure-SQL-Database-Elastic-Scale/RSSAzureScalabilitySQLSQL AzureAzure Search and Geospatial DataThis episode of Data Exposed welcomes back Liam Cavanagh, a Senior Program Manager in the Azure Data Platform Incubation team at Microsoft. No slides, all demos today in this amazing video as Liam shows us how to use Azure Search to search Geo-spatial data. Liam shows off a publicly available sample application which shows how to add geospatial search to your web applications through the use of Azure Search and Bing Maps. http://azure.microsoft.com/en-us/documentation/articles/search-create-geospatial/]]>http://channel9.msdn.com/Shows/Data-Exposed/Azure-Search-and-Geospatial-DataThis episode of Data Exposed welcomes back Liam Cavanagh, a Senior Program Manager in the Azure Data Platform Incubation team at Microsoft. No slides, all demos today in this amazing video as Liam shows us how to use Azure Search to search Geo-spatial data. Liam shows off a publicly available sample application which shows how to add geospatial search to your web applications through the use of Azure Search and Bing Maps. http://azure.microsoft.com/en-us/documentation/articles/search-create-geospatial/ 1089http://channel9.msdn.com/Shows/Data-Exposed/Azure-Search-and-Geospatial-Data
Wed, 24 Sep 2014 15:00:18 GMThttp://channel9.msdn.com/Shows/Data-Exposed/Azure-Search-and-Geospatial-DataScott KleinScott Klein4http://channel9.msdn.com/Shows/Data-Exposed/Azure-Search-and-Geospatial-Data/RSSAzureDataSQLInsights into Azure SQL DatabaseIn this special episode of Data Exposed, Scott welcomes to the show the three individuals who own the relational database at Microsoft; Shawn Bice (Partner Director SQL Relational Assets), Nigel Ellis (Distinguished Engineer SQL Database), and Rohan Kumar (Partner Director SQL RDBMS). In this episode, Shawn, Nigel, and Rohan provide a candid and insightful behind-the-scenes look at Azure SQL Database, the new service tiers, and the process around determining the right set of capabilities at each tier. We discuss the operational hardening of Azure SQL Database and the journey that took the relational service from where it began to the only relational database service in the world with 99.99 availability SLA. We gain fantastic insight into how the SQL Server team learned through the operational hardening process how to ship SQL Server in a cloud cadence by looking at operational metrics with the magic being in the velocity of delivering quickly and efficiently. Microsoft is bullish about the new service tiers and the richer capabilities available in Azure SQL Database. ]]>http://channel9.msdn.com/Shows/Data-Exposed/Insights-into-Azure-SQL-DatabaseIn this special episode of Data Exposed, Scott welcomes to the show the three individuals who own the relational database at Microsoft; Shawn Bice (Partner Director SQL Relational Assets), Nigel Ellis (Distinguished Engineer SQL Database), and Rohan Kumar (Partner Director SQL RDBMS). In this episode, Shawn, Nigel, and Rohan provide a candid and insightful behind-the-scenes look at Azure SQL Database, the new service tiers, and the process around determining the right set of capabilities at each tier. We discuss the operational hardening of Azure SQL Database and the journey that took the relational service from where it began to the only relational database service in the world with 99.99 availability SLA. We gain fantastic insight into how the SQL Server team learned through the operational hardening process how to ship SQL Server in a cloud cadence by looking at operational metrics with the magic being in the velocity of delivering quickly and efficiently. Microsoft is bullish about the new service tiers and the richer capabilities available in Azure SQL Database. 1761http://channel9.msdn.com/Shows/Data-Exposed/Insights-into-Azure-SQL-Database
Tue, 16 Sep 2014 20:30:00 GMThttp://channel9.msdn.com/Shows/Data-Exposed/Insights-into-Azure-SQL-DatabaseScott KleinScott Klein0http://channel9.msdn.com/Shows/Data-Exposed/Insights-into-Azure-SQL-Database/RSSAzureSQLSQL Azure