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.
Yet another new tool from Microsoft ! Why should you consider using it? Thats a good question. In this session we will explore at least 10 reasons to use the tool, and maybe a few more.
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.
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.
Tinkered with Powershell but not with Python yet? Let's get you started, and we'll do that with some practical examples focussed around talking to SQL Server and importing and exporting some data.
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 !
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.
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.
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...
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.
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.
In this session you’ll learn more about Azure data services on Azure Arc
How many features of Azure Data Studio can the team blaze through in 20 minutes? We'll find out in this fast paced, lightning-talk style demo session that will touch oh-so-briefly on as many features as possible.
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.
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.
Come to this session to see how SQL Server 2019 mitigates two common performance killers: scalar functions and table variables!
How to code everything in SSRS with PowerShell.
In this demo-heavy session, the PM and engineering team will share some of the very latest tools functionality, along with sneak peaks of upcoming features and prototypes for the SQL Server tool suite.
A Q&A panel session with Andrew Pruski and Anthony Nocentino talking about all things containers! Hosted by Rob Sewell
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
Dance your way to an understanding row and filter contexts in DAX.
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.
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.
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.
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.
In this 20 minute session we will have an overview and demos of Dynamic Data Masking which allows us to obfuscate data in real time
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.
How to understand where bias lies, how to collect data and the impact of bias and ethical considerations in your data science solutions.
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.
SQL Server 2019 introduces FROID, a framework to inline user-defined functions, promising much better performance. What problem does it solve? And how does it work?
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.
In this session, we will discover how to utilize common machine learning approaches for daily SQL Server DBA tasks.
How to increase security by using symmetric and asymmetric server encryption, client side Always Encrypted, secure SSL/TLS channels and Transparent Data Encryption for data at rest.
SQL Server 2019 is full of new features. Some of them are very interesting and useful, but unfortunately not well-known. So far.
Wanted to join with open-source projects but don’t know how? This quick session will give you all that you need to start doing so.
We often talk about DevOps when everything is going well, but what about when it isn't? We will walk through three real-world 'unhappy path' examples and how to overcome the challenges.
This talk sets out to explain some of the terminology, the differences and the similarities between Oracle and SQL Server and hopefully make Oracle not look quite so intimidating.