SQLSaturday #99 - Minnesota 2011 11/11/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat99 Grace Church Eden Prairie 9301 Eden Prairie Road Eden Prairie MN 55347 http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 1574 Quest Software You Rock! [max 3] http://www.quest.com http://www.quest.com/images/common/quest_logo.gif 60 170 1645 HP-Microsoft Alliance You Rock! [max 3] http://www.microsoft.com/enterprise/partners/hp.aspx http://minnesota.sqlpass.org/Portals/70/1_2_MS-Frontline-Partnership_2010.jpg 60 170 1407 Digineer, Inc. Breakfast Sponsor [max 1] http://www.digineer.com http://minnesota.sqlpass.org/Portals/70/SponsorImg/logo1_fullcolor_rgb_web.jpg 60 170 1427 Emergent Networks Gold Sponsor http://www.emergentnetworks.com http://minnesota.sqlpass.org/Portals/70/SponsorImg/EN_logo_small.jpg 60 170 1455 Virteva Gold Sponsor http://www.virteva.com http://minnesota.sqlpass.org/Portals/70/SponsorImg/Virteva_lrg.gif 60 170 1474 Idera Gold Sponsor http://www.idera.com http://www.idera.com/images/promos/Idera_60.jpg 60 170 1493 RBA Consulting Gold Sponsor http://www.rbaconsulting.com http://www.rbaconsulting.com/PublishingImages/RBALogo-clear400.gif 60 170 1547 GNet Group Gold Sponsor http://www.gnetgroup.com http://www.gnetgroup.com/gfx/header/gnetlogo170_104.png 60 170 1611 Fusion-io Gold Sponsor http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 1626 Superior Consulting Services Gold Sponsor http://www.teamscs.com http://minnesota.sqlpass.org/Portals/70/SponsorImg/scslogo_sharp.jpg 60 170 1639 Data Education Gold Sponsor http://dataeducation.com http://dataeducation.com/wp-content/uploads/2011/10/170x601.jpg 60 170 1434 Magenic Silver Sponsor http://magenic.com http://minnesota.sqlpass.org/Portals/70/SponsorImg/magenic_custom_solutions_2.png 60 170 1551 Nimble Storage Silver Sponsor http://www.nimblestorage.com http://minnesota.sqlpass.org/Portals/70/SponsorImg/nimble_logo_300.png 60 170 1578 Intertech Silver Sponsor http://www.Intertech.com http://www.intertech.com/images/logoheader.gif 60 170 1579 Solution Design Group Silver Sponsor http://www.solutiondesign.com http://minnesota.sqlpass.org/Portals/70/SponsorImg/SolutionDesign_Logo.JPG 60 170 1603 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 1487 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 1542 SSWUG.ORG Bronze Sponsor http://www.sswug.org http://www.sswug.org/editorial_images/SSWUG_LOGO_CLEAR.jpg 60 170 1577 O'Reilly Media, Inc. Bronze Sponsor http://ug.oreilly.com http://minnesota.sqlpass.org/Portals/70/SponsorImg/oreilly_logo_plain.gif 60 170 1646 Wiley Publishing Bronze Sponsor. http://www.wrox.com http://a2.twimg.com/profile_images/1352261395/New_WROX_Logo_RGB.jpg 40 100 1450 Lohn Solutions Blog Sponsor http://www.sqlfeatherandquill.com/ http://www.sqlfeatherandquill.com/wp-content/themes/atahualpa/images/SQLFAQ.jpg 40 100 1614 Blackdog Innovative Solutions, Inc. 50-Lunch Sponsor http://www.blackdogis.com http://minnesota.sqlpass.org/Portals/70/SponsorImg/BlackdogISLogo.png 60 170 5322 William E. Pearson III BI-2 M210 The Data Analysis Expressions (DAX) language is a library of operators and constants that we can combine to craft formulas and expressions in PowerPivot Client. In this introductory session Microsoft BI Architect and SQL Server MVP Bill Pearson will concentrate upon crafting simple DAX expressions whose purposes, for the most part, are to return a set of data. He’ll overview a simple data source structure, outline the components of simple DAX syntax, and get you started understanding basic expressions. 11/11/2011 3:30:00 PM 11/11/2011 4:45:00 PM 5326 William E. Pearson III Prof Develop M215 Independent BI consultant, MSSQL Server MVP, and practicing CPA Bill Pearson examines the various options available for organizing and protecting your consulting business. In this section, he covers C Corp, S Corp, LLC, Partnership, and Sole Proprietorship (“Schedule C”) options, as well as other practical advice (trademarks, etc.) useful in forming your business entity. 11/11/2011 2:00:00 PM 11/11/2011 3:15:00 PM 5381 Mike Benkovich DEV-2 M213 Working with data is core to what we do as developers. With the release of the Microsoft SQL Azure Database cloud offering, developers have a new set of options and features that make it possible to take full advantage of the scalability and availability of this platform. In this webcast, we take a look at what SQL Azure means for developers and show how to create and manage a database in the cloud. We also explore the tools and the practices for using the tools. 11/11/2011 8:15:00 AM 11/11/2011 9:30:00 AM 5398 Ross McNeely BI-1 M209 Processing large cubes can consume vast amounts of IO, and create lengthy response times. This presentation will demo how to process dimensions and dynamically create, process, and delete measure group partitions to minimize IO. By taking control of cube processing through a SSIS package you are able to process only the bare minimum in order to bring a cube current while keeping response times acceptable. Additional areas to cover will include the support tables to control cubes, and a review of the XMLA for creating, processing, and deleting. 11/11/2011 8:15:00 AM 11/11/2011 9:30:00 AM 5484 Janis Griffin DBA-1 M211 More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment. 11/11/2011 3:30:00 PM 11/11/2011 4:45:00 PM 5485 Janis Griffin DEV-2 M213 Service Broker can be used to simplify messaging between applications and assist in asynchronous programming by queuing messages and/or events. This presentation will explain how to use the Service Broker services, discuss its many components and show why you’ll benefit from using it. Several case studies will illustrate an elegant way to maintain data across multiple servers and show how to reduce dependencies between related programs and/or data structures. 11/11/2011 9:45:00 AM 11/11/2011 11:00:00 AM 5541 Ted Krueger DBA-2 M212 How many times have you been sitting in a meeting and you hear, “We want all our users to have access to the data, 24/7. That includes when they are offline and on a client location”. At this point you may start letting out a large sigh because you are thinking, “How could the user get to the data if there is no connection?” This isn’t as hard as you may think and this session will show how to use SQL Servers Merge Replication in order to accomplish the task. Merge replication offers a scalable option for data mobility. This session will go over how Merge Replication can be used to replicate data to users that spend many hours offline. 11/11/2011 2:00:00 PM 11/11/2011 3:15:00 PM 5566 Tim Plas DBA-1 M211 A comparison of SQL HA DR options, by a practitioner who has implemented managed all the SQL HA and DR approaches ( various combinations thereof). Tim is an operational SQL DBA, who keeps SQL servers up running optimized for managed-services customers. We will compare trade-offs between the various SQL HA DR options: for complexity, usability, hardware, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc. And we’ll briefly cover some of the upcoming SQL Denali HA / DR features. 11/11/2011 9:45:00 AM 11/11/2011 11:00:00 AM 5569 Eric Zierdt DBA-1 M211 This session is geared for people who write SQL and have little to no experience with Execution Plans; we will go over how to read an execution plan, how to improve server performance based on the results and common things to watch out for. 11/11/2011 8:15:00 AM 11/11/2011 9:30:00 AM 5602 Robert Biddle DEV-1 M214 You've just been assigned a data warehouse project. Maybe you've figured out what tables you want to work with, but outside of that you don't really know how to get started. In this session you'll learn how to load a data warehouse using SSIS, as well as techniques that you can use for any platform. 11/11/2011 3:30:00 PM 11/11/2011 4:45:00 PM 5661 Bill Preachuk DBA-2 M212 Having consistent, regular, verified backups are only a starting point. When failures happen - and they will happen - can you recover your database? In this presentation we will dive into the mechanics of database restores and discuss how choices made previously in database/server/backup design can have profound effects on how ( what) you can recover. We will also discuss spectacular ways to fail miserably... all in the hopes of preventing those same failures in the future. 11/11/2011 3:30:00 PM 11/11/2011 4:45:00 PM 5681 Zach Mattson DBA-2 M212 It turns out there might be something better than the combination of beer and peanuts (at work anyway); using Powershell to gather Performance Monitor (perfmon) metrics! In this session we will tackle gathering all the perfmon counters, storing them and alerting when they reach a defined level. This will be a demo intensive session that will also use SQL and XML components of Powershell. Attendees will leave this session with ideas and examples that they can implement in their jobs immediately. A basic working knowledge of Powershell syntax and commandlets will be assumed. 11/11/2011 8:15:00 AM 11/11/2011 9:30:00 AM 5693 Natalie Wood BI-1 M209 Project Crescent is the new self-service BI tool that will ship with SQL Server Denali. This session will cover what you need to know to install, configure and secure your new Project Crescent environment. It will also provide an overview of the features of Project Crescent and demonstrations of it's powerful yet simple reporting capabilites. 11/11/2011 2:00:00 PM 11/11/2011 3:15:00 PM 5704 Dan Lewendowski, Aaron Bangasser BI-2 M210 Security is a vital part of any business intelligence solution. Unfortunately, creating a solution that presents users only with the information they should see can be a challenge. In this session we’ll look at how the various security pieces come together to make the solution work. We’ll cover configuring Kerberos for securing SSRS, SSAS, and SharePoint; Scripting permissions in SSAS using MDX, Active Directory groups, and SSIS; and finally, configuring SharePoint, PerformancePoint services, and Power Pivot services to access user’s data by passing Windows credentials and/or the use of data sources with execution accounts. 11/11/2011 12:30:00 PM 11/11/2011 1:45:00 PM 5705 Jin Cho BI-1 M209 The presentation will consist of slides to lay out the approach/strategy for Microsoft's single BI semantic model (BISM). Also, demonstration of the new capabilities in SQL Server Denali CTP3 for PowerPivot and BISM. 11/11/2011 12:30:00 PM 11/11/2011 1:45:00 PM 5725 Dan English BI-1 M209 This session will provide an overview of what PerformancePoint is, where it came from, and how do you get it. We will also discuss what’s changed in the 2010 release (including with the latest SP1 update). Along with this we will go over the Dashboard Designer tool showing you how to install it and explain what it is used for. Then hold on to your seats, I will build out and deploy a fully functional and interactive dashboard. Along the way I will provide insight from the trenches including tips and tricks along with experience from client deployments. 11/11/2011 3:30:00 PM 11/11/2011 4:45:00 PM 5796 Kirby Richter DBA-2 M212 Understand the basics of SQL Server locking including lock modes, lock granularity and lock escalation. Also what is blocking, why should you be concerned and what you can do about it. 11/11/2011 9:45:00 AM 11/11/2011 11:00:00 AM 5821 Hans Johnson DEV-2 M213 Speaker Hans Johnson will entertain and educate attendees with a lesson on how to set up a dynamic database connection for an external application to call the web report server and render a .pdf for read only viewing. Hans will also show how to set up the same report with multi-language capabilities based on the end users browser language setting. Prizes will be given away based on a few different criteria that Hans will make fun, thought provoking and participant centered. 11/11/2011 12:30:00 PM 11/11/2011 1:45:00 PM 5841 Steve Hughes DEV-1 M214 Unlike SSIS 2008, there are a number of developer improvements in SSIS Denali, beyond the rounded corners and new icons. This session will explore the changes and how they improve the developer experience. 11/11/2011 8:15:00 AM 11/11/2011 9:30:00 AM 5842 Jason Strate DEV-2 M213 The upcoming release of SQL Server is full of new features to help everyone from DBAs to developers. In this session, we'll examine some of the new features that are being added to the T-SQL language. From error handling to windowing functions, we'll look at the new flexibility and power available within the T-SQL language. 11/11/2011 3:30:00 PM 11/11/2011 4:45:00 PM 5843 Jason Strate Prof Develop M215 Microsoft has a number of certifications for SQL Server. They cover the DBA, developer and business intelligence skills. But, does anyone take them seriously? In this session, see the tracks for SQL Server certifications and discover what you need to know about the exams. Which track will be right for you? What steps should you take? How do you get going? And what value will they bring to your career? 11/11/2011 12:30:00 PM 11/11/2011 1:45:00 PM 5849 Andy Lohn DEV-1 M214 This session will demonstrate tips and tricks that will help you complete tasks fast and efficient using TSQL. This session is targeted at TSQL beginners to SQL Server experts looking to add to their TSQL bag of tricks. The focus of this session will be on leveraging builtin functions, scripts to create scripts, troubleshooting procedures and other uses. 11/11/2011 12:30:00 PM 11/11/2011 1:45:00 PM 5870 Peter Kral DEV-1 M214 In this session, you will be introduced to some simple PowerShell techniques, and see how to combine them to create an event-driven listener job running in SQL Server Agent service. Designed to be accessible to database administrators and database developers, you will see how easy it is to create useful scripts in PowerShell. 11/11/2011 2:00:00 PM 11/11/2011 3:15:00 PM 5879 Rowland Gosling DBA-1 M211 This discussion will be about storage design and how it affects SQL Server's performance. Topic will include Solid State Drives (SSDs), SAN and Direct Attached Storage (DAS) and how the perform using RAID 5,RAID 6 and RAID 10. We will also cover File Groups, Files and entry level Table Partitioning. 11/11/2011 2:00:00 PM 11/11/2011 3:15:00 PM 5881 Gus Siefker DBA-1 M211 Improving Response Times, Reduce Workload, Enhance Reliability, and Save Money with IOMemory Solutions• Improve performance and scalability• Provide High Availability• Empower data warehouses• Improve ROI 11/11/2011 12:30:00 PM 11/11/2011 1:45:00 PM 5885 Jeff Krebsbach DEV-1 M214 With SSRS we can quickly generate reports that can be exported to multiple formats. What happens when you want to extend your report with custom code? Perhaps you need a custom authentication layer, custom access to data requiring .Net code, or you want to extend some of the controls that come out of the box with SSRS. In this session we will see an example of extending SSRS to use a .Net library for a data provider allowing us to use a custom .Net business layer for our report. We will also show an example extension to the SSRS graph control allowing us to make design graphs for SSRS. Custom code is a great alternative for those considering using toolkits like Nevron or Dundas toolkits to extend their SSRS graphing capabilities 11/11/2011 9:45:00 AM 11/11/2011 11:00:00 AM 5889 Greg Beaumont BI-2 M210 In recent years, governments throughout the world have made large volumes of data available for public use. Vast data with detailed insights into verticals such as healthcare, census, weather, natural resources, land use, financial markets, and economics are available to be extracted, transformed, joined and unleashed. In this session PowerPivot will be used to tie data together for analysis. Examples include uniting commodity prices with weather patterns, integrating free healthcare data with economic data, and integrating US economic data with that of other countries. 11/11/2011 2:00:00 PM 11/11/2011 3:15:00 PM 5895 Brian Larson Prof Develop M215 This session will explore the many and varied uses of the map report item in Reporting Services. From providing geographic analytics to diagramming locations on a warehouse floorplan, the map report item – when combined with SQL Server spatial data types - can be used in a variety of ways to create spatial representations of your data. We may even look at a game or two created using the map report item. 11/11/2011 3:30:00 PM 11/11/2011 4:45:00 PM 5896 Brian Larson BI-1 M209 Data mining provides a powerful tool for predictive analysis. These capabilities are available free as part of your SQL Server license. Unlock this powerful analytical tool to assist with decision making, cross-selling, and data analysis, and other areas within your organization. 11/11/2011 9:45:00 AM 11/11/2011 11:00:00 AM 5909 Neelesh Raheja BI-2 M210 This session is a primer to understanding the differences and advantages between Analysis Services and PowerPivot; which scenarios to use analysis services vs. PowerPivot and how both serve to provide a perfect BI platform addressing short term vs. long term BI needs of organizations. We will focus on the differences between the two storage methods that are available for creating a BI Semantic Model, OLAP and Tabular, including a deep-dive into comparing Analysis Services vs. PowerPivot on topics such as security, hierarchies, KPIs and scalability. Understand when you should use PowerPivot in comparison with SQL Services Analysis Services (OLAP) so you are equipped to create robust Self Service BI applications in your organization. 11/11/2011 8:15:00 AM 11/11/2011 9:30:00 AM 5918 Marc Beacom DEV-2 M213 Just getting started with SQL Server Integration Services (SSIS)? Not sure where to start? Or have you been using SSIS for a little while now and are still trying to figure out the basics. The biggest barrier to learning something new is figuring out the first few steps. We will discuss what SSIS is and a few lessons learned. 11/11/2011 2:00:00 PM 11/11/2011 3:15:00 PM 5919 Marc Beacom BI-2 M210 Just starting or thinking of starting a data warehousing project but not sure where to begin. Or still not sure if your organization needs a data warehouse. This discussion is geared towards answering the what and why (or why not) of data warehousing. 11/11/2011 9:45:00 AM 11/11/2011 11:00:00 AM 5932 . . BI-2 M210 Box lunches, in commons area. 11/11/2011 11:00:00 AM 11/11/2011 12:30:00 PM 5933 SQL Saturday # 99 Committee BI-1 M209 Gather in commons area for raffle drawings and prizes. Must be present to win. 11/11/2011 4:45:00 PM 11/11/2011 5:15:00 PM 5935 (Panel) . Prof Develop M215 Everyone has heard that the number of women in technology is declining. How can all of us, women and men, encourage more young women to consider a career in technology? Join our dynamic Women in Technology panelists Nicole Roepke, Amanda Bates, and Barb Rokke, to discuss this important and hot topic. Attendees are encouraged to ask questions, make suggestions, and share their experiences as well. (Session moderator: Tim Plas) 11/11/2011 8:15:00 AM 11/11/2011 9:30:00 AM 6002 Jason Horner DBA-2 M212 This presentation will provide a brief overview of how to get started with powershell and will be demo intensive. Demo topics will include common challenges that database professionals face including: basic code generation, deployment automation, and database discovery. We will also attempt to touch on automation and general script development best practices. 11/11/2011 12:30:00 PM 11/11/2011 1:45:00 PM 6107 (Panel) . Prof Develop M215 This session will be an open discussion on the various types of community involvement such as user groups, professional organizations, and events along with social networking such as Twitter and blogs. We will discuss how to get started, usage etiquette, and career impact related to these topics. Plan on a lively discussion. Panelists are: Andy Lohn, Dan English, Jason Strate, and Steve Hughes. (Moderator: Ted Krueger) 11/11/2011 9:45:00 AM 11/11/2011 11:00:00 AM 6108 Ajay Nangia DBA-1 M211 . 11/11/2011 11:00:00 AM 11/11/2011 12:30:00 PM 6109 Trent Mera BI-1 M209 Why creating SQL Server performance baselines is important. Methods and approaches for baselining. How you can make use of baselines. Tools and applications that can help. 11/11/2011 11:00:00 AM 11/11/2011 12:30:00 PM