Jan 162017
 

UPDATE: The SQL Saturday in Chicago this year has hit peak capacity two months before the event! However, if you enroll in one of the precons, and hopefully my “The Complete Primer to SQL Server Infrastructure and Cloud” session, email the SQL Saturday coordinators with your EventBrite receipt and your admittance will be guaranteed!

This event 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.

Registration is now open here, and seats are limited! Register today!

Oct 312016
 

pass_2016_websiteLast week I had one of the best experiences of my career – attending this year’s PASS Summit in Seattle. I felt like this event came up suddenly, as this last year has been a blur with the move to Maine, working and expanding our business, learning new things, and traveling all over the place. But… last week was both intense and calming at the same time, all while time felt like it stood still during this #sqlfamily reunion.

20161025_081313I was lucky enough to present three sessions to packed rooms. The first was an all-day precon on SQL Server virtualization, and we went until 6pm with questions! I learn so much from you all every time I present a precon, and hope I get selected for another precon next year!

I also presented a general session on SQL Server virtualization to a packed room of die-hards who stayed to the last session of Wednesday to hear the content. Thank you all for staying late, and we went almost two hours into the evening answering questions!

actual-virtual

I also sat on a panel session on Thursday with Denny Cherry, Joey D’Antoni, and Geoff Hiten called PASS the Bacon, all sponsored by SIOS and SanDisk.

pass-the-bacon-breakfast-01

Finally, Argenis Fernandez and Lou Lydiksen from Pure Storage and I presented a session on storage benchmarking on Friday. We had a blast talking to folks about how synthetic tools are not what they are cracked up to be, and how real world workloads can do a much better job showing you what your storage underneath your SQL Servers can truly handle.

The networking and comradery does not have to end when the last session wraps up either. I put out a few tweets inviting folks to the Seattle Underground for a 6pm tour, and we ended up with over 50 people! The 6pm tour was sold out by the time the bulk of people arrived, but we were all able to squeeze into this tour and the one at 7pm. We had a great time touring the underground locations and learning more about the history of this attraction.

20161028_184107

Remember to keep your Friday night free if you’re staying over until Saturday, as I try to gather informal fun activities at this time each conference.

I will always attend this conference, no matter if I’m presenting or just attending. If you are a SQL Server professional, you should make it mandatory to attend. Take the time to network, get to know people, strike up conversations with random passersby, and learn!

PASS, as always, this was the best PASS Summit ever! Keep up the great work!

20161027_170749

 Posted by at 8:59 pm
Oct 202016
 

I am pleased to announce that we are launching our next round of all-day precon training session at the upcoming SQL Saturday in Washington DC on Friday, December 2 called ‘The Complete Primer to SQL Server Infrastructure‘.

The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with the concept and purposes 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 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

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.

We are really happy to be delivering this precon training session, and are looking forward to seeing you all there! Reserve your seat at this exciting event here. Tickets are available at just $175!

Oct 172016
 

lisa16_button_neat_180I am proud to present that Deji Akomolafe from VMware Corporation, Cody Chapman from our team at Heraflux, and I will be presenting at this year’s USENIX LISA16 conference in Boston, MA, from December 4-9th!

The three of us are presenting a half-day workshop entitled “Designing Your VMware Virtual Infrastructure for Optimal Performance, Resilience and Availability – Straight from the Source” from 1:30p – 5:00p on Monday, December 5th.

akomolafe_deji_100x115  chapman_cody_100x115  klee_david_100x115

Continue reading »

Oct 102016
 

pass_2016_websiteI’m very honored to be speaking at the PASS Global Summit again this year in Seattle during the week of October 24th.I have a special discount code for you if you have not already registered for this outstanding conference. Please use the discount code PRE250DK for $250 off of the full three-day conference registration with a pre-conference training session. This discount code expires at midnight on Thursday, October 13th, so act fast!

I’m presenting two sessions on my favorite topic – the convergence of infrastructure and data.

The first is an all-day preconference training session on Tuesday, October 25th, entitled “The Complete Primer to SQL Server Virtualization“.

Abstract: Your SQL Servers are probably virtualized at this point, but do you feel you have lost that control over the infrastructure that you used to have when they were physical servers? Do the virtual SQL Servers “feel” slower after they were virtualized? When architected and managed with SQL Server in mind, this added layer will help improve the SQL Server’s availability and ability to change with the business, but only when executed properly.

The second general session is a rapid-fire deep-dive on the virtualization topic for those that cannot make the precon session, entitled “Virtual SQL Servers. Actual Performance.

Abstract: Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance.

This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so 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.

I really hope each and every one of you can make it to this conference. I’ve said it before, and I will undoubtedly say it again, that this conference is the best SQL Server conference of the year, and speaker or not, I will always make time to attend this event. The speaker lineup is amazing, and the education is world class. I cannot wait until then!

Sep 192016
 

pass_chapterI will be presenting a technical session entitled ‘Virtual SQL Servers. Actual Performance‘ tomorrow evening for the Suburban Chicago SQL Server Users Group. Doors open at 5:30pm and the session starts at 6:00pm!

Abstract: Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance. This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so 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.

pureOur friends at Pure Storage are sponsoring this event as well, so if you have any infrastructure administrators that have questions about some of the fastest storage on the planet, or want to know infrastructure questions related to SQL Server virtualization, make sure to invite them!

Bring your questions, as I can go on all evening until all of your questions are answered! RSVP for this event here.