Learn to make better analytic solutions by following current thoughts on data modeling.
Automate optimising your hybrid production databases by recording workloads and replaying them either on-prem or onto Azure instances whilst identifying bottlenecks and exploring SQL tuning techniques.
Using PowerShell Desired State Configuration (DSC) we'll install and configure a SQL Server instance in under 5 mins.
Are you looking to take your career to the next step? Microsoft Certifications help validate knowledge and ability required to perform current and future industry job-roles in a modern digital business. Our certification
While you might have read about notebooks being used for Data Science, this session is for DBAs. You will see how you can use SQL Notebooks to simplify your work.
This session covers all kinds of T-SQL tips and tricks, focusing on backdoors and workarounds for restrictions and missing features in SQL Server and Azure SQL Database.
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 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.
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
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.
Paginated reports (SSRS), are available in both on-premises and cloud-based solutions. Join this session to experience the journey of SSRS and how to create and deploy reports across all the different products available in the Microsoft Ecosystem.
The dbatools module now has over 400 commands you can work with. How do you know where to start and which ones you can use in your day-to-day work?
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 hour long session we will attempt to include lots of advice and guidance on how to develop code that will easily get approved by your DBA prior to release to production.
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?
<<1234>>