This year for the first time not only is the Minnesota SQL Saturday on a Saturday, but we are also going to have pre-con events the day before!
Pre-con events are all day long events limited to 20 people for each session and they cost $99. There will be four pre-cons, two database and two business intelligence related. If you register for a pre-con you will receive your lunch for the SQL Saturday event for free. If you have already paid you will be refunded your $10 charge.
BI1 – Dan English & Brian Larson: Unlocking Insight – Be A Data Hero
Today, gaining insight from an organization’s data is not a luxury, but a necessity – no matter what that organization’s size and specialty. This all-day pre-conference session will equip DBAs, developers, and BI professionals alike to utilize the powerful data analysis arsenal offered by Microsoft. Together we will learn to use tools such as PowerPivot, Power View, Reporting Services, and the Tabular BI Semantic model in an agile approach that minimizes time to insight and maximizes return on investment. Along the way we’ll explore methods to empower subject matter experts making them partners in this pursuit.
By the end of the day you’ll discover that you don’t need to be a full-time BI specialist to be your organization’s Data Hero!
BI2 – Steve Hughes: Exploring Analytic Data Storage Options On SQL Server
With the release of PowerPivot and SQL Server 2012, Microsoft expanded their analytic data storage options. Now with in-memory database support in SQL Server 2012, three analytic storage options exist. This preconference session will explore all three – SQL Server Analysis Services Multidimensional Model, SQL Server Analysis Services Tabular Model, and SQL Server PowerPivot. In each case, you will learn about design considerations, system impact, performance tuning and data visualization usage within each storage choice. As part of the session, we will do a quick build with each tool to understand the development differences as well. Armed with this information, we will compare the platforms and make the case for using each of the options in your environment. Whether you are new to Analysis Services or have worked extensively with it, this is a great opportunity to learn about the new choices and how they will impact your environment, both from a capability and maintenance perspective.
DB1 – Ted Krueger: Make Me A Tuning Believer
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? Did you go to a class, training, or past session and find yourself lost in the mix of execution plan operations and indexing and scans?
Start over. 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 that revolve around what you will see most commonly in an everyday database shop, 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
DB2 – Jason Strate: Indexing For Performance
This pre-con is a full day session that looks at indexing from the basics down to the internals. With guidance on how to collect statistics on indexes and use that information to drive changes to indexing.
Indexing is an important aspect of maintaining an well-performing database. Without the proper indexes, database will not perform to their potential and users will inevitable help you share their pain. In this session, we’ll take a deep dive into indexes and how they work within the database. We’ll look at the indexes types available to the statistics collected on the indexes. From there, we’ll dig deeper into the internals, maintenance, and tools available for indexing your databases. The session concludes with a walk through of a process for collecting index statistics and using them to validate the indexes in place and drive changes that are needed.
Sessions BI1 and DB2 will be held at Benchmark Learning in Edina. Sessions BI2 and DB1 will be held at the Doubletree by Hilton, Bloomington.
Please direct any questions regarding the pre-cons to the SQL Saturday #149 team at firstname.lastname@example.org