PASS
PASS Performance VC Webinar Dec 2019
David Klee will be presenting a presentation for the PASS Performance Virtual Chapter at 2pm Eastern on December 19th entitled "Zen and the Art of Baselines".
Session Details: If your boss asked you for the list of the five most CPU-hungry databases in your environment six months from now for an upcoming licensing review, could you come up with an answer? Performance data can be overwhelming, but you can make sense of the mess. Twisting your brain and looking at the data in different ways can help you identify resource bottlenecks that are limiting your SQL Server performance today. Painting a clear picture of what your servers should be doing can help alert you when something is abnormal. Trending this data over time will help you project how much resource consumption you will have months away. Come learn how to extract meaning from your performance trends and how to use it to proactively manage the resource consumption from your SQL Servers.
PASS HA/DR Virtual Chapter Open Q&A Extravaganza
The friends of the PASS HA/DR virtual chapter are invited to bring your questions for a mega Q&A session on Tuesday, December 10th, at 1pm Eastern time. We have assembled one of the largest lineups of SQL Server HA/DR experts in our history, and any question goes!
- Bob Pusateri, Database Engineering Lead – Salesforce
- Brandon Leach, Vice President Database Operations - Financial Company
- David Klee, Founder – Heraflux Technologies
- Ed Leighton-Dick, Founder – Kingfisher Technologies
- Edwin Sarmiento, Managing Director – 15C
- Elizabeth Noble, Database Engineer – Pull-A-Part
- Matt Gordon, Architect - Insight
- Peter Shore, Database Administrator – Thirty-One Gifts
- Rick Lowe, Founder – Data FLowe
- Rob Volk, Senior Infrastructure Engineer – RMS Automotive
- Taiob Ali, Database Administrator – GMO
- Tom Norman, Data Architect – KPA
This open-ended Q&A session will help you answer any questions that you have wondered about with SQL Server and Microsoft data platform high availability and/or disaster recovery. Bring your questions and we have the answers! RSVP today for this free webinar!
Omaha SQL Server Users Group Presentation - Dec 4
I'm proud to announce that I'll be presenting an updated session entitled "Level Up Your Cloud Infrastructure Skills" for the Omaha SQL Server Users Group tomorrow on December 4th at 6pm.
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!
RSVP for this free event here, and I look forward to seeing you all there!
PASS HA/DR Open Q&A Extravaganza Dec 10
As leader of the PASS High Availability and Disaster Recovery virtual chapter, I invite you to bring your questions for a mega open Q&A session on Tuesday, December 10th, at 1pm Eastern time. We have assembled one of the largest lineups of SQL Server HA/DR experts in our history, and any question goes! Not in any order, the speakers are:
- Bob Pusateri, Database Engineering Lead – Salesforce
- Brandon Leach, Vice President Database Operations - Financial Company
- David Klee, Founder – Heraflux Technologies
- Ed Leighton-Dick, Founder – Kingfisher Technologies
- Edwin Sarmiento, Managing Director – 15C
- Elizabeth Noble, Database Engineer – Pull-A-Part
- Matt Gordon, Architect - Insight
- Peter Shore, Database Administrator – Thirty-One Gifts
- Rick Lowe, Founder – Data FLowe
- Rob Volk, Senior Infrastructure Engineer – RMS Automotive
- Taiob Ali, Database Administrator – GMO
- Tom Norman, Data Architect – KPA
This open-ended Q&A session will help you answer any questions that you have wondered about or currently fight with on SQL Server and Microsoft data platform high availability and/or disaster recovery. Bring your questions and we have the answers! RSVP today for this free webinar!
PASS Summit 2019 Precon - SQL Server Virtualization
I am proud to announce that I am presenting at this year’s PASS Summit conference, to be held in Seattle WA from November 5th to 8th at the Washington State Convention Center. The biggest session of this conference for me is presenting a full-day preconference training session called “Advanced Virtual SQL Server Performance“ as part of the Architecture stream.
Virtualization is the new norm in datacenters. Even the ubiquitous “cloud” is nothing more than virtualized servers in someone else’s datacenter with advanced automation on top of it. However, just because it’s everywhere doesn’t mean it is implemented and managed correctly. Done incorrectly, your SQL Server performance can take a massive dive. Are your SQL Servers running at their best possible performance? This full-day boot camp covers all aspects of performance engineering for virtualized SQL Servers. We will review critical topics such as virtualization layers, VM construction, NUMA, resource scheduling, query parallelization and physical server alignment, “right-sizing,” and storage performance-oriented presentation. Availability and disaster recovery guidelines will also be reviewed. Most importantly, this seminar informs you on methods and terminology to help you work better with your infrastructure team to streamline your critical SQL Server performance. You will understand how to review your critical SQL Servers for both their performance and availability as they relate to the virtualization and physical compute layers underneath, and work with your infrastructure team to implement and streamline any of your findings.
If you’ve never attended the PASS Summit before, I urge you to go. This conference is the best Microsoft data-platform-centric conference there is, and the information you will gain is second to none. Just look at this list of sessions! The friends you make last a lifetime. The sessions are certain to improve your career and your job. I know won’t miss it, and I hope to see you there!
PASS Virtualization VC Open Q&A Oct 16
David Klee will be answering questions during an open Q&A session with the PASS Virtualization Virtual Chapter at 1pm Central on October 16th. Bring your questions and RSVP today!
Sponsoring Lincoln SQL Server Users Group with Kevin Kline
Heraflux is proud to sponsor this month's SQL Server User Group in Lincoln, NE, to be held at Don't Panic Lab's Barnyard on October 11th starting at 6pm. Kevin Kline from SentryOne is joining us to discuss Five Critical Considerations When Moving to the Cloud. RSVP for this outstanding event today at the group web site.
Lincoln SQL Server Users Group 2019
David Klee is proud to present at the Lincoln Nebraska SQL Server Users Group on September 5th! Stay tuned for more details!
GLASS User Group Remote Presentation 2019
Heraflux is proud to announce that David Klee will be presenting a remote user group session entitled "Modern CPU Architecture and SQL Server Performance" for the Greater Lansing Area for SQL Server on August 13th, 2019. Please RSVP for the user group session here!
Abstract: Modern CPU architectures are complex and misunderstood, especially as they relate to SQL Server instance configuration and database usage patterns. Default values in virtualization and the SQL Server instance can cause misalignments and improper balance in the way the SQL Server lines up with the CPUs and memory, which results in an immediate (and silent) performance penalty. Come learn as we discuss topics such as physical and virtual NUMA, hyperthreading, query parallelism, and instance settings, and show you how to validate your SQL Server architecture and improve the performance of your critical SQL Servers for both on-prem and cloud-based SQL Servers.
Edmonton SQL Server Users Group Remote Presentation
On February 21st at 5:30pm Mountain Time, David Klee will be presenting a remote session for the Edmonton SQL Server Users Group. RSVP today!
Zen and the Art of Perfmon
If your boss asked you for the list of the five most CPU-hungry databases in your environment six months from now for an upcoming licensing review, could you come up with an answer? Performance data can be overwhelming, but you can make sense of the mess. Twisting your brain and looking at the data in different ways can help you identify resource bottlenecks that are limiting your SQL Server performance today. Painting a clear picture of what your servers should be doing can help alert you when something is abnormal. Trending this data over time will help you project how much resource consumption you will have months away. Come learn how to extract meaning from your performance trends and how to use it to proactively manage the resource consumption from your SQL Servers.