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
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.
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.
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!
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.
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.
<<12>>