Tags
Search
Conference
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.
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.
See how to analyze images in your Data Lake with Azure Data Lake Analytics, U-SQL and custom models
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.
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.
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.
Based on real life scenarios, an audience interactive session.
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).
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
Start your database off right so you can scale when you need to
Graph databases – Origins, how they work, strengths and weaknesses
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
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!
This session aims to introduce database professionals to the language of HiveQL.
Everyone that has been involved in Software Development can notice how huge the impact of a bug can be, and Databases are not the exception. In this session, you will learn how to test your SQL Server projects using Visual Studio and SQLUnitTesting.
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.
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.
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.
In this session, you will learn about the latest additions to the portfolio of network security features for Azure SQL Database. This session will be heavy on the “how-to” for securing the network connectivity for Managed Instance.  ?
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.
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.
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!
Learn how to make Azure do the work for you by developing smart responses for Azure SQL DB alerts using Automation and Logic Apps.
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
We'll examine how SQL Server databases function at the very lowest level, records and pages.
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. 
Learn about the metadata features in SQL Server that describe your database and how they can make documentation, tuning, and maintenance much easier.
Azure Cosmos DB has many use-cases, and not all of them are clear to Azure Cosmos DB newcomers. If you're a relational expert and have been wondering about graph, how you'd survive without a schema, and scale out databases this session can help.
Ever wondered how you can add the power of ML to your existing SQL estate without the need to invest in new services? Come to this session to learn about running Python and R workloads in SQL, the PREDICT function, and how to operationalise models in Azure SQL Database
This session will focus on the new features and capabilities that help you meet compliance and security needs with SQL Server on-premises as well as in Azure SQL Database. This includes the new Static Data Masking, new authentication capabilities, new functionalities in Vulnerability Assessment and Threat Detection as well as Always Encrypted. If you want to know about the latest developments in SQL Security, this session is for you.
Come learn about all the new innovations, features and deployment options available when using Azure SQL Database.
<<1>>