Sessions & Content

Search
Content Type
Conference
Tags
SQL Server farm management vs single instance management Per Christopher Undheim
Most DBA’s are cowboys, but there is much to learn from the world of cow herding and dairy farms that can make us manage SQL Server instances in a better way. Come and learn how SQL Server farms are the future.
Turn Runbooks into Notebooks: ADS for the On-Call DBA Matt Gordon
On-call DBAs have all had that phone call in the middle of the night: "the database is down, fix it now!" Learn how Azure Data Studio notebooks can make our responses faster and more organized so we can get more sleep!
An overview of SQL Server 2019 for the busy DBA / developer Randolph West
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.
Create a SQL Test Lab on Your Workstation David Fowler
This session looks at creating a SQL test lab on your workstation. We start by selecting a hypervisor, look at building a virtual machine and then creating a domain controller, a Windows failover cluster and a couple of SQL Servers.
The video is not available to view online.
dbatools-PowerShell and SQL Server Working Together Sander Stad
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?
The video is not available to view online.
Developing SQL Server code to keep your DBA happy Annette Allen
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.
The video is not available to view online.
Improving SQL Server Performance with Indexing Richard Douglas
Indexing presents daunting challenges for even the most seasoned professionals, it offers countless options to choose from. With a little help you’ll see how to simplify indexing in your environment & improve the overall performance of your apps
Kick Start! SQL Server 2017/2019 Performance Tips and Trick Pinal Dave
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 2017 / 2019 has introduced many new features.
Secrets of SQL Server-Database Worst Practices Pinal Dave
This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days.
Slack for the DBA Stuart Moore
Slack, Bots, ChatOps? Is any of this useful to a DBA? Yes, come and let me show you how!
The video is not available to view online.
Taming the Beast - How a DBA can keep Kerberos under control David Postlethwaite
The word Kerberos can strike fear into a SQL DBA as well as many Windows Server Administrators. This talk looks at the principle of Kerberos, how it applies to SQL Server and what we need to do ensure it works
The video is not available to view online.
Validate Your SQL Server Estate with Ease Using dbachecks Rob Sewell
Learn how you can validate your SQL Server estate with ease using dbachecks
Apache Cassandra for the SQLServer DBA Richard Munn
A tour of Cassandra, a popular NoSQL DBMS
Creating complex labs from start to finish with Lability Andre Kamman
Introduction on how to use the Powershell library Lability to create complex SQL Server based test labs.
Data Science For The DBA - Get Started Now Manohar Punna
If you are a DBA and want to get started with Data Science, then this session is for you. This demo-packed session will show you an end-to-end Data Science project covering the core technologies in Microsoft Data + AI stack.
DevOPS for DBAs-Where is your magic wand? Satya Jayanty
DEVOPS - a buzzword in IT and how beneficial it is to include within your DBA activities
Improving SELECT * Query Performance Erik Darling
For anyone frustrated by column-hoarding users and developers
Kick Start! SQL Server 2016/2017 Performance Tips and Tricks Pinal Dave
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. In this session we will discuss newly introduced SQL Server 2016 / 2017 features for performance.
Run your DBA morning checklist with Policy Based Management Pieter Vanhove
In this session you will learn how you can perform your DBA morning checklist with Policy Based Management to evaluate your servers and how I configured my setup.
VLDBs: Lessons Learned Bob Pusateri
Maintaining very large databases (VLDBs) can involve a lot more creativity and bending of the rules than their smaller brethren. Attend this session to learn tips and tricks amassed from years of managing them.
<<12345>>