Sessions & Content

Tags
Content Type
Search
Conference
"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 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.
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
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.
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.
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 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.
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 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.
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
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.
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.
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 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.
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
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 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 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.
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.
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.
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?
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.
To the Cloud with SQL Server Data Tools
Learn how the SQL Server Data Tools can help you migrate your on-premise SQL Server databases to SQL Azure
Database Development with SQL Server Juneau
Juneau is a new developer tool in Denali. Brings VS paradigms to SQL Server like Debug, Refactor and Declarative maintenance. Come to this session and learn what these tools are really about.
SQL Azure-Design Concepts
Basic outline of SQL Azure: How SQL Azure fits in with other Azure Storage Options. Main differences between SQL Azure and SQL 2008. Brief new design challenges.
SQL Server Community presents : The A to Z of SQL Nuggets
The leaders from every SQL user group across England, Scotland & Wales have got together and created the definitive dictionary of essential SQL know-how, and crammed all of this into a single fast paced romp through the SQL alphabet.
28 Weeks later - How to scale-out your MS Business Intelligence environment
The SQL Server provides much functionality that increases the scalability and flexibility of your solution by distributing data and jobs among low-priced commodity servers.
Consolidation and Virtualization Strategies-Microsoft Technology Center
This session will teach you how to successfully plan, implement and manage SQL Server consolidation and virtualization within your organization
Keynote
Mark Souza (General Manager in the SQL Server product team) will spend an hour of presentation and discussion of Microsoft's next generation database platform followed by a discussion on cloud technology.
Extreme scaling with SQL Azure
SQL Azure is Microsoft’s new strategy for storing your data in the cloud, but what to do when you exceed the 10/50GB limit. This is where sharding or partitioning comes into play – this session shows you how it can be done in an OLTP system and show you some of the common pitfalls of SQL azure as we have discoverd in analyzing SQL Azure as an alternative to onsite SQL Server instances at different clients.
How to build a private cloud, a consolidation project on SQL Server 2008
Consolidation of SQL Server infrastructure has become increasingly popular. This is true from both a technological and financial perspective, may it be through virtualization, instance concentration or in building SQL Server hotel environments. This is an in-depth presentation on one of the biggest consolidation projects ever in the Nordic countries based on SQL Server 2008. This presentation will cover both the business aspects as well as the technical reasons behind this project by two of its top resources. In one year the customer went from nearly 200 physical machines hosting over 1100 databases to only 20 servers without using any form of virtualization!
<<12>>