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!
Greetings everyone! We had so many people stay after our SQL Server on VMware sessions at VMworld USA to ask great questions, I thought I’d extend an offer to everyone at the European show coming up in a week! Let’s talk SQL Server! We are going to crash the VMvillage hang space on Tuesday, September 12 at 3pm local time to hold an open-ended SQL Server on VMware Q&A session. This unscripted and unofficial session is for you, has no official agenda, and marketing is strictly off-limits.
Our illustrious experts include:
Michael Corey, Founder – Corey and Associates
Thomas LaRock, Head Geek – Solarwinds
Argenis Fernandez, Principal Architect – Pure Storage
Niran Even Chen, Double VCDX, VMware Corp.
… and me!
Mark your calendars, and bring your questions, specific challenges, or discussion points, and let’s do this! Anything goes – performance, availability, setup and configuration, conflicts between best practices for SQL Server and VMware, anything!
Heraflux is proud to announce that I am teaching a preconference training session at this year’s upcoming SQL Saturday in Chicago. The training class is entitled “The Complete Primer to SQL Server Infrastructure and Cloud” and is to be held on Friday, March 10th, at the DeVry University Campus in Addison, IL. This course has been updated to include key concepts about SQL Server in the cloud, including the similarities, differences, and performance characteristics.
Session Details: Microsoft MVP and VMware vExpert David Klee leads this full-day introduction to getting the most out of the infrastructure underneath your SQL Server environment, whether on-premises or in the cloud. The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with function and purpose of each layer of the architecture around their databases, and how this knowledge can benefit them as data professionals. Participants will gain exposure to all layers of infrastructure, virtualization, and cloud underneath SQL Server, from storage all the way through to the SQL Server instance and database, and will learn how to review and engineer the entire stack with a strong emphasis on SQL Server performance.
I am proud to announce the availability of our new training offerings! We are launching a live web-based version of our one-day SQL Server infrastructure and virtualization master class. We are hosting an all-day training session before the end of the year to help you take advantage of quiet(er) times around the holidays. Select from one of the dates that works best for you and register today!
Looking to ramp up on the infrastructure and virtualization underneath your databases? Want to learn how to work effectively with the other silos in your IT organization? This live web-based training will help take you to the next level by understanding the architecture, performance characteristics, and performance tuning opportunities of the storage, physical server hardware, virtualization hypervisor, and VM layers underneath your critical SQL Server databases.
Microsoft MVP and VMware vExpert David Klee leads this full-day introduction to getting the most out of the infrastructure underneath your SQL Server environment. The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with function and purpose of each layer of the architecture around their databases, and how this knowledge can benefit them as data professionals. Participants will gain exposure to all layers of infrastructure and virtualization underneath SQL Server, from storage all the way through to the SQL Server instance, and will learn how to review and engineer the entire stack with a strong emphasis on SQL Server performance.
The intended audience of this course is information workers (both business and IT-centric) involved with architecting an enterprise IT strategy for SQL Server.
The following topics will be addressed during the course:
- Datacenter Fundamentals
- Infrastructure Stack Fundamentals
- Storage and SAN Concepts and Design
- Networking and Interconnect Topologies
- Physical Server Technologies
- The SQL Server Virtual Machine
- High Availability and Disaster Recovery
- Performance Investigation and Tuning of the Entire Stack
Upon completion of this course, attendees will be able to:
- Understand key infrastructure concepts
- Determine the optimal infrastructure configuration for best performance
- Review their own enterprise infrastructure for performance bottlenecks
- 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 infrastructure-related SQL Server performance killers
- Understand proper capacity management techniques for long term management
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 SQL Server and the infrastructure underneath in their own environments.
Seats are limited in this training offering, so register now!
I’m extremely honored to be named Microsoft Data Platform MVP for the third year in a row! I thank the technical community that allows me to speak on topics that I am truly passionate about. A community award like this is never an expectation or an entitlement, and is never an assumption in my book. I’m humbled to say the least. As always, I’m going to continue to do what I do – spread knowledge around the convergence of infrastructure and SQL Server to help people make their data more available and perform better – and hope that I’m making a difference!
Thank you Microsoft!
If it were not for the SQL Server community, I would not be where I am at with my career today. Period.
Some of you know me personally but a lot do not. I come from a hard-working family of teachers and educators. We’ve had our struggles over the years, just like any other family, but we always push hard (sometimes to a fault) to try to make our dreams a reality.
Ever since I was in grade school, I knew I was a geek. I got my first computer when I was five, and built my first computer for my parents when I was nine. I was building networks when I was in middle school. I loved technology but always got a thrill out of being able to put it to use to solve problems. But, there’s the conundrum that was always in the back of my head. When you are a technologist, how can you cross that chasm into the business world?
About eight years ago I discovered the SQL Server community through the very first Omaha SQL Server Users Group meeting that John Morehouse (t | b | l), a great friend of mine, first launched. It was an incredible experience, and because of the fantastic sense of community that the first meeting brought me, I decided to become the best SQL Server professional that I could be. I really enjoyed the technology, but the community was the biggest factor. The community accepted me for the person that I am in ways that non-techie groups wouldn’t understand.
Somewhere around this time I had a few jobs that were up and down and kept me on the tech side. I wanted more ability to make a positive difference on business and people. But how? How can a tech make any sort of impact? Making the impact helps to cross the bridge. Fortunately, the community helped to steer me along the right path.
About three years ago I decided that it is time to start giving back, and struggled to find the avenues to do so. I never thought I would enjoy it until I played a bit part to help coordinate the first SQL Saturday in Nebraska back in 2010. I had always been the person to quietly get the job done but never one to be in front of people. I think the teacher part of my upbringing came out for the first time with my SQL Saturday session at that first event. I found that giving back helped me feel more complete. Giving back helped me feel like I could make a difference. And it grew from there…
My commitment to the SQL Server and other technical communities that I am a part of is simple. You helped originally steer me in this direction. You helped mentor and guide me over the years. You supported me when I launched my own consulting company in ways that continue to astound and amaze me. I want to give you everything that I can in return. I want to help others any way that I can.
Today I am honored and humbled to be awarded the Microsoft Most Valuable Professional (MVP) award for my efforts in the SQL Server community over the years. To have Microsoft acknowledge the work that I have done is incredible and amazing and very much appreciated, but the impact to the communities and people, and the friends that I have made for life as a result, is the best reward.
#SQLFamily – This award is for you, because of you. As my friend Argenis Fernandez wrote so eloquently a few days ago, now the real work begins for those of us who were selected for this award, past and present. But it does not have to just be me or the other folks who are visible in the community today. Speak at community events. Blog. Tweet. Nominate anyone you know that is an unsung hero in this community for MVP. Continue to grow the community participation and give back. You never know how fulfilling that it can be unless you give it a shot!