Welcome to SQLSaturday #151
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Sep 29 2012 at Seminole State College, Main Campus, 100 Weldon Boulevard Bld, University Partnership Building, Sanford, FL 32773. Admittance to this event is free, but we do charge a lunch fee of 10.00 so that we can provide a lunch - not pizza! Please register soon as seating is limited, and let friends and colleagues know about the event.
Stacia Misner - A 360-Degree View of SQL Server 2012 Business Intelligence
In this session, we’ll take a holistic look at the BI features in the latest version of SQL Server by reviewing the architecture requirements, exploring the implications for existing BI applications, and introducing new capabilities that support the transformation of data into business insight. We'll start with data integration and management by reviewing the overhaul that Integration Services received in this release, how to formalize the data cleansing process by using the new Data Quality Services, and how master data management is improved with the updates to Master Data Services. Then we'll discuss the improvements to analytical capabilities by exploring updates to Analysis Services, including the new Tabular Model, and enhancements available in PowerPivot. Last, we'll cover the new presentation layer options available in Reporting Services and the new release of Power View. Of course, you’ll see demonstrations of the new features, but the primary purpose of this session is to give you a chance to ask lots of questions and to get a look “under the hood” to better understand what you’ll need to do to get these BI features up and running properly. You’ll also learn how to prepare your data environment to leverage these features and how best to manage the user experience.
Stacia Misner is a consultant, educator, mentor, and author specializing in Business Intelligence solutions since 1999. With more than 25 years of experience in IT, she is the author or co-author of twelve books about BI. Her most recent book is Introducing Microsoft SQL Server 2012 and she is working on Microsoft SQL Server 2012 Reporting Services to be released in summer of 2012. Stacia provides consulting and custom education services through Data Inspirations, writes about her experiences with BI at blog.datainspirations.com, and tweets as @StaciaMisner.
Kevin Kline - Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2
This full day seminar will teach you introductory, intermediate and advanced techniques for troubleshooting and performance tuning using SQL Server's built-in Dynamic Management Views (DMVs), Performance Monitor, Profiler, Wait Stats, and Extended Events. In troubleshooting, you’ll learn how to detect, diagnose, and resolve problems on SQL Server using the native tools, as well as how to determine where SQL Server is experiencing bottlenecks that prevent it from achieving optimal performance. Bring your laptop with SQL Server 2008 R2 and AdventureWorks R2 to work through the labs as Kevin demonstrates various techniques. (SQL Server 2005 is also allowable, but you will not be able to demo those that are specific to SQL Server 2008 R2).
Kevin Kline is a renowned database expert and software industry veteran. A long-time Microsoft SQL Server MVP and noted leader in the IT industry, Kevin is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a top-rated speaker at industry trade shows worldwide. He tweets at @kekline and blogs at KevinEKline.com