Register now
Toggle navigation
Home
SQLBits 2023
Sponsors
Sponsors
Sponsorship
FAQ
Videos on Demand
It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript,
click here for a page that doesn't require javascript
.
Home
Sessions & Content
Sessions & Content
Search
Content Type
Slide Deck
3
OtherSample
1
Video
107
Conference
SQLBits 2020
116
>
Tags
On-prem
(116)
"Stop that!": What does compliance mean for development?
Christopher Unwin
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.
"Whats in a Name?", Data Stories to Impress the Bard
James McGillivray
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.
10 reasons to look at using Azure Data Studio
Robert French
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.
300-Level Guide to Career Internals: Planning Your Career
Brent Ozar
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.
500-Level Guide to Career Internals: Building a Brand
Brent Ozar
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 Groups Primer
Allan Hirt
A distributed availability group is not your mother's availability group. Want to know more? Attend this session.
A journey through the Tidyverse
Thomas Hütter
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.
A Python primer for DBAs, how to talk to a SQL Server
Andre Kamman
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.
Advanced Azure DevOps With Containers and Pipeline As Code
Chris Adkin
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 !
Advanced Plan Explorer Usage for Tuning Execution Plans
Andy Yun
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.
Always Encrypted for Beginners
Monica Rathbun
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.
An administrators guide to SQL Server 2019 BDC
Buck Woody
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.
Analysis Services DevOps with Tabular Editor
Daniel Otykier
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...
Analyzing database with XE and Query Store data using R / Py
Tomaž Kaštrun
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.
The video is not available to view online.
Art of Feature Engineering- For Machine Learning
Sandip Pani
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.
Artificial Intelligence, Machine Learning and Deep Learning
Buck Woody
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.
Azure AI, Power new possibilities for every organization
Lindsey Allen
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.
Azure data services on Azure Arc
Umachandar Jayachandran
In this session you’ll learn more about Azure data services on Azure Arc
Azure Data Studio Features in 20 Minutes
Vicky Harp
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.
Azure SQL and SQL Server: Path to an Intelligent Database
Pedro Lopes
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.
Baking Extended Events recipes without breaking a sweat
Gianluca Sartori
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.
Baselining Performance with DEA
Dustin Dorsey
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.
Build or buy AI?
Steph Locke
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.
Building a Better Backup Strategy
Paul Randal
Learn how backup and restore work and how to put together an effective backup strategy.
Building a Modern Enterprise BI in a Mobile Games Company
Raúl Jiménez Aguilera
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.
Can SQL Server 2019 auto-magically fix my bad T-SQL code?
Andy Yun
Come to this session to see how SQL Server 2019 mitigates two common performance killers: scalar functions and table variables!
Code Your Report Environment
Frank Geisler
How to code everything in SSRS with PowerShell.
Coming Soon: Upcoming SQL Tools Features
Vicky Harp
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.
Common Data Science Mistakes
Tomaž Kaštrun
Taken from the 20+ years of field experiences, many common statistical and data science mistakes have been detected. Session will tackle couple of them.
The video is not available to view online.
Container questions that Andrew and Anthony DM each other
Andrew Pruski
A Q&A panel session with Andrew Pruski and Anthony Nocentino talking about all things containers! Hosted by Rob Sewell
Data Modeling Trends for Analytics
Ike Ellis
Learn to make better analytic solutions by following current thoughts on data modeling.
The video is not available to view online.
Data Virtualization and Data Lake using SQL Big Data Cluster (part 1)
Dennes Torres
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
DAX as Dance-Contexts Explained
Barney Lawrence
Dance your way to an understanding row and filter contexts in DAX.
Deadlocks: Lets Do One, Understand It, and Fix It
Brent Ozar
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.
Deep dive into Tabular Editor's scripting engine
Daniel Otykier
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.
Democratizing Machine Learning on the SQL Platform
Michelle Wallig
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.
Deploying SQL Server in Kubernetes
Anthony Nocentino
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.
De-risk Your Azure SQL Migration: 5 Critical Considerations
Kevin Kline
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.
Digital Transformation from Edge to Cloud with Azure Data
Rohan Kumar
In 2020, organizations have undergone digital transformation at breakneck speeds. In this keynote Rohan Kumar, Corporate Vice President of Azure Data, will discuss how you can be at the heart of change for your company.
The video is not available to view online.
Docker Deep Dive
Andrew Pruski
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.
Dynamic Data Masking in 20 Minutes
David Postlethwaite
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
Elementary! The Curious Case of Deceptive Query Optimizer
Pinal Dave
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.
Ethics and Bias in data science
Robin Lester
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 ... where do I start?
Hugo Kornelis
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!
Eyes On The Prize: Dashboard Visualization Techniques
Kevin Feasel
Learn how to create dashboards which your end users appreciate and want to use.
Fast Focus: Scalar User-defined Functions in SQL Server 2019
Hugo Kornelis
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?
Faster SSIS
Andy Leonard
Learn tips and tricks to make SSIS perform better.
Financial Modelling with Power BI
Bob Duffy
Bob will show the “secret sauce” to financial modelling for General Ledger (GL) structures such as Profit and Loss and Balance Sheet.
First Dates: AI & DBAs. Any Chance to be a perfect match?
Sascha Lorenz
In this session, we will discover how to utilize common machine learning approaches for daily SQL Server DBA tasks.
Getting To Know SQL Server Encryption Capabilities
Mladen Prajdic
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.
<<
1
2
3
>>