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.
Enhancements that will make your SQL Server roar-SP1 Ed. Bob Ward
It just works – performance and scale in SQL Server 2016 database engine and what is being added to in-market versions.
The video is not available to view online.
Flash Storage For The SQL Server Professional Chris Adkin
The storage industry is at one of the greatest inflection points in its history. Learn the basics of flash storage and how conventional wisdom needs to change and how best to leverage what is fast becoming the main stream storage technology.
The video is not available to view online.
Powershell community scripts for DBAs Andre Kamman
We will take a look into my favourite Powershell scripts
SQL Server Internals and Configuration for R Ginger Grant
Learn how to configure SQL Server 2016 for running R. The individual components and executables installed with R on SQL Server will be explored to understand the internal interactions and processes involved.
Troubleshooting common DBA scenarios with SQL on Linux Denzil Ribeiro
This session will cover common DBA troubleshooting scenarios on SQL Server on Linux. In this demo rich session, we will cover various every-day from troubleshooting startup and configuration to performance and bottleneck analysis.
The video is not available to view online.
An End-to-End Troubleshooting Checklist for SQL Server Kevin Kline
Microsoft ships a multitude of tools to help detect, diagnose and resolve problems inside of SQL Server. But which is best to use and when? This session teaches attendees how to tackle the troubleshooting process to achieve repeated, optimal results.
The video is not available to view online.
Introducing the SQL Server 2016 Query Store Enrico van de Laar
In this session we will take a deep dive into one of the, in my opinion, most exciting new feature in SQL Server 2016, the Query Store. Learn all about the inner workings of the query store and how it can help you analyse query performance!
The video is not available to view online.
Operational insights with Azure temporal tables and PowerBI Raoul Illyés
System-versioned temporal tables provide information about data at any point in time rather than just the current moment, and are a must have feature for any DBA. Collect vast amounts of operational data using OSS based on PowerShell technology and Azure. Add PowerBI to the mix and get mind blowing insights, the future will never be the same.
The video is not available to view online.
Plan optimization from DBA to Developer Martin Wild
Maximise resolution time with some joined up thinking between developers and DBAs. We'll show how to identify poorly performing SQL, how to navigate and analyse its plan and how to increase performance, and cover some free tools to help connect you resolve issues faster.
The video is not available to view online.
SQL Server 2016 Performance and Scalability Improvements Marko Hotti
In this session we will cover the core database engine improvements that make SQL Server 2016 run faster than previous releases. We will also cover some new performance related features and how Windows Server 2016 will improve SQL Server performance.
The video is not available to view online.
SQL Server 2016, New Features & Enhancements John Q Martin
SQL Sever 2016 is just around the corner and with it come some great new features and enhancements to existing capabilities, in this session we will look at some of these and understand how they might make us change the way that we look at designing
The video is not available to view online.
SQL Server Clustering Basics for the DBA Allan Hirt
Windows failover clustering is the foundation for clustered instances and availability groups. A successful DBA needs to understand the underlying Windows portion of clustering. This session will show what you need to know
The video is not available to view online.
AD 2015. 2AM A Disaster just Began Tobiasz Janusz Koprowski
2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW?
An End-to-End Troubleshooting Checklist for SQL Server Kevin Kline
Microsoft ships a multitude of tools to help detect, diagnose and resolve problems inside of SQL Server. But which is best to use and when? This session teaches attendees how to tackle the troubleshooting process to achieve repeated, optimal results.
BI DBA Performance Tuning Bradley Ball
Understanding how SQL Server performance tuning works is not just a job for DBA's. It is important for BI professionals to understand as well
Daily problems with indexing and its-possible-solution Uwe Ricken
This session will demonstrate query performance issues a dba is confronted with every day. The demos will handle these scenarios and it's solution
Easy Performance Tuning: an Intro to Wait Statistics Brent Ozar
You're a DBA who's struggled with Perfmon metrics and Profiler. You're facing a sea of confusing numbers, and you don't know where to focus first. Microsoft Certified Master Brent Ozar will give you a friendly introduction to wait statistics.
Hadoop Primer for SQL Server DBA Konstantin Korobkov
Big Data is here to stay, no doubt about that. And Hadoop is THE framework for Big Data. But what is Hadoop? Is it a friend or foe for SQL Server DBA? Let’s explore what Hadoop is and how to make it work together with SQL Server.
Headache guaranteed: Deadlocking in SQL Server! Klaus Aschenbrenner
SQL Server needs its locking mechanism to provide the isolation aspect of transactions. As a side-affect your workload can run into deadlock situations - headache for you as a DBA is guaranteed!
Monster Text Manipulation: Regular Expressions for the DBA Sean McCown
DBAs are always asked to perform tasks against dozens of objects and the requests never come in the format we need them. Learn how to make regular expressions parse through the requests for you to get your day back and become a star in your office.
The video is not available to view online.
ORM Tuning From A Database Perspective Andre Kamman
Most ORM's tend to be very chatty and generate complex queries. In this session we will look at optimizing database access in ORM's. Using Nhibernate, LINQ &Entity Framework in the demos, we will examine how your ORM talks to the database and why.
Succeeding as a Remote Worker Tim Ford
With over 15 years of experience as a semi-remote Lead DBA for a medical system, running a consultancy firm, producing SQL Cruise events and balancing a personal life Tim Ford has a pocketful of tips to share in making "remote" work for you.
Understanding SQL Database Elastic Scale for the DBA Scott Klein
This session will look at SQL Database Elastic Scale through the important lens of the DBA, focusing on the critical aspects of database performance, maintenance, and management without adding unnecessary complexity.
Do's and don'ts of database corruption Gail Shaw
In this session we'll look at the things you should and shouldn't be doing now, to protect yourself and your data against the risk of corruption and thing you should and shouldn't do should the database ever become corrupt.
Hadoop: Big Data or Big Deal? Eduard Erwee
Hadoop (Big Data) vs SQL Server. A view from a SQL Server DBA / Developer
Monitoring Databases in a Virtual Environment Thomas LaRock
This session will help DBAs to understand what changes they need to make in their performance and monitoring practices for virtualized database servers.
Revenge: The SQL! Rob Volk
Are you a frustrated DBA? Ready to snap? Before you do, come see Revenge: The SQL! and learn a kinder, gentler form of vengeance.
SAN eye for the SQL girl/guy Hue Holleran
More and more senior roles require familiarity with SAN technologies - tricky for us, 'just' the DBA. This '90% practical' session will explore Hue's 2× different SAN in a box'es. Come and gain this much-needed exposure to Enterprise technologies.
SQL 14 In-memory OLTP : Architecture to Implementation Microsoft
What is In-Memory OLTP? How is it architected? Where can I use in-memory technology in my solutions? Learn this and more from the Microsoft team
The Day After Tomorrow; Why You Need to Baseline Richard Douglas
Ensuring top performance is never easy. To maintain performance you need to make sure you’re monitoring the right things. How do you know if the figures you’re seeing are good or bad? Baseline comparisons can help.
<<12>>