Cloud | Convergence of Data and Infrastructure

SQL Saturday Iowa City Precon June 22

Cloud, Events, Professional Development, SQL Server, Virtualization No Responses »

May 222018

I’m extremely proud to announce that I have 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!

PASS Summit Session – On-Prem SQL Servers, Interstellar Performance

Cloud, Events, Performance, Professional Development, SQL Server, Storage, User Groups, Virtualization No Responses »

May 092018

I’m very pleased to announce that one of my sessions submitted for this year’s PASS Summit in Seattle, held from November 6 to 9th, called On-Prem SQL Servers, Interstellar Performance, has been selected and one of the first sessions to be announced for the conference. On-premises virtualization is still the principal location for your organization’s mission critical SQL Servers. Even during the journey to the cloud, improving the performance while on-prem improves your life and makes your databases more efficient.

Session Abstract: Your business-critical SQL Servers should not suffer from infrastructure-related bottlenecks. When properly architected and managed, the principal bottleneck to 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. Layers like virtualization, storage, and networking can all detract from database performance, and they are tough to identify. This session is packed with many live examples of tips and tricks gained from years of experience for getting the most performance from your physical and virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure teams so that you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.

Register for this amazing conference today and take advantage of the lower conference fees now before they raise the price!

Free Webinar – DBAs vs. SysAdmins in Cloud Availability April 19

Cloud, Events, Professional Development, SQL Server No Responses »

Apr 022018

SIOS and I are proud to host a joint free webinar entitled “DBAs vs. SysAdmins in Cloud Availability” on Thursday, April 19th, at 1pm Eastern. This webinar is hosted by MSSQL Tips.

Database and system administrators have historically had different perspectives on many topics such as high availability, disaster recovery, and performance tuning. Since one silo generally does not have full visibility into the other silos, the age-old shouting match exists when an availability challenge occurs. “Your systems must have the issue, not mine!” is a constant theme during these situations. However, moving these critical systems to the cloud presents some new challenges. Availability becomes an even more critical topic, as outages can occur more randomly than with on-premises systems, and the two sides must work more closely to achieve system availability that meets their organization’s SLAs. Come learn tips on how to work with your system administrators to achieve a higher level of ability for your critical SQL Servers in the cloud.

Update – Due to my fault of falling ill to influenza this late in the season, this webinar is being moved to May 3rd. Stay tuned for an updated link!

PASS Virtualization Webinar – April 11

Cloud, Events, Professional Development, SQL Server No Responses »

Mar 292018

I am proud to present a free webinar for the PASS Virtualization virtual chapter entitled “Level Up Your Cloud Infrastructure Skills” on Wednesday, April 11, at 1pm Eastern.

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 webinar here! Bring your questions!

A Swiss Army Knife Might Not Make the Best Shovel

Cloud, Technology No Responses »

Mar 012018

You might have noticed that I’ve been pretty quiet as of late. We’re working on a super top secret internal project here at my company, and we’ve got the need to ingest a LOT of data around the clock for some analytics work. My preferred DBMS is, of course, Microsoft SQL Server, and like a lot of DBAs, we want to make this swiss army knife of a relational DB platform do everything we can dream up. Thankfully, it can perform most of the tasks we throw at it pretty well. But, the pragmatist in me asks – “Is this the best tool for the job?”. Because we’re just starting this project, we can step back a bit and look at all of our options.

For our project, we do not want to deal with a datacenter of our own. Yes, we’re known as on-prem virtualization enthusiasts, and there in certainly many reasons for keeping things on-prem for some time to come, but cloud is the right choice for us for this project. We’re working on the cloud platforms just as much as we are on-prem these days, and we’re seeing the shift occurring in the industry.

Take a look at the costs of SQL Server licensing in the cloud. To design a SQL Server that can consume upwards of a few million data points a minute, we’re likely to need to spend quite a bit of capital on this platform. It’s just overkill for a straightforward ingestion then export platform. Then, we need to accommodate high availability, disaster recovery, reporting, and analytics needs.

Hmm.

Cloud brings some differences that might be advantageous here. We’re partial to MS Azure as a cloud platform for our company internally, so what does Azure have that can help us?

Azure Cosmos DB.

Now, it’s not as simple as that. Cosmos DB is a collection of APIs for different database types under the hood.

Each one are used differently, and all of the options include many differences in operation and architecture. Of the five listed platform APIs, which should we use? That’s a good question. For this particular project, we want the ability to store tons of inbound data and then will be pulling it out for analysis. Azure Table API seems to work best for this purpose.

SO! Over the next few months, expect a number of blog posts from me here exploring Azure Table on Cosmos DB and the questions, challenges, and experiences we have on ramping up on this new platform.

PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed

Best Practices, Business, Cloud, Events, Performance, Professional Development, SQL Server, Storage, Technology, User Groups, Virtualization No Responses »

Sep 152017

PASS has continues to ramp up the plans for the PASS Summit in Seattle this October, and my precon session, “Virtual SQL Servers – Right to Ludicrous Speed” has a few open slots for this Tuesday session. This topic is near and dear to my heart, and I’m thrilled to be able to present to the group advanced SQL Server VM tuning techniques learned from over 17 years of performance tuning.

If any of you want to excel your DBA skills, not only for your on-premises SQL Server VMs but also your VMs in the cloud, I hope all of you can join me in what I consider the best SQL Server ecosystem conference in the world.

Session Details:

Join this full-day introduction session focused on managing and boosting the performance of a virtualized SQL Server environment. The focus of the course is to help those new to virtualization, infrastructure, and cloud-based infrastructure-as-a-service 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, no matter if on-premises or in the cloud, 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
• Storage and SAN Concepts and Design
• Virtualization and Infrastructure Fundamentals
• The SQL Server Virtual Machine
• Networking, Support, and Licensing
• SQL Server Infrastructure in the Cloud
• High Availability and Disaster Recovery and SQL Server
• Performance Investigation and Tuning of the Entire Stack

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 their own environments.

Register today! Seats are sure to fill up for these precons!

Older Entries