SQLSaturday #29 - Birmingham 2010 3/27/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat29 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 398 Microsoft Gold Sponsor http://www.microsoft.com/sql http://i.microsoft.com/global/sqlserver/2008/en/us/PublishingImages/logo-header-sql08-dg.gif 60 170 405 Teksouth Gold Sponsor http://www.teksouth.com http://www.teksouth.com/images/logo.jpg 60 170 430 Confio Software Gold Sponsor http://www.confio.com http://www.sqlsaturday.com/images/Confio_LogoLg_0106.jpg 60 170 448 Bit Wizards Gold Sponsor http://www.bitwizards.com http://www.sqlsaturday.com/files/7fe5bf1d-ef40-458e-9153-d74581405138.jpg 60 170 407 CozyRoc LLC Silver Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 446 Red Gate Software Silver Sponsor http://www.red-gate.com http://www.red-gate.com/images/redgatelogo_black.jpg 60 170 452 Telerik, Inc. Silver Sponsor http://www.telerik.com/ http://www.telerik.com/Libraries/Company/TelerikLogoPreview.sflb?Download=true 60 170 463 Intellinet Silver Sponsor http://www.intellinet.com http://www.intellinet.com/media/31199/intellinet_tagline.png 60 170 493 Attunity Silver Sponsor http://www.Attunity.com http://www.attunity.com/images/logo_attunity.gif 60 170 387 O'Reilly Media, Inc. Bronze Sponsor http://ug.oreilly.com/ http://cdn.oreilly.com/images/standard/oreilly-logo-footer.gif 60 170 447 Tek Systems Bronze Sponsor http://www.teksystems.com http://www.teksystems.com/Images/Layout/HomeFlash/teksystems.gif 60 170 475 Wiley Publishing Bronze Sponsor http://www.wrox.com http://media.wiley.com/assets/253/59/wrox_logo.gif 60 170 1018 Aaron Nelson SQL Development HSB 129B In this session we will learn to perform several everyday DBA tasks like backing up user databases, scripting table objects and evaluating disk space usage with PowerShell. For each task we will explore the benefits of using PowerShell over the standard method. Only a basic understanding of PowerShell or DOS is needed. This session should serve as a good introduction to PowerShell for database users. The goal is to get data professionals feet wet using PowerShell. 3/27/2010 9:15:00 AM 3/27/2010 10:15:00 AM 1042 Geoff Hiten Database Administration HSB 129A Learn about the major changes in clustering in recent SQL and Windows releases and how clustering is something you can implement that will actually make your work life easier. 3/27/2010 2:45:00 PM 3/27/2010 3:45:00 PM 1044 Geoff Hiten Database Administration HSB 129A Policy-Based Management, Central Management Server, Enterprise Policy Management Framework, and Powershell combine to allow automation of DBA tasks more than ever before. Learn how to put these pieces together to do more with less. 3/27/2010 1:30:00 PM 3/27/2010 2:30:00 PM 1132 Aaron Nelson Database Administration 2 HSB 129D With the list of features of SQL Server growing constantly the need to sandbox and test drive features in a separate environment that can communicate with but not interfere with your existing environment has become vital. With virtualization, setting up consistent test, dev, and even sandbox environments can happen minutes instead of hours AND be consistent with previous/ existing environments. In this session we will focus on Microsoft Virtualization solutions that you can leverage starting with your desktop/laptop and extending to your server environments. Even if you aren’t going to be doing the virtualization yourself it’s good to know what your options are. 3/27/2010 2:45:00 PM 3/27/2010 3:45:00 PM 1216 Sven Aelterman SQL Development HSB 129B This session is designed to provide an introduction to FILESTREAM from installation to basic use, and then delve into how FILESTREAM can be put to use in N-Tier applications. 3/27/2010 10:30:00 AM 3/27/2010 11:30:00 AM 1217 Sven Aelterman SQL Development HSB 129B This session is a follow-up session on FILESTREAM in Depth. This session will cover how to use FILESTREAM data in a variety of scenarios, including Reporting Services and in a transactional scenario. 3/27/2010 12:15:00 PM 3/27/2010 1:15:00 PM 1266 Janis Griffin Database Administration HSB 129A Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait type data, column selectivity, and several more that will help you succeed on future tuning projects. 3/27/2010 12:15:00 PM 3/27/2010 1:15:00 PM 1322 Barry Ralston Business Intelligence HSB 129C This 100-level session will provide SQL programmers with the tools to begin querying SQL Server Analysis Services (SSAS) databases. Through examples, including the creation of an SSAS database from the AdventureWorks example database, students will have a primer of knowledge to begin using SSAS to the fullest. 3/27/2010 2:45:00 PM 3/27/2010 3:45:00 PM 1343 Robert Cain Business Intelligence HSB 129C SQL Server Integration Services is Microsoft's powerful tool for doing ETL (Extract, Transform, and Load) in the Business Intelligence arena. In this introductory course you can get up to speed on the basic tools of ETL and learn how to leverage SSIS not just for Business Intelligence but for data conversion as well. 3/27/2010 1:30:00 PM 3/27/2010 2:30:00 PM 1346 Louis Davidson Database Administration HSB 129A 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). 3/27/2010 9:15:00 AM 3/27/2010 10:15:00 AM 1347 Louis Davidson Database Administration HSB 129A Beyond database design fundamentals (for example, Normalization) lies the area where you have to create 'real' solutions. In this session, I will cover a good number of patterns that we commonly find useful to try to apply to the problem of building a database solution. Ideas like generalization, subclassing, single table domain tables, optional data, and more will be discussed, some of them good, some not so good (don't assume which will be which), but all that are common and/or useful for your database implementations. 3/27/2010 10:30:00 AM 3/27/2010 11:30:00 AM 1349 Rodney Landrum Database Administration 2 HSB 129D I put together the DBA Repository a few years back and have written and spoken about it for as many years with updates and enhancements over time. At it's heart, the solution employs SSIS and SSRS and in late 2009 I updated it for performance and resiliency. You can read about the original solution in SQL Server Magazine. The latest update will be published in 2010. This will be a sneak peak at those enhancements. The session will cover some interesting uses of package variables and MERGE in SSIS with new reports as well. 3/27/2010 1:30:00 PM 3/27/2010 2:30:00 PM 1407 Jim Wooley Database Administration 2 HSB 129D With the release of .NET 3.5 and the subsequent SP1, attention has focused upon the legitimacy of Object Relational Mapping systems. Regardless of whether you embrace LINQ to SQL, the Entity Framework, NHibernate, or any of the hundreds of other O/R Mappers, the question remains for the DBA: Is it time to consider alternatives to stored procedures? In this session, we'll introduce LINQ and discuss how programmers and DBA's can work together with these emerging technologies to build robust, performant and dynamic systems. 3/27/2010 12:15:00 PM 3/27/2010 1:15:00 PM 1415 Kevin Boles Database Administration 2 HSB 129D Like the title says, be prepared to get really down and dirty with memory allocations and usage in SQL Server. RAM is one of the three pillars of server performance and understanding how it is used, how you can analyze what is going on with it and how to properly adjust the the few knobs you have at your disposal are very important topics for both your server's health and performance. 3/27/2010 10:30:00 AM 3/27/2010 11:30:00 AM 1416 Kevin Boles Database Administration 2 HSB 129D What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine. 3/27/2010 9:15:00 AM 3/27/2010 10:15:00 AM 1461 Joe Webb SQL Development HSB 129B A good working knowledge of how SQL Server makes use of locking and transaction isolation levels can go a long way toward improving an application’s performance. In this session, we will explore SQL Server’s locking methodology and discover techniques for enhancing query response times. 3/27/2010 2:45:00 PM 3/27/2010 3:45:00 PM 1462 Joe Webb SQL Development HSB 129B Transact-SQL is not a very difficult language to learn. As long as the syntax is correct, it can be quite forgiving. However to truly get the best performance from your SQL Server, careful consideration should be given to the structure and logic of the queries. In this session, we’ll discuss some Transact-SQL tips and tricks that can be employed to help you write better queries, allowing your server to perform better. 3/27/2010 1:30:00 PM 3/27/2010 2:30:00 PM 1493 Kevin Grohoske Business Intelligence HSB 129C With SQL Server 2008 R2, Microsoft has added spatial capabilities that provides a developer an very powerful toolset to create dynamic and powerful location aware applications. In this demonstration we will review the available spatial capabilities, objects, and complimentary Bing services used to develop a custom spatial aware Business Intelligence application. 3/27/2010 10:30:00 AM 3/27/2010 11:30:00 AM 1523 Vincent Mayfield Business Intelligence HSB 129C Most ASP.NET Developers are able to build ASP.NET Applications. However, few understand the principles of building scalable Enterprise Applications that are deployable in a Network Load Balanced or Clustered Server network configuration. This seminar targets advanced developers who desires to understand the considerations required in designing and building a scalable ASP.NET Applications. Topics covered in this seminar include: The NLB and Clustered Network Topology, Handling State, Inproc versus SQL Server State Management, Sticky Sessions, Programming Considerations, Database Considerations, and Statistics. 3/27/2010 12:15:00 PM 3/27/2010 1:15:00 PM 1569 Robert Cain Business Intelligence HSB 129C PowerPivot is an exciting new technology from Microsoft that will allow users to leverage their data to answer many of their business questions. Commonly referred to as 'Self Service Business Intelligence', PowerPivot consists of two components, PowerPivot for Excel 2010 and PowerPivot for SharePoint 2010. This presentation will provide an overview of both components then dig deeper into PowerPivot for Excel 2010. Multiple demos illustrate everything from importing data to creating pivot tables and charts, as well as using techniques such as filters and calculated columns. 3/27/2010 9:15:00 AM 3/27/2010 10:15:00 AM