Omaha SQL Server Users Group Presentation - Dec 4
I'm proud to announce that I'll be presenting an updated session entitled "Level Up Your Cloud Infrastructure Skills" for the Omaha SQL Server Users Group tomorrow on December 4th at 6pm.
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!
RSVP for this free event here, and I look forward to seeing you all there!
David Klee presenting at PASS Summit 2019
Heraflux is proud to announce that the founder David Klee is presenting at this year's PASS Summit conference, to be held in Seattle WA from November 5th to 8th at the Washington State Convention Center.
David is presenting a full-day preconference training session called "Advanced Virtual SQL Server Performance" as part of the Architecture stream.
Session Abstract: Virtualization is the new norm in datacenters. Even the ubiquitous “cloud” is nothing more than virtualized servers in someone else’s datacenter with advanced automation on top of it. However, just because it’s everywhere doesn’t mean it is implemented and managed correctly. Done incorrectly, your SQL Server performance can take a massive dive. Are your SQL Servers running at their best possible performance?
This full-day boot camp covers all aspects of performance engineering for virtualized SQL Servers. We will review critical topics such as virtualization layers, VM construction, NUMA, resource scheduling, query parallelization and physical server alignment, “right-sizing,” and storage performance-oriented presentation. Availability and disaster recovery guidelines will also be reviewed. Most importantly, this seminar informs you on methods and terminology to help you work better with your infrastructure team to streamline your critical SQL Server performance. You will understand how to review your critical SQL Servers for both their performance and availability as they relate to the virtualization and physical compute layers underneath, and work with your infrastructure team to implement and streamline any of your findings.
In addition to the preconference training day, David is presenting an abridged technical fire hose session on key topics in a session called "Virtual SQL Server Performance Deep Dive". This session is designed to ramp up attendees on critical (and silent) performance killers in both cloud and on-premises virtual SQL Servers.
Session Abstract: Your business-critical SQL Servers should not suffer from virtualization-related bottlenecks. When properly architected and managed, the principal bottleneck of performance of these SQL Servers should be only limited by code. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance. Items such as CPU scheduling, storage queueing, and memory overcommitment can all penalize database performance, and are tough to identify.
This session is packed with many live examples of tips and tricks gained from years of experience in getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed, and tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.
If you've never attended the PASS Summit before, we urge you to go. This conference is the best Microsoft data-platform-centric conference there is, and the information you will gain is second to none. The people you meet networking lasts a lifetime. The content is guaranteed to improve your data platform operations. We won't miss it, and we hope to see you there!
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
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.
Did VMware Just Reinvent Itself?
I was fortunate enough to speak at and attend this year's VMworld USA conference in Las Vegas last week. I caught a small announcement there that I found absolutely intriguing, and feel it could be a revolution in the world of VMware and on-premises virtualization.
Last week, they quietly announced that Amazon Relational Database Services (RDS) will soon be able to be used on your on-premises VMware environment. Very few other details were released, but the RDS web page has a signup form for preview program.
The power of the cloud is largely in the automation that it provides. Our experience has shown that most organizations have fantastic on-prem virtualization but lack the automation to provide a solid end-user self-provisioning platform. The automation in the cloud is one of the primary drivers for cloud adoption.
Did VMware Corp. just expand to become the on-premises extension of Amazon to allow corporations to gain the power of Amazon cloud automation but on their existing on-prem IT investment?
Is this the first service of many to be offered?
Microsoft Azure Stack was an absolute game changer when it launched. I love every bit of it, and we use it in a number of shops to contribute to DevOps initiatives to help IT move as fast as the business. The only downside to Azure Stack is that it must be deployed for production purposes on certified hardware, and that list is small and rather pricey. Consistent hardware is a bonus when keeping the experience constant and predictable, but most organizations are not able to leverage their current IT platform investments to deploy Azure Stack because it is not completely certified for Azure Stack. The expense of a new investment in equipment is most likely hurting adoption.
I've been thinking about this for years now. I actually thought that this would happen in a daydream over two years ago. What if the Amazon automation deployment doesn't require special hardware to run when on-prem? What if it will run on a certified and supported VMware deployment, of which there are millions of such deployments worldwide? How does this change the private cloud game?
Only time will tell. We're eagerly watching this one. I can't wait to see if anything new will be announced at Microsoft Ignite in a few weeks!
Heraflux and CRN at VMworld 2018
Heraflux is proud to have contributed to a few news releases from CRN at this year's VMworld conference in Las Vegas. David Klee was there presenting on SQL Server on VMware related topics, was interviewed by CRN for his thoughts on the current state of VMware, and contributed to the conversation around networking.
Networking has been historically fragmented,” he said. “So, if you can turn it around…lock it down better, make it more streamlined and more automated, especially around NSX, then we can be closer to a more secure environment.
Read more on this release here.
Next, the interview talked more about networking here.
Finally, David spoke about the announcements that came from this year's conference.
This was an exciting conference, and we are thrilled to work with CRN on these announcements!
VMworld 2018 USA Direct Playback Links
VMware has prepared and released the video recordings from this year's VMworld 2018 USA conference that was held in Las Vegas last week in an incredibly short time. William Lam (@lamw) has prepared the links into one consumable format at GitHub so you can watch them as you find the time. Check them out!
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!
SQL Server Sessions at VMworld 2018 USA
We hope to see you all at this year's VMworld 2018 USA conference where we are fortunate enough to have been selected to present four SQL Server-themed sessions!
The first is an all-day boot camp (VAP3768WU) with Oleg Ulyanov from VMware Corp. and David Klee from Heraflux where we take participants through a comprehensive journey of understanding how to manage, performance tuning, and business continuity planning for high performance SQL Servers on the VMware virtualization platform. It's the Sunday before VMworld officially ramps up, and if you have infrastructure engineers attending this conference, please tell them to register for this boot camp.
Next, Thomas LaRock from SolarWinds (@sqlrockstar) and David 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 David 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, David has a solo session called "Database vDisks and You" (VMTN5520B), where he'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.
As always, it's going to be a great show! Contact us if you want to meet up in person while at the show, and let's geek out and talk shop! Register for this conference here, and make sure to enroll in the SQL Server on VMware boot camp!
SQL Server on VMware Boot Camp at VMworld 2018
Heraflux is extremely proud to announce that we are presenting in conjunction with VMware Corp. an all-day boot camp for advanced SQL Server operations, performance tuning, and business continuity strategies at this year's VMworld 2018 USA in Las Vegas on Sunday, August 26th, at the Mandalay Bay conference center.
David Klee from Heraflux will be joining Oleg Ulyanov from VMware Corp. to present this all-day intensive workshop.
Workshop Abstract: Learn the essential skills necessary to run SQL Server implementations on VMware vSphere. VMware expert Oleg Ulyanov will be joined by Microsoft MVP David Klee from Heraflux to cover best practices and optimal approaches to deployment, operation, and management of SQL Server on VMware vSphere. This technical workshop delivers real-life, instructor-led, live training and incorporates the recommended design and configuration practices for architecting business-critical databases on VMware vSphere infrastructure. Subjects covered in depth will include performance, monitoring , high availability and disaster recovery with failover cluster instances or availability groups, and advanced storage architectures.
Register for this exciting workshop as part of your VMworld conference admission ASAP, as seats are filling up! SQL Server is not a trivial business-critical application to manage in a virtual environment, and come learn many real-world tips and tricks for making these databases run as fast and smooth as possible.