Azure sessions from SQLBits

‘Out of the box’ advanced analytics & data warehousing

Pyramid Analytics BI Office’s Enterprise BI Platform and PrecisionPoint’s data warehousing solution for MS Dynamics ERP systems combine to deliver simplified access to key Business and Financial data.

A Deep Dive Into Data Lakes

Learn the ins and outs of Azure Data Lake in this deep dive

Adaptive QP Enhancements in SQL Server and SQL Azure

The SQL team has been working on next-gen query processing improvements to improve the performance of your queries and to enable new scenarios. This talk will explain these enhancements and how they fit into the overall product roadmap for SQL.

Azure SQL Database best practices in resiliency design

We’ll share in the session best practices of designing highly available SQL Databases in the context of cross region deployment; how to make your application robust to handle transient connectivity issues.

Azure SQL DataWarehouse: 0-100 (DWUs)

Azure SQLDW - WHAT, WHERE, WHEN and HOW to use it.

Better than PowerBI? Best-in-class, on-prem for Microsoft BI

Industry independent analysts say “Pyramid Analytics is essentially the best-in-class, on-premises offering for Microsoft BI today and tomorrow” What does this mean for you and PowerBI?

Building an End to End IoT Solution Using Pi Sensors & Azure

Demonstrating an end to end IoT solution providing real-time sensor data from a Raspberry Pi into an Azure IoT Hub, through Stream Analytics, then with outputs to Power BI and SQL DB. Learn how to build this simplified IoT solution from scratch.

Building Blocks of Cortana Intelligence Suite in Azure

A practical look at the components of Cortana Intelligence Suite.

Database Design Throwdown

Data architects and DBAs have debated database design best practices for decades. Join us for some great debates and laughs.

Database Security in SQL Server 2016 and beyond

In this session we will review the new enhancement to SQL Server security available in SQL Server 2016 and Azure SQL DB.

Impact of weather on English Premier League in Power BI

By using open data and web scraping in Power BI we will examine if weather has an impact on games in the English Premier League. We will look at the advantages and disadvantages of using open data and web page data how Power BI works with it.

Including Your Database in a DevOps CI/CD Process

Many organizations want to build software in a DevOps framework, but struggle to include the database. Come see how Continuous Integration, Testing, and Continuous Deliver can work with a database.

Introducing the Query Store

The Query Store will change how you tune queries and gather metrics about them in both SQL Server 2016 and Azure SQL Database.

Introduction to Azure Analysis Services

Learn to build Analysis Services models in the cloud

Migrating from SQL Server to Azure SQL Database

Come to this session to learn about AzureSQL DB migration approaches, challenges, and solutions from SQLCAT. We will present practical migration guidance and learnings from our engagements with high scale and complex customer migrations

Near real-time IoT Analytics of Pumping Stations in PowerBI

An IoT analytics solution addressing real-life issues with SCADA data from a network of 600 Waste Water Treatment Plants and 100s of Pumping Stations. An end-to-end solution with Azure Data Warehouse, Azure Data Factory, Azure Analysis Services and PowerBI

Operational Machine Learning: MS Tech for Data Science

Discover the Microsoft technologies that enable end-to-end data science, including SQL Server and Azure PaaS Services, along with practical scenarios and demos.

Orchestrating data with Azure Data Factory

See how Azure Data Factory orchestrates the movement of data in Azure, with a case study from a Microsoft partner.

Power BI and SSRS-Better Together

What are the pros and cons of SSRS compared to Power BI? How can you benefit from Power BI on-premises?

Review ColumnStore Index in SQL 2016 and Azure SQL DB

This session describes columnstore index internals with deep insight into data compression methodology for achieving high query performance including improvements in column store investments for SQL Server 2016 and Microsoft Azure SQL Database

SQL Server/Azure Engineering Model

The SQL Team delivers value monthly to both cloud and on-premises environments. This is not easy to do. This talk will explain the model, telemetry and security

Whats new in Azure SQL DB and SQL engine

Attend this session to get an overview of the wide array of significant changes and investments with Azure SQL Database, including parity with SQL Server 2016 and Intelligent database capabilities.

Who Am I? Managing Identities in Azure

Learn about identity management in Azure. You will learn about how to manage identity across your cloud environments.

A Beginner’s Guide to Cloud Computing and SQL Azure

This talk takes a look at Cloud Computing – what it is, the types of Cloud available and their advantages and disadvantages along with what Microsoft Azure has to offer.

Accelerating Business with Mission Critical Intelligence

Join Joseph for a fascinating look into SQL Server 2016 and its unmatched innovation across on-premises and the cloud to help you turn data into intelligent action

Advanced Topics for Azure SQL Data Warehouse

This session covers the more advanced aspects of development for Azure SQL Data Warehouse. Areas such as data movement, workload concurrency and resource management will all be covered during this intense 60 minute session.

Are failover clusters ready for extinction?

This session will compare Microsoft’s options for deploying highly available SQL Server data platforms in mid-2016.

Azure Data Factory vs SSIS

Azure Data Factory and SSIS are both data movement tools, but built for different purposes. In this session you will learn pros and cons of using each technology, and best practices of using each in real world scenarios.

Azure DocumentDB: Advanced Features for Large-Scale Apps

Let's talk about how you can get the most out of Azure DocumentDB. In this session we will dive deep in to the mechanics of DocumentDB and explain the various levers available to tune performance.

Azure SQL Database Security - Microsoft product team

Join me for an overview of how Azure SQL DB customers can simply secure their data using our most advanced features to-date including Always Encrypted, Transparent Data Encryption, Dynamic Data Masking and SQL Threat Detection.

Dumping data into Azure Data Lake with Data Factory

An introduction with worked examples of the new Data Lake storage platform in Azure.

Essential Architecture for Bi in a Virtual Environment

Virtualization has had a major impact on computing. While data professionals have adjusted to this for database servers, many BI workloads have moved there as well. Learn about the impact of virtualization on BI.

Intelligent Database as a Service

Azure SQL DB can automatically make apps run faster and more cost-effectively, based on workload telemetry from millions of customers. Come and see live demos about what the service can do

Introducing U-SQL: Big Data Processing made easy

This presentation will give you an overview on U-SQL, why we decided to build a new language, what its core philosophical underpinnings are as well as show the language in its natural habitat, development tooling and language capabilities

Machine Learning demystified: ask the right questions

In this session, we are going to look at a typical machine learning process and how to apply it to real world data. We are going to use Azure Machine Learning to transform data and ideas into models that are production ready in minutes.

Migrating databases to Azure

Running databases in SQL Servers in your office or data centre? Considering moving them to Azure? Want to know what options and benefits of Infrastructure as a Service and Platform as a Service?

Modeling Data in a Document-Oriented NoSQL Database

In this talk, you will get an overview on what to think about when storing data in a document database.

New T-SQL capabilities in SQL Server 2016 & Azure

Discover the ins and outs of some of the newest capabilities of our favorite data language. From JSON to COMPRESS/DECOMPRESS, from SESSION_CONTEXT() to DATEDIFF_BIG(), and new query hints.

Operational insights with Azure temporal tables and PowerBI

System-versioned temporal tables provide information about data at any point in time rather than just the current moment, and are a must have feature for any DBA. Collect vast amounts of operational data using OSS based on PowerShell technology and Azure. Add PowerBI to the mix and get mind blowing insights, the future will never be the same.

Re-architecting your old-school database into Azure

The quickest way to migrate your on-premises OLTP database to Azure is to "Lift & Shift". In this session we will investigate how we could use more of the cloud features like SQL Database, Redis Cache, Search, etc.

SSDT – insights from the product team

Join us in this session to learn about recent improvements and the ongoing work made to SSDT. This session gives you a chance to directly connect with the product team and get their insights.

The Intelligence of your Things

The Internet of Things starts with your things. It's a great time to take a look at game changing technologies you can use today to make your IoT ideas stand out from the rest using Microsoft Azure.

The Modern Intelligent Application

This session will examine how to successfully design a modern data architecture on the Microsoft Azure cloud platform. Focusing on design tenants for efficient, scalable and resilient data processing

The Query Store and Query Tuning in SQL Server vNext

SQL Server 2016 introduces the Query Store. The Query Store will change how you tune queries. Come to this session to learn everything you'll need.

Time Travel with Azure ML

This session looks at building time series analysis with AzureML in R

Warehouse of the Future: Lakes Vs Marts

Data Warehouses are changing. This session will run through the architecture of the modern warehouse, from structured/unstructured Azure Data Lakes to platform as a service Azure Data Warehouse and bringing the two together.

Agnostic, Hybrid Big Data Integration using PDW and PolyBase

PolyBase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and Windows Azure Storage Blobs (WASB). See it in action.

Analyze data streams with Azure stream analytics

Azure stream analytics is a new Azure service for analyzing streaming data.

Azure Machine Learning from the ground up

Azure Machine Learning is a fully managed cloud service for predictive analytics. In this 1hour session, we will run through; ML Studio,using data, Creating and running Experiments, visualising results, R , publishing and using experiments.

Azure Networks and VMs for the DB Guy

Sometimes don't want our data in the cloud, but that doesn't mean we can't use the cloud at all.

Building an Operational Data Store using SQL Server in Azure

This presentation will focus on techniques and practices for using memory optimized tables in SQL Server to build “warm” data stores from a variety of application data sources (logs,traces, performance statistics)

Building Big - In The Cloud

The Azure CAT team has successfully architected, designed and built hundreds of cloud projects. In this session we will share the learnings on how to design a cloud application to scale to handle large, complex workloads.

Building scalable analytical solutions on Azure

Come to this session to see how to build a scalable analytical solution on Microsoft Azure with Elastic Search and Kibana.

Cloud Migration: The anatomy of a whole datacentre migration

Come to this session to find out what is involved and what we learned from migrating 700+ servers into Microsoft Azure.

Columnstore Indexes in SQL 2014: Flipping the DW Faster Bit

This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites

Cool Story, Bro: The DBAreactions Guide to SQL Server 2014

You're hearing a lot about the new features in SQL Server, but you're not hearing a lot about the drawbacks. Ever wonder why? Join Brent Ozar, the guy behind DBAreactions.com, for a sarcastic, funny look at SQL Server 2014's "features" and bugs.

Data Culture

Being able to reason over your data and accelerate your insights is essential in this cloud first mobile first world. This session visits key technologies, PowerBI, AzureML and IoT to help you start driving your data culture.

Delivering Agile Analytics with Azure Machine Learning

Does the concept of analytics make you nervous? Are you being asked to do more advanced analysis with existing tools? Come learn how to take your predictive capabilities to the next level with new azure technologies.

Deploying SQL Server with Microsoft Azure Virtual Machine

Many customers are looking toward Cloud technologies to reduce operational and capital expenditures. A popular choices today for SQL Server customers is to deploy in the Microsoft Azure Virtual Machine environment. Come to this session and learn how

DR with the Worlds largest data center

This session will look at providing cost effective DR capability with Azure.

From Here to Azure

Attend this interactive session and learn how to create, deploy, and migrate data from your on-premises instance of SQL Server to Microsoft Azure Virtual Machines and Microsoft Azure SQL Database.

Getting Started with Azure DocumentDB

Come to this session if you want to find out about Microsoft's Document storage option in the cloud. You will leave understanding what it is, why it exists and how to get started.

Getting Started with Azure Search

Need to search your data efficiently whilst in the cloud? This session introduces you to MSFT's highly scalable search solution in Azure

Getting Started: Azure SQL DB Audit & Dynamic Data Masking

Learn how Auditing provides Configurable Auditing policy and Azure storage to log database activity. Also learn how to leverage Dynamic Data Masking reduce the exposure of sensitive data in application and DevOps scenarios.

Microsoft Azure SQL DB-an inside look

In this talk, I will share my experience in creating and running Azure SQL Database, a large cloud scale service powered by SQL Server technologies.

Microsoft SQL Server: Hybrid Computing Evolution

One of the crawl, walk then run onramps to the cloud would be to exploit Hybrid computing. Microsoft SQL Server gives you this on ramp as it continues to extend the value to your on premise environment with features that let you extend to the cloud

Power BI as your Business Intelligence Proof of Concept Tool

Learn how to use the Power BI tools to help you analyse, specify and test the concepts and requirements of your next data Warehouse project.

Power BI Dashboarding

Power BI offers new features for creating dashboards on the cloud. In this session, you will learn how to create data models, display visualizations and synchronize cloud data with on premise data sources.

Query Store: New Query Tuning Feature For SQL Server & Azure

Query Store is a new feature that is coming to SQL Azure and SQLServer. It aims to greatly simplify the process of getting insight intothe performance of your application. Come learn how the SQL team is going to make your life awhole lot easier!

Scaling the DVD Store from 100 to a million TPM

Come along to see us attempt to optimise and redesign the “Dell DVD Store” sample dot.net/SQL application from a modest 100 transactions per minute to a million transactions per minute.

Shiny: dashboards in R

Need a snazzy dashboarding tool, and want it free or cheap? With a modicum of R and Linux knowledge, you can make interactive realtime dashboards for free that can be used in any web browser. Learn how in this session.

SSIS & HDInsight

In this session, we show how SSIS and HDInsight can work together, as well as how Hadoop jobs can be executed and how data can be transferred with SSIS between HDInsight, SQL Server, and other sources or destinations.

To The Cloud, Infinity, & Beyond: Top 10 Lessons Learned

Microsof IT's Cloud strategy involves migrating hundreds of applications to Azure. The scale on which it is being done may be unprecedented. Lessons Learned are numerous. This session exposes the most important—& painful—ones.

Under Construction-Power BI for Developers ?

Power BI is the Self-Service BI offering of Microsoft to all Information Workers out there, but hey: Is there anything for developers? We will have a look.

Understanding SQL Database Elastic Scale for the DBA

This session will look at SQL Database Elastic Scale through the important lens of the DBA, focusing on the critical aspects of database performance, maintenance, and management without adding unnecessary complexity.

Azure SQL DB - Running a cloud database service at scale

In this talk, I will share my experience in creating and running Azure SQL Database, a large cloud scale service powered by SQL Server technologies. This presentation will provide an outline of the scenarios and requirements for a database service.

Blend SQL Azure with SQL Server to drive Performance Insight

Peter O'Connell will talk about how SpotlightEssentials.com uses SQL Azure to collect and mine over 40TB of SQL Server Performance data across thousands of instances to drive unique insights into SQL Server Performance.

Demonstrating PDW integration with Hadoop & Polybase

Polybase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and soon Windows Azure Storage Blobs (WASB). See it in action.

Extending your datacentre to the cloud with SQL Server 2014

Microsoft is moving to the cloud and SQL Server 2014 is the first release with features designed specifically to extend your datacentre into the cloud. In this session we'll look at these features with end-to-end demos, discussions and scenarios so you can understand what the future could look like in your own SQL Server environment.

Microsofts big data strategy : Enhancements & Scenarios

Firstly we will show off Microsoft's enhancements to the Hadoop open source stack with HDInsight showing you how easy it is to get started with Hadoop. Secondly we'll explore an interesting big data use case

Migrating to the Cloud

In one hour we will take a sample ecommerce application and database, show tools available for both schema and data migration and the demo performance, scalability and monitoring impacts.

Monitoring Windows Azure SQL Server VMs and SQL Databases

Once you've decided to move to Azure with any of your databases, you're going to need to know how they're performing, this session shows you.

Patterns & Practices for Scaling Windows Azure SQL Database

This session will discuss the recommended approaches and best practices for partitioning and scaling Windows Azure SQL Database, allowing you to fully leverage the managed relational database service and take advantage of massive scale-out scenarios.

SQL Server Storage vNext: Welcome to the Future

The way our data will be stored is changing and it's all about your network. Come find out why CSVs, SMB, Windows Scale Out File Servers, fast networks, and maybe even the cloud are in your future.

Top 5 SQL Server 2014 Hybrid Features

This session will focus on 5 great hybrid cloud features available in SQL Server 2014 that show how you can use these features to lower your TCO and leverage the cloud to provide new disaster recovery and backup solutions.

Windows Azure SQL Database Design: Concepts and Trade-offs

An overview of the architectural reasons to consider cloud-based SQL Server solutions and insights into the differences you need to know between Windows Azure SQL Database and on-premises SQL Server.

Keynote - Architecting Large-Scale Solutions on Azure

While there are many similarities between SQL Server and SQL Azure, there are different kinds of applications that are easier to build in one or the other. One of the major differences relates to how to build an application that “scales”. This presentation will provide an introduction into the difference between scale-up (SQL Server) and scale-out (SQL Azure) architectures and give you a primer on how you can build a large, Internet-facing service that can scale to arbitrarily large sizes on commodity hardware. This talk is targeted at SQL Server practitioners to give them a working knowledge of how the two platforms differ based on Microsoft’s experiences with its largest Software-as-a-Service (SaaS) customers running on SQL Azure.

Query Tuning in the Clouds

Just because you're using an Azure SQL database does not mean you can avoid tuning queries. This session will introduce you to the tools you have available to identify poor performing queries, understand, and fix them. All in the cloud.

SQL Azure for the DBA

In this session we are going to look at the some of the flavours of SQL in Azure, namely Windows Azure Database and SQL on IaaS. We will discuss the differences between them, look at what this means from a DBA stand point

SQL Server in Windows Azure Infrastructure as a Service

Ewan Fairweather and Silvano Coriani from the SQL CAT team will take you on a tour of the new features that make up the Windows Azure Virtual Machines and Virtual Networks running SQL Server 2012 in a Virtual Machine.

Using Windows Azure to provide SQL Server Disaster Recovery

This session provides an architectural blueprint to deploying disaster recovery solutions combining on-premise and Windows Azure cloud technologies. The session looks at a design pattern to solve a long standing and often expensive issue of DR.

Windows Azure For SQL folk

We aim to cover the fundamental concepts that you should know on the Cloud and Windows Azure. In this demo based hour we will step through building Azure applications, deploying and managing them and what storage choices you will face.

Windows Azure SQL Database Troubleshooting

While knowledge of SQL Server troubleshooting still applies to the Windows Azure SQL Database service, there are new and different features, methods, and tools that are unique to cloud database computing. Come learn about these new techniques.

Architectural Patterns and practices SQL Azure

As a shared database infrastructure in the cloud, SQL Azure provides the opportunity for creating large workloads in a scalable and reliable environment.

Big Data, Cloud, and other Marketing Buzzwords De-mystified

When your boss sends you to a conference, she expects you to learn something useful. Like all of the buzzwords she has to explain to her boss. Make it worth her while (and budget) and bring back the info she craves.

Deep Dive on Database Private Cloud

Come see what a Database Private Cloud is all about. If you have many SQL Server instances already or need to grow use of on-premises SQL Server and other demanding workloads you may need a database private cloud.

Designing a Private Cloud Infrastructure for SQL Server

Do you want to learn how Microsoft helped one of the largest Financial Services organizations in the world design a Private Cloud infrastructure using Windows Hyper-V and System Center 2012 to standardize and consolidate hundreds of SQL Servers?

Introduction to Microsoft Codename "Data Explorer"

Microsoft Codename "Data Explorer" provides a new way to organize, manage, enrich, share and gain new insights from your data.

Scaling out your Cloud Database with SQL Azure Federations

In this presentation, we provide an introduction to SQL Azure Federations and also show some interesting patterns that provide additional capabilities such as scale-out query processing, cross-shard schema management and multi-key sharding.

Sql user group leaders present an A-Z of nuggets

About

Useful information

Sessions & Content

About

Useful information