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 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 1287 Fusion-io Platinum Sponsor http://www.fusionio.com/ http://www.fusionio.com/images/fusionio-logo.gif 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 1315 Idera Gold Sponsor http://www.idera.com http://www.sqlsaturday.com/images/resized%20-%20idera_logo.png 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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