Proud to support this year's VMworld 2020 conference

I'm thrilled to support and participate in this year's VMworld 2020 conference, which is going online due to COVID-19. I'm presenting a new session called "Architecting SQL Server Workloads on the VMware Hybrid Cloud Platform", session HCP1720, along with Oleg Ulyanov, Senior Solutions Architect at VMware and Shawn Meyers from Tintri by DNN.

Session details: Microsoft SQL Server is one of the most common RDBMSes running on the VMware hybrid cloud platform. In this session, you will learn how to plan a hybrid cloud platform to host SQL Server workloads, what to consider when designing a highly available SQL Server solution, and how to efficiently and effectively deploy SQL Server in a VM. We will also provide an introduction to SQL Server licensing on a virtual environment.

The best part about this conference is that it is FREE! OK, the General Pass is free, but the General Pass includes seven live VMworld video channels covering over 500 sessions and the VMware hands-on labs. If you want to upgrade for even more content, the Premier Pass is only $299, and adds a number of limited capacity sessions, roundtable sessions, and additional one-on-one sessions with VMware engineers.

You should register now! It's free! Sign up now and come learn with me!


Technical Sessions at P21 WWUG Connect Conference 2020

We are looking forward to seeing you at the virtual and free 2020 Prophet 21 Worldwide User Group Connect conference, starting Friday August 14th through Friday September 11th!  It is outstanding to be involved in the event for a fifth consecutive year!

David Klee, Heraflux’s Founder and Chief Architect, has a total of seven conference presentations and will be co-leading two roundtable discussions.

The dates and times for David’s sessions and roundtables (recommended early sign in to roundtables as there are limited virtual seats) are below:

Monday August 17th

  • Infrastructure, Cloud, and Virtualization Health Checks (Part 1) from 11:30-12:30pm EDT
  • Roundtable on Open Technology from 2:30-4:00pm EDT

Wednesday August 19th

  • Infrastructure, Cloud, and Virtualization Health Checks (Part 2) from 11:00-12:30pm EDT
  • SQL Server Health Checks from 2:30-3:30pm EDT

Thursday August 20th

  • P21 High Availability and Disaster Recovery Fundamentals from 2:00-3:00pm EDT

Friday August 21st

  • SQL Server Health Checks (Part 2) from 11:30-1:00pm EDT

Monday August 24th

  • Cloud – No Way, All In, or Kind Of? (Part 1) from 11:30-12:30pm EDT
  • Roundtable on Virtualization from 2:30-4:00pm EDT

Tuesday August 25th

  • Cloud – No Way, All In, or Kind Of? (Part 2) from 2:00-3:30pm EDT

If you are not available to attend a session but have questions for us, please contact us about scheduling a meeting.

Many thanks again to the Prophet 21 Worldwide User Group event coordinators for including Heraflux Technologies in the 2020 Connect user conference.  We are looking forward to virtually seeing our many customers and other attendees.

Thank you!

The Heraflux Team

 

 

 


Renewed as Microsoft MVP for 2020-2021

I have been fortunate enough to be renewed as a Microsoft Data Platform MVP for the calendar year July 2020 to June 2021. I’m honored, humbled, and thrilled that Microsoft values my little piece of the SQL Server community contributions to have awarded me this honor for the seventh year in a row. The MVP Award is Microsoft’s way of thanking community leaders for their activities in the technical communities to advocate and teach so that people get the most from their products.

You can learn more about the MVP program at mvp.microsoft.com, and view all current MVPs here.

Thank you Microsoft for your support! Given the state of the world lately, I’m thrilled to be able to contribute to some positive change and education for everyone to enjoy. Let’s continue to make this year better! Thank you!!


Packet Pushers Podcast released

I am thrilled to have recently recorded a podcast with our friends over at PacketPushers. The podcast, "How an IT Specialist Chooses Adjacent Competencies", talks about how adjacencies in IT, as well as deeply intertwined technologies that compete and conflict with each other, can become a great means to specialize in multiple technologies to become an increasingly valuable asset to your organization and career.

General IT practitioners are incredibly valuable, as it makes you immensely adaptable to emerging and changing technologies. Specializing in one area gives you the potential to become the master at that topic. What is better - specializing or generalizing? I find that you can do both - and quite successfully mind you - but it takes your interest in multiple topics to make it happen. Listen in to learn more!

For those of you who read my blog, you'll find that I have an intense fascination with how large database servers (notably Microsoft SQL Server) play nice - or often enough do NOT play nice - with the infrastructure underneath, regardless of on-premises or public cloud placement. I've been virtualizing these systems and doing performance tuning of these platforms for over 20 years now. I'll never say I've seen it all, but I've seen a lot of how infrastructure and database systems often do not work well together, and knowing one side well makes you stronger at the other.

Coincidentally, I recorded this podcast with Scott Lowe, who authored the book "Mastering VMware vSphere 4", the book that I used to help start my VMware certification path many years ago back in 2009. I'm amazed at how I was able to connect to contribute so many years later! Thanks Scott for your great words of wisdom!


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

Clumio’s Rapid Recovery is Amazing for SQL Server

Clumio’s Rapid Recovery is amazing, and you should know more about it.

You might not have heard of Clumio before. Clumio is an upstart SaaS-based backup solution for both cloud and on-premises environments where the storage endpoint is in the cloud instead of a storage platform in your own datacenter. I’ve been exploring their offerings, since I’m a data nerd and always intrigued by these sorts of things. I gave their Rapid Recovery architecture a solid once-over with the flagship SQL Server availability solution architecture called Availability Groups.

The physical environment that I performed the tests on consists of:

  • Two HPE DL380 Gen9 servers
  • VMware vSphere 6.7, latest update
  • Pure Storage //M20 all-flash SAN
  • 10GbE iSCSI connected storage
  • VAAI is active in the vSphere architecture

The SQL Server testbed VMs were configured as the following.

  • Four total virtual machines
  • Two SQL Server 2019 Enterprise edition and two SQL Server 2016 Enterprise edition VMs
  • vHardware compatibility level 15
  • 4 vCPUs, 16GB RAM
  • Six hard disks, spread amongst multiple VMware Paravirtual SCSI controllers, for a total of 500GB of consumed space per VM
  • Windows Server 2019 Datacenter operating system
  • A fileshare witness for the Windows Server Failover Cluster was configured on a third VM

Two SQL Server Availability Group pairs were configured, each on 2016 and 2019 respectively. The database VMs were then setup with Clumio to replicate their backups to the cloud, and my Internet provider is fast enough that I was able to replicate this up to the cloud within a day.

Now, let’s get a stream of end-user traffic to change some data. I used the HammerDB synthetic database benchmarking tool to generate a workload in a database called ‘tpcc’. I built an initial database at 400GB on each primary instance of the Availability Group with the benchmarking utility so we had some pseudo-real data to work with. Once constructed, I set up a pair of users on a standard workload on a 24-hour timer to continuously insert a stream of data changes into this database, all while Clumio was backing up the servers on a periodic basis.

After a day, I shut down the VMs, and went to the Clumio web-managed interface to restore these VMs into new VMs for database validation. I first instructed Clumio to restore the first VM in each Availability Group replica pair, then the second.

Each restore took 4.5 minutes to restore the entire virtual machine and have it running and active in VMware. Four minutes to restore a 500GB VM of active database data? That’s absolutely incredible, even for an on-premises solution. Given the fact that this is a cloud-native solution is almost unbelievable if I had not witnessed it myself. I’m floored at just how quick this performed.

But did SQL Server come up? Short answer – yes! Restoring a SQL Server Availability Group solution, especially given the Windows Server Failover Cluster (WSFC) configuration underneath, is a delicate but straightforward process.

I first restored the first of the two VMs. The presence of the file share witness allowed the WSFC to come up properly without issue. The first of the two AG replicas also turned right on successfully with no errors in the error logs. The second VM was then restored, and because the restoration point was from the same point in time as the first replica, the databases on the secondary replica were successfully able to come back online and re-synchronize with the primary replica.

It. Just. Worked.

If the second VM had been restored from a different point in time, the database synchronization inherent to the AG could have caused a database transaction log pointer mismatch, and would have meant that the secondary AG database copies would have needed to be re-synchronized. Nothing in this process of re-synchronization is any different than if the database servers had been restored in a more traditional backup and restore process, and is quite normal for DBAs to need to re-sync as needed for these sorts of scenarios.

The process was repeated both on the SQL Server 2019 and 2016 servers, and worked as advertised each time.

During the initial backup streams, there were never any issues while taking database transaction log backups, including dropped transactions or application-level errors.

The speed of restoration process exceeded anything that I could have envisioned. The magic performed in the Rapid Recovery process made this restoration process quick without the need for additional fast storage in your own datacenter. I’m thrilled to have explored this, and am quite eager to continue to work more with the technology!


Webinar - SQL Server Business Continuity - Know Your Options

I’m proud to announce a new webinar that I’ll be presenting at 1pm Eastern on Thursday, May 21st, in conjunction with MSSQLTips and SIOS called “SQL Server Business Continuity – Know Your Options“.

SQL Server database business continuity, including high availability and disaster recovery, is not an easy topic to engineer for. The business must work with the IT teams to define service-level agreements, statistically significant scenarios to plan for, and then decide on a budget.

What are the questions you should ask before starting to build servers? Are the questions different if you are running SQL Server in the cloud vs on-premises? What haven’t you thought of that will threaten to disrupt your strategy during a real disaster? This conversational webinar will discuss all of the scenarios and topics that you should consider for enterprise business continuity planning and strategy before, during, and after building your SQL Servers. Be better prepared for the possibility of disruption to help save your business with the strategies discussed!

I look forward to seeing you there! RSVP for this free webinar here.


Presenting at Global Azure Virtual Day 2020 Omaha

I'm thrilled to be presenting along side of some industry greats at the upcoming Global Azure Virtual Day on April 25th as part of the Omaha users group. The event was originally intended to be in person in Omaha and other cities around the globe, but due to COVID-19, the event is now online. This means that you can attend from the comfort of your own home / couch / wherever you want to join from!

I'm proud to present a session called "All Things SQL in Azure", starting sharp at 10am.

This event is brought to you by the Omaha Azure User Group. The Omaha Azure User Group was formed to promote a community of people that are interested in understanding the benefits of Azure and to learn from others how they are leveraging the platform to solve business problems. Omaha Azure User Group has been a part of Azure Tech Communities as of November’2019. For more details, please visit – https://omahaaug.com/

Agenda:

8:00 AM – 8:30 AM Setup / Networking
8:30 AM – 9:15 AM Session-1: “Getting Started with Azure” – Vaibhav Gujral
9:15 AM – 10:00 AM Session-2: “Building Event-Driven Solutions with Azure Functions” – Mike Pfeiffer
10:00 AM – 10:45 AM Session-3: “All Things SQL In Azure” – David Klee
10:45 AM – 11:00 AM Break
11:00 AM – 11:45 AM Session-4: “The Power of Azure DevOps” – Jeff Bramwell
11:45 AM – 12:30 PM Session-5: “Why Identity Matters: Intelligent Security with the Microsoft Cloud” – Drew Wigodsky
12:30 PM – 1:00 PM Q&A Discussion
1:00 PM – 1:15 PM Wrap-up

Register for this outstanding free event today so you can join on the 25th!


Why you need SQL Server Acceleration Services during COVID-19

So what can really help you and your business succeed during these challenging times?  Your SQL Server and infrastructure teams need to work better together and make the most of the data platform that your business depends on. Performance, availability, and system efficiency are paramount to your business operations, and making sure everyone is on the same page on these topics is critical to squeeze the most from your databases.

Microsoft SQL Server, similar to other relational databases, is a significant cost to your businesses including software licenses, maintenance, support, and the associated on-prem and/or cloud platform.  These are the expenses that companies have been trying to reduce spend for many years.  During this time where you and your company are trying to strategize how to deal with the indirect impact of Coronavirus to financial projections and lost employee productivity, Heraflux can produce results in a short amount of time at a very reasonable cost.

Our high-level approach and focus for a successful project are to deliver both a SQL Server platform review and training package in less than two weeks.  Cost savings identified after our Capacity Management review are often more than the cost of the training.  The training is accomplished throughout the interactive systems review.  Since most businesses have stopped traveling, our remote training is delivered while working on your systems.  A much better alternative to traditional classroom training even without the current world challenges.

If your company has SQL Server in the cloud, planning to move to the cloud, or running SQL Server on-prem and you don’t feel like you “right-sized” the correct resource requirements, I encourage you read more about what we can do with our SQL Server & Platform Skills Acceleration Bundle.

Let us know if these boot camp training services can help you and your organization! Contact us to learn more.


VMware vExpert 2020

I'm proud to announce that I've been awarded the VMware vExpert community award for the calendar year 2020. I'm absolutely thrilled to be awarded this title for the eighth year in a row. It's an honor to be part of the team driving advanced SQL Server virtualization adoption and performance tuning on the VMware platform.

Thank you VMware!

Things are quite different today than they were eight years ago. Cloud is now a big thing, and VMware now runs natively on multiple public cloud providers, but the more things change, the more they stay the same. Without specific tuning, the core platforms (on-prem & cloud) that power my technology of choice, SQL Server, continues to hold back the raw performance of the database engine. My mission is to make sure that these platforms, VMware included, work to their best possible abilities so that the SQL Server workloads can thrive!

The VMware vExpert Program is VMware’s global evangelism and advocacy program. The vExpert award is for individuals, not companies, and last for one year. Employees of both customers and partners can receive the vExpert award. A list of all VMware vExperts is available in the vExpert Directory, including my own.