Tags
Content Type
Search
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.
Data on its own is useful, but boring. Data in story form makes people sit up and take notice. Learn to craft effective stories and maximise the impact of your data communication.
How do you test your data projects? Do you even test? Let's face the truth that data processing solutions are very rarely tested ... So let's start with fundamentals of (not only data warehouse) testing.
In this session, we'll cover the 10 most common tasks a DBA needs to learn to manage in Azure SQL as well as they currently manage their On Prem installs.
Isn't it awkward when someone asks you, "So, where do you see yourself 5 years from now?" Brent Ozar will share how he analyzed the data job market to build his career path.
We're fortunate in seeing tons of customers migrate to the cloud - this session covers major
If you want to work for yourself, you need to be able to sell yourself. I know, I hate it too - it feels gross when I write it that way. I'm Brent Ozar. You recognize my name, that's why you wanna learn this from me.
A distributed availability group is not your mother's availability group. Want to know more? Attend this session.
An introduction to the philosophy of tidy data and the collection of R packages called Tidyverse that help to treat your data appropriately. Including lots of demos from ingesting to cleaning to visualizing your data.
In this session you’ll learn about some of these advanced analytical features in Power BI, including: the Analytics pane on visuals; the Key Influencers visual and other AI features.
You are a developer and you want to leverage the 'Power' features in Azure DevOps via YAML pipeline as code, then this session is for you !
This demo-heavy session will show you advanced methods Paul's used extensively over the years to salvage data for real-life clients after catastrophic corruption.
Join this session to learn about new and upcoming SQL security features and how they are supported in hybrid environments.
Users of Plan Explorer often only utilize the basic capabilities to tune execution plans. This session will cover more advanced techniques to get the most out of SentryOne's FREE execution plan analysis tool.
Curious about Visual Recognition and Object Detection in Azure? Are you wondering what the difference is between the Computer Vision API and the Custom Vision API? Get up Speed with the Vision API in less than an hour!
That session explains how to put AI algorithms on Edge devices, with feedbacks from a computer vision project
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...
DBA and Data scientists should work together! Analyzing data gathered with XE and Query Store data using R or Python for better database insight and discovering hidden patterns.
In this session, you'll learn about an end-to-end scenario that takes customers through the application migration process, and how that relates to the data migration.
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.
When buzzwords like DevOps and Machine Learning collide, you need a demo and talk that shows how to actually increase the delivery speed of Advanced Analytics solutions.
The most challenging area of machine learning are Data acquisition, Feature extraction, Feature Selection. Almost in all data science project, 80% of time people spend in Data acquisition and Feature engineering.
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.
Automated Machine Learning, "1 button data science", has been with us for a while. As always there's fans and detractors. We'll discuss when and why you'd use AutoML and when it's better to avoid it.
Learn how to configure source control and use Azure Key Vault to implement Continuous Integration and Continuous Delivery (CI/CD) for Azure Data Factory solutions using Azure DevOps pipelines.
Join us for this session to learn about using serverless in SQL Database and save cost while achieving the desired performance.
AI and data is at the center of the digital feedback loops. We have invested in a comprehensive portfolio of AI tools, infrastructure and services. Come to this session to get an update of Azure AI with demos.
Learn the tools and techniques you can use to create governance and insights around your Azure spend
Data lakes have been around for years yet there is still much hype and hyperbole surrounding their use. This session goes beyond corny puns and broken metaphors and instead provides real-world guidance.
In this session you’ll learn more about Azure data services on Azure Arc
In this action-packed demo full session, we will be showing you how to combine Azure DW and Power BI to get optimal performance for running your day to day reports.
This session will talk about how you can combine the serverless power of Azure Functions with the flexibility of Azure Cosmos DB to process large amounts of data and gain real-time insights.
Azure Key Vault, Azure Dev Ops and Data Factory how do these Azure Services work perfectly together!
How do you deploy multiple machine learning models in production to solve your challenge? How do enable canary releases and A/B testing? How do you make sure a user is always served by the same version of the model?
Understand how to create, train and operationalize your data science projects in Azure Machine Learning.
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.
Azure SQL Database Edge has taken the same SQL database engine and optimized it for the Edge.This session explores customer implementations with Azure SQL Database Edge, along with new product features.
We will deep dive into the architecture of Hyperscale and its various components. We will dive into scaling aspects and the new application patterns it enables and also diagnostics that enable bottleneck identification.
Learn all about Azure Synapse Analytics, including demos so you can see exactly how it works and how it can make your life easier.
In this session we explore Azure Synapse Analytics, we will dive into this limitless analytics service and explore how it brings together enterprise data warehousing and Big Data analytics.
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 boards within Azure DevOps give you the capability to organise your project and analyse the it’s progress. Do you want your manager to stop bugging you about your project’s progress, come to this session?
Come learn how Azure Synapse brings together big data and data warehousing through new technology and a unified development experience
Come learn how to use .NET and Spark together in Azure Synapse and elsewhere to cook and analyze your data!
Together Power BI and Azure Synapse Analytics can handle huge datasets. This session details how the composite model and aggregation capabilities of Power BI can be used to fully exploit the scale provided by Synapse.
Come learn how to build enterprise-scale analytics platforms and fully harness the power of Apache Spark with Azure Databricks
Come learn how you can convert you data into structured formats, apply machine learning skills and index it to make it easy to find information and relationships that can save you time and money.
If AI is on the cards in your business you might need to make a recommendation as to whether your company should Buy or Build. Come to this session to work out the moving parts to turn "It Depends!" into an answer.
Learn how backup and restore work and how to put together an effective backup strategy.
How does a Modern Enterprise BI Architecture with Power BI, SQL Server, Hadoop and Azure look like? Visit my talk and I will show you how we at InnoGames put all these components together to simply make better decisions.
In this session we'll focus on the benefits of using Azure Data Lake. We will cover how we use ADLS in real projects to produce a security architecture which is adaptable, scalable and provides monitoring capabilities.
Learn how to use parameters, variables, expressions, functions, lookups, and loops to build a dynamic and reusable Azure Data Factory solution.
A client's case on how to build a robust metadata driven datahub by utilizing Databricks (Delta Lake) for data ingestion, validation, and loading
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.
Building real-time big data analytics solutions with Azure Data Explorer and Azure Stream Analytics - Come learn about the latest that Azure has to offer in real-time analytics
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.
This session will cover how to create flexible, reliable, and scalable ETL and ELT pipelines across Azure using Azure Data Factory
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.
We will see how to construct a cloud-first architecture based on serverless data analytics. We will look at specific challenges and cost saving strategies, to produce a reliable, scalable and cost effective solution!
Common Data Model as the foundation of Power BI Dataflows and as part of the Open Data Initiative with SAP and Adobe, seems to be a pretty good move from Microsoft. We want to take a closer look to this approach
Taken from the 20+ years of field experiences, many common statistical and data science mistakes have been detected. Session will tackle couple of them.
Learn the four core practices which enable high performance for database development and delivery.
Look beyond the marketing to understand how, when and why you should consider Cosmos DB. Based on real world experience, we'll explain the complexities and gotchas in building realistic cost and performance models.
This presentation is about how to create custom visuals (components) for your PowerBI reports. Power BI reporting features could be extended with custom components, that developers can implement.
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.
Learn how Azure supports interactive, exploratory notebooks (e.g. Jupyter) for data processing and experimentation across a range of scales from simple single-computer work up to massively parallel Databricks clusters.
Learn to make better analytic solutions by following current thoughts on data modeling.
Getting your data model right is key to having a performant report and avoiding the use of unnecessarily complex DAX for your calculations. This session will show you how to effectively design and build your data models.
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.
In this session you’ll learn the real-world ins and outs of how we successfully migrated customers to Azure data platform.
Databricks, Lakes & Parquet are a match made in heaven, but explode with extra power when using Delta Lake. This session will dive into the details of how Databricks Delta works and how to make the most of it.
You keep getting warnings and emails about deadlocks, but let's be honest: you're not really sure how they happen or what to do about it. Brent Ozar will show one, use sp_BlitzLock to analyze it, then fix it.
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.
Deep dive into the Common Data Model world and learn how to deploy, extend and use it along with other Microsoft technologies like Power Apps, Power BI Dataflows and Azure Databricks.
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.
Everything you need to know about dataflows & how to easily prep your data, leverage Microsoft’s standardized schema (CDM), improve time-to-value, eliminate data silos, & create one source of truth for your organization.
Are you thinking about running SQL Server in Kubernetes and don’t know where to start…are you wondering what you really need to know? Then this is the session for you.
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!
Come learn how to design your enterprise-scale data lake on Azure using Azure Data Lake Storage
An introduction to the principles that underpin DevOps and the practices that are derived from those principles. This session is mostly theoretical, although it finishes with a brief overview of an Azure DevOps pipeline.
Learn how to take your Azure Databricks Workspace and store all you care about in a git repo, and maybe even have some tests running as part of your release pipelines!
How do we handle the edge cases, the unique or temporary solutions to get data from emails, file shares, FTP, a user's desktop etc? We need DIY ETL when the easy data sources don't exist, and the usual methods won't work
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
How to understand where bias lies, how to collect data and the impact of bias and ethical considerations in your data science solutions.
What happens when you combine a cloud orchestration service with a Spark cluster?! The answer is a feature rich, graphical, scalable data flow environment to rival any ETL tech we’ve previously had available in Azure.
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!
Execution plans are key to understanding bad query performance. But they can be overwhelming to the new user. Where to start? This session will show the basics!
Learn how to create dashboards which your end users appreciate and want to use.
Learn tips and tricks to make SSIS perform better.
Bob will show the “secret sauce” to financial modelling for General Ledger (GL) structures such as Profit and Loss and Balance Sheet.
Learn how to use a financial transaction dataset and build out interactive, automated and secure reports that can be extended to manage modelling and planning scenarios
<<12345678910...>>