SQLSaturday Madison #287 Pre-Cons Registration Now Open
Posted by denglishbi on February 13, 2014
Just announced this week, there will be three amazing pre-con events on Friday, March 28 at the SQLSaturday event in Madison. Registration is now open and seating is limited, so sign up while you still have the opportunity.
The pre-con events are an all-day event with a small group, lunch is provided, and there is a nominal fee of $100. These pre-con events are a great way to really dive into a particular area and have a really up-and-close interactive experience with the instructors and fellow classmates. I will be doing a self-service Power BI course that will cover Power Pivot, Power Query, Power View, and Power Maps all using Excel, very powerful and cool:)
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:
- Understand key virtualization and cloud concepts
- Determine the optimal infrastructure configuration for best performance
- 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 virtualized SQL Server performance killers
- Understand proper virtualized 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 prospective reference in working with virtualized SQL Server in their own environments.
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:
- The life cycle of a transaction
- Preventing bad T-SQL coding practices
- Reading an Execution Plan
- Plan Cache and Monitoring
- Execution Plan Tuning
- Capturing bad execution plans that need to be tuned
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!
Don’t delay, to secure your spot register now!