Bob Pusateri presenting at Chicago Suburban SQL Server Users Group

Bob Pusateri from our team is proud to be presenting at the Suburban Chicago SQL Server Users Group on April 17th at 6pm a session called “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.

RSVP for this event today!


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!


Heraflux is Presenting at SQLBits

Heraflux is extremely proud to have one of our Solutions Architects – Bob Pusateri – speaking at SQLBits – Europe’s largest SQL Server conference! Bob will be delivering two SQL Server administration sessions on February 23rd and 24th in London.

VLDBs: Lessons Learned

Whoever coined the term “one size fits all” was not a DBA. Very large databases (VLDBs) have different needs from their smaller counterparts, and the techniques for effectively managing them need to grow along with their contents. In this session, join Microsoft Certified Master Bob Pusateri as he shares lessons learned over years of maintaining databases over 20TB in size. This talk will include techniques for speeding up maintenance operations before they start running unacceptably long, and methods for minimizing user impact for critical administrative processes. You’ll also see how generally-accepted best practices aren’t always the best idea for VLDB environments, and how, when, and why deviating from them can be appropriate. Just because databases are huge doesn’t mean they aren’t manageable, attend this session and see for yourself!

SQL Server Administration on Linux

Times are certainly changing with Microsoft’s recent announcement to adopt the Linux operating system with the SQL Server 2017 release, and you should be prepared to support it. But, what is Linux? Why run your critical databases on an unfamiliar operating system? How do I do the basics, such as backing up to a network share or add additional drives for data, logs, and tempdb files?

This introductory session will help seasoned SQL Server DBAs understand the basics of Linux and how it differs from Windows, all the way from basic management to performance monitoring. By the end of the session, you will be able to launch your own Linux-based SQL Server instance on a production ready VM.

We are thrilled to participate and contribute to this incredible event we’ve been watching from afar for years! Join us at Bob’s two sessions and learn from his years of knowledge!


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!

RSVP today and we’ll see you at this event!


Welcoming the Year 2018

On behalf of the Heraflux Technologies team, we want to wish you a very happy new year! Twenty-seventeen has been an incredible and exciting year for us and our customers. We had an absolute blast traveling and speaking at a number of different events in 2017, including SQL Nexus, Pure Accelerate, VMworld (USA and EMEA), P21 Connect, PASS Summit, and too many SQL Saturdays and SQL Server User Groups to mention.

Our journey is just beginning. The world continues to change and evolve, especially with the seismic shift from on-prem computing to cloud-based computing, and as it changes, so do we. We at Heraflux have set our sights on a new chapter of innovation for 2018, so stay tuned for some exciting announcements over the next few months!


MSSQLTips Webinar with SIOS - Thursday 1p Eastern

Come join SIOS and Heraflux for an exciting webinar discussing the inherent challenges with infrastructure problems, database performance, and bridging the silos within the IT organization.

  • Learn why legacy tools fall short in helping you fully solve SQL Server problems
  • Comparison: Step through how to troubleshoot the cause of a SQL Server problem vs. using Machine Learning
  • Get answers you need to help prevent future SQL Server performance challenges

Attend this webinar to learn more.

Webcast Date

Thursday, November 16, 2017
6:00 PM UTC | 1:00 PM EST

Register for this webinar here.


VMworld 2017 Recap

Heraflux was proud to participate in both VMworld USA and EMEA over the last month, and our enterprise SQL Server content stole the show!

Our VMworld USA experience was simply amazing.

First, David Klee from Heraflux, along with Deji Akomolafe from VMware Corp. presented an all-day boot camp the Saturday before VMworld on SQL Server virtualization, where we presented an incredible amount of tips and tricks on SQL Server-on-VMware performance, availability, and scalability topics.

Both of our general session presentations made the VMworld USA best-of-the-day list for Tuesday, August 29th! They are now available for you to watch and learn from out on YouTube.

Monster VMs (Database Virtualization) with vSphere 6.5: Doing IT Right [VIRT1309BU] with Michael Corey

Performance Tuning and Monitoring for Virtualized Database Servers [VIRT1430BU] with Thomas LaRock

Our panel session with Argenis Fernandez from Pure Storage, Thomas LaRock from Solarwinds, Allan Hirt from SQLHA, and Niran Even-chen from VMware Corp. was also a smash hit.

Thanks Argenis for the great photo!

Special thanks goes to Don Sullivan from VMware Corp. for championing the enterprise database content at these conferences!

Heraflux also announced a partnership with SIOS Corporation for an upcoming add-on for the SIOS iQ product for advanced SQL Server state collection into the iQ machine-learning platform to boost the advanced performance anomaly detection into the application layer in a virtual environment. Stay tuned for more details regarding this exciting development!

David Klee and Sergey Razin, PhD., from SIOS Corporation demonstrating the SQL Server enhancements in SIOS iQ

David Klee and Jon Shields at the SIOS booth in the exhibition hall

David also presented with Argenis Fernandez from Pure Storage in the Pure booth in the exhibition hall on SQL Server storage benchmarking fallacies.

Heraflux also met with our good friends at Rubrik to discuss the impressive state of their SQL Server-integrated backup platform, who won both the VMworld 2017 Best of Show and Gold awards for their incredible platform.

Argenis Fernandez of Pure Storage, David Klee of Heraflux, Biswaroop Palit from Rubrik

Argenis and David also presented in the Intel booth on modern CPU architectures and VMware vNUMA for enterprise SQL Server workloads.

As you can see, our VMworld USA conference was quite the show.

Just one week later, Heraflux participated in VMworld EMEA in Barcelona, Spain.

Just like in Las Vegas, all of our SQL Server content made the featured videos list! They are now available for you to watch and learn from out on the VMworld EMEA featured videos list.

Monster VMs (Database Virtualization) with vSphere 6.5: Doing IT Right [VIRT1309BU] with Michael Corey

Performance Tuning and Monitoring for Virtualized Database Servers [VIRT1430BU] with Thomas LaRock

David also presented a session for the vBrownBag TechTalks series called vNUMA and You.

We even held an impromptu SQL Server architect open Q&A in the VMvillage to help folks successfully improve their SQL Server virtualization experience.

The announcements from VMware at both of these shows were a bit mixed, in our opinion. The announcement of the general availability for VMware Cloud on Amazon AWS is an interesting shift in strategy. Pivotal Container Service shows VMware’s commitment to containers and workload portability, which to us is a sign of the direction of VMware Corp. On-premises virtualization is generally seen as the new beige at this point, and the unified direction of VMware, based on the messaging from these shows, demonstrates that VMware is shifting to attempt to be the conduit between the various platforms for on-prem virtualization and public cloud providers. The jury is still out on how well the industry will adopt and embrace this shift, but we at Heraflux are quite interested to know your thoughts!

We’ll see you at the next one!


Q&A Session with SQL Server on VMware Experts at VMworld EMEA

Greetings everyone! We had so many people stay after our SQL Server on VMware sessions at VMworld USA to ask great questions, I thought I’d extend an offer to everyone at the European show coming up in a week! Let’s talk SQL Server! We are going to crash the VMvillage hang space on Tuesday, September 12 at 3pm local time to hold an open-ended SQL Server on VMware Q&A session. This unscripted and unofficial session is for you, has no official agenda, and marketing is strictly off-limits.

Our illustrious experts include:


Michael Corey, Founder – Corey and Associates

Thomas LaRock, Head Geek – Solarwinds

Argenis Fernandez, Principal Architect – Pure Storage

Niran Even Chen, Double VCDX, VMware Corp.

… and me!

Mark your calendars, and bring your questions, specific challenges, or discussion points, and let’s do this! Anything goes – performance, availability, setup and configuration, conflicts between best practices for SQL Server and VMware, anything!


SQL Server on VMware VMworld USA Videos Now On YouTube

We just saw that our two SQL Server on VMware sessions that David Klee co-presented on Tuesday at VMworld USA, both of which made the top 10 sessions of the day list at the conference, are now on YouTube! They are free to watch for everyone!

For those of you with virtualized SQL Servers, regardless of platform and cloud or on-premises, we urge you to watch these two sessions at your convenience.

Monster VMs (Database Virtualization) with vSphere 6.5: Doing IT Right (VIRT1309BU) (co-presented with Michael Corey)

Performance Tuning and Monitoring for Virtualized Database Servers (VIRT1430BU) (co-presented with Thomas LaRock)


VMworld EMEA SQL Server Sessions

This trip to Barcelona for Heraflux to the next VMworld EMEA conference next week will be our second trip to this conference in two years. David Klee from Heraflux is presenting on SQL Server performance, scalability, and monitoring in three sessions at this conference.

Tuesday 11amMonster VMs (Database Virtualization) with vSphere 6.5: Doing IT Right (VIRT1309BU) with Michael Corey

Wednesday 12:30pmPerformance Tuning and Monitoring for Virtualized Database Servers (VIRT1430BE) with Thomas LaRock

Wednesday 5:30pmvBrownBag session – vNUMA and You (VMTN6680E)

We are also going to hold at least one impromptu SQL Server experts open Q&A session in the VMvillage at some point early in the week, so stay tuned to this blog for when and where to meet up!

If you want to schedule some time to meet, please contact us and schedule some time. We look forward to meeting with all of you at the show!