PASS

PASS Summit 2020

I'm thrilled to participate in this year's PASS Summit, to be held during the week of November 10th in Houston TX.

First, I am lucky enough to be able to present a precon training session at the conference on Monday, November 9th, entitled "Amplify Your Virtual SQL Server Performance".

Abstract: Virtualization has been the norm in data centers for years. However, implemented incorrectly, your SQL Server performance can take a massive dive. Are you sure that your SQL Servers are running at optimal performance? This full-day boot camp covers all aspects of performance engineering for virtualized SQL Servers on all virtualized platforms, including VMware and Hyper-V. 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. New features such as SQL Server containers and hybrid cloud architectures will be demonstrated. Backups, high availability, and disaster recovery guidelines will also be reviewed. Most importantly, this seminar informs you on methods and terminology to improve your collaboration with your infrastructure team in order to streamline your critical SQL Server performance.

More details are coming soon!


PASS Virtualization VC Presentation Jul 8 2020

I'm pleased to present an updated session called "Modern SQL Server CPU Performance" for the PASS Virtualization virtual chapter on Wednesday, July 8th, at 1pm Eastern.

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.

Registration is at the virtual chapter home page here. I hope to see you all there!


PASS Summit 2020 Precon Announcement

I am thrilled to announce that I have been accepted to deliver a preconference boot camp called 'Amplify Your Virtual SQL Server Performance' at this year's PASS Summit conference, to be held the week of November 9th-13th. My precon is to be held on Monday, November 9th.

Description: Virtualization has been the norm in data centers for years. However, implemented incorrectly, your SQL Server performance can take a massive dive. Are you sure that your SQL Servers are running at optimal performance? This full-day boot camp covers all aspects of performance engineering for virtualized SQL Servers on all virtualized platforms, including VMware and Hyper-V.

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. New features such as SQL Server containers and hybrid cloud architectures will be demonstrated. Backups, high availability, and disaster recovery guidelines will also be reviewed. Most importantly, this seminar informs you on methods and terminology to improve your collaboration with your infrastructure team in order to streamline your critical SQL Server performance.

PASS has commited to ensuring that the conference will take place, even with the pandemic still rampant at the time of this writing. They are going to make a decision on if the event will be held in-person or online hopefully by early June. So, register today for this outstanding event! Even if you decide that my precon is not for you, the precon offerings at this year's conference are stellar! I can't wait to see you all there, either virtually or in-person!

Scene from PASS Summit 2019

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.

RSVP for this event today!


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:

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.