Trends and news around the convergence of data, cloud and infrastructure

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.


0 Comments2 Minutes

COVID-19 Thoughts

With the recent outbreak of the COVID-19 virus, we want to take a moment to share with you the approach that we are taking to support our staff, contractors, customers, and partners during this unfolding event. Our hearts go out to those that have been personally, directly, and indirectly impacted.

Our first commitment is to the health and safety of our team. We have been largely a remote services company since we started, and maintain flexible working locations to help our team adapt to any social distancing or isolation that we feel will help reduce the community spread of this virus. We are not affected by office closures and have the tools and resources to accomplish our tasks in our home offices without interruption. While we normally have a fair amount of on-site visits with clients, for the near-term, we have cancelled all work related travel, in-person technical community events, and are now fully remote as we perform our services for our customers.

We are quite happy to remotely present technical content to various technical user groups worldwide, and feel free to contact us if you'd like to learn more!

We are closely monitoring the situation and following the guidance of the World Health Organization, and will adjust our practices as the situation continues to evolve.

We will continue to use our expertise to ensure that our customers and their needs are still moving forward and meet our expected customer experience through these challenging times. If you have any questions or concerns, please contact us directly.

Sincerely,

David Klee and the rest of the Heraflux Team


0 Comments2 Minutes

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.

 

0 Comments2 Minutes

Presenting at Omaha Azure User Group this Wednesday

This Wednesday, February 26th, I will be presenting a new session entitled "All Things SQL in the Microsoft Cloud" for the Omaha Azure Users Group, starting at 6pm Central time. It is held at the Blue Cross and Blue Shield of Nebraska office at 1919 Ak-Sar-Ben Drive (that's Nebraska spelled backwards for those of you not from the area).

Session Details: Microsoft’s SQL Server database platform has been the foundation of enterprise applications for decades. The adoption of the cloud has started to change the data landscape, and you should be prepared. Microsoft’s Azure cloud platform brings many compelling reasons to move your databases to the cloud, but what do you need to know to have a successful migration? Should you pick Azure SQL Database, Managed SQL Instances, or a SQL Server running in a VM in the cloud? How do I size the new service to maximize performance while minimizing cost? What should I expect in the cloud? What about a hybrid architecture? This interactive session will discuss the similarities and differences of operating a SQL Server in the cloud and will demonstrate many tips and tricks for properly selecting and managing the databases in the cloud.

I look forward to seeing you all there! Bring your questions, and make sure to RSVP at the Meetup group today!


0 Comments3 Minutes

Tell Us About Your Worst Database Code Offenders

For years, I've done consulting around helping organizations tune their database platforms, both from within the database and underneath, to help boost performance and availability. Some database design or code is capable of being tuned, since the organization owns it, but they might lack the time or ability to tune beyond a lab environment. Other times, third-party software vendors ship some pretty troubling code that eats an extraordinary amount of CPU time or storage demand on the database servers. Throwing hardware at the problem only pushes the pain further out into the future but doesn't solve the problem.

We've made some significant improvements lately with our ability to work with ISVs to help them tune their code so that their customers benefit. Their willingness to help shows me that some software vendors do listen and care about their customer complaints. Given the gains we've made for some large ISVs, I'd love to hear your thoughts on specific applications and vendors that ship sub-optimal code. We want to use the list to approach these vendors directly to see if we can convince them to let us help tune their code, and in turn, make their software perform better and get happier customers. If you have a moment, please fill out the SurveyMonkey survey here and let me know your top offenders that you'd like to see corrected! I really appreciate your feedback!


0 Comments2 Minutes