Speaking at SQL Saturday Minnesota

Heraflux is proud to be participating in this year’s SQL Saturday Minnesota on Saturday, October 1st.

David Klee is presenting two sessions at this exciting event. The first is on behalf of VMware Corporation, entitled “Advanced SQL Server on VMware Features“.

Session Abstract: The world’s most powerful virtualization platform, VMware vSphere, contains a number of hidden gems that DBAs can use to make their SQL Servers more highly available and perform better. The demos in this session have been developed to illustrate a few key capabilities of VMware vSphere and VMware NSX that can be used to enhance the overall SQL Server implementation. Features such as vSphere vMotion, vSphere HA, Distributed Resource Scheduler and Fault Tolerance are complimentary to all the features and capabilities of SQL Server and create an unparalleled combination of the world’s top RDBMS and the world’s most complete and effective virtualization proposition. With network virtualization NSX can provide security enhancements unachievable with any other technology and can streamline SQL server deployment automation processes. Please join us for this demonstration of advanced vSphere and NSX feature functionality and an explanation as to how this enhances your SQL Server environment.

The second session is a more hypervisor agnostic session entitled “Virtual SQL Servers. Actual Performance.” Bring your virtualization and infrastructure questions!

Session Abstract: Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance.

This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.

We look forward to seeing you there!


SQL Saturday Minnesota Precon – The Complete Primer to Infrastructure Tuning

Heraflux is pleased to announce that we are launching our next round of all-day precon training session at the upcoming SQL Saturday in Minnesota on Friday, September 30 called ‘The Complete Primer to SQL Server Infrastructure Tuning‘.

The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with the concept and purposes of each layer of the architecture around their databases, and how this knowledge can benefit them as data professionals. Participants will gain exposure to all layers of infrastructure and virtualization underneath SQL Server, from storage all the way through to the SQL Server instance, and will learn how to review and engineer the entire stack with a strong emphasis on SQL Server performance.

The following topics will be addressed during the course:

  • Datacenter Fundamentals
  • Infrastructure Stack Fundamentals
  • Storage and SAN Concepts and Design
  • Networking and Interconnect Topologies
  • Physical Server Technologies
  • The SQL Server Virtual Machine
  • High Availability and Disaster Recovery
  • Performance Investigation and Tuning of the Entire Stack

A working set of the screens and configuration settings referenced in the session, together with the reference slides and documentation, will be provided to attendees, for strategic reference in working with SQL Server and the infrastructure underneath in their own environments.

We are really happy to be delivering this precon training session, and are looking forward to seeing you all there! Reserve your seat at this exciting event here. Tickets are available at just $110!


Speaking at SQL Saturday Dallas

Heraflux is proud to be participating in this year’s SQL Saturday Dallas on Saturday, September 24th. David Klee is presenting a redeveloped version of a session called “Objective SQL Server Performance” at 11:00 am in Room 100.

Session Abstract: “It’s slow! FIX IT!” is not a fun way to walk into the office on a Monday morning. However, putting objective metrics to the subjectivity of ‘slow’ is as much a science as it is art. Performance engineering takes effort well before an issue arises. Collecting the right metrics, trending and comparing against an established baseline, and identifying bottlenecks are all part of the performance process. This interactive session will help the DBA fine-tune their performance tuning approach so that the foundation for long-term proactive performance review is in place. The DBA can then shift the job responsibilities from a reactive response to a more predictive and proactive role.

We look forward to meeting you there!


Speaking at Suburban Chicago SQL Server Users Group Tuesday

pass_chapterThis Tuesday David Klee will be presenting a technical session entitled ‘Virtual SQL Servers. Actual Performance‘ for the Suburban Chicago SQL Server Users Group. Doors open at 5:30pm and the session starts at 6:00pm!

Abstract: Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance. This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.

pureOur friends at Pure Storage are sponsoring this event as well, so if you have any infrastructure administrators that have questions about some of the fastest storage on the planet, or want to know infrastructure questions related to SQL Server virtualization, make sure to invite them!

Bring your questions, as he won’t leave until all questions are answered! RSVP for this event here.


Heraflux is Speaking at IT/Dev Connections 2016

ITnDevConnections_logo_TylerOptimized_236x59Heraflux is pleased to announce that we are speaking at this year’s IT/Dev Connections conference held at the ARIA Resort in Las Vegas from October 10th – 13th.

The first session is to be held on Wednesday, October 12th, at 11:00am, and is titled “Business Continuity for Virtual SQL Servers“.

Session Abstract: Do your SQL Servers have a different high availability or disaster recovery strategy than the rest of the servers, and the differences cause some friction with the infrastructure admins? SQL Server provides many features for improving high availability and disaster recovery resiliency, and they continue to evolve and change with each release. However, do these strategies and features complement or conflict with the current infrastructure strategy? How do these layers work together to protect the business? What if you can augment (or possibly replace) a complex SQL Server BC solution with a simpler, but just as effective, solution using some of the virtualization features available in today’s virtualized environments? This session will discuss strategies for improving your SQL Server uptime while reducing the complexity of your overall SQL Server continuity strategy.

The second session is to be held on Thursday, October 13th, at 10:30am, and is titled “SQL Server Infrastructure Performance“.

Session Abstract: The compute infrastructure beneath your critical SQL Servers is just one layer in the application system stack, but if issues are rampant under your data, your database performance is guaranteed to suffer, and your end user application performance experience is sure to be poor. As a DBA, we are usually at the mercy of the groups managing this hidden layer, but it does not have to be this way. Learning more about these layers of the system stack – physical compute server, virtualization, storage, interconnects, and networking – will help you understand how the infrastructure responds to a query request, and will make you a stronger database professional. You can also indirectly (or even directly) measure the performance of these layers to gain critical insight into their peculiarities.

This conference is not one to miss! Please register for this conference here, and make sure to get in early so we can meet up and talk about your virtual and cloud-based SQL Servers!


Buy some time if a VM datastore fills up

drive-harddisk-3VM snapshots are one of the best virtualization features ever. But…have you ever had a VMware vSphere or Hyper-V snapshot grow out of control and fill the datastore the VM resides on? You know what happens… The VM crashes and goes into a suspended state until free space is added to the datastore. Even the best VM admins out there seem to get burned once when they create a snapshot for some routine maintenance and just forget about it afterwards.

Sometimes this task is harder than it sounds. If your SAN is out of space, or the SAN management tools are out of your control, you could be stuck.

We just added a how-to guide to show you how to create a failsafe placeholder in each datastore that you can delete to buy yourself some time in the event that a rogue snapshot or other operation is about to fill up a VM’s datastore.

Read more about it here!


PASS Summit 2016 Preview Session this Wednesday

PASS_2016_WebsiteHeraflux is very excited to be presenting the opening slot for this year’s 24 Hours of PASS – Summit Preview Edition – this Wednesday morning (September 7th) at 8am Eastern. The title of the session is “The Complete Primer to SQL Server Virtualization“. The session is a one-hour preview to David’s all-day PASS Summit pre-conference training session to be held on Tuesday, October 25th ahead of the PASS Summit conference.

Session Abstract: Your SQL Servers are probably virtualized at this point, but do you feel you have lost that control over the infrastructure that you used to have when they were physical servers? Do the virtual SQL Servers “feel” slower after they were virtualized? When architected and managed with SQL Server in mind, this added layer will help improve the SQL Server’s availability and ability to change with the business, but only when executed properly.

Register for the 24 Hours of PASS – Summit Preview Edition – here!

PASS-24HOP_SummitPreview2016_624x93b_thumb

The expanded all-day session goes into 400-level detail on the hypervisors, how they work, and how to squeeze the most performance from every layer of your virtual environment.

If you are interested in the topic, check out the preview session! If you are intrigued after listening in, please register for the pre-conference session at the PASS Summit 2016.


VMworld 2016 – Heraflux in Las Vegas Day 6 (VMworld Conference Day 4 – Final VMworld 2016 Conclusions)

The morning started with a conference call with an international services firm interested in working with Heraflux on Oracle to SQL Server migration services.  This is an area that really seems to be gaining momentum.  Although we have already blogged about why the timing for an Oracle to SQL Server migration is now, there will be more blogs to follow on this topic.

Read more


VMworld 2016 – Heraflux in Las Vegas Day 5 (VMworld Conference Day 3)

After another successful breakfast meeting with a partner contact, we had some unplanned free time due to rescheduling of a meeting. This allowed us a chance late morning to walk the Solutions Exchange floor to meet with Heraflux hardware and software alliance contacts.

Read more