PASS Virtual Summit 2020 Conference Sessions

Whether you are a SQL Server Database Administrator or Infrastructure Architect, you should be attending this year's PASS Summit 2020 conference, held virtually from November 10 to 13th online.

I am thrilled to deliver a preconference boot camp called ‘Amplify Your Virtual SQL Server Performance‘ , to be held live on Monday, November 9th.

Session Description: Virtualization has been the norm in data centers for years. However, implemented incorrectly, your SQL Server performance can take a massive dive. Are you sure that your SQL Servers are running at optimal performance? This full-day boot camp covers all aspects of performance engineering for virtualized SQL Servers on all virtualized platforms, including VMware and Hyper-V.

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. New features such as SQL Server containers and hybrid cloud architectures will be demonstrated. Backups, high availability, and disaster recovery guidelines will also be reviewed. Most importantly, this seminar informs you on methods and terminology to improve your collaboration with your infrastructure team in order to streamline your critical SQL Server performance.

Next, as part of the "Modernizing with SQL Server" Learning Pathway, I'm presenting a 100-level session called "10 Cloudy Questions to Ask Before Migrating Your SQL Server".

Session Description: Cloud adoption of database-related services continues to accelerate, but the choices for which service to select – IaaS, DBaaS, and PaaS – all impact the features available to your applications. Selecting a service is a critical first step in the migration process, and selecting poorly can lead to cost overruns and significant time spent going down the wrong path. The questions you do not ask or consider prior to a migration can make or break your cloud experience. The most important ten questions to answer, such as your availability requirements, database-level dependencies, migration strategies, and other critical concerns, will all be discussed so that you are ready to move to the cloud with confidence in your platform of choice.

Register for this conference today! This is my personal favorite conference of the year for Microsoft data platform-specific content. I know you'll get as much out of it as I do!

https://youtu.be/nPZCARbsOMA

VMworld 2020 – Top 10 Database Sessions (Part 2)

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member of IT managing SQL Servers in a virtualized environment, you should already be registered for this year’s VMworld 2020 conference, to be held next week – September 29 to October 1. I have compiled my list of the top ten favorite sessions for the SQL Server-on-VMware topic at the show. In no particular order, the second five of my top ten include:

https://www.youtube.com/watch?v=kxDqv-9Vsbw

The first five sessions of this top ten list is located here.

Register for the conference today! The General Pass is free and the conference is next week! What are you waiting for?


PASS Summit 2019 Precon - SQL Server Virtualization

I am proud to announce that I am 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. The biggest session of this conference for me is presenting a full-day preconference training session called “Advanced Virtual SQL Server Performance as part of the Architecture stream.

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.

If you’ve never attended the PASS Summit before, I 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. Just look at this list of sessions! The friends you make last a lifetime. The sessions are certain to improve your career and your job. I know won’t miss it, and I hope to see you there!


Heraflux is Presenting at SQLBits

Heraflux is extremely proud to have one of our Solutions Architects - Bob Pusateri - speaking at SQLBits – Europe’s largest SQL Server conference! Bob will be delivering two SQL Server administration sessions on February 23rd and 24th in London.

VLDBs: Lessons Learned

Whoever coined the term “one size fits all” was not a DBA. Very large databases (VLDBs) have different needs from their smaller counterparts, and the techniques for effectively managing them need to grow along with their contents. In this session, join Microsoft Certified Master Bob Pusateri as he shares lessons learned over years of maintaining databases over 20TB in size. This talk will include techniques for speeding up maintenance operations before they start running unacceptably long, and methods for minimizing user impact for critical administrative processes. You’ll also see how generally-accepted best practices aren’t always the best idea for VLDB environments, and how, when, and why deviating from them can be appropriate. Just because databases are huge doesn’t mean they aren’t manageable, attend this session and see for yourself!

SQL Server Administration on Linux

Times are certainly changing with Microsoft’s recent announcement to adopt the Linux operating system with the SQL Server 2017 release, and you should be prepared to support it. But, what is Linux? Why run your critical databases on an unfamiliar operating system? How do I do the basics, such as backing up to a network share or add additional drives for data, logs, and tempdb files?

This introductory session will help seasoned SQL Server DBAs understand the basics of Linux and how it differs from Windows, all the way from basic management to performance monitoring. By the end of the session, you will be able to launch your own Linux-based SQL Server instance on a production ready VM.

We are thrilled to participate and contribute to this incredible event we’ve been watching from afar for years! Join us at Bob's two sessions and learn from his years of knowledge!


VMworld 2017 USA SQL Server Sessions

Heraflux is proud to announce that our SQL Server sessions for this year's VMworld 2017 conference in Las Vegas have turned up in the VMworld Content Catalog! David Klee has four exciting sessions at the conference, and for those DBAs with VMware administrators attending this conference, tell them to attend these sessions so they can help build a better platform for your data.

ALL DAY SQL Server on VMware Boot Camp

The second revision of our business critical applications and databases pre-conference workshop is to be held at VMworld 2017 US this year on August 26th!

We will cover all pertinent aspects of best practices for deployments and ongoing management of MS SQL Server running in virtualized infrastructure. This deep-dive full-day workshopwill be delivered by VMware technical SQL Server specialists working in concert with world renowned external SQL Server and Virtualization experts, including me! The attendee will experience a workshop rich with technical content to include subjects such as vMotion for Failover Cluster Instances, Availability groups, SQLaaS with vRealize Automation and Site Recovery Manager. The content will be focused on best practices for design, implementation and management augmented with anecdotes of successful customer implementations.

SQL Server professionals, listen up. If your infrastructure admins are attending VMworld this year, please let them know about this course. Training them in the intricacies of the VMware platform as it relates to SQL Server, and having the training come from SQL Server professionals, is going to make your virtualization experience better.

Register for VMworld here! Add the training course at the bottom of the VMware Education courses during the registration process.

Monster VMs (Database Virtualization) with vSphere 6.5: Doing IT Right [VIRT1309BU]

with Michael Corey

VMware vSphere 6.5 has made a lot of changes to enhance the performance of Monster virtual machines (VMs). Databases by their very nature are the classic Monster VMs. If Monster VMs are not virtualized properly, they will never perform well and can negatively impact the performance of other VMs on the hosts. In this presentation, we will teach you how to properly virtualize Monster VMs/databases with vSphere 6.5. We will discuss why you should virtualize and take a look at some installation issues as well as how to architect for performance in terms of vSphere 6.5 specifics, including the storage layer, the processor, memory considerations, and the network layer. Topics will also include NUMA, memory reservations, and how to avoid common mistakes. These lessons will help you optimize any workload you are virtualizing.

Performance Tuning and Monitoring with Virtualized Database Servers [VIRT1430BU]

with Thomas LaRock

Business-critical database platforms are the last holdouts to enterprise virtualization. These systems are the most resource-demanding and latency-sensitive applications, and at the first symptoms of infrastructure challenges the DBAs blame the infrastructure. Successful virtualization of these platforms requires a different approach to virtualization from other applications. The speakers will share their years of experience in virtualizing data platforms. You will learn how to validate your VMware environment and manage the performance properly. Scalability concerns will be addressed through discussions on scaling database VMs upwards and outwards as you work with the DBAs to manage the data lifecycle. Key talking points will help you learn how to perfect database virtualization from a technical, an organizational, and people level.

SQL Server on vSphere: A Panel with Some of the World's Most Renowned Experts [VIRT1930PU]

with Niran Even-Chen, Thomas LaRock, and Allan Hirt

Continuing from last year's successful session, learn from some of world's most renowned SQL Server experts' real-life experiences gained while virtualizing the most demanding SQL Servers! In this panel discussion, you will also have the chance to ask your own questions about SQL Server on VMware vSphere and get answers from the SQL Server gurus.

For those of you who don't manage SQL Servers in a VMware environment, check out all of the fantastic sessions in the performance tuning areas, as they are sure to help you boost performacne across your vSphere farms.

Register for VMworld USA today, and make sure to select the SQL Server on VMware boot camp as part of registration! We look forward to seeing you all there!

 

 


SQL Nexus Wrap Up

This past week, David Klee presented a preconference session and regular session at this year's SQL Nexus conference in Copenhagen, Denmark.

The preconference session called "The Complete Primer to SQL Server Virtualization" was well received! The attendees were well prepared for deep discussions on SQL Server virtualization, infrastructure, and cloud XaaS topics, and the questions were wonderful.

The SQL Server on Linux session was also solid and well attended, as David discussed common administration tasks around tasks that are necessary when making the transition to SQL Server on Linux, such as backing up databases and logs to a file share, and how to configure and mount additional disks for objects such as tempdb, database data, and database log files.

The slides for the SQL Server on Linux session are available for you to download here.

SQL Nexus, thank you for a great time! This is a great conference for folks in the region to attend. We really enjoyed our discussions and deep-dives with attendees and other speakers, and would be very happy to return next year to this conference!

 


Preconference Session at SQL Nexus - SQL Server Virtualization

If you are attending this year's SQL Nexus conference in Copenhagen, Denmark, from May 1st to 3rd this year, we urge you to attend David Klee's preconference training session - "The Complete Primer to SQL Server Virtualization". The architecture of the infrastructure underneath your mission-critical SQL Servers is vital to the well-being of your databases, and if any little component underneath is not running at its peak potential, your SQL Servers are artificially bottlenecked and your performance suffers.

Session Details
Microsoft MVP and VMware vExpert David Klee leads this full-day introduction to enabling and managing a virtualized SQL Server environment. The focus of the course is to help those new to virtualization and/or infrastructure concepts to become familiar with the concept and purposes of virtualization and how it can benefit them as data professionals. Participants will gain exposure to all layers of virtualization underneath SQL Server, from storage to hypervisor to the SQL Server instance, and will learn how to construct the entire stack with a strong emphasis on SQL Server performance.

Intended Audience. The intended audience of this course is information workers (both business and IT-centric) involved with architecting a virtualization strategy for SQL Server, or managing business-critical SQL Servers that have already been virtualized.

Course Topics
The following topics will be addressed during the course:

  • The Physical Infrastructure Underneath the VM
  • Virtualization and Infrastructure Fundamentals
  • The SQL Server Virtual Machine
  • Networking, Support, and Licensing
  • Performance Investigation and Tuning of the Entire Stack
  • Similarities and Differences with Cloud versus On-Prem

Course Objectives
Upon completion of this course, attendees will be able to:

  • Understand key virtualization and cloud concepts
  • Determine the optimal infrastructure configuration for best performance
  • Construct a SQL Server virtual machine template with best practices for agility and performance
  • Understand how and what stack metrics to benchmark and baseline to ensure proper objective performance measurement
  • Identify and remediate common virtualized SQL Server performance killers
  • Understand proper virtualized capacity management techniques for long term management

Prerequisites
Attendees with the following experiences will benefit the most from this course:

  • Basic familiarity with the core components of a server
  • SQL Server installation and configuration
  • Exposure to SQL Server performance metric measurement and identification

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 virtualized SQL Server in your own environments.

We look forward to seeing you all there! Register today, as seats are limited!


VMworld Europe 2016 Wrap Up

vmworld-2016This past week we had the pleasure of attending our first VMworld Europe conference, held this week at the Fira Gran Via in Barcelona, Spain. What a great experience!

20161017_085815

The key takeaways from the conference are quite interesting. The announcements from last and this week indicate some challenges in portions of their strategy going forward. This photo from the speaker room sums up our thoughts on the state of VMware right now - many of the important puzzle pieces are in place, but there are some significant holes that need to be addressed for a more complete picture.

20161018_130601-copy

Sessions

20161018_103107-copyFirst up, I presented a session entitled "Performance Tuning and Monitoring for Virtualized Database Servers" with Thomas LaRock from Solarwinds. We talked about the need to monitor each layer at and underneath the databases for becoming proactive in active performance troubleshooting and monitoring. We presented to a packed room and fielded a number of great questions afterwards.

A little later in the day, I presented a session entitled "Performance Perspectives" for the vBrownBag TechTalks, where I talked about how VM admins need to understand that measuring performance statistics only from the hypervisor presents only a portion of the actual performance of the system.

At the end of the day, I sat on a panel session with Patric Chang and Jonathan Flynn from SanDisk, and Jase McCarty from EMC entitled "Running Business Critical Applications and the Software Defined Data Center on Hyper-Converged Infrastructure and VSAN" where we discussed the implications of business-critical applications and their intersection with hyperconverged and all-flash systems.

vmworld-sandisk-session_photo-small

Wednesday

20161019_104942-copyWednesday was also a day filled with presentations and meetings. I started with a fun and action-packed session with Michael Corey entitled "Monster VMs (Database Virtualization) Doing IT Right" where we gave a rapid-fire stream of useful tips and tricks on maintaining maximum performance of virtualized SQL Server and Oracle VMs.

20161019_110304-copy

That afternoon I presented a repeat session of the "Performance Tuning and Monitoring for Virtualized Database Servers" to another near capacity room. Thank you to all of the die-hard attendees that came for the repeat session when you could not get into the previous session.

Next, VMworld has a lounge area that they call "Meet the Experts". Michael Corey and I chatted with numerous attendees about their unique challenges with virtualizing business-critical apps, especially databases, and hopefully our answers will help them go and solve some of their concerns!

20161019_073942-copy

Announcements

At this conference, VMware announced the next version of their flagship virtualization suite, vSphere 6.5. The whole list of updates and improvements are found here. I feel that this release is a solid evolutionary step towards the future of the on-premises software defined datacenter. I am exceptionally happy about the new REST-based API for managing the environment. We've got some ideas that we're working on where this will come in handy! VMware says general availability of this release is scheduled for later on this year.

However, the overarching buzz at the conference was from VMware's announcement last week. VMware is partnering with Amazon AWS to provide the means to extend the on-prem VMware deployments to the Amazon public cloud in order to create a seamless hybrid cloud approach. The reaction from the attendees was mixed. I am going to save my thoughts on this announcement for an upcoming blog post. It does open a lot of questions about target platform performance, database licensing implications, and operational management.

Barcelona

I did get to venture outside of the convention center and briefly explore Barcelona on Monday with several other SQL Server presenters. Barcelona is an incredible city. I wish I had a full month to just go exploring!

Thanks for having me speak at the conference VMware! This was my first trip to VMworld Europe, but it will certainly not be the last!

20161017_144823 20161017_151920 20161017_110839


Heraflux Presenting at USENIX LISA16 in December

lisa16_button_neat_180Heraflux is proud to present that Deji Akomolafe from VMware Corporation, and Cody Chapman and David Klee will be presenting at this year's USENIX LISA16 conference in Boston, MA, from December 4-9th!

The three of us are presenting a half-day workshop entitled "Designing Your VMware Virtual Infrastructure for Optimal Performance, Resilience and Availability - Straight from the Source" from 1:30p - 5:00p on Monday, December 5th.

akomolafe_deji_100x115  chapman_cody_100x115  klee_david_100x115Read more


IT/Dev Connections Wrapup

ITnDevConnections_logo_TylerOptimized_236x59Last week Heraflux had the pleasure of presenting at this year's IT/Dev Connections conference at the ARIA Resort in Las Vegas. David Klee presented two sessions entitled "Business Continuity for Virtual SQL Servers" and "SQL Server Infrastructure Performance" during the week.

20161010_203220-copy

Thanks to all of the event attendees that came to our sessions! This is a great event, and if you have not considered IT/Dev Connections before, this conference is a must-visit. The variety of topics, from software development, data, professional development, and enterprise IT is quite unique and rewarding for organizations of all sizes. Connections is not small by any stretch of the imagination, but has sessions presented in a more intimate setting, rather than massive events such as Ignite, and you can spend time with the speakers, network with your peers, and do it all without feeling overwhelmed by the huge crowds.

Thanks everyone! Save the date for next year. It's going to be held at the Hilton Union Square in San Francisco, CA, from October 23-26, 2017.