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.
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.
This session will compare Microsoft’s options for deploying highly available SQL Server data platforms in mid-2016.
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.
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.
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
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.
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?
In this talk, you will get an overview on what to think about when storing data in a document database.
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.
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.
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.
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
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.
This session looks at building time series analysis with AzureML in R
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.
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.
Azure stream analytics is a new Azure service for analyzing streaming data.
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.
Sometimes don't want our data in the cloud, but that doesn't mean we can't use the cloud at all.
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)
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.
Come to this session to see how to build a scalable analytical solution on Microsoft Azure with Elastic Search and Kibana.
Come to this session to find out what is involved and what we learned from migrating 700+ servers into Microsoft Azure.
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
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.
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.
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.
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
This session will look at providing cost effective DR capability with 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.
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.
Need to search your data efficiently whilst in the cloud? This session introduces you to MSFT's highly scalable search solution in Azure
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.
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.
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
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 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 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!
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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