Peter Shore
Data professional
Dublin, Ohio, United States
Actions
Peter is a seasoned IT professional with over 25 years experience. He took the accidentally intentional DBA plunge in 2013 and has discovered that he loves to find the stories the data has to tell. Peter is comfortable working with physical, virtual, and cloud instances where he tries to apply best practices to attain performance improvements. He is also adept at bridging the gap between technical and business language in order to bring technology solutions to business needs.
Area of Expertise
Topics
Shopping at the Query Store
Without a doubt Query Store and the GUI front end in Management Studio are fantastic for digging into queries which misbehave and go bump in the night, or any other time of day. However, like the host of that late night informercial, Microsoft could easily say “but wait, there’s more.” Did you know that feeding those lovely Query Store windows are a bunch of DMVs? Did you know that you can query those DMVs? By the end of this session you will be able to query those underlying DMVs to find plans with:
• Plan affecting implicit conversions
• Key or RID lookups
• Missing Indexes
Further more you will be able to gather other data to help prioritize which of your problem child queries you need to pay attention to first and which can wait until later, all by shopping at the query store.
SQL Triage: Where to Start When the Proverbial Excrement Hits the Rotating Oscillator
When SQL Server melts down—users are shouting, dashboards are glowing red, your phone won’t stop buzzing, and someone well up the management chain just joined the call—where do you even begin? This session is a practical survival guide for those high-pressure moments when performance tanks, queries grind to a halt, or the system simply refuses to cooperate.
Aimed at junior to mid-level DBAs working with SQL Server in any environment (on-prem, cloud, or hybrid), we’ll step through a clear triage process that helps you cut through the noise and zero in on what matters most. You’ll learn:
• How to assess the situation quickly and separate symptoms from root causes
• Which DMVs, logs, and tools deliver the fastest insights
• How to approach issues focusing on impact, not just errors
• Practical scripts and techniques for common failure scenarios
• When to escalate, when to keep digging, and when to just take a breath
From blocking to memory pressure to those mysterious disconnects, you’ll walk away with a repeatable framework you can rely on when the pressure is on. Bring your curiosity (and maybe some caffeine)—this session will prepare you for the messy, challenging, and oddly rewarding world of SQL Server triage.
Go Jump In A [Data] Lake
The world of data, ML, and AI is abuzz with a multitude of concepts and services by which the data you have can be turned into the insights you need powering a “data driven” workplace. Data Lakes, at least in name, are a prominent talking point among the movers and shakers in the world of data, but what the heck is a data lake? That dear reader is the primary question this session is designed to answer, paired with a point of view as to why you might want to use a data lake. While there will be some hints about how, this is with out a doubt a what and why session to open your eyes to the concepts associated with data lakes.
Azure Infrastructure: An Introduction
Azure infrastructure has a language all its own, yes, the words sound the same as the ones we are used to on-premises, they might even mean the same thing, or almost the same thing, or something mostly different. This session is entirely devoted to clarifying those terms, demystifying concepts and generally prepare you to have a better conversation about Azure. By the end of our time together you will be familiar with the major types of services in Azure, redundancy, and recovery, along with the concepts that will allow you to ask the questions which lead to success in Azure.
Hello My Friends Welcome to CosmosDB
Microsoft says Azure Cosmos DB is a globally distributed, multi-model database. Your reaction might be something like, “what the heck is it”, “why would I use it”, or “how do I use it”. The fundamental purpose of this session is to answer those very questions. After briefly discussing what CosmosDB is, we’ll take some time to discuss why you might use CosmosDB instead of SQL Server or another platform, and finally touch on some basics to get you started with CosmosDB. Upon completion of this session, you will be better equipped to discuss the value of CosmosDB to your organization.
Azure Data: A Guided Tour
As Azure has grown at a breakneck pace, the umbrella once known as SQL Server, including components like Integration Services, Analysis Services, and Reporting services has morphed into a full-fledged tent known as the Microsoft Data Platform. We will briefly introduce Azure as a whole after which focus will turn to the data specific and data adjacent services, covering as many as possible, after all, it seems more are added daily. Rather than a deep dive on one or two services, this session will answer five basic questions about each component:
1. What is it?
2. Who would it be used?
3. Why would it used?
4. How would it be used?
5. Where can more information be found?
At the end of the session you should be able to data services and have a brief idea of their use case thus enabling you to bring a more holistic solution back to the office.
Wait Wait Do Tell Me: A Look At SQL Server Wait Stats
Hurry up and wait, it happens to all of us, even SQL Server. Why is SQL Server waiting? What can we do about it? These questions will be addressed as we define what a wait really is in SQL Server and some approaches to make SQL wait less. This session, targeted at data professionals, managers, developers, and sys admins, will also explore a few of the common SQL waits and specifically what we can do about them
Infrastructure for Data Professionals: An Introduction
It doesn’t matter if you are a Junior DBA, an accidental DBA or all the way up to a Senior DBA, the infrastructure your SQL Server environment runs on is important. Many among the DBA community came in as developers or perhaps directly into database administration roles it is equally possible that you have been out of the operations world long enough to have fallen out of the loop with what is happening. This session is intended to provide a full stack infrastructure overview so that you can talk shop with your cohorts in operations to resolve issues and maybe even be proactive. We will discuss, in an introductory fashion, hardware, network, storage, virtualization and operating system layers. Additionally, some suggestions as to where to find more information will be provided.
DBA 102: Now What
You did it, you made a choice, intentional or otherwise lead to your boss saying “congratulations” you are our new DBA, or maybe you are just DBA curious. The good news, your environment is running, nothing seems to be down, but you are wondering “now what” or “what’s next”. The focus of this session is on what and why, there are defiantly plenty of pointers to resources covering the how. We will talk about your mindset, things you need to focus on like recoverability, availability, and performance while answering your “what’s next” questions and hopefully giving you several beneficial things to look at the next time you logon to the office.
A Query Runs Through It: An Introduction to the SQL Server Engine
Have you ever wondered what happens inside SQL Server when you execute that query you wrote? This session will serve as an introduction to what is going on under the hood, commonly called SQL Server Internals. Whether writing queries or tuning them, SQL Server internals knowledge is highly valuable in Azure VMs or SQL DB, AWS, GCP, and on-premises as the SQL Server engine is the same. Together we will dip into why data types matter, ponder pages, sample the storage engine, and ponder the query processor as we see what happens when your query runs.
The Other side of the GUI: A Survey of Windows Internals
Windows, server or desktop, the nearly ubiquitous “clicky-clicky draggy-draggy” operating system has a lot going on behind those pretty (relative to a command prompt at least) windows all over the screen. Have you ever thought about what an operating system does? In your role as a developer, system administrator, or data professional the operating system has critical impact on the work you do. Throughout the course of this session, we will take your first steps into workings of the Windows operating system, both what it does and the tools, like Process Explorer and WinDbg, to see what Windows is doing. You will leave the session with more insight as to what Windows does behind the scenes and how to see what it is doing.
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top