Glenn Berry
Glenn Berry, Services Database Engineer
Elizabeth, Colorado, United States
Glenn works as a Services Database Engineer for Koerber Supply Chain Software in Elizabeth, CO. He is a Microsoft Data Platform MVP. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University - University College. He is the author of the book SQL Server Hardware. Glenn blogs regularly at https://glennsqlperformance.com/. He is active on Twitter as @GlennAlanBerry.
Links
Awards
Area of Expertise
Topics
How to Survive a SQL Server Health Check
You have just found out that an outside consultant is going to be conducting a comprehensive SQL Server Health Check on one of your database servers. What do you do now? Is it time to panic?
No, that is not the answer! This session will cover the most common and important things that consultants look for in a health check. Knowing this in advance will help you prepare for and do better in the health check.
More importantly, this session will help you understand best practice configuration settings and practices for your database servers and databases.
Building a Desktop System on a Test Bench
If you want to build a new desktop PC from parts, it is helpful to assemble as much of the system as possible outside of the case.
This makes assembly easier and also lets you test the system before the final build. This session shows you how to do this on an actual test bench and how you can also do it without a test bench.
Building a desktop PC is not as hard as many people think, and this session will demonstrate that.
High Availability/Disaster Recovery 101
How do you design a SQL Server 2019 infrastructure in order to meet specific Recovery Time Objective (RTO) and Recovery Point Objective (RPO) service levels? There are many aspects to consider, from technology choices and licensing, to policies and procedures. This session outlines and compares the various HA/DR technologies available in SQL Server 2019, showing how you can combine them to design and build a solution to help meet your HA/DR goals. It also covers how to come up with the necessary policies to make the technology actually work in your situation.
High Availability/Disaster Recovery 101
How do you design a SQL Server 2019 infrastructure in order to meet specific Recovery Time Objective (RTO) and Recovery Point Objective (RPO) service levels? There are many aspects to consider, from technology choices and licensing, to policies and procedures. This session outlines and compares the various HA/DR technologies available in SQL Server 2019, showing how you can combine them to design and build a solution to help meet your HA/DR goals. This session also teaches you how to formulate policies that enable effective use of technology in your organization.
Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance
The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don't let this happen to you! This session covers current and upcoming hardware from Intel and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.
Dr. DMV's Troubleshooting Toolkit
Dynamic Management Views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates and explains a complete set of diagnostic DMV queries that you can easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases.
This session goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance and databases in order to avoid performance and scalability issues.
Building a Home Computer Lab
f you want to learn about new data-related technologies and features in a controlled and affordable environment, one option is a home computer lab. Depending on your needs and budget, there are many different ways to build a home lab. These range from using a laptop, to building desktop machines from parts, to using actual servers for a lab. This session covers key considerations for deciding which method to choose. It also has many tips and tricks to make your home computer lab more effective and efficient. This session also covers virtualization considerations.
Glenn Berry
Glenn Berry, Services Database Engineer
Elizabeth, Colorado, United States
Links
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