SQLSaturday #81 - Birmingham 2011 7/30/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat81 Birmingham AL 35242 1287 Fusion-io Platinum Sponsor http://www.fusionio.com/ http://www.fusionio.com/images/fusionio-logo.gif 60 170 1315 Idera Gold Sponsor http://www.idera.com http://www.sqlsaturday.com/images/resized%20-%20idera_logo.png 60 170 1192 Teksouth Corporation Gold Sponsor http://www.teksouth.com http://www.teksouth.com/images/logo.jpg 60 170 1196 Confio Software Gold Sponsor http://www.confio.com/ http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 1386 Red Gate Software Gold Sponsor http://www.red-gate.com/ http://www.sqlsaturday.com/files/58c1ba01-73ff-4cd4-9224-47dd0446ce74.jpg 60 170 1382 Telerik, Inc. Silver Sponsor http://www.telerik.com http://www.telerik.com/Libraries/Company/TelerikLogoPreview.sflb?Download=true 60 170 1395 O'Reilly Media Bronze Sponsor http://oreilly.com http://www.sqlsaturday.com/files/6a38ec19-53f9-41a1-8a6a-5fc233d63473.gif 60 170 1397 Apress Media LLC Bronze Sponsor http://www.apress.com http://www.sqlsaturday.com/files/45a7ba82-8c36-4124-a58a-e12e5628feff.jpg 60 170 1400 Computer Technology Solutions Bronze Sponsor http://www.askcts.com http://www.sqlsaturday.com/files/d4491cea-0417-4ec6-b9bf-198d6ff0d159.JPG 60 170 1406 Morgan Kaufmann Publishing Bronze Sponsor http://mkp.com http://mkp.com/wp-content/themes/Reshma_MK/images/mk_logo.jpg 60 170 1221 CozyRoc Bronze Sponsor http://cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 1381 TEK Systems Bronze Sponsor http://www.teksystems.com http://www.teksystems.com/Images/Layout/HomeFlash/teksystems.gif 60 170 5066 Aaron Nelson Aaron Nelson ( @SQLvariant ) is a Senior SQL Server Architect with over 10 years experience in architecture, business intelligence, development, and performance tuning of SQL Server. He has experience managing enterprise-wide data needs in both transactional and data warehouse environments. Aaron holds certifications for MCITP: Business Intelligence Developer, Database Administrator, Database Developer. He is also a Microsoft MVP for SQL Server @http://twitter.com/sqlvariant http://www.linkedin.com/in/sqlvariant http://sqlvariant.com/wordpress/ https://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/sqlvariant 48 48 4950 Alex Tocitu Alex Tocitu is an engineer with MSEE in Automation and MBA in Finance. With over 27 years of software experience he has enjoyed 11 of them in Sillicon Valley. After a long time with Java and Sybase/Oracle, he switched to C# and SQL Server and had lots of fun. Alex Tocitu speaks at local user groups, SQLSaturdays and code camps; he also writes articles for MSSQLTips and SQLServerCentral. Alex is an avid chess player both live and online. @ClrJedi https://api.twitter.com/1/users/profile_image?screen_name=@ClrJedi 48 48 4943 Andy Warren Andy Warren is a consultant focusing on SQL administration and performance tuning. He runs the free SQLShare.com training site, is currently a SQL Server MVP, blogs daily at SQLAndy.com, started the SQLSaturday franchise, is a past President of the Orlando SQL Server Users Group, serves as a member of the Board of Directors of PASS, and was a founding partner in SQLServerCentral.com. @sqlandy http://www.linkedin.com/in/sqlandy http://www.sqlandy.com https://api.twitter.com/1/users/profile_image?screen_name=@sqlandy 48 48 4832 Chris Eargle Chris Eargle is a Telerik Developer Evangelist, Microsoft Most Valuable Professional – C#, and two-time INETA Community Champion from Columbia, SC, USA. He has over a decade of experience designing and developing enterprise applications, and he runs the local .NET User Group: the Columbia Enterprise Developers Guild. He is a frequent guest of conferences and community events promoting best practices and new technologies. His blog, kodefuguru.com, has been featured on ASP.NET, MSDN, and Reddit. @kodefuguru http://www.linkedin.com/in/chriseargle http://www.kodefuguru.com https://api.twitter.com/1/users/profile_image?screen_name=@kodefuguru 48 48 4878 Geoff Hiten Microsoft MVP Geoff Hiten is a Principal SQL Server consultant for Intellinet. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in high-availability and high-performance SQL systems. Geoff was recently appointed to fill an interim Director position at the National PASS organization and is responsible for Virtual Chapters. @sqlcaftsman http://www.linkedin.com/profile/view?id=5834715trk=tab_pro http://weblogs.sqlteam.com/geoffh/default.aspx https://api.twitter.com/1/users/profile_image?screen_name=@sqlcaftsman 48 48 4330 Janis Griffin Janis Griffin has over 24+ years of DBA experience including design, development and implementation of many critical database applications. Before coming to Confio, Janis held DBA positions @DoBoutAnything http://www.linkedin.com/pub/janis-griffin/0/914/aba http://www.confio.com https://api.twitter.com/1/users/profile_image?screen_name=@DoBoutAnything 48 48 4244 Jarrett Vance Jarrett Vance, MCSD lives in Birmingham, Al and is an architect for Computer Technology Solutions, Inc. He has experience in many areas of software engineering including QA, BI, machine vision, desktop, mobile, and web. However, Jarrett prefers building enterprise web applications. In his spare time, Jarrett works on an open-source blogging platform called AtomSite. @jarrettv http://www.linkedin.com/in/jarrettv http://jvance.com https://api.twitter.com/1/users/profile_image?screen_name=@jarrettv 48 48 4652 John Welch John Welch is BI Architect with Varigence. Varigence builds tools and frameworks that enable the creation and management of end-to-end business intelligence solutions with unprecedented ease and speed. John has been working with business intelligence and data warehousing technologies since 2001, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server BI topics. @john_welch http://www.linkedin.com/in/johncwelch http://agilebi.com/jwelch https://api.twitter.com/1/users/profile_image?screen_name=@john_welch 48 48 4998 Ken Simmons Ken Simmons is a database administrator, developer, and Microsoft SQL Server MVP. He is the Author of Pro SQL Server 2008 Administration (Apress, 2009), Pro SQL Server 2008 Mirroring (Apress, 2009), and Pro SQL Server 2008 Policy-Based Management (Apress, 2010). He has been working in the IT industry since 2000 and currently holds certifications for MCP, MCAD, MCSD, MCDBA, MCTS for SQL 2005, and MCITP for SQL 2008. @KenSimmons http://www.linkedin.com/in/kensimmons http://cybersql.blogspot.com https://api.twitter.com/1/users/profile_image?screen_name=@KenSimmons 48 48 4383 Kevin Boles Kevin is a SQL Server expert, working exclusively with the product since version 6.5. With over fifteen years of database experience, he holds virtually every SQL Server related certification including MCT and MVP. Kevin teaches occassionally and has been a very successful independent consultant for the past ten years. He is also a Mentor with Solid Quality Mentors, a top-tier global SQL Server consulting firm. His passion is the relational engine, especially performance analysis and tuning. @TheSQLGuru http://www.linkedin.com/in/thesqlguru https://api.twitter.com/1/users/profile_image?screen_name=@TheSQLGuru 48 48 4396 Louis Davidson Louis has been in the IT industry for 17 years as a corporate database developer and architect. He has been a Microsoft MVP for 7 years and has written 4 books on database design. Currently serves as the Data Architect for the Christian Broadcasting Network supporting offices in Virginia Beach, Virginia and Nashville, Tennessee. Louis has a bachelor's degree from the University of Tennessee at Chattanooga in computer science with a minor in mathematics. For more information visit drsql.org. @drsql http://www.linkedin.com/in/louisdavidson http://drsql.org https://api.twitter.com/1/users/profile_image?screen_name=@drsql 48 48 4488 Nathan Mourfield Nathan has developing BI solutions with MS SQL and Sybase ASE for the last 11 years in health care, 8 of those involved working with SSAS. He currently works at a large hospital as a systems analyst, specializing in line and middle management analytic applications, specifically on the business/finance side. @masakatsu http://www.linkedin.com/profile/view?id=20425064trk=tab_pro https://api.twitter.com/1/users/profile_image?screen_name=@masakatsu 48 48 4265 Rob Schoenborn Rob is a Business Intelligence Architect for EyeWonder, a LimeLight networks business, were he has fun doing global interactive marketing analytics. Rob’s experience designing and implementing databases in various technical and business environments has enabled him to become a subject matter expert in database administration and development, especially working with technologies such as Microsoft SQL Server, Analysis Services, Web Services, and XML. @sql_r http://www.linkedin.com/profile/view?id=10542308locale=en_UStrk=tab_pro https://api.twitter.com/1/users/profile_image?screen_name=@sql_r 48 48 4252 Sven Aelterman Sven Aelterman is a lecturer in Information Systems at Troy University in Troy, Alabama. He teaches undergraduate courses in database design, data warehousing and network infrastructure and security. He is also the technology specialist for the Sorrell College of Business at TROY and performs a variety of technology roles with a global scope. He continues consulting work through Adduxis, where he assists customers with software development projects using the Microsoft .NET Framework. @svenaelterman http://linkd.in/svena http://spkr8.com/svenaelterman https://api.twitter.com/1/users/profile_image?screen_name=@svenaelterman 48 48 4133 Tim Radney Senior DBA for a top 40 US held bank. Microsoft Systems Admin turned DBA. Have been a full time DBA going on 3 years. Prior to becoming a full time DBA I spent 10 years supporting Citrix, Novell, Windows, IIS, and MSSQL. @http://www.twitter.com/tradney http://linkedin.com/in/tradney http://www.timradney.com https://api.twitter.com/1/users/profile_image?screen_name=@http://www.twitter.com/tradney 48 48 4167 William E. Pearson III Bill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill's background as a CPA, Internal Auditor, Management Accountant and SQL Server MVP (BI) enable him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies, and focuses his practice upon the integrated Microsoft business intelligence solution. @Bill_Pearson http://mvp.microsoft.com/en-US/findanmvp/pages/profile.aspx?MVPID=02c5cd07-7511-4151-a678-3a4a3451f85e https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E https://api.twitter.com/1/users/profile_image?screen_name=@Bill_Pearson 48 48 4133 4133 Tim Radney Level 100 HSB 129A You have recently inherited the support of a new or existing database, what are the things you should immediately check and start monitoring and what are the things that you should address over the next few weeks. When taking over support of a database or system, you cannot ASSUME anything. At the end of this session you will have a nice checklist of things you should check and be doing on ALL your databases not just the one you inherited. Whether you are a seasoned DBA or just starting out, this session should be informative and something you can relate to. 7/30/2011 9:15:00 AM 7/30/2011 10:15:00 AM 4167 4167 William E. Pearson III Level 400 HSB 129D As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence. 7/30/2011 4:30:00 PM 7/30/2011 5:30:00 PM 4170 4170 William E. Pearson III Level 100 HSB 129A In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. 7/30/2011 3:15:00 PM 7/30/2011 4:15:00 PM 4244 4244 Jarrett Vance Level 300 HSB 129C EF Code First provides an elegant and powerful way to work with data. In this session, we will learn how to mark up our model with metadata, automatically generate a database, and efficiently query for objects using LINQ. You will learn why the code-only approach of the library means that model layers end up being flexible and easy to customize. 7/30/2011 9:15:00 AM 7/30/2011 10:15:00 AM 4252 4252 Sven Aelterman Level 300 HSB 129C Currently in CTP1, the next version of SQL Server, codename 'Denali', offers several new features and improvements. This session will cover the ones that are most of interest to application developers, including enhancements to FILESTREAM, T-SQL and developers tools (including SSIS). 7/30/2011 4:30:00 PM 7/30/2011 5:30:00 PM 4265 4265 Rob Volk Level 400 HSB 129D Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG! This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them. (But they deserved it!) Learn how to: create tables with no names; columns with duplicate names; and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you'll ache for the chance! 7/30/2011 12:45:00 PM 7/30/2011 1:45:00 PM 4330 4330 Janis Griffin Level 200 HSB 129B SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL Diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query. 7/30/2011 12:45:00 PM 7/30/2011 1:45:00 PM 4332 4332 Janis Griffin Level 400 HSB 129D Management Data Warehouse (MDW) which was introduced in 2008 can provide DBAs with useful performance information about Disk Usage, Server Activity and Query Statistics. This presentation will explore how to set up MDW, look at its underlying schema / statistics and point out some of its shortcomings in comparison with other performance tools. 7/30/2011 10:30:00 AM 7/30/2011 11:30:00 AM 4383 4383 Kevin Boles Level 300 HSB 129C We will cover most of the bases in this broad and deep coverage of table/index partitioning in the relational engine. Numerous demonstrations will help gel knowledge you can take back to the office and begin to apply to your environments to reap the many benefits of this fine addition to the product that has been significantly enhanced since SQL 2005. 7/30/2011 3:15:00 PM 7/30/2011 4:15:00 PM 4384 4384 Kevin Boles Level 500 HSB 159 Time for another deep dive from TheSQLGuru, this time on the transaction log. Architecture and internals, monitoring, tuning/optimizing will all be covered. A great learning experience on another pillar of the SQL Server relational engine. 7/30/2011 2:00:00 PM 7/30/2011 3:00:00 PM 4385 4385 Kevin Boles Level 500 HSB 159 When you know how to find out WHAT your queries are waiting on you get a very good clue about how to fix them - or help the server as a whole in many cases. Lots of stuff here you will want to put in your bag of tuning tricks! I could be putting myself out of work teaching stuff like this! :-D 7/30/2011 12:45:00 PM 7/30/2011 1:45:00 PM 4396 4396 Louis Davidson Level 200 HSB 129B In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming 'difficulties' are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently). 7/30/2011 9:15:00 AM 7/30/2011 10:15:00 AM 4397 4397 Louis Davidson Level 200 HSB 129B When queried, most database professionals would mention normalized as one of the most important characteristics that tell the difference between a good and bad database design. I won't disagree in the least, but there is so much more to be considered. Even if you did a great job of normalization, poor naming, poorly implemented keys, too many or too few indexes, and so on can derail your design. In this session I will present seven primary characteristics of a design that differentiates between an ugly design that will have your colleagues nitpicking you to death and one that will have them singing your praises. Characteristics such as comprehendible, documented, secure, well performing, and more (including normalized, naturally) will be 7/30/2011 10:30:00 AM 7/30/2011 11:30:00 AM 4488 4488 Nathan Mourfield Level 100 HSB 129A This session covers a basic overview of SSAS in 08. The session will go over how cube and dimensions are build and developed, basic data mining, and the other information SQL Devs and Data Analysts need to know moving into Analysis Services. 7/30/2011 10:30:00 AM 7/30/2011 11:30:00 AM 4652 4652 John Welch Level 200 HSB 129B SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks or packages that adhere to a pattern, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you'll learn how to automate package creation in SSIS, including the dynamic generation of data flows. We’ll cover some of the free and open source tools available for this, and discuss “roll your own” options. 7/30/2011 3:15:00 PM 7/30/2011 4:15:00 PM 4665 4665 John Welch Level 500 HSB 159 So you’ve used SSIS to populate a simple star schema data mart, and everybody’s happy. But now you have new requirements that require more advanced data warehouse approaches, like late arriving dimensions, bridge tables, parent child dimensions, and Type 3 or Type 6 slowly changing dimensions (SCD). How do you handle those in a scalable, efficient way in SSIS? This session will present some common patterns for handling these scenarios. You’ll learn when to use each advanced approach and the pros and cons associated with each pattern. You will learn how to implement these patterns in SSIS, and how to tune them for high performance. 7/30/2011 4:30:00 PM 7/30/2011 5:30:00 PM 4718 4718 Tim Radney Level 300 HSB 129C TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session. 7/30/2011 10:30:00 AM 7/30/2011 11:30:00 AM 4819 4819 Sven Aelterman Level 300 HSB 129C Originally released with Visual Studio 2010 and .NET Framework v4, Entity Framework v4 has seen a remarkable evolution in the past year or so. In April, Microsoft released version 4.1. Most notably, there is now great support for Code First development. This talk will delve into the use of Code First in Entity Framework v4.1 and will be very code focused. Developers will learn how they can use the Entity Framework APIs to create applications that use Entity Framework features to access relational databases without the need to use designers to create the model. It is in essence a 'code only' approach, which has many benefits, including for testability and long-term evolution of your code. 7/30/2011 2:00:00 PM 7/30/2011 3:00:00 PM 4820 4820 Sven Aelterman Level 500 HSB 159 Are you faced with the dilemma of where to store large files that are related to your structured, relational data? In this session, FILESTREAM will be discussed in details, with lots of demos, so you'll know when to use this SQL Server 2008 and up feature to handle BLOB storage. The demos will show how to enable FILESTREAM at the instance level, database level and table level; and how to leverage the features for optimum performance in your applications. 7/30/2011 3:15:00 PM 7/30/2011 4:15:00 PM 4832 4832 Chris Eargle Level 100 HSB 129A Do you want to learn or have a refresher on the fundamentals of object-oriented programming and C#? This session is perfect for the DBA who must occasionally code and the developer who wants a deeper understanding of C# and OOP. 7/30/2011 4:30:00 PM 7/30/2011 5:30:00 PM 4878 4878 Geoff Hiten Level 500 HSB 159 AlwaysOn is the new High Availability branding for Microsoft SQL Server that combines the best in Clustering, Mirroring, and Log Shipping for a simple, seamless experience. See what Microsoft is building into SQL Server Codename “Denali” and how you can plan for this new way to increase database availability in your shop. 7/30/2011 10:30:00 AM 7/30/2011 11:30:00 AM 4943 4943 Andy Warren Level 100 HSB 129A A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan. 7/30/2011 2:00:00 PM 7/30/2011 3:00:00 PM 4944 4944 Andy Warren Level 100 HSB 129A This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you're a DBA or trying to get by without one, this session will give you the information you need to know. 7/30/2011 12:45:00 PM 7/30/2011 1:45:00 PM 4950 4950 Alex Tocitu Level 200 HSB 129B This talk will go over some of the best practices of software engineering as they apply to SQL Server CLR projects. We will also show how to build a small library of utilities, stored procedures, functions, etc., that should help you remove some of SQL Server built-in functional barriers. 7/30/2011 2:00:00 PM 7/30/2011 3:00:00 PM 4952 4952 Alex Tocitu Level 300 HSB 129C This talk will go over some of the best engineering and management practices as they apply to PowerShell scripts addressing SQL Server. We will also show how to build a small library of utilities that should help you in your day to day database related tasks. 7/30/2011 12:45:00 PM 7/30/2011 1:45:00 PM 4998 4998 Ken Simmons Level 200 HSB 129B As the demand for data keeps growing and security and compliance keep tightening, the role of the DBA has become an increasingly critical part of maintaining compliance within the organization. This session will cover real world examples you can use with Policy-Based Management to ensure you have the proper server configuration and security settings in place along with the appropriate encryption and auditing options for your environment. 7/30/2011 4:30:00 PM 7/30/2011 5:30:00 PM 5000 5000 Rob Schoenborn Level 500 HSB 159 The demand is increasing for analytical data on the web for dashboards and ad-hoc analysis. Companies are using this data to provide immediate insight into their business. Data as a service model requires that users can only access the data they have permission to use. This session discusses a method of using an Analysis Services Stored Procedure to secure both dimensions and measures in SQL Analysis Services based on Security Authentication from either Performance Point, Share Point or via Excel Web Services (MSMDPUMP) layer. This mechanism can also be extended to provide custom application security to a SSAS cubes. 7/30/2011 9:15:00 AM 7/30/2011 10:15:00 AM 5066 5066 Aaron Nelson Level 400 HSB 129D Continuously gathering performance data to log history and developing a performance baseline is a really important task in any environment. Having quick access to what’s happening right now is equally important. In this session we’ll take a look at how to continuously gather Perfmon counters and DMV info. We’ll also take a look at how to Visualize the data using charts. 7/30/2011 2:00:00 PM 7/30/2011 3:00:00 PM 5318 5318 Aaron Nelson Level 400 HSB 129D This session will cover the new features of PowerShell in SQL Denali. The new module for SQL Server, the new module for SSAS, and the new Replica cmdlets for High Availability databases. 7/30/2011 3:15:00 PM 7/30/2011 4:15:00 PM 5382 5382 Janis Griffin Level 400 HSB 129D 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. 7/30/2011 9:15:00 AM 7/30/2011 10:15:00 AM