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
Choose Your Own Data Adventure: Data Storage
Do you need to rise above the noise and confusion of the complaints your DBA makes about the queries you write? Do you almost hear the voice of your DBA while you are dreaming, can you hear them say “write better queries”? Yet, what you never hear their voices say is just how to write better queries. During our time together you will be set on a course to understand the anatomy of an ANSI standard query. Not only will you learn the parts of a query, but you will also be given what you need to make those queries more efficient. With the focus on ANSI standard queries, rather than engine specific variants, what you learn will be applicable to Oracle, SQL Server, Azure SQL, Postgres, MySQL, and several other relational engines. Come, learn to query on and perhaps there will be peace, with your DBA, we you are done.
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.
Introducing Infrastructure for Developers and Data Professionals
It doesn’t matter if you are a DBA, application developer, database developer, or BI pro the infrastructure your environment runs on is important. If you didn’t “grow-up” on the system administration side of IT or, perhaps, 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.
Choose Your Own Azure Data Store
The cloud in general, Microsoft Azure specifically, is not going away anytime soon. Among the questions one might ask looking at a personal or corporate move to Azure is “Where do I put my data?” From Infrastructure as a Service to Software as a Service, files to databases, points between and beyond there are a multitude of ways to approach storing data in Azure. In this session we will take an introductory look at the ways to store data in Azure, giving you foundational knowledge as to what the best use case for different types of data storage is, who is responsible for recovery and security, as well as taking a glance at cost, thus enabling you to start making choices as to the best place to store your data in the Microsoft Cloud.
Accessing Your Data: A Look at Querying Relational Databases
SQL Server/Azure SQLDB, Oracle, PostgreSQL, MySQL, the big players in the relational database game, each with its own features and strengths, different as night and day, or are they? To be sure, all four are different, all four really do have features that set them apart from each other. However, when it comes to their primary feature/function the ability to store data and allow you to access it, they all have a lot on common. They are all based on the relational database work of Edgar Codd and while each uses their own dialect, the query language is based on ANSI Standard SQL. While there are stark differences in each implementation of the querying language, this session ill focus on the intersection between those languages. Specifically, we will start with a brief look at the concept of relational databases, then look at some ways you can write better queries to retrieve the data you need a bit faster.
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