Toggle navigation
FAQ
Venue & Travel
Sponsors
Sessions
Training Days
Wednesday
Thursday
Friday
Saturday
Login
It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript,
click here for a page that doesn't require javascript
.
Home
Sessions & Content
Sessions & Content
Tags
Azure
(153)
Content Type
Slide Deck
47
OtherSample
4
Video
104
Search
Conference
SQLBits I
0
SQLBits II
0
SQLBits III
1
SQLBits IV
2
SQLBits V
0
SQLBits VI
1
SQLBits VII
2
SQLBits VIII
4
SQLBits IX
4
SQLBits X
8
SQLBits XI
7
SQLBits XII
11
SQLBits XIV
29
SQLBits XV
23
SQLBits XVI
25
SQLBits XVII
36
"Start Small and Grow Big" with Power BI and Azure AS
In this talk you will learn how to use Power BI to prototype/develop a BI solution in days and then evolve it into a fully scalable Azure BI solution.
An introduction to HDInsight
Are you still asking yourself, what is big data? What is HDInsight and how can I benefit from it? which type of HDInsight Cluster should I use? come to this session and find an answer
An Introduction to Machine Learning
Learn how to build an Azure Machine Learning model, how to use, integrate and consume the model within other applications, and learn the basic principles and statistics concepts available in the different ML algorithms.
Analyzing real-time data using Azure Streaming Analytics.
Businesses today require real-time information to make better-informed decisions, this requires a new set of tools. In this session you will learn about Azure Stream analytics and how it can help address real-time data scenarios
Azure and SQL Server: Getting the best out of the cloud
SQL Server and Azure are built for each other. New hybrid scenarios between on-premise SQL Server and Azure mean they don't have to exclude each other but instead you can have the best of both worlds, reducing operational costs.
Azure Cosmos DB: design patterns and case studies
Come learn about the business goals and technical challenges faced by real-world customers, why they chose Azure Cosmos DB, and the patterns they used to deliver highly available, globally distributed experiences.
Azure Data Catalog Adoption Patterns and Best Practices
Get the most from Data Catalog with patterns and practices.
Azure Data Lake-The Services. The SQL. The Sharp.
Let’s understand the role of this hyper-scale two tier big data technology and how to harness its power with U-SQL, the offspring of T-SQL and C#. We’ll cover everything you need to know to get started developing solutions with Azure Data Lake.
Azure SQL Data Warehouse Optimizing and Maintaining
In this talk we will discuss best practices around how to design and maintain an Azure SQL Data Warehouse for best throughput and query performance.
Azure SQL Database vs. Cosmos Db. How do you choose?
Focusing on the micro-service / OLTP domain, this talk approaches the challenge of choosing between Azure SQL Database and Cosmos Db (Document Db) by using solution use cases to test each storage's offering for appropriateness.
Back to the future with Temporal Tables
Back to the Future is the greatest time travel movie ever. I'll show you how temporal tables work, in both SQL Server and Azure SQL Database, without needing a DeLorean.
Building a Data Delivery Solution in the Cloud
Case study on using all of the Azure Data Platform and how to build out your optimal architecture.
Chatbots for Dummies
Learn how to build, debug and deploy a chatbot using the Azure Bot Service and the Microsoft Bot Framework.
Cloud Processing: PaaS SSIS & Advanced Patterns with ADFV2
Many existing Data Factories include large numbers of workarounds due to limitations with the service. Now that ADF V2 is available, we can restructure our Data Factories to be lean, efficient data pipelines, and this session will show you how.
Confidential computing with Always Encrypted using enclaves
Always Encrypted using enclaves enables rich queries on encrypted data.
Database Continuous Delivery with SSDT and VSTS
Using SSDT and VSTS to reliably build, test, and deploy SQL Server databases in the cloud and in the datacentre.
Deep Dive into SSIS 2017 and Beyond
We will showcase the latest feature of SSIS 2017 such as connectors for Azure Data Lake Store (ADLS), Azure SQL Data Warehouse (SQL DW), SSIS Scale-Out at package level for the box product as well as the SSIS package execution on Azure Data Factory
DirectQuery in Power BI and Analysis Services
DirectQuery best practices in Analysis Services and Power BI
Dont cross the streams, a closer look at Stream Analytics
This session takes a closer look at Azure Stream Analytics, and how you can make it work in your Projects.
DWH and Microsoft BI in an Online Games Company
How does Big Data with Hadoop, Cloud Computing in Azure, Self Service BI and “classic” BI with SQL 2016 interact with each other to build a modern enterprise BI architecture at InnoGames? Watch my talk and you will know!
Evaluating Models: Get Ready to ROC
Introducing the ROC curve and its use in Azure ML.
How to Architect Azure for Insights & Analytics
Selecting the right PaaS components in Azure
Hybrid Data Solutions-how to have you cake and eat it!
We live in a cloud first World, but many organisation still run largely on-premise. This session covers how these organisations can begin their journey and leverage Azure data services.
Master your Data in the Cloud
Learn how to master your data in the cloud with Azure services.
Maximise compute performance with Azure SQL Data Warehouse
Learn about the new compute optimized performance tier in SQL Data Warehouse and how to maximize your performance through improved table design and columnstore optimization.
Power BI security deep dive
One hot topic with Power BI is security, in this deep dive session we will look at all the aspects of security of Power BI, from users, logging to where and how your data is stored andleverage additional Azure services to secure it even more.
Scalable deep learning model training with Azure Batch AI
Deep learning is an essential component of an analytical toolbox. There are considerable challenges in training deep learning models and this presentation explores how to overcome these using Microsoft’s scalable ML offering, Azure Batch AI.
SQL Intelligence excels your tuning and security expertise
Azure SQL Database built-in intelligence features will help you improve performance and security of your database and dramatically reduce the overhead of managing thousands of databases.
SQL Storage Fundamentals for Azure IaaS
SQL disk configuration and planning can really hurt you if you get it wrong in azure. There is a lot more to getting SQL right on Azure VMs than next-next-next.
The Internet of Things in the Real World
Data acquisition and analysis in the real world with IoT.
The Pathway to the cloud using Azure SQL Managed Instances
If you have 100's SQL Servers, some legacy applications, running on older versions and no cloud subscription? Then the path is to cloud very different from a single click. We focus on the key steps needed for a cloud SQL data migration.
What are Azure SQL Database Managed Instances?
The range of options for storing data in Microsoft Azure keeps growing, the most notable recent addition is the Managed Instance. But what is it, and why is it there? Join John as he walks through what they are and how you might start using them.
What is the Azure SQL Datawarehouse?
In this session we will discuss about the Azure SQLDW and how we can use it to help on our day to day.
What’s New with SSIS in ADFv2
See the latest features of SSIS in ADFv2, e.g. ARM VNet, Enterprise Edition, Custom Setup Interface, Execute SSIS Package Activity, etc.
Whats New in Azure Analysis Services
This session will reveal what's new for Azure Analysis Services in the areas of performance, scalability, advanced calculations, model management, and monitoring.
Which database, when ?
I walk through the database services in Azure and how to characterize a workload to make the right DBaaS selection for your use case.
‘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.
Creating the single view of a Customer; at volume, without code
Business expects 360 view of Customer but data is difficult to build, challenging to clean and complex to de-duplicate. The challenge is to synchronise this data with systems of record. See how Profisee can solve this problem at volume & without code
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
Using a gateway to leverage on-premises data in Power BI
I look at how you can take advantage of an on-premises gateway to make use of local data when creating reports and dashboards for Power BI. This will start with Power BI Desktop, and the choices you have for SQL Server and Analysis Services.
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.
<<
1
2
>>