Sessions & Content

Search
Content Type
Conference
Tags
Test Driven Development in SQL Server, safer code deploys Hamish Watson
Testing data in SQL Server is hard, but it is easier than having to restore your database. This session will show how easy it is to test database code using industry frameworks, tools and processes
Adding unit tests to the database deployment pipeline Eduardo Piairo
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.
An overview of SQL Server 2019 for the busy DBA / developer Randolph West
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.
An R primer for SQL folks Thomas Hütter
A walk-through on what is possible analyzing your data with the "R" language.
Azure Managed Instances—Your Bridge to the Cloud Joey D'Antoni
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.
Benchmarking in the Cloud Gianluca Sartori
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.
Build hybrid data platform with Azure SQL Database and SQL Server Microsoft
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.
Deeper Integration and New Transformation for SSIS in ADF Sandy Winarko
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).
Environment Provisioning: The Third Age Richard Macaskill
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
Getting your Database off to a Right Start Andrew J. Kelly
Start your database off right so you can scale when you need to
Graph databases - What, how and why Mark Whitehorn
Graph databases – Origins, how they work, strengths and weaknesses
Identify opportunities for In-Memory OLTP Margarita Naumova
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.
Improving SQL Server Performance with Indexing Richard Douglas
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
Introduction to ElasticSearch Steph Martin
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!
Managed Instances - Deep Dive Jovan Popovic
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.
Modernize on-prem SQL Servers to Azure using Azure Database Migration Service Microsoft
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 and running enterprise workloads in Azure Database for MySQL, PostgreSQL and MariaDB Microsoft
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.
Monitoring AzureSQLDB Martin Wild
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.
Packaging Permissions in Stored Procedures Erland Sommarskog
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.
Partitioning Party James C Yarrow
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.
<<12>>