The next location for my ‘Virtualization for SQL Server DBAs’ SQL Saturday preconference training session is Friday, March 28th, in Madison, Wisconsin. If you are a SQL Server DBA or infrastructure administrator and wish to know how to properly and efficiently manage your mission-critical SQL Servers when virtualized, or want to know how to squeeze the most performance from your environment, this session is for you!
|VMware vExpert and SQL Server performance expert David Klee leads this full-day, hands-on introduction to enabling and managing a virtualized SQL Server environment. The focus of the course is to help those new to virtualization and/or infrastructure 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, and will learn how to construct the entire stack with the focus on SQL Server performance.
Upon completion of this course, attendees will be able to:
Attendees with the following experiences will benefit the most from this course:
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 prospective reference in working with virtualized SQL Server in their own environments.
For more details and to register for this session, please visit the SQL Saturday Madison home page!
Two other great preconference sessions are also being held on the same day!
|Are you an accidental DBA or developer that has been told to make a T-SQL query run faster? How many times have you heard complaints from the business about a report taking 5 minutes, 10 minutes, or longer to run? Have you found yourself lost in the mix of execution plan operations and indexing and scans?
Come to this class to build your query and execution plan tuning skills from beginning to end. We’ll focus on the everyday DBA’s and developer’s needs for tuning, and build up to more advanced methods which can be taken directly to work and bring immediate improvements in performance.
The workshop will show you skills and tools that revolve around what you will see most commonly in any business, such as:
You’ll also have plenty of time to ask your questions and get answers!
|Having the freedom and ability to easily explore and provide reporting and valuable insights within an organization has been a challenge for years. Well no more! The time to unlock and open up the doors to information is now. In this all-day pre-conference you will see that with the use of Excel you can be empowered to easily load and relate data, build business logic and calculations, enrich data with additional sources, and build highly visual and compelling reports.
We will explore Excel, Power Query, Power Pivot, Power View, and Power Maps and show you how you can maximize the investment in the tools that Microsoft has provided. By the end of the day you will see how you will no longer be held back to waiting for a report request or being able to not ask the questions you have wanted to, take the next step and see what powers await you with Excel and unleash your data!
I want to go to both of these precons but will be busy with my own. I hope you can attend one of these sessions. These are world class training sessions at an incredible price. Even if you cannot lend your Friday for a precon, do not miss the free SQL Saturday event! Register for it here, and I cannot wait to see you there!