IEVLT: Immersion Event on Very Large Tables: Optimizing Performance and Availability through Partitioning

Live Online: January 9-11, 2018


Overview

Very large tables are large because they’re holding data that’s not only current but historical. Companies are keeping more data around longer and wanting to better evaluate that data for trends over time. These larger-and-larger data sets become difficult to deal with as there are many distinct and often conflicting access patterns, from the critical “hot” data needing to be inserted, to the somewhat recent “read-mostly” data that’s still fairly active, to the older data that’s rarely used but still needed. All of this is “sales” data and it seems appropriate to have it stored in our “sales” table – but how do we do this efficiently and effectively so that modifications do not affect queries and queries do not affect modifications. Worse yet, maintenance is needed for the volatile data but not the older / static data so how can we do this on our large tables when really only a small portion of the table needs maintenance.

But, it’s really a lot more than this. There have long been features (partitioned tables since SQL Server 2005, and partitioned views since SQL Server 7.0) that tackle various aspects of the “VLT” problem but each feature has problems in and of itself. What this class does is directly address all of the problems to show you a realistic and powerful architecture that gives you the best of all worlds: scalability, maintainability, and high-availability.

This class is delivered live via online streaming.

Instructor: Kimberly L. Tripp

For a detailed agenda click HERE.

If you need help justifying training to your organization, we can help you:

Select Quotes From Past Attendees of Kimberly’s SQLskills Classes

  • “Amazing learning experience! Having followed SQLskills from afar while developing my SQL Server knowledge, it was eye-opening to learn from Paul and Kimberly in person.”
  • “In 20 years of database administration, best performance training I have ever had!”
  • “By far the most useful and educational training I have attended. Aside from the material covered, which was well organized, the discussions and Q&A information was great.”
  • “Lots of good material – I would love to take another course with SQLskills (I’d even get a lot of value from repeating this same course!)”
  • “Excellent course. I consider myself to be lucky to have attended course presented by the ‘best’ in the world. Not only you guys are extremely knowledgeable, but had the ability to break it down.”
  • “The difference of knowing how to cook in your own kitchen and then being taught how to be a chef in a 5-star restaurant.”
  • “Excellent. Mind blown. Can’t wait to take another SQLskills class.”
  • “Great course! Impressive scope and depth of knowledge, very well delivered with real-world examples and practical takeaways.”

Event details:

  • The class will be streamed live through three WebEx meetings and you will receive an email invitation to the WebEx meetings during the week before the class.
  • Class will be spread over three days, from Tuesday, January 9th, 2018 through Thursday, January 11th, 2018
  • Detailed agenda for each day (all times are in Pacific Standard Time)
    • 10am to 11:30am: morning session
    • 11:30am to 12pm: morning Q&A
    • 12pm to 12:30pm: break
    • 12:30pm to 2pm: afternoon session
    • 2pm to 3pm: afternoon Q&A
  • You will receive a PDF of the lecture content. Additionally, after the event ends, we will provide all possible demo content and any electronic whiteboard slides on our website as a zip file.
  • The class will be recorded and you will receive streaming access to the recordings for six months.
  • Class size is limited to 50 students.

Pricing Details:

  • Full price for this online Immersion Event is US$595.

Cancellation/Transfer policy:

  • Your class registration can only be canceled up to 1 calendar week before the day the class begins, and the cost will be refunded minus a US$50 administration fee (and 5% credit-card processing charges).
  • Registrations can be transferred to a colleague to attend the class, up to one day prior to the first WebEx meeting and at no cost, as long as we are notified of the new attendee’s name.
  • A no-show registration (the attendee does not attend the class) is not eligible for a transfer or refund.

Registration details:

Click HERE to go to our events registration page, and please make sure to select the correct class from the drop-down menu at the top of the page.

Questions?

If you have any questions, please contact us.