Where in the World is Bob?

Our Bob Pusateri has been quite busy lately with SQL Server technical talks, and we wanted to highlight some of the in-person events that he’s spoken at.

We love presenting for local technical user groups. Back in August, Bob spoke at the Chicago SQL Server Users Group on August 9th. This session was his first session highlighting Microsoft’s global scale database – Cosmos DB – called “Select Stars: A SQL Server DBA’s Introduction to Azure Cosmos DB.” Bob also presented this session for the Chicago Suburban SQL Server Users Group on September 18th.

We are also proud to speak at a number of SQL Saturdays. Bob spoke at the SQL Saturday in Oslo Norway on September 1st! Bob presented this Cosmos DB session at this event. His slides are available for you to download.

Bob also presented at the SQL Saturday in Boston MA on September 22nd. This session was called “Supercharging Backups and Restores for Fun and Profit“, and his slides are available for you to download.

Bob will be presenting at the Red-Gate SQL in the City Summit in Chicago on October 26th. This session is called “Maximize Availability and More with SQL Server Estate Monitoring“.

Bob is also presenting at this year’s PASS Summit in Seattle during the week of November 6th. He is presenting two sessions – the Cosmos DB introductory session, and “SSMS & T-SQL Tricks: Working Smarter, Not Harder“. This conference is world-class and we want to see you there with us!

If you want Bob or David to speak for your user group or SQL Saturday, contact us!


SQL Saturday Oslo 2018

Bob Pusateri is proud to present at this year’s SQL Saturday in Oslo, Norway, on September 1st, 2018. Bob’s session, “Select Stars: A SQL DBA’s Introduction to Azure Cosmos DB” is new and centered around introducing Cosmos DB to SQL Server professionals.

Abstract: 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!


SQL Saturday Iowa City 2018

Heraflux is proud to have David Klee present at this year’s SQL Saturday in Iowa City, IA, on June 23! Learn more at sqlsaturday.com.


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!


Speaking at SQL Saturday Olso 2018

I always feel honored when chosen to present at a SQL Saturday event. Being selected is never a guarantee, especially these days when organizers seemingly have more speakers and abstracts to pick from than ever before. But I am just over-the-moon happy to share that I was picked to speak at SQL Saturday in Oslo, Norway coming up on September 1. Norway has been on my list of places to visit for years, and I really can’t wait. Thank you so much to the SQL Saturday Oslo organizing team for putting together an amazing schedule and for allowing me to be a part of it – this is going to be a fantastic event!

My presentation at this event is entitled “Select Stars: A SQL DBA’s Introduction to Azure Cosmos DB”. I’ve been working with Azure Cosmos DB for a while now, and it’s really an incredible product. It’s been generating lots of buzz as of late, but there are still plenty of DBAs out there who have yet to use it. This is an introductory-level session that focuses on explaining what Azure Cosmos DB is, how it works, what its strengths are, and how they can be leveraged. To anyone curious about Azure Cosmos DB, this is the session for you!

Registration for SQL Saturday Oslo is now open – register today before it fills up! If you would like to extend your SQL Saturday experience even further, they are also offering four pre-conference sessions on Friday August 31.

I am incredibly stoked to visit Norway and I hope I’ll see you there in just three short months!

(Syndicated from Bob’s home blog site at bobpusateri.com)


SQL Saturday Iowa City Precon June 22

We are extremely proud to announce that David Klee has been selected to present an all-new preconference training session on Friday, June 22, ahead of the SQL Saturday in Iowa City, Iowa. This all-day training class, entitled “Level Up Your Cloud Infrastructure Skills“, is designed to help you, the SQL Server professional, ramp up your knowledge so you know how to better manage workloads in the cloud.

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 in this all-day boot camp on ramping up your knowledge on cloud management!

RSVP for this exciting preconference training session here for just $125! Seats are limited, so register soon!


SQL Saturday Madison 2018

Heraflux is proud to announce that Bob Pusateri will be presenting at this year’s SQL Saturday in Madison WI on Saturday, April 7, at the Pyle Center. His session is entitled “Locks, Blocks, and Snapshots: Maximizing Database Concurrency.”

Abstract: The ability for multiple processes to query and update a database concurrently has long-been a hallmark of database technology, but this feature can be implemented in many ways. This session will explore the different isolation levels supported by SQL Server and Azure SQL Database, why they exist, how they work, how they differ, and how In-Memory OLTP fits in. Demonstrations will also show how different isolation levels can determine not only the performance, but also the result set returned by a query. Additionally, attendees will learn how to choose the optimal isolation level for a given workload, and see how easy it can be to improve performance by adjusting isolation settings. An understanding of SQL Server’s isolation levels can help relieve bottlenecks that no amount of query tuning or indexing can address – attend this session and gain Senior DBA-level skills on how to maximize your database’s ability to process transactions concurrently.


SQL Saturday Chicago 2018

Heraflux is proud to support this year’s SQL Saturday in Chicago! Stay tuned for details on our involvement.

SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Mar 17 2018 at Benedictine University, 5700 College Rd, Lisle, Illinois, 60532, United States.


Speaking at SQL Saturday Chicago

Heraflux is proud to contribute to this year’s SQL Saturday event in Chicago on March 17. Not only is our own Bob Pusateri one of the primary event coordinators, David Klee is presenting a new session called “Level Up Your Cloud Infrastructure Skills“.

Session 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!

Register for this exciting event today, and we look forward to meeting you there!


SQL Saturday Nashville 2018

Our very own Bob Pusateri is proud to present a session entitled “Minimizing User Impact with Advanced Restore Methods” at this year’s SQL Saturday in Nashville, TN on January 13. SQL Saturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Jan 13 2018 at Middle Tennessee State University (MTSU), 1301 East Main Street, Murfreesboro, Nashville, Tennessee, 37132, United States.

Minimizing User Impact with Advanced Restore Methods

Speaker: Bob Pusateri

Duration: 60 minutes

Track: Database Administration

We all know that backups are only half the battle – restores are what really matter when disaster strikes. Standard restores, while effective, may require additional downtime and further affect the business. This session will demonstrate three advanced restore methods you should know: point-in-time restores, piecemeal restores, and page restores, and will discuss when each method is appropriate. Attend this session to learn how to be a better DBA by minimizing downtime and user impact after disaster has struck!

RSVP today and we’ll see you at this event!