In this session you'll learn some of the key data privacy problems facing database developers and DBAs and 10 steps to help your database team build a "defensible position" through development.
A distributed availability group is not your mother's availability group. Want to know more? Attend this session.
Let's learn about what Always Encrypted is, how it works, and the implications for your environment. By the end you will know how to now easily encrypt columns of data and just as importantly how to unencrypt.
Join this session if you are interested in the administration scenarios of the big data clusters, including tooling for monitoring, how to deploy and secure the environment, and to learn about the latest improvements.
Azure Synapse Analytics combines the power of Data Lakes with Data Warehouses, empowering the organizations to build Big Data, Advanced Analytics and Business Intelligence in one single platform.
Continuous Integration and Delivery can be a pickle for Analysis Services Tabular Models when using the standard tools. With Azure DevOps, GIT and Tabular Editor, there's a better way...
Application and Database migrations can be a cause for concern. How many times have you heard, "If it isn't broke don't fix it". Come see how you can give confidence to key stake holders on testing the process.
What is the difference between Artificial Intelligence, Machine Learning and Deep Learning and how can each be used? Join Buck Woody cover simple, clear explanations for these technologies, how they can be applied.
Come join us in the intelligent database world that started with SQL Server 2017 and takes a leap forward with the upcoming SQL Server 2019 and Azure SQL DB.
In this demo intensive session I will show you how to tackle the most challenging tasks with Extended Events without writing a single line of code.
Learn what the Database Experimentation Advisor is and how you can start using it to baseline performance from a target and source server when new changes are introduced.
Azure Synapse Analytics combines the power of Data Lakes with Data Warehouses, empowering the organizations to build Big Data, Advanced Analytics and Business Intelligence in one single platform.
If you are planning to implement CCI in your production environment you need to be aware of certain aspects before you start. This session outlines key areas that you need to include in your planning beforehand.
Columnstore Indexes were launched in SQL Server 2012 and greatly enhanced in 2014 & 2016 - but if you thought that Microsoft was done with them - you are missing a lot of important improvements that were added.
SQL Server 2019 comes with Python as an installation option. Let’s use this to gather data from various sources to create your test and development data.
Learn common patterns for testing data, and the anti-patterns that trip developers up.
In this session we will merge practice and theory, analyzing what is data virtualization and data lake, what their benefits and how to implement them using SQL Server 2019 Big Data Cluster
In this demo heavy session we will show how Containers and Kubernetes, along with Azure DevOps can work for your CI/CD pipeline.
If you're not afraid of a little bit of C# and LINQ, Tabular Editor can take your productivity to a whole new level. This session will teach you how to use Tabular Editor's scripting and Best Practice Analyzer features.
Come and join us this session to unleash the power from your data as we introduce Machine Learning Services for Python and R across the SQL Platform.
The session takes you through the most critical considerations for moving your on-premise data and databases into the Azure cloud, with a focus on the steps leading to the migration and immediately afterwards.
Unfortunately, disasters can affect cloud technologies and if you are't prepared for it, the results can be painful. Let's discuss ways to implement Azure SQL disaster recovery techniques to help protect your data!
Played around with SQL Server in containers and want to delve further into the platform? This session is for you! In this session we'll dive straight into the Docker platform and investigate its internals.
We will see two important case studies where the optimizer is obviously a criminal who has killed the query performance. We will together with carefully investigate inside the query optimizer understand the reason.
Delivering enterprise BI with Power BI Premium tabular cubes, Azure Databricks ETL and Delta Lake for transaction integrity
Join us to get the scoop on the newest certification in Microsoft's certification portfolio. If you implement or manage cloud-based or hybrid data platform solutions, this certification could be the one for you!
Learn tips and tricks to make SSIS perform better.
In this session, we will discover how to utilize common machine learning approaches for daily SQL Server DBA tasks.
With the grow of the SQL Graph surface in 2017-2019 (incl. the ShortestPath() function) we have a chance to do some pretty exciting calculations and start analysing different types of Networks such as the Social ones.
SQL Server 2019 is full of new features. Some of them are very interesting and useful, but unfortunately not well-known. So far.
Data is important and metadata even more so! How does SQL Server keep track of what you're keeping track of and what you’re doing? We’ll look at the various types of metadata and explore the metadata using T-SQL queries.
Learn about two innovations in – Accelerated Database Recovery and Resumable Operations – that will help you meet even the strictest SLAs by reducing startup and maintenance time and increasing up-time.
In this session, we will dive deep into the Kubernetes platform and how SQL Server containers can be deployed, managed, and configured. This session assumes a fundamental knowledge of both SQL Server and containers.
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 2019 has introduced many new features. Here is a glimpse of the features we wil
One of the newest buzzwords of the last few months and years is definitely Kubernetes - or K8S. Microsoft has made with SQL Server 2019 a huge investment into Kubernetes.
You’ve just been given a server that is having problems and you need to diagnose it quickly. This session will take you through designing your own toolkit to help you quickly diagnose a wide array of problems.
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
The goal of the talk will be to show you how to choose among the various storage technologies that exist when building your next application.
This session is for all developers who want to learn about the new Dev features and enhancements of SQL Server 2017 and 2019
In this session, learn from the tools team about what a notebook is and how to use SQL, Python, and Powershell notebooks for deployment, automation, troubleshooting and analytics.
This session is designed to guide you through what a query plan is and what information it holds to help you diagnose and understand how the code you write is actually executed by the Database Engine.
Learn how you can take advantage of the separation of compute and storage between BDC and Hadoop to isolate your workloads and increase your compute processing power without having to scale your Hadoop environment.
Walk through partitioning strategies and look into partitioned views to consolidate distributed data. Enterprise features makes this easy, however hacks will be demo'd to make this work in Standard edition.
When you design and build an application, do you think about security first or is it an afterthought? In this talk, you will learn strategies for designing and securing your data layer.
In this talk we look at how we can stream data from SQL Server to the de facto standard for streaming: Apache Kafka.
Shared dev databases have a disastrous effect on quality and throughput. However, moving to self-service dev/test databases is hard due to storage and data privacy concerns. The solution? Docker and dbaclone.
Learn what SQL Injection is and all the mechanisms you should employ to help stop it.
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.
SQL Server 2019 introduces set of new features and improvements to bring close to parity with SQL Server on Windows. Also SQL Server improvements on Linux in Azure ecosystem enables new scenarios for HA/DR.
SQL Server 2019 represents the next evolution of the leading database platform in the industry. In this session, we will cover the complete set of features and capabilities in SQL Server 2019.
<<12>>