SQLSaturday #175 - Fargo 20134/27/2013 12:00:00 AM(GMT-06:00) Central Time (US and Canada)SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat175Microsoft Executive Briefing Center Fargo4550 42nd Street SouthFargoND581043247Microsoft Fargohttp://www.microsoft.com/ebc/fargo.mspxhttp://www.jasonstrate.com/images/ms-Fargo_bL.PNG601702901Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/confio_logo.jpg601702763PASS Headquartershttp://www.sqlpass.orghttp://www.sqlsaturday.com/images/pass_logo_partner_bw.jpg601703246PASSMN (Minnesota SQL Server User Group)http://minnesota.sqlpass.org/http://minnesota.sqlpass.org/Portals/70/logo.gif601703278Nimble Storagehttp://www.nimblestorage.comhttp://info.nimblestorage.com/rs/nimblestorage/images/Nimble_Logo_150.jpg601703314Tegile Systemshttp://www.tegile.comhttp://jasonstrate.com/images/Teglie-Logo-Blue-White-Background.jpg601703396SIOS Technology Corp.http://us.sios.comhttp://ftp.us.sios.com/dgallagher/images/SIOS_logo_170x60.jpg401003258Digineer, Inc.http://www.digineer.comhttp://www.jasonstrate.com/images/digineer_logo1_fullcolor_rgb_web.jpg401002751StrateSQLhttp://www.jasonstrate.comhttp://www.jasonstrate.com/images/StrateSQLBanner.jpg401003228Red Gate http://red-gate.comhttp://www.red-gate.com/assets/images/common/logo.png401003254xsql Softwarehttp://www.xsql.com/http://www.xsql.com/images/xSQLSoftware.png401003255Pluralsighthttp://pluralsight.comhttp://s.pluralsight.com/mn/img/logo/pluralsight-fullcolor-175x39-v1.png401002827Steve Stedmanhttp://DatabaseHealth.SteveStedman.comhttp://stevestedman.com/wp-content/uploads/SteveStedman-Database-Health-Reports.png401003120Aaron Stanley Kinghttp://www.aaronstanleyking.comhttp://4.bp.blogspot.com/-93_zp7_4Cd0/TdJ1A5UaQWI/AAAAAAAAAGY/YewNZMA39-U/s1600/AaronStanleyKingBanner60.png4010011501Aaron KingAaron King is an application architect specializing in enterprise web applications and very large databases. He has helped several successful startups move to the software plus services model. He is currently working as an independant consultant on several long term engagements. Aaron is also a community leader and active in vNext, IndyNDA, and Indy PASS.@trendoidhttp://www.linkedin.com/in/trendoidhttp://www.aaronstanleyking.comhttps://api.twitter.com/1/users/profile_image?screen_name=@trendoid484811491David KleeDavid Klee (@kleegeek) is a SQL Server performance and virtualization expert. With over fifteen years of IT experience, David spends his days virtualizing mission critical SQL Servers as a Solutions Architect for House of Brick Technologies. His areas of expertise are virtualization and performance, datacenter architecture, software engineering, security, and business process analysis.@kleegeekhttp://www.linkedin.com/in/davidakleehttp://davidklee.nethttps://api.twitter.com/1/users/profile_image?screen_name=@kleegeek484812689Eric NessEric is a level 65 Data Slayer, who has worked with SQL Server for over 10 years, spending the past 7 as a DBA for real estate, marketing, application distribution, and medical device companies. Eric enjoys performance tuning, T-SQL programming, and SQL Server Administration.@EricZierdthttp://www.linkedin.com/in/ericzierdthttps://api.twitter.com/1/users/profile_image?screen_name=@EricZierdt484813168Jason HornerJason Horner has been working with SQL Server for over 10 years. He is currently focused on a large scale Spatial Data Warehouse project. He
holds MCITP Certifications in both Database Administration and Database Development.@Jason Hornerhttp://www.linkedin.com/in/jasonstratehttps://api.twitter.com/1/users/profile_image?screen_name=@Jason Horner484811415Jeff PromJeff Prom is a Senior Consultant with Magenic Technologies. He holds a bachelor’s degree, three SQL Server certifications, and is an active PASS member. Jeff has been working in the IT industry for over 14 years and currently specializes in business intelligence.http://www.linkedin.com/pub/jeff-prom/7/1b7/bb1https://api.twitter.com/1/users/profile_image?screen_name=484813462Jes BorlandJes Schultz Borland is a Consultant with Brent Ozar Unlimited and a Microsoft SQL Server MVP. She holds an AAS - Programmer/Analyst degree, and has worked with SQL Server since 2007, focusing on Reporting Services and day-to-day administration. She is an active member of PASS, President of FoxPASS, founder of Tech on Tap, and a LessThanDot.com blogger. She's a frequent presenter at user groups, SQL Saturdays, and other community events. She is also an avid runner and chef. @grrl_geekhttp://www.linkedin.com/pub/jes-borland/9/393/705https://api.twitter.com/1/users/profile_image?screen_name=@grrl_geek484812726Jim DorameI am currently the Database Systems Manager for a large scale educational assessment corporation. I have been working with technology for over 20 years and specifically with Microsoft SQL Server since version 6.5. I have decided to start giving back to the community that has provided me with so much information in the past. @DBAJDhttp://www.linkedin.com/profile/view?id=172603locale=en_UShttps://api.twitter.com/1/users/profile_image?screen_name=@DBAJD484812109Kathi KellenbergerKathi Kellenberger is a Sr. Consultant with Pragmatic Works. She enjoys speaking and writing about SQL Server having presented at many SQL Server events including the PASS Summit and has authored or co-authored four SQL Server books. In her free time, Kathi enjoys spending time with family and friends, especially her three grandchildren.@auntkathihttp://www.linkedin.com/in/kathikellenbergerhttp://www.bidn.com/blogs/kathikellenberger/https://api.twitter.com/1/users/profile_image?screen_name=@auntkathi484812043Michael DeFehrMichael DeFehr is an independent SQL Server consultant based in Winnipeg, Manitoba. His career has focused on database administration and development using Microsoft SQL Server. A SQL Server MVP, Professional Engineer and MCITP in both Database Development and Administration, Mike has spent the past 15 years producing and maintaining database solutions. Mike specializes in the relational and storage engines and his solutions emphasize performance and simplicity. @mdefehrhttp://ca.linkedin.com/in/mdefehrhttp://mikedefehr.comhttps://api.twitter.com/1/users/profile_image?screen_name=@mdefehr484813352Mike DonnellyMike works as a SQL Server consultant in the Twin Cities. He has been working with SQL Server for 13 years and holds the MCTS for Database Developer 2008 and MCITP Database Administrator 2008 certification. He is an avid runner and a wannabe gourmet chef.@SQLMDhttp://www.linkedin.com/in/melsar93 http://sqlmd.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLMD484813497Paul TimmermanPaul Timmerman is the lead SQL Server DBA at Hennepin County Medical Center in Minneapolis, Minnesota. Paul has over a decade of experience in database administration and is currently the Chapter Leader of the Minnesota SQL Server User Group, PASSMN.@mnDBAhttps://api.twitter.com/1/users/profile_image?screen_name=@mnDBA484812103Ross McNeelyRoss McNeely has presented at several SQL Saturday events in Minnesota, Wisconsin, and Iowa. Recently Ross presented at ERworld2012 on data modeling. Ross adds real-world examples from the Financial Services, Logistics, and Retail industries in his presentations. Regardless if you have a beginner, intermediate, or advance skill set Ross will provide a solid foundation in each of his presentation. Please join Ross McNeely for a fun and informative SQLSaturday.http://www.linkedin.com/in/rossmcneelyhttp://mcneelydwbi.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=484813869Scott ShawScott Shaw is the co-author of two T-SQL books through Apress publishing. He is a frequent speaker at community events and most recently spoke at the 2013 SQL PASS Summit. He is co-chair of the SQL PASS Virtual Chapter on Virtualization and teaches classes at both Washington University CAIT program and Saint Louis University. Scott lives in Saint Louis with his wife and 2 children. He is a Principal Consultant for Oakwood Systems Group.@shawsqlhttp://www.linkedin.com/in/scottpshawhttp://www.dbaexperience.comhttps://api.twitter.com/1/users/profile_image?screen_name=@shawsql484813894Steve HughesSteve Hughes is a Principal Consultant at Magenic. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored two books and delivered more than 30 presentations on SQL Server and data architecture over the past six years. @dataonwheelshttp://www.linkedin.com/in/way0utwesthttps://api.twitter.com/1/users/profile_image?screen_name=@dataonwheels484812897Terry BunioTerry started his career working with Adabas as a DBA., Over the next 20 years, Terry has worked with Oracle, Informix, Sybase, and Microsoft SQL Server as both a Data Modeler and DBA. Terry is a huge proponent of normalization and dimensional modeling.
Terry has implemented Operational Data Stores, Data Warehouses, and ETL solutions for Investors Group, LPL Financial, Manitoba Blue Cross, and others.
Terry has recently worked on integrating Agile practices into Database projects.
@tbuniohttp://ca.linkedin.com/pub/terry-bunio/4/218/67http://www.agilist.cahttps://api.twitter.com/1/users/profile_image?screen_name=@tbunio48481140511405SQLSaturday 175Room 213Lunch Break4/27/2013 11:15:00 AM4/27/2013 12:15:00 PM1140511405SQLSaturday 175Room 212Lunch Break4/27/2013 11:15:00 AM4/27/2013 12:15:00 PM1140511405SQLSaturday 175Room 211Lunch Break4/27/2013 11:15:00 AM4/27/2013 12:15:00 PM1140511405SQLSaturday 175Room EBCLunch Break4/27/2013 11:15:00 AM4/27/2013 12:15:00 PM1140611406SQLSaturday 175Room 213Registrations4/27/2013 7:00:00 AM4/27/2013 8:30:00 AM1140611406SQLSaturday 175Room 212Registrations4/27/2013 7:00:00 AM4/27/2013 8:30:00 AM1140611406SQLSaturday 175Room 211Registrations4/27/2013 7:00:00 AM4/27/2013 8:30:00 AM1140611406SQLSaturday 175Room EBCRegistrations4/27/2013 7:00:00 AM4/27/2013 8:30:00 AM1140711407SQLSaturday 175Room 213Raffle4/27/2013 4:45:00 PM4/27/2013 5:15:00 PM1140711407SQLSaturday 175Room 212Raffle4/27/2013 4:45:00 PM4/27/2013 5:15:00 PM1140711407SQLSaturday 175Room 211Raffle4/27/2013 4:45:00 PM4/27/2013 5:15:00 PM1140711407SQLSaturday 175Room EBCRaffle4/27/2013 4:45:00 PM4/27/2013 5:15:00 PM1141511415Jeff PromRoom EBCData Quality ServicesAs the old adage goes, 'Garbage in, garbage out.' Stop spending hours manually cleansing your data, and start using DQS! DQS is the new data
quality tool provided with SQL Server 2012. By leveraging knowledge bases, you can correct invalid data and improve the quality of your data.
In this session we will cover creating a knowledge base, data cleansing, data matching, and using 3rd party knowledge bases (Reference Data). We will talk about installation, show how to use the DQS tool, and how to integrate DQS into your SSIS packages. After this session you should have a good understanding of what DQS is, how to use it, and how to get started with your own Data Quality initiative.4/27/2013 3:15:00 PM4/27/2013 4:30:00 PM1149111491David KleeRoom 212Database Health and PerformanceSure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? In an emergency, can you objectively demonstrate where a performance problem lies? This dynamic dialog session will present a solid process for checking your environment's overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO.4/27/2013 8:30:00 AM4/27/2013 9:45:00 AM1150111501Aaron KingRoom 213A Complete BI Solution in About an Hour! In this presentation Aaron will cover how to collect data from multiple sources using SQL Server 2012 Integration Services (SSIS). Then he will use SQL Server Reporting Services (SSRS) to report detail on that data. After that he will use SQL Server Analysis Services (SSAS) to create a KPI. Finally he’ll present that KPI on a dashboard via a web page. The goal of this presentation is to show how seamless the Microsoft Business Intelligence products are. If you’ve only used a few of these products, you’ll appreciate seeing them together all at once. Code will be provided.4/27/2013 10:00:00 AM4/27/2013 11:15:00 AM1204312043Michael DeFehrRoom 212Deadlocks: What to do about the dreaded 1205Deadlocks can be very tricky, unpredictable and generally nasty. Is all hope lost? This demo-intensive session will explore several types of deadlocks and give you some insight into how to track them down and prevent them. We wil start with a quick review of locking and blocking concepts, then take a deep-dive into deadlock demos.4/27/2013 10:00:00 AM4/27/2013 11:15:00 AM1210312103Ross McNeelyRoom EBCF# for Data AnalysisBegin using F# for Data Analysis. Learn how to take advantage of this function-based language to tackle advanced analysis. I will walk through what F# is, and why it is a great tool for data analysis. This presentation will be full of demonstrations on how to use F# with data sets, analysis models, and data visualization. Supplement your SQL data analysis with the F# functional language, which is ideal for solving complex analytical problems.4/27/2013 1:45:00 PM4/27/2013 3:00:00 PM1210912109Kathi KellenbergerRoom 211T-SQL Analytic FunctionsYou have been writing T-SQL for years but just haven't had time to learn about the new features. Attend this session to take your T-SQL skills to the next level. We'll cover the new analytic functions that can help you write highly performing queries with less effort than the old techniques. 4/27/2013 12:15:00 PM4/27/2013 1:30:00 PM1268912689Eric ZierdtRoom 211Table Partitions for Archiving and PerformanceWhat is Table Partitioning? How can it be used to enhance performance? How can it be used with a data archiving strategy to quickly and easily drop archived data from a table? We will discuss the practical applications of table partitioning using scripts to generate new table partitions, move a partition to another table and discussion on how this can benefit you. 4/27/2013 8:30:00 AM4/27/2013 9:45:00 AM1272612726Jim DorameRoom 213PowerShell and SQLPSX the Dynamic Duo for the DBAWith PowerShell and SQLPSX your DBA life can be a lot simpler.
SMO is powerful, but can be difficult to use. Enter SQLPSX. Chad Miller put together a set of PowerShell functions that
streamline the use of SMO, easing management of a multi-server environment.
Come learn when and how the addition of PowerShell and SQLPSX can benefit you.4/27/2013 12:15:00 PM4/27/2013 1:30:00 PM1289712897Terry BunioRoom EBCHow to install and configure SSRS 2012/SharepointCome to this session and learn how easy it is to install an SQL Server Reporting Services (SSRS) Environment with a SharePoint Foundation environment. Terry will share his lessons learned on how to install and configure an SSRS/Sharepoint environment. Terry will also share the lessons learned about what the books don't tell you and how to set up your SharePoint sites and security to lessen future grief. Terry will even cover some more detailed topics like how to configure Visual Studio to be able to deploy from within Visual Studio right to Sharepoint and how to call an SSRS report from Java.
4/27/2013 10:00:00 AM4/27/2013 11:15:00 AM1316813168Jason StrateRoom 211Discovering the Plan CacheExecution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery.
4/27/2013 3:15:00 PM4/27/2013 4:30:00 PM1331813318Kathi KellenbergerRoom 213SQL Server 2012 T-SQLHave you heard about all the great new T-SQL features? Attend this session to learn about new functions, OVER clause enhancements, the Sequence Object and more!4/27/2013 8:30:00 AM4/27/2013 9:45:00 AM1335213352Mike DonnellyRoom 212Flipping Through the SSIS CatalagWith the release of SQL Server 2012 one of the biggest changes for SSIS Administration was the addition of the Integration Services Catalog and using parameters. The Catalog is the storage and logging location for SSIS 2012. Parameters are the new configurations in SSIS 2012 and once you start using them you will never go back. Package Variables, Configuration Strings, Package properties can all be configured using Parameters. You will learn how to create the catalog, use parameters to deploy packages through different environments and use the built in reporting to monitor packages as they run.
4/27/2013 12:15:00 PM4/27/2013 1:30:00 PM1346213462Jes BorlandRoom 211Index Options You're Not UsingThere are index options in SQL Server that can enhance the performance of your queries - but most likely, you aren't using them! If you have a solid knowledge of index basics and want to add to your collection, this is the session for you! I'll show you how filtered indexes, compressed indexes, and indexed views work and can improve performance!
4/27/2013 10:00:00 AM4/27/2013 11:15:00 AM1349713497Paul TimmermanRoom 212An Optimistic Approach: Snapshot Isolation in SQL Until 2005, SQL Server was a very pessimistic RDBMS. However with the introduction of the Read Committed Snapshot database option and the new Snapshot Isolation level, that is no longer the case.
After a high level look at all SQL Server isolation levels, we’ll spend the majority of this session discussing the implementation of optimistic concurrency control in SQL Server. We’ll look at the benefits and drawbacks of using an optimistic isolation level and discuss use cases where it may or may not be appropriate.
Come learn how to put one of the more powerful, but least understood, aspects of SQL Server to work for you!4/27/2013 1:45:00 PM4/27/2013 3:00:00 PM1379913799Eric NessRoom EBCData Mining Deep Dive: ClusteringMicrosoft SQL Server makes it simple to apply data mining algorithms to a wide variety of data. Applying the results to business decisions without a thorough understanding of how the algorithms work is dangerous to the bottom line of the business, though. This session will take one of the algorithms, the Microsoft Clustering Algorithm, and do a deep dive into the mechanics of how it works. The algorithm is valuable for analyzing data in the fields of marketing, social networks and many others. The session will also examine the types of data that are valid for clustering. A demonstration of building a clustering model using SQL Server Analysis Services and viewing the model using the Excel Data Mining Add-In will be given.4/27/2013 8:30:00 AM4/27/2013 9:45:00 AM1386913869Scott ShawRoom EBCThe Future of the DBAWhat will the DBA role look like in 10 years? 20 years? Will a DBA still be necessary? We'll explore a number of scenarios in an forum as we try6 to determine how, as DBAs, we can position ourselves for a bright and productive future. I'll talk about trends I'm seeing in companies of all shapes and sizes. This presentation isn't about concensus, but about tackling tough issues facing the future of our profession.4/27/2013 12:15:00 PM4/27/2013 1:30:00 PM1389413894Steve JonesRoom 211The Encryption PrimerLearn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.4/27/2013 1:45:00 PM4/27/2013 3:00:00 PM1401814018Jason HornerRoom 213Dimension Modeling Design Patterns: Beyond BasicsThis session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.4/27/2013 1:45:00 PM4/27/2013 3:00:00 PM1405414054Steve HughesRoom 212Building BI Solutions with Excel 2013If you have not experienced building BI solutions with Excel 2010, be amazed at what you can do in Excel 2013. In this session we will use PowerPivot, Power View, Quick Explorer, and other great features in Excel to build an Excel 2013 BI solution. Microsoft has went 'all-in' with Excel as their primary BI client. If you want to get a first hand look at using it more fully, you will be amazed. I know I was.4/27/2013 3:15:00 PM4/27/2013 4:30:00 PM1507015070Jes BorlandRoom 213The What, Why, and How of Filegroups Having multiple database files and filegroups is one of many strategies to improve performance and make administration easier. What are filegroups, and how do you use them? In this session, I'll show you how to create filegroups, create objects in them or move objects to them, and discuss how they can help performance. I'll also cover Enterprise-level features like piecemeal restores. 4/27/2013 3:15:00 PM4/27/2013 4:30:00 PM