One of the last technical challenges of cloud adoption is right security configuration. This session focuses on Azure Sql PaaS, covers governance, risk management and compliance and provides 8-step process for securing public cloud.
This talk will address how to add the unit testing framework tSQLt to the database deployment pipeline. The purpose is to reduce the cost of validate every change in the database with a fully automated pipeline.
We introduce the concept of aggregation, we show several examples of their usage understanding the advantages and the limitations of aggregations, with the goal of building a solid understanding on how and when to use the feature in data models.
This session will take a look at better Unicode support, query processing improvements for row store tables, secure enclaves, and other neat things you'll find useful as a modern database administrator or developer.
A walk-through on what is possible analyzing your data with the "R" language.
Find out how a major UK hotel chain unified their wildly different sources of data to build a supercharged analytics and pricing engine to power their business. Find out how Cosmos and Databricks helped them get to know their customers, how best to retain them, and how best to keep them happy, all while ensuring GDPR compliance and the right to be forgotten.
Do you want to know why customers chose Cosmos DB? Come learn about the business goals and technical challenges faced by real world customers, and learn about key Cosmos DB features so you can help your customers deliver their high-performance business-critical applications on Cosmos DB.
We will review this new feature of ADFv2, do deep dive to understand the mentioned techniques, compare them to SSIS and/or T-SQL and learn how modelled data flow runs Scala behind the scenes.
Azure Machine Learning is a platform for developing and deploying your machine learning models on Azure. We will look at the life cycle of ML projects: from data, to model, to consumption. This will include Automated Machine Learning capabilities.
Managed Instances can make your cloud migrations simpler, but have their own nuances. Learn about what you need to know to manage this new platform.
Learn in 75 Minutes what Batch Execution Mode is, when & how it will affect your workloads (in upcoming SQL Server 2019 & Azure SQLDB) on the traditional Rowstore Indexes.
Look inside Query Store to see what it does and how it works
Join me in this session and learn how to capture a production workload, replay it to your cloud database and compare the performance. I will introduce you to the methodology and the tools to bring your database to the cloud without breaking a sweat.
Biml is not just for generating SSIS packages! Come and see how you can use Biml to save time and speed up other Data Warehouse development tasks like T-SQL development, test data creation, and dimension population.
This session presents how to migrate, replicate, and synchronize data between SQL Server, SQL VM, Azure SQL Database, and Azure SQL Database Managed Instance, across on-premises, Microsoft Azure, and other cloud platforms to build a real hybrid data platform. We introduce our current technology choices, deep dive in customer scenarios, and use cases, and share product roadmap.
Azure offers a wide range of services that can be combined into a BI solution in the cloud.
In this session, we’ll look at the different options within the Cognitive Services suite, show you how to connect to the APIs using Python code, walk through a live bot demo, and build an Azure Cognitive Search index. You should leave this session feeling like you’ve had a jump start to further your AI developer skill set.
Learn how to troubleshoot AGs ad FCIs.
If you have already mastered the basics of Azure Data Factory (ADF) and are now looking to advance your knowledge of the tool this is the session for you.
Azure offers a vast comprehensive data estate! While this is great for enabling users to pick the right tools for the right job - this has also increased the surface area for understanding how to integrate a vast number of components. In this session, we will show off the plug and play nature of Azure products by showcasing you can write to Azure Cosmos DB with a data pipeline moving data from multiple sources powered by Azure Data Factory and Databricks.
Data lakes have been around for several years and there is still much hype and hyperbole surrounding their use. This session covers the basic design patterns and architectural principles.
Join the Microsoft Data Platform Product group, from engineers to data scientists and lean about the data platform evolution, and the skills you need to know to stay current. Full of demos and information, this fast-moving story will get you ready for another SQLBits conference
The FILTER function does not create a new filter context but a row context. The ROW function is executed in a filter context without creating a row context. To demystify this and all the other DAX Gotchas that I bumped into is the goal of my session.
In this session, we will explore real world DAX and Model performance scenario's. These scenarios range from memory pressure to high CPU load. Watch as we will dive into the model and improve performance by going through concrete examples.
This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR).
In this session I will show you how to apply DevOps practices to speed up your development cycle and ensure that you have robust deployable models. We will focus on the Azure cloud platform in particular, however this is applicable to other platforms
Clarify differences between many-to-many and weak relationships in Power BI
Using Azure DevOps and Azure RM templates to created isolated environments for testing PaaS solutions.
Monitoring for Power BI is one of the things that tends to be an afterthought. Apart from some standard reports, there's nothing that actually has an impact or helps you drive automation one step further. This session shows you the way.
Hybrid data landscapes are common and the on-premises data gateway enables connecting to your on-premises data sources from online services (like Power BI, PowerApps, Microsoft Flow and Logic Apps) without the need to move your data to the cloud. Come to this session to see the latest gateway features and best practices related to setup and configuration along with troubleshooting tips and tricks, investigate bottlenecks and resolve your common gateway errors.
Many organisations using Power BI seek the Nirvana of self-serve and enterprise reporting, but are left with an unstructured governance strategy. This session simplifies the governance process, by utilising Microsoft Flow and Power BI together.
Power BI Premium and Analysis Services enable you to build comprehensive, enterprise-scale analytic solutions. This session will deep dive into exciting new and upcoming features.
Various topics will be covered such as management of large, complex models, connectivity, programmability, performance, scalability, management of artifacts, source-control integration, and monitoring. Learn how to use Power BI Premium to create semantic models that are reused throughout large, enterprise organizations.
Step back through the ages and explore how database teams have approached creating environments for dev and test. Learn how, in the new age of provisioning, databases are delivered safer, faster, and more efficiently
If you've been using Extended Events the same way you used to use Trace, you might be wondering if there's more to it. There is! In this session we will explore what else you can do with XE besides capture long-running queries.
SQL Server provides a wealth of tools in the box to help you spot troublesome queries. We'll explore those and examine how they can best be used.
SQL Server 2019 includes new query processing features such as batch mode on rowstore, memory grant feedback, approximate query processing, and more. How do these work? Are they as good as Microsoft wants us to believe?
An end-to-end solution covering many Azure features
During this all-demo session, we will dig deep into some of the most captivating, but less publicized features of the desktop.
Real-time decisions enabled by massively scalable distributed event driven systems with embedded analytics are re-shaping our digital landscapes. But how do you know which technology to choose? We'll cover the fundamentals of streaming systems, how and why they can deliver value to your business, and a look at options for streaming analytics in Azure
Start your database off right so you can scale when you need to
Graph databases – Origins, how they work, strengths and weaknesses
If you never have errors in your SSIS packages, then you don't need to attend this session. But if you want your packages to be reliable and safe, and to handle errors appropriately, then this session is for you.
In this session you'll learn how Hyperscale removes limits for cloud based VLDBs.  We'll demonstrate how to create, migrate, and do point in time restore of very large databases in Azure.
The session will uncover the In-Memory OLTP architecture, the concerns about data durability and database startup and recovery as well as some important consideration on Management of in-memory objects.
Indexing presents daunting challenges for even the most seasoned professionals, it offers countless options to choose from. With a little help you’ll see how to simplify indexing in your environment & improve the overall performance of your apps
Come learn all the new capabilities of SQL Server 2019 directly from the Microsoft engineering team. This session will provide the strategy behind SQL Server 2019 as well as a deep dive into all the new features and how they can help you modernize your data estate with SQL Server.
SQL Server 2019 expands on the Polybase feature from SQL Server 2019 by providing a robust data virtualization solution to reduce the need for ETL and data movement. Come learn how new data connectors work with sources like Oracle, MongoDB, CosmosDB, Terradata, and HDFS.
Containers are the new virtual machines. They present a new way to deploy, manage, and run SQL Server never possible before. This session will present an internal view of how Docker containers work, how SQL Server runs in them, and how they work in environments such as Kubernetes
With SQL 2017 we entered a brave new world with cross-platform SQL Server, and with the new Azure Data Studio, we now have the tools to go with it. In this demo-packed session, learn about the newest tool for SQL Server for Windows, MacOS, and Linux, and how you can use it and extend it for your own needs. Be one of the first to see the new Notebooks feature for SQL Server, which brings the power of Jupyter notebooks to your SQL Server workflow.
Learn how dataflows can be used to load data in Power BI.
Relational database engines are great, but with increasing data volumes and user patience decreasing we need to look for other options. Step forward ElasticSearch, a search engine for our data!
An overview of PowerApps and the platform
In this session, attendees learn about how to create PowerApps solutions, how to use PowerApps as data entry application for Power BI. How to integrate PowerApps in Power BI and Power BI in PowerApps.
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2017 / 2019 has introduced many new features.
In this session we will learn which processes are required to build a real-time analytical model along with batch-based workloads, which are the foundation of a Lambda architecture.
Learn how to understand and read execution plans.
In this session, you'll learn about the various prebuilt AI/ML models that are available for your consumption through Microsoft's Cognitive Services. Additionally, you'll see examples of how these prebuilt services can be leveraged with SQL Server 2019.
Moving to the cloud means that we need to take a different approach when it comes to how we design and tune databases. Managed Instance included, get the storage configuration wrong and it will not perform. We'll look at the storage options and architecture for Managed Instance before demonstrating how to get tune the storage layer to get the performance we need
In this session, you will learn about the architectural details of Managed Instance, the available features, and the best ways to configure it and migrate your databases to Managed Instance.
Power BI Premium enables you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through Microsoft Power BI. The session will focus on performance, scalability, and application lifecycle management (ALM).
In this session, we will discuss the strategies and thought process one should adopt for modeling and partition data effectively in Azure Cosmos DB. We will also briefly cover related topics such implementing optimistic concurrency control, transactions with stored procedures, batch operations, and tuning queries + indexing
SQL Server 2008/R2 is soon reaching end of support. We'll take a look at the migration life cycle and show you how easy it is to migrate SQL Server instances to Azure with near-zero downtime by using the Azure Database Migration Service and related tools. We'll also give you a deep dive how to perform scale migrations using our CLI components
Modernizing is often a loaded term in a software application setting. In this session, we will break down what are the options of modernizing an existing application, what are the benefit of moving applications to managed Azure Open Source Database platform and what are the best practices and gotcha(s) that you need to look out during data migration.
Upgrades should be approached with the same rigor and processes as a full software or hardware project – a solid methodology is required for success. Microsoft provides you with all the tools you need to achieve a seamless, reliable upgrade experience. In this session we demonstrate some of the free tools that Microsoft provides in order to ensure your SQL Server upgrade is a success.
Join this session to learn how managing performance is even more critical with Azure SQL DB. Learn what key performance indicators are most applicable, what auto-tuning really means and get some tools to help you identify and fix issues.
This session covers situations where the SQL Server query optimizer does not rely on index order and provides tips and tricks to solve those.
Learn in this session how you can package any database- or server-level permission in a stored procedure with help of certificate signing or EXECUTE AS and why one method is to prefer over the other.
Database Partitioning has been around for a while but is always being updated and enhanced. In today big data volume world, we to think how we are going to support these large tables.
Manish Kumar from Microsoft will take you through various performance tuning measures you should take before increasing service tier of your database. The session will be packed with tons of information, steps and demos.
Automatic Plan Correction is a feature you can use whether you're a pro at performance tuning or just starting with SQL Server. Come to this session to learn how to spend less time fighting fires with this new feature.
Come to this session to learn how to enable collaboration and solution design for business users and IT specialists to build solutions that enable an origanization to harness the power of their big data.  This session will enable you to collaborate across business and IT, and how we can extend intelligence beyond Power BI into Azure Data Services. Once Power BI has landed in an organization, attaching and extending into Azure can be achieved using common use cases and modernization plays.
The Microsoft Power BI and Analytics team present an interactive Q&A session
Power BI Premium has many features that organisations desire yet the price makes it impractical for most. In this talk you will learn how Power BI Embedded can be used to enable many of these features at a much lower cost.
Have you ever looked at other people's Power BI reports, and wondered how they look so good? Designing an aesthetically pleasing report does not require a graphic designer, just the lessons you'll take away from this session.
A stream of handy tips, tricks, and ideas to boost your PowerShell skills and productivity.
The in-memory OLTP engine has been around since version 2014 of the database engine, do you need to be a SaaS provider processing billions of transactions a day to use this ?, the short answer is absolutely not and this session will show you why.
What data profiling is & why you should do it.
IoT is difficult. You need to know C and C++. It takes months to get it working. You need devices to start. And none of that is true. Join me to see how easy, in few minutes, you can have your IoT project up and running.
Azure Stream Analytics is a fully managed serverless offering that enables customers to perform real-time data transforms and hot-path analytics using a simple SQL language. In this session, we will show how to combine SQL reference data to augment data coming from devices and create real-time alerts, leverage partitioning to write data to SQL at high speed, and create real-time dashboards.
This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days.
Are you curious about Azure Cosmos DB? This is the session for you! Join us to find out what it is, how it compares to other database platforms, and what all the hype is about!
This quick vendor session demonstrates the spectrum of SentryOne's best-of-breed products for the Microsoft Data Platform, from Task Factory, to Plan Explorer, to DOC xPress, to the SentryOne monitoring platform, and beyond.
Azure introduces a range of new services for transaction processing and analytics solutions which mean we don’t need to deploy virtual machines. This session provides insight into how we see customers deploying evergreen and futureproof solutions.
Take an idea and learn how to develop your first session.
Join me for this session as I demo how disaster recovery can be greatly simplified using PowerShell.
Learn how to make Azure do the work for you by developing smart responses for Azure SQL DB alerts using Automation and Logic Apps.
Machine Learning is a popular buzzword, but what does it actually look like, and how can we use it? This session will show a number of high level examples of using ML to do some useful and fun stuff, including training a model to play a game
To build analytical models, we need to start by extracting, transforming, cleaning, preparing and loading the data. This session analyzes a set of scenarios that may happen during the ETL step using the Power Query in Power BI.
In this session Buck Woody explains how Microsoft has implemented the SQL Server 2019 relational database engine in a big data cluster leverages an elastically scalable storage layer that integrates SQL Server and HDFS to scale to petabytes of data storage. You’ll see the three ways you can interact with massive amounts of data: Data Virtualization, Data Marts, and working with a complete Kubernetes Cluster in SQL Server. You’ll also learn common use case scenarios that leverage big data and the SQL server 2019 Big Data Cluster on-premises, in the cloud, and in a hybrid architecture.
Learn about the Graph functionality integrated into the SQL engine, and the unique value it provides
Why do you need anything more than SQL Server? We will discuss what factors influence platform choices, such as data and processing scaling and open source tool chains that include Hive and Spark.  This session will include a quick overview of HDInsight and some of the tools that SQL Developers can use to interact with it, as well as some best practices and gotchas. There will be a short demo on some of the tool choices.
The Microsoft SQL Server leadership team present an interactive Q&A session
With GDPR and the number of data breaches we see in the news, encrypting sensitive data is incredibly important. In this talk we start with the basics of encryption, moving on to look at the ways we can encrypt data in SQL Server and Azure SQL DB.
Learn how Machine Learning Services in SQL Server is a powerful end-to-end ML platform for customers, on both Windows and Linux. Come learn about the unique value proposition of doing your entire machine learning pipeline in-database – right from data pre-processing, feature engineering, and model training to deploying ML models and scripts to production in secure and compliant environment without moving data out. 
I'll share what I've learned so you can successfully manage SQL Server on Linux!
Learn about the metadata features in SQL Server that describe your database and how they can make documentation, tuning, and maintenance much easier.
Organisations need to know how to get started with Artificial Intelligence. This practical session offers organizations, small and large, with a helping hand in practical advice and demos using Microsoft Azure with Open Source technologies.
Do you want to install a new SQL Server instance in less time than it takes to get a latte at Starbucks? In this session, we'll walk through the reasons you need to automate, the process you should use in determining what tasks you need to automate.
Building solutions based on powerful platforms is a key requirement for success. Join this session to see the PowerPlatform and its members (PowerApps, Power BI and Microsoft Flow) in action and how they can improve your daily work.
<<12345678910>>