SQL Saturday Atlanta Precon May 17

I am very proud to announce that I have been selected to present an exciting preconference training session at this year’s SQL Saturday Atlanta on May 17th, 2019, called “Level Up Your Data Platform Cloud Infrastructure“. If you are in the cloud or even remotely considering it, I urge you to attend this session!

We also have a discount code for those interested. It’s PAPERJAM, and enter it at the EventBrite checkout page.

Designed to help people that are starting to consider cloud for their data platforms ramp up quickly on all of the items that they need to hit the ground running and make the best choices while selecting and using the platform.

Session Abstract: While your on-premises infrastructure is likely maintained by another team, in the cloud this responsibility falls on you. Whether your organization is just planning for the cloud, all-in, or leveraging a hybrid architecture, this course is designed to ramp you up on maximizing your investment in the cloud components that you utilize.

Infrastructure skills are essential when managing your environment in the cloud. Knowledge is power; key items such as firewalls and connectivity, storage presentation and performance, baselining, and even platform selection are all necessary areas of concern. Capacity management is also crucial, as the old ways of “throwing hardware” at a performance problem will translate into a larger bill each month.

Attend this session to learn how to efficiently manage cloud resources, set yourself apart from your peers, improve the performance of your mission-critical workloads, and potentially save your employer money!

Register for this exciting preconference training session today! If you’re even remotely interested in the cloud, this session is for you!


SentryOne announces SQL Sentry Essentials

Today SentryOne, one of the few SQL Server monitoring platforms that we are proud to stand behind, announced a new version of their monitoring platform called SQL Sentry Essentials. It’s for monitoring SQL Server environments at a smaller scale, and provides a good balance of features that these platforms need without the overhead of unnecessary features that these organizations do not need. Read their full press release here and if you’re interested in exploring this platform, contact us for an introduction!


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!


Live360 2018 Conference

Heraflux is proud to contribute to this year’s Live360 conference, to be held in Orlando Florida at the Royal Pacific Resort at Universal from December 2nd to 7th.

David Klee is presenting two sessions at this conference. The first is Thursday in room SQH01 called “Cosmos DB for SQL Server Pros” at 8:00am.

Microsoft’s Cosmos DB is the first globally distributed database service, allowing low-latency scalability across multiple geographical regions. As a SQL Server pro, why does this matter? SQL Server is a great multi-function database that can handle many of your tasks with ease. However, it’s not the only tool in the toolbox, and Cosmos DB is a tremendous alternative for some use cases. This introductory session explores Cosmos DB and walks you through the similarities and differences in the two platforms. We explore how to provision and design your database, insert sample data and query for specific records. We’ll review the scalability and throughput settings, and help you ramp up your DBA and development skills on this compelling new platform.

You will learn:

  • The core concepts of Cosmos DB and the reasons to consider it for data requirements
  • Key concepts around data design, placement and document construction
  • How to query for data and process client-side

Just after this session completes on Thursday, the next session is called “Level Up Your SQL Server Cloud Skills” in room SQLH05 at 9:30am.

Think infrastructure in the cloud is still just for sysadmins? Think again! As your organization moves into the cloud, infrastructure architecture 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? Should you use a Database as a Service or provision a cloud-based virtual machine? How many compute resources does your database consume during a given day? Can you secure it properly? Come learn many of the key cloud infrastructure points that you should master as the DBA role continues to evolve!

You will learn:

  • To identify key concepts around database platform selection, such as Azure SQL DB versus Infrastructure as a Service, and make educated recommendations for the appropriate platform
  • To identify key performance metrics, such as storage performance, vCPU/DTU requirements and so on, that help with properly sizing the destination resources
  • About Identifying and recognizing the key reasons to migrate databases to the cloud versus keeping them on-premises

Register for this exciting conference today! We look forward to seeing you there!


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!


PASS Summit 2018

What a whirlwind year this has been! I’m thrilled to invite you to my sessions at this year’s PASS Summit, happening this week in Seattle WA.

Tuesday 11:30am to 1:00pm I’m part of the cloud availability panel over lunch at the SentryOne Data Day precon at the Summit. I hope you already registered for this exciting opportunity to learn more about performance and availability-related topics in this whole-day discussion.

Next, for those of you that still have your mission-critical workloads in your on-premises datacenter (or even for those who have them in the cloud, because almost all of the topics directly apply!), come to my session Wednesday morning at 10:45am entitled “On-Prem SQL Servers, Interstellar Performance“. This deep-dive on virtual SQL Server performance will help you squeeze the most performance from your virtualized SQL Servers, and will help you communicate with your infrastructure team on things that matter the most to performance-oriented SQL Servers. You’ll be sure to have quite a bit of real-world tips and tricks to take back to the office as soon as you return from the conference.

Thursday morning I’m part of the SIOS PASS the Bacon breakfast panel, where we’ll get a good chuckle while we discuss a number of topics pertinent to today’s DBA, such as availability both on-prem and in the cloud, disaster mitigation and preparation, and other availability topics. Come register here, get a great breakfast on the house, and learn while you laugh!

Next, Bob Pusateri and I have a session Thursday afternoon called “SELECT STARS: A SQL DBA’s Introduction to Azure Cosmos DB”, where we discuss and present Microsoft’s new Cosmos DB offering on the Azure platform. This platform is a completely different model of databases than what most SQL Server professionals are accustomed to, and we’ll give you the details you need to expand your horizons and learn about this exciting platform. This session is more of the ‘what’ session to get you amped to learn more about the platform on Friday.

Friday my final session of the conference is entitled “Cosmos DB for SQL Server Pros”, designed to give you more of the ‘how’ when continuing your exploration of Cosmos DB. Bob Pusateri and I will share more of the use cases, scalability details, and live code demos of how to access and alter data in a Cosmos DB database.

I hope to see you at the show! If you want to sync up and talk geek, make sure to ping me to set up some time over your favorite form of caffeine.


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!