Technical Sessions at P21 WWUG Connect Conference 2020
We are looking forward to seeing you at the virtual and free 2020 Prophet 21 Worldwide User Group Connect conference, starting Friday August 14th through Friday September 11th! It is outstanding to be involved in the event for a fifth consecutive year!
David Klee, Heraflux’s Founder and Chief Architect, has a total of seven conference presentations and will be co-leading two roundtable discussions.
The dates and times for David’s sessions and roundtables (recommended early sign in to roundtables as there are limited virtual seats) are below:
Monday August 17th
- Infrastructure, Cloud, and Virtualization Health Checks (Part 1) from 11:30-12:30pm EDT
- Roundtable on Open Technology from 2:30-4:00pm EDT
Wednesday August 19th
- Infrastructure, Cloud, and Virtualization Health Checks (Part 2) from 11:00-12:30pm EDT
- SQL Server Health Checks from 2:30-3:30pm EDT
Thursday August 20th
- P21 High Availability and Disaster Recovery Fundamentals from 2:00-3:00pm EDT
Friday August 21st
- SQL Server Health Checks (Part 2) from 11:30-1:00pm EDT
Monday August 24th
- Cloud – No Way, All In, or Kind Of? (Part 1) from 11:30-12:30pm EDT
- Roundtable on Virtualization from 2:30-4:00pm EDT
Tuesday August 25th
- Cloud – No Way, All In, or Kind Of? (Part 2) from 2:00-3:30pm EDT
If you are not available to attend a session but have questions for us, please contact us about scheduling a meeting.
Many thanks again to the Prophet 21 Worldwide User Group event coordinators for including Heraflux Technologies in the 2020 Connect user conference. We are looking forward to virtually seeing our many customers and other attendees.
Thank you!
The Heraflux Team
Renewed as Microsoft MVP for 2020-2021
I have been fortunate enough to be renewed as a Microsoft Data Platform MVP for the calendar year July 2020 to June 2021. I’m honored, humbled, and thrilled that Microsoft values my little piece of the SQL Server community contributions to have awarded me this honor for the seventh year in a row. The MVP Award is Microsoft’s way of thanking community leaders for their activities in the technical communities to advocate and teach so that people get the most from their products.
You can learn more about the MVP program at mvp.microsoft.com, and view all current MVPs here.
Thank you Microsoft for your support! Given the state of the world lately, I’m thrilled to be able to contribute to some positive change and education for everyone to enjoy. Let’s continue to make this year better! Thank you!!
Podcast recording with Dallas DBAs
I'm thrilled to have recently recorded a podcast with Kevin3NF of Dallas DBAs called Data Bits. I had an absolute blast with it, and we laughed for over an hour with fun war stories and goofy things that I chuckle with. You should check this out if you get a moment! Listen to the other podcasts while you're there. You can get a really good sense for the people behind the persona, and it's fantastic to see more about these folks!
PASS Summit 2020 Precon Announcement
I am thrilled to announce that I have been accepted to deliver a preconference boot camp called 'Amplify Your Virtual SQL Server Performance' at this year's PASS Summit conference, to be held the week of November 9th-13th. My precon is to be held on Monday, November 9th.
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.
PASS has commited to ensuring that the conference will take place, even with the pandemic still rampant at the time of this writing. They are going to make a decision on if the event will be held in-person or online hopefully by early June. So, register today for this outstanding event! Even if you decide that my precon is not for you, the precon offerings at this year's conference are stellar! I can't wait to see you all there, either virtually or in-person!
Webinar - SQL Server Business Continuity - Know Your Options
I’m proud to announce a new webinar that I’ll be presenting at 1pm Eastern on Thursday, May 21st, in conjunction with MSSQLTips and SIOS called “SQL Server Business Continuity – Know Your Options“.
SQL Server database business continuity, including high availability and disaster recovery, is not an easy topic to engineer for. The business must work with the IT teams to define service-level agreements, statistically significant scenarios to plan for, and then decide on a budget.
What are the questions you should ask before starting to build servers? Are the questions different if you are running SQL Server in the cloud vs on-premises? What haven’t you thought of that will threaten to disrupt your strategy during a real disaster? This conversational webinar will discuss all of the scenarios and topics that you should consider for enterprise business continuity planning and strategy before, during, and after building your SQL Servers. Be better prepared for the possibility of disruption to help save your business with the strategies discussed!
I look forward to seeing you there! RSVP for this free webinar here.
Why you need SQL Server Acceleration Services during COVID-19
So what can really help you and your business succeed during these challenging times? Your SQL Server and infrastructure teams need to work better together and make the most of the data platform that your business depends on. Performance, availability, and system efficiency are paramount to your business operations, and making sure everyone is on the same page on these topics is critical to squeeze the most from your databases.
Microsoft SQL Server, similar to other relational databases, is a significant cost to your businesses including software licenses, maintenance, support, and the associated on-prem and/or cloud platform. These are the expenses that companies have been trying to reduce spend for many years. During this time where you and your company are trying to strategize how to deal with the indirect impact of Coronavirus to financial projections and lost employee productivity, Heraflux can produce results in a short amount of time at a very reasonable cost.
Our high-level approach and focus for a successful project are to deliver both a SQL Server platform review and training package in less than two weeks. Cost savings identified after our Capacity Management review are often more than the cost of the training. The training is accomplished throughout the interactive systems review. Since most businesses have stopped traveling, our remote training is delivered while working on your systems. A much better alternative to traditional classroom training even without the current world challenges.
If your company has SQL Server in the cloud, planning to move to the cloud, or running SQL Server on-prem and you don’t feel like you “right-sized” the correct resource requirements, I encourage you read more about what we can do with our SQL Server & Platform Skills Acceleration Bundle.
Let us know if these boot camp training services can help you and your organization! Contact us to learn more.
COVID-19 Thoughts
With the recent outbreak of the COVID-19 virus, we want to take a moment to share with you the approach that we are taking to support our staff, contractors, customers, and partners during this unfolding event. Our hearts go out to those that have been personally, directly, and indirectly impacted.
Our first commitment is to the health and safety of our team. We have been largely a remote services company since we started, and maintain flexible working locations to help our team adapt to any social distancing or isolation that we feel will help reduce the community spread of this virus. We are not affected by office closures and have the tools and resources to accomplish our tasks in our home offices without interruption. While we normally have a fair amount of on-site visits with clients, for the near-term, we have cancelled all work related travel, in-person technical community events, and are now fully remote as we perform our services for our customers.
We are quite happy to remotely present technical content to various technical user groups worldwide, and feel free to contact us if you'd like to learn more!
We are closely monitoring the situation and following the guidance of the World Health Organization, and will adjust our practices as the situation continues to evolve.
We will continue to use our expertise to ensure that our customers and their needs are still moving forward and meet our expected customer experience through these challenging times. If you have any questions or concerns, please contact us directly.
Sincerely,
David Klee and the rest of the Heraflux Team
Bob Pusateri Presenting at PASS Summit 2018
I’ve been honored to present a session at PASS Summit for the past few years, but this year I am especially humbled as I had not one but two abstracts accepted! The first is an introduction to Azure Cosmos DB. The other is covering some of my favorite SSMS and T-SQL tips and tricks that can help you save time!
Select Stars: A SQL DBA’s Introduction to Azure Cosmos DB
Level: 200
Where: Skagit 4 (TCC Lower Level)
When: Thursday November 8, 2018 1:30-2:45pm
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!
SSMS & T-SQL Tricks: Working Smarter, Not Harder
Level: 100
Where: Room 6A
When: Wednesday November 7, 2018 4:45-6:00pm
Do you spend a considerable amount of time in SQL Server Management Studio? Are you always in search of ways to write better code with less effort? Attend this session to see demonstrations of all the helpful gems SSMS has hiding in plain sight that will save you keystrokes, mouse clicks, and time while getting your work done. We will also cover useful T-SQL Scripts to make common tasks easier and faster, and solutions to frequently-encountered coding problems. Whether you’re a developer or a DBA, whether you do your work on-premises or in the cloud, attend this session to learn how easy it is to write better T-SQL code and save the day, all while working smarter, not harder!
I hope to see you there!
PASS Summit starts in a little over a month, and if you’re thinking this sounds pretty awesome, registration is still open! The program committee has put together an incredible schedule combining top presenters from all aspects of the Microsoft Data Platform. On top of that, opportunities for networking abound. While the sessions are awesome, the community is PASS Summit’s greatest asset. You really don’t want to miss this.
Even if you can’t attend, be sure to follow me on Twitter (@SQLBob). I’ll be sharing plenty of updates and photos from throughout the conference. Even if you can’t experience PASS Summit in person, by following myself, other community members, and the #PASSsummit2018 hashtag, you can get a great virtual experience.
This post was originally posted on Bob's personal blog over at bobpusateri.com.
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!