SQL Saturday
SQL Saturday Iowa City 2018
Heraflux is proud to have David Klee present at this year’s SQL Saturday in Iowa City, IA, on June 23! Learn more at sqlsaturday.com.
SQL Saturday Madison 2018
Heraflux is proud to announce that Bob Pusateri will be presenting at this year’s SQL Saturday in Madison WI on Saturday, April 7, at the Pyle Center. His session is entitled “Locks, Blocks, and Snapshots: Maximizing Database Concurrency.”
Abstract: The ability for multiple processes to query and update a database concurrently has long-been a hallmark of database technology, but this feature can be implemented in many ways. This session will explore the different isolation levels supported by SQL Server and Azure SQL Database, why they exist, how they work, how they differ, and how In-Memory OLTP fits in. Demonstrations will also show how different isolation levels can determine not only the performance, but also the result set returned by a query. Additionally, attendees will learn how to choose the optimal isolation level for a given workload, and see how easy it can be to improve performance by adjusting isolation settings. An understanding of SQL Server’s isolation levels can help relieve bottlenecks that no amount of query tuning or indexing can address – attend this session and gain Senior DBA-level skills on how to maximize your database’s ability to process transactions concurrently.
SQL Saturday Chicago 2018
Heraflux is proud to support this year’s SQL Saturday in Chicago! Stay tuned for details on our involvement.
SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Mar 17 2018 at Benedictine University, 5700 College Rd, Lisle, Illinois, 60532, United States.
Speaking at SQL Saturday Chicago
Heraflux is proud to contribute to this year’s SQL Saturday event in Chicago on March 17. Not only is our own Bob Pusateri one of the primary event coordinators, David Klee is presenting a new session called “Level Up Your Cloud Infrastructure Skills“.
Session abstract: Think infrastructure in the cloud is still just for sysadmins? Think again! As your organization moves into the cloud, infrastructure skills are more important than ever for DBAs to master. Expert knowledge of cloud-related infrastructure will help you maintain performance and availability for databases in the cloud. For example, know what an IOP is? How many does your database consume during a given day? Properly sizing a cloud database depends on your knowledge of this metric. Failure to properly configure storage performance at the time of deployment will slow down your SQL Server considerably. Come learn many of the key cloud infrastructure points that you should master as the DBA role continues to evolve!
Register for this exciting event today, and we look forward to meeting you there!
SQL Saturday Nashville 2018
Our very own Bob Pusateri is proud to present a session entitled “Minimizing User Impact with Advanced Restore Methods” at this year’s SQL Saturday in Nashville, TN on January 13. SQL Saturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Jan 13 2018 at Middle Tennessee State University (MTSU), 1301 East Main Street, Murfreesboro, Nashville, Tennessee, 37132, United States.
Minimizing User Impact with Advanced Restore Methods
Speaker: Bob Pusateri
Duration: 60 minutes
Track: Database Administration
We all know that backups are only half the battle – restores are what really matter when disaster strikes. Standard restores, while effective, may require additional downtime and further affect the business. This session will demonstrate three advanced restore methods you should know: point-in-time restores, piecemeal restores, and page restores, and will discuss when each method is appropriate. Attend this session to learn how to be a better DBA by minimizing downtime and user impact after disaster has struck!
SQL Saturday Oregon 2017
Heraflux is proud to announce that two members of the Heraflux team, David Klee and Bob Pusateri, are presenting at this year’s SQL Saturday Oregon.
SQL Saturday Minnesota 2017
SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Oct 07 2017 at Saint Paul College, 235 Marshall Avenue, Saint Paul, Minnesota, 55102, United States
SQL Saturday Minneapolis Precon Training
Microsoft MVP and VMware vExpert David Klee leads this full-day introduction to getting the most out of the infrastructure underneath your SQL Server environment, whether on-premises or in the cloud. The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with function and purpose of each layer of the architecture around their databases, and how this knowledge can benefit them as data professionals. Participants will gain exposure to all layers of infrastructure, virtualization, and cloud underneath SQL Server, from storage all the way through to the SQL Server instance and database, and will learn how to review and engineer the entire stack with a strong emphasis on SQL Server performance.
SQL Saturday Atlanta 2017 Precon - Virtualization for SQL Server DBAs
Microsoft MVP, VMware vExpert and SQL Server performance expert David Klee leads this full-day, hands-on introduction to enabling and managing a virtualized SQL Server environment. The focus of the course is to help those new to virtualization and/or infrastructure concepts to become familiar with the concept and purposes of virtualization and how it can benefit them as data professionals. Participants will gain exposure to all layers of virtualization underneath SQL Server, from storage to hypervisor to the SQL Server instance, and will learn how to construct the entire stack with the focus on SQL Server performance.
The following topics will be addressed during the course:
- Datacenter Fundamentals
- Infrastructure Stack Fundamentals
- Storage and SAN Concepts and Design
- Networking and Interconnect Topologies
- Physical Server Technologies
- The SQL Server Virtual Machine
- SQL Server in the Cloud
- High Availability and Disaster Recovery
- Performance Investigation and Tuning of the Entire Stack
Upon completion of this course, attendees will be able to:
- Understand key infrastructure, virtualization, and cloud concepts
- Determine the optimal infrastructure configuration for best performance
- Review their own enterprise infrastructure for performance bottlenecks
- Construct a SQL Server virtual machine template with best practices for agility and performance
- Understand how and what stack metrics to benchmark and baseline to ensure proper objective
- performance measurement
- Identify and remediate common infrastructure-related SQL Server performance killers
- Understand proper capacity management techniques for long term management
Register for this exciting event here!
SQL Saturday Iowa City 2017
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free – all costs are covered by donations and sponsorships. Lunch is available on-site for $10. Our Solutions Architect Bob Pusateri will be presenting a session at this exciting event!