sql server

Live360 Conference 2018

Heraflux is extremely proud to announce our involvement in this year’s SQL Server Live conference, part of the Live360 conference, in Orlando Florida from December 2 – 7.

David Klee is presenting a number of SQL Server, infrastructure, and virtualization-themed sessions. Stay tuned for more details!


PASS Summit 2018

Heraflux is thrilled to announce our contributions to this year’s PASS Summit to be held in Seattle, WA held November 6-9th at the Washington Conference Center.

Both David Klee and Bob Pusateri are presenting sessions this year. Stay tuned for more details!


SQL Server Content at VMworld 2018

The SQL Server content at this year’s VMworld 2018 USA is phenomenal, and we want to share our recommended sessions for you to attend.

First, Oleg Ulyanov from VMware Corp. and I are presenting a full-day boot camp on running and managing high performance SQL Servers on the VMware platform (VAP3768WU) this Sunday. We will cover a plethora of topics, such as disk presentation, vCPU scheduling, vNUMA, and high availability.

Oleg is also presenting with Divya Sethi session called Highly Available Microsoft SQL Server on VMware vSphere (VAP3687BU) and MS SQL Server on the virtual platform (MTE5027U). Both should be outstanding!

Oleg is a machine with another session called Monitoring Business-Critical Applications: Doing It Right (VAP1448BU) where he’ll discuss monitoring and important KPIs for these systems.

David Morse and Todd Muirhead are presenting a session called Performance of SQL Server, Oracle, and SAP Workloads in VMware Cloud on AWS (VAP1492BU). This session should cover many of the performance topics for these systems that are near and dear to our hearts.

Next, Thomas LaRock from SolarWinds (@sqlrockstar) and I will be presenting a session called “Performance Deep Dive for Demanding Virtual Database Servers” (VAP1425BU). We’ll be discussing advanced performance-related topics such as CPU scheduling and vNUMA, “right-sizing” for both performance and licensing, virtual disks and performance discrepancies, and general operational efficiency.

Next, Michael Corey from LicenseFortress (@michael_corey) and I will be presenting a session called “Database Virtualization (Monster VMs) with VMware vSphere: Doing IT Right” (VAP1296BU), which is an updated version of the continued track of performance-related tips and tricks. Come see us laugh our way through over a hundred slides packed full of things you can take back to your environments!

Finally, I  have a vBrownBag session called “Database vDisks and You” (VMTN5520U), where I’ll talk about all of the various layers of queueing between the SQL Server database and the enterprise SAN, and how to measure and monitor these layers, plus discuss ways to performance tune each layer.

Come learn more about how to manage and tune your SQL Servers at this incredible conference! We’ll see you there!


P21 Connect 2018

Heraflux is proud to sponsor this year’s P21 Connect Conference in Washington DC from August 19 to 21, 2018. David Klee is presenting five technical sessions around SQL Server and infrastructure / cloud technologies!

Register for this exciting event today!


Chicago SQL Server Users Group Presentation Aug 2018

Bob Pusateri from Heraflux is proud to present at this month’s Chicago SQL Server Users Group.

Meeting Topic: A SQL DBA’s Introduction to Azure Cosmos DB

Azure Cosmos DB has quickly become a buzzword in database circles over the past year, but what exactly is it, and why does it matter? This session will cover the basics of Azure Cosmos DB, how it works, and what it can do for your organization. You will learn how it differs from SQL Server and Azure SQL Database, what its strengths are, and how to leverage them. We will also discuss Azure Cosmos DB’s partitioning, distribution, and consistency methods to gain an understanding of how they contribute to its unprecedented scalability. Finally we will demonstrate how to provision, connect to, and query Azure Cosmos DB. If you’re wondering what Azure Cosmos DB is and why you should care, attend this session and learn why Azure Cosmos DB is an out-of-this-world tool you’ll want in your data toolbox!

Speaker Bio: 

Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years experience on SQL Server. His interests involve internals, performance optimization and cloud technologies. He is an active member of both Chicago-area chapters of PASS, a community speaker, and maintains a web presence through both twitter (@SQLBob) and his blog (bobpusateri.com).


Podcast - Database Protection in the Cloud Era

We’re proud to announce that we were part of a podcast recording with Rubrik recently where we discuss database protection in the public cloud era.

Today, companies are on a journey to modernize their infrastructures and meet the changing demands of businesses. The cloud is becoming a strategic part of this initiative due to its potential to unlock cost savings and increase agility. However, the cloud also brings a new set of migration and data protection challenges.

In this episode, Michael Fal (Rubrik), David Klee (Heraflux Technologies), and John Morehouse (Denny Cherry & Associates) explore the database landscape in the cloud era and share protection best practices.

The podcast is hosted over at SoundCloud. Check it out!


Red-Gate SQL in the City Chicago 2018

Our very own Bob Pusateri is presenting as part of the Red-Gate SQL in the City conference at the Microsoft Technology Center in Chicago IL on October 26th!

SQL in the City Summit Chicago takes place at the Microsoft Technology Center, near Millennium Park, and will focus on the concept of Compliant Database DevOps.

With world-class speakers, thought-provoking sessions, engaging panel discussions, interactive workshops, keynotes, and time for networking, the Summit will support senior data professionals to deliver value quicker while keeping their data safe.

Key discussions:

  • Reduce manual tasks to free up teams to spend more time on development
  • Break down silos to enable Dev and Ops to work together to deliver value
  • Reduce the risk of downtime or compliance breaches going undetected
  • Processes and solutions that equally balance the need to release faster while ensuring data security

Who should attend?

The sessions are for C-level IT executives, directors, managers, and senior database engineers and administrators who work with the Microsoft Data Platform.

Professionals interested in learning about all things DevOps will learn what’s needed to effectively balance the demand for delivering software faster, while protecting and preserving business critical data.

From healthcare to finance, government to technology, today’s leaders should be embracing the benefits of DevOps and supporting the implementation of change across IT teams.

There is a limited number of tickets available for the Summit, to support effective networking and ensure a friendly and inspiring atmosphere for all

You’ll need to use an Access Code to register, please reach out to your regional Redgate Account Rep to obtain a code.

Get your access code and register here!


SQL Saturday 2018 Iowa City Precon

David Klee is proud to announce that he will be delivering a new preconference training the Friday before the SQL Saturday in Iowa City, June 22nd, called “SQL Server Infrastructure in the Cloud“.

If you consider that the on-premises infrastructure underneath your SQL Servers is someone else’s responsibility, think again when your systems are in the cloud. Infrastructure skills are essential when planning a cloud migration and managing the environment once the data is in the cloud. Knowledge is power, and key items such as firewalls and connectivity, storage performance, baselining, and even the differences between infrastructure and applications as a service are all necessary areas of concern. Capacity management is also crucial, as the old ways of “throwing hardware” at a performance problem have evolved into a larger bill for cloud resources at the end of each month, and effective handling of the allocated resources will set you apart from the rest. Come learn more about all the areas you need to master as your organization embraces the cloud!

RSVP today at SQLSaturday.com!


Speaking at SQL Saturday Olso 2018

I always feel honored when chosen to present at a SQL Saturday event. Being selected is never a guarantee, especially these days when organizers seemingly have more speakers and abstracts to pick from than ever before. But I am just over-the-moon happy to share that I was picked to speak at SQL Saturday in Oslo, Norway coming up on September 1. Norway has been on my list of places to visit for years, and I really can’t wait. Thank you so much to the SQL Saturday Oslo organizing team for putting together an amazing schedule and for allowing me to be a part of it – this is going to be a fantastic event!

My presentation at this event is entitled “Select Stars: A SQL DBA’s Introduction to Azure Cosmos DB”. I’ve been working with Azure Cosmos DB for a while now, and it’s really an incredible product. It’s been generating lots of buzz as of late, but there are still plenty of DBAs out there who have yet to use it. This is an introductory-level session that focuses on explaining what Azure Cosmos DB is, how it works, what its strengths are, and how they can be leveraged. To anyone curious about Azure Cosmos DB, this is the session for you!

Registration for SQL Saturday Oslo is now open – register today before it fills up! If you would like to extend your SQL Saturday experience even further, they are also offering four pre-conference sessions on Friday August 31.

I am incredibly stoked to visit Norway and I hope I’ll see you there in just three short months!

(Syndicated from Bob’s home blog site at bobpusateri.com)


SQL Saturday Iowa City Precon June 22

We are extremely proud to announce that David Klee has been selected to present an all-new preconference training session on Friday, June 22, ahead of the SQL Saturday in Iowa City, Iowa. This all-day training class, entitled “Level Up Your Cloud Infrastructure Skills“, is designed to help you, the SQL Server professional, ramp up your knowledge so you know how to better manage workloads in the cloud.

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 in this all-day boot camp on ramping up your knowledge on cloud management!

RSVP for this exciting preconference training session here for just $125! Seats are limited, so register soon!