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!
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!
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 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.
New Case Studies Added
Heraflux continues to work hard to service our various customers’ needs, including those that are looking to move into the cloud. We have posted a few new success stories to highlight some of our recent successes.
- Heraflux recently helped an employee engagement and customer loyalty web application platform company validate that their application would be right at home in the cloud, where it could save them operational expenses while improving the availability of the platform. The proof-of-concept showed that Microsoft Azure’s App Service and a SQL Server VM performed up to 32% faster than their on-premises web hosting platform.
- Heraflux also recently helped a global computer hardware and software manufacturer improve the availability of the Microsoft SQL Server databases underneath a global perimeter security platform by leveraging Availability Groups for high availability and log shipping for disaster recovery. Our “right-sizing” of the previous servers also helped the Client to save over $200,000 in anticipated SQL Server licensing expenses.
MSSQLTips Webinar with SIOS - Thursday 1p Eastern
Come join SIOS and Heraflux for an exciting webinar discussing the inherent challenges with infrastructure problems, database performance, and bridging the silos within the IT organization.
- Learn why legacy tools fall short in helping you fully solve SQL Server problems
- Comparison: Step through how to troub
leshoot the cause of a SQL Server problem vs. using Machine Learning - Get answers you need to help prevent future SQL Server performance challenges
Attend this webinar to learn more.
Webcast Date
Thursday, November 16, 2017
6:00 PM UTC | 1:00 PM EST
Register for this webinar here.