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!


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!


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!