SQLSaturday #60 - Cleveland 2011 2/5/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat60 Cleveland OH 44212 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 851 UpSearch Platinum Sponsor http://www.upsearch.com/ http://www.sqlsaturday.com/files/ce4ac119-cc88-4204-8842-97d3e1b5d6a7.png 60 170 862 Red Gate Software Platinum Sponsor http://www.red-gate.com http://www.sqlsaturday.com/files/b84eb9e4-ac00-4aa5-ba54-11f29147fe53.png 60 170 872 Confio Software Platinum Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 910 Hyland Software, Inc. Platinum Sponsor http://www.hyland.com http://www.sqlsaturday.com/files/1931bdb1-2259-4888-8c4a-108912b6f6a5.jpg 60 170 957 SQL Sentry Platinum Sponsor http://www.sqlsentry.net/ http://www.sqlsentry.net/images/ext/SQLSentryLogo148.jpg 60 170 963 Fusion-io Silver Sponsor http://www.fusionio.com/ http://www.fusionio.com/images/fusionio-logo.gif 60 170 938 Melissa Data Silver Sponsor http://www.melissadata.com http://www.melissadata.com/home/new-2009/melissa-data-logo.gif 60 170 866 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 960 SHI Bronze Sponsor https://www.shi.com/ 60 170 931 Gerasus Software Friends of SQL Saturday http://www.gerasus.com/ http://www.gerasus.com/images/logo.png 40 100 950 Aspose Pty Ltd Friends of SQL Saturday http://www.aspose.com/ http://www.aspose.com/images/aspose-logo.gif 40 100 953 Wrox/Wiley Friends of SQL Saturday http://www.wrox.com/WileyCDA/ http://www.sqlsaturday.com/files/81e45e31-9533-4473-9b69-ee734a5a7bf7.png 40 100 954 Manning Publications Friends of SQL Saturday http://www.manning.com/ http://www.sqlsaturday.com/files/352cae85-6afd-4144-b646-42d20593a366.medium.gif 40 100 955 Apress Friends of SQL Saturday http://apress.com/ http://www.sqlsaturday.com/files/3425728c-3d8f-4207-a41a-93c484f6dda1.png 40 100 2609 Jeff Moden Room 314 Room 314 There are dozens of things we do in T-SQL which require some type of iteration. 'Iteration' means 'counters', 'loops' and recursion to most people. To those well versed in the “Black Arts” of high performance 'Set-based' programming, it means a 'Numbers' or 'Tally' Table, instead. This “Developer-to-Developer” session starts with the basics of how SQL Server can be tricked into counting faster than you can imagine, how that simple act of counting replaces slothful loops and other forms of “RBAR”, and provides a substantial introduction to “set based thinking. The session also includes tips on using Pseudo Cursors, CROSS APPLY, and INLINE TABLE VALUED FUNCTIONS (iTVFs) to make your code that much faster . 2/5/2011 1:30:00 PM 2/5/2011 2:30:00 PM 2632 Michael Coles Room 325 Room 325 SQL Server 2008 introduced support for new spatial data features -- providing powerful visualization capabilities to your users. In this course attendees will learn the basics of the Geography and Geometry data types, spatial indexing, and spatial calculations. We will also explore more advanced uses for spatial data: loading spatial data into SQL Server from other formats, the new Map control in SSRS, and using online mapping software like Bing Maps to visualize SQL Server spatial data. 2/5/2011 9:00:00 AM 2/5/2011 10:00:00 AM 2633 Michael Coles Room 314 Room 314 SQL Server 2008 once again improves on the classic built-in SQL Server full-text search (FTS) functionality by making FTS more efficient and transparent. In this course attendees will learn both the basics of the new Integrated FTS (iFTS) and how to build user-friendly Google-style search interfaces on top of SQL Server for the benefit of their end users. 2/5/2011 2:45:00 PM 2/5/2011 3:45:00 PM 2635 Joe Kuemerle Room 314 Room 314 Learn to protect data in your application by leveraging the built in encryption functionality in SQL Server 2005/2008 by taking a brownfield application and bringing it up to modern standards. Topics covered will include column level data encryption, providing lookups of encrypted data, basics of key management and the transparent data encryption capabilities of SQL Server 2008. 2/5/2011 11:30:00 AM 2/5/2011 12:30:00 PM 2637 Joe Kuemerle Room 313 Room 313 The economy is still tight. Companies continue to reduce costs across the board. With outsourcing and off-shoring achieving success, how can today’s in-house DBA or developer prove his value to the business? Technical expertise is valuable to product and technical management. However, it’s the professionals understanding of the business and his role in generating revenue that’s invaluable. This presentation explains various techniques technical professionals can use to increase their business savvy, proving they are providing value and not just an expense. 2/5/2011 2:45:00 PM 2/5/2011 3:45:00 PM 2674 William Pearson Room 315 Room 315 In this session 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. 2/5/2011 2:45:00 PM 2/5/2011 3:45:00 PM 2683 Eddie Wuerch Room 325 Room 325 An often-overlooked aspect to data optimization is what is happens under the covers – how does SQL Server store and access data? There are plenty of common rules covering tuning, but this session looks at data access from the physical layer, detailing how table access and indexes work, showing why some designs perform poorly, and why adding more indexes may not help. This will not be a discussion of normal forms or design rules. Instead, it will be a technical session providing the foundation for you to choose which concepts to apply to your designs. The session starts with the notion that SQL Server is not a magic box – most of what happens is well-documented and must be taken into consideration when designing or tuning databases. 2/5/2011 1:30:00 PM 2/5/2011 2:30:00 PM 2685 Jeremiah Peschka Room 313 Room 313 Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can’t promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server. 2/5/2011 9:00:00 AM 2/5/2011 10:00:00 AM 2754 Joe Fedak Room 329 Room 329 You've got SSAS cubes and they work. Now people are using them and everyone's queries are slow. I'll cover how to see who's using the cubes, what query they're running. Also, what can we do to make the queries run faster and how to stop bad queries that are hogging system resources. Specifically I'll cover the SSAS DMVs, the SSAS Activity Viewer available from CodePlex that uses theses DMVs. Also the aggregation designer that is available as part of the BIDS project and how it can be used to speed up queries against the cube database. 2/5/2011 4:00:00 PM 2/5/2011 5:00:00 PM 2794 Chris Skorlinski Room 315 Room 315 Change Data Capture (CDC) is used by data warehouse applications to retrieve Type I and Type II dimension updates. This sessions provides a walk through of Microsoft's newest SQL Replication feature called CDC. Sessions covers overview of CDC, setting up CDC and using various CDC functions to retrieve list of Type I and Type II data changes. 2/5/2011 9:00:00 AM 2/5/2011 10:00:00 AM 2795 Chris Skorlinski Room 315 Room 315 Working together, Change Data Capture (CDC) and SSIS can identify changed data and move changes to your Data Warehouse. This session will focus on using SSIS package to pull daily, hourly, or near real-time Type I and Type II dimension changes from SQL Server running CDC. 2/5/2011 10:15:00 AM 2/5/2011 11:15:00 AM 2864 jeremiah Peschka Room 325 Room 325 Unfortunately, the real world isn't always as cut and dry as third normal form; sometimes things get muddy. What do you do then? This talk will examine the use of NULLs, sparse columns, XML data types, and other ways of storing data with a murky format. This presentation will introduce techniques for common data modeling problems and examine potential patterns and practices for working with flexible data modeling that can be immediately useful in real-world scenarios. 2/5/2011 4:00:00 PM 2/5/2011 5:00:00 PM 2890 Aaron Bertrand Room 314 Room 314 The session will cover a collection of minor bad habits that can occasionally lead to major problems. 2/5/2011 4:00:00 PM 2/5/2011 5:00:00 PM 2911 Mike Walsh Room 330 Room 330 You've always wanted to get promoted into the DBA position. The good news is you got it - the bad news is you have no idea what to do first. What's important, what's not a big deal, and what can get you fired if you're not careful? If your answer wasn’t, “update my resume”, then this session is a good start. We’ll chat about a natural priority for the overwhelming flood waiting in our offices. By focusing on a few words ending in “ity” we’ll realize what is most important. Through the interaction, stories and examples you’ll leave feeling ready to attack your environment. Be warned – along the way to knowing where to start, you may get that feeling in your stomach that makes you log on to the VPN to check a few things out. 2/5/2011 9:00:00 AM 2/5/2011 10:00:00 AM 2913 Aaron Bertrand Room 330 Room 330 This presentation will cover all of the new features coming our way in the next major version of SQL Server. From contained databases to high availability to T-SQL enhancements, we will cover the good, the bad, the missing and the ugly. Lots of demos and no marketing. 2/5/2011 10:15:00 AM 2/5/2011 11:15:00 AM 2921 Kendra Little Room 330 Room 330 Does SQL Server's table partitioning feature offer performance improvements, manageability benefits, or both? Table partitioning is a significant investment: it's important to understand many aspects of the feature to evaluate where it will be useful. This session will cover basic concepts of table partitioning. We'll discuss where the feature can be applied, its benefits, and changes that partitioning may require to existing database schema. Special considerations for management of partitioned tables will be discussed, as well as potential changes to query optimization and plans. SQL Server 2008 R2 features for partitioning will be included in the discussion. 2/5/2011 2:45:00 PM 2/5/2011 3:45:00 PM 2969 Kendra Little Room 325 Room 325 Understanding transaction isolation levels is critical for developing concurrent software as well as administering databases. Unfortunately most of us learn about transaction isolation early in our careers and don't maintain an in-depth knowledge of different isolation levels. This talk will help! We'll cover all isolation levels and discuss problems and benefits. A broadsheet handout will keep your knowledge fresh later on. This is suitable for developers and DBAs at all levels. 2/5/2011 11:30:00 AM 2/5/2011 12:30:00 PM 3009 Karen Lopez Room 325 Room 325 A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions. 2/5/2011 2:45:00 PM 2/5/2011 3:45:00 PM 3022 Ira Whiteside Room 315 Room 315 We will implement several code samples based on a series of articles amd posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various SQL tools(TSQL, VB,SSIS and MDS). Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms.The steps are as follows: 1. Cleansing and standardization 2. Group records 3. Split records 4. Compare records and determine scores 5. Split into separate match categories 6. Analyze results of matches 7. Evaluate using match tools to determine if best algorithms have been combined. 2/5/2011 4:00:00 PM 2/5/2011 5:00:00 PM 3041 Allen White Room 313 Room 313 We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly. 2/5/2011 4:00:00 PM 2/5/2011 5:00:00 PM 3063 Paul Hiles Room 313 Room 313 How can PowerShell take SQL Server Automation to the next level? PowerShell with the help of the SMO (Server Management Objects) allows a script to interact with the operation system and SQL Server at the same time. In this session we will cover the basics of PowerShell and the SMO object model. Then review a number of scripts that demonstrate the power of PowerShell when automating SQL Server tasks and can be used as building blocks for further automation. 2/5/2011 11:30:00 AM 2/5/2011 12:30:00 PM 3071 Steve Jones Room 315 Room 315 Learn practical ways that you can build your career brand and stand out from the crowd. Steve Jones, editor of SQLServerCentral and longtime DBA shares some of the ways in which he has successfully grown his career over the years. Learn some tips and tricks for social networking, blogging, volunteering, leadership, and resume hints to help you find a great job. 2/5/2011 11:30:00 AM 2/5/2011 12:30:00 PM 3080 Rob Collie Room 329 Room 329 The paradox of Business Intelligence: it's one of the few tech sectors that actually grows during recessions, and yet, satisfaction levels with BI investments remain on average quite poor. Also, BI remains the domain of specialists, off-limits to most of us. Why do these conditions persist when the funding, and therefore the business need, only continues to grow? In this session I will demonstrate how PowerPivot is opening the world of BI to a broader audience ( range of applications). The only prereqs: curiosity, and fondness for numbers :) I will explain how PowerPivot impacts benefits you depending on role (analyst, DBA, BI Pro, etc.), show off its capabilities in real-world usage, and field as many q's as you can muster :) 2/5/2011 11:30:00 AM 2/5/2011 12:30:00 PM 3099 Thomas LaRock Room 330 Room 330 Many database professional have little to no understanding about how to use wait events as part of an overall performance tuning process. And yet wait events are the secret sauce that many leading experts have been using for years. Attend this talk and you will gain an understanding of the SQLOS execution model, an understanding of how to use DMVs to find out what your queries are waiting for, and why using wait events could be the best thing to happen for your career as a DBA. 2/5/2011 1:30:00 PM 2/5/2011 2:30:00 PM 3106 Brian Davis Room 325 Room 325 Have you heard of Service Broker? Do you know what it is? How about how to use it? This session will answer these questions and more. Service Broker is arguably one of the least known and used features of SQL Server. We'll explore Service Broker and learn what it is and how it works. We'll walk through the setup and configuration along with demonstrating its use. You'll leave this session with a better understanding of Service Broker, its use and implementation, along with ideas of how you can implement it in your own environments. 2/5/2011 10:15:00 AM 2/5/2011 11:15:00 AM 3118 Jeff Mlakar Room 314 Room 314 The Cloud is fast becoming the latest hot topic in the technology arena. We need to understand how we as SQL Developers and Administrators can utilize SQL Azure, Microsoft’s platform for relational data storage in the Cloud, to meet our needs. It doesn’t always have to be full sites deployed to the Cloud, it could also be 'hybrid solutions', with a Client tool accessing a Cloud database. That is what will be demonstrated in this talk: A step-by-step demo of how to obtain an Azure subscription, create and administer a SQL Azure database, and work with it from your own SQL Server Management Studio Addin. The end result is an Addin in SSMS that uses the SQL Azure Cloud as a common script repository. 2/5/2011 9:00:00 AM 2/5/2011 10:00:00 AM 3127 Sandra Mueller Room 329 Room 329 Every data warehouse needs a date dimension to help users slice and dice data. What should be included in the dimension, what is enough and what is too much? Should you use the wizard to generate the dimension for you; what are the advantages and disadvantages? We will explore a generic date dimension load script, loading a custom table and configuring SSAS to use the table as the time dimension. Finally we will address the advantages of role-playing dimensions to make an Order Date, Ship Date, Received Date exposed to users as opposed to multiple date dimensions. 2/5/2011 1:30:00 PM 2/5/2011 2:30:00 PM 3132 Craig Purnell Room 330 Room 330 A review of Database Mirroring in the context of operations in the real world. A high level review of the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a ultra fast upgrades or to move large databases to a different location. 2/5/2011 11:30:00 AM 2/5/2011 12:30:00 PM 3137 Sam Nasr Room 329 Room 329 SQL Server 2008 introduced the FileStream object. This allowed developers to resolve an age long dilemma of storing large binary files in the database or accessing them on the file system. SS08 provides the best of both worlds while allowing applications to access the data readily through the FileStream object via Transact SQL or File I/O. 2/5/2011 9:00:00 AM 2/5/2011 10:00:00 AM 3138 Sam Nasr Room 329 Room 329 SQL Server 2008 provides a great platform for producing Business Intelligence reports. With the ability to create SSIS packages and SSRS reports, BI can be utilized to provide vital information for running any business. Learning these skills will help any developer to maximize the full potential of any database application. In addition, many of the new features in Reporting Services make it easier to provide a rich BI report with little effort. 2/5/2011 2:45:00 PM 2/5/2011 3:45:00 PM 3140 Tim Chapman Room 314 Room 314 Poor database performance is Achilles' heel of any system. Better and faster hardware can improve systems to a certain point. However, for truly great performing systems, there is no substitute for properly written queries and designed indexes. In this session we'll take a look at some common query performance killers, along with some no so obvious things that we can do to our queries to make them as fast as possible. 2/5/2011 10:15:00 AM 2/5/2011 11:15:00 AM 3142 Erin Stellato Room 313 Room 313 Database administrators - you don't really trust your third party software vendors, do you? Software vendors - you think most of the DBAs out there are hiding things, don't you? Well guess what, you're both right! Join Erin Stellato (representing vendors) and Mike Walsh (representing customers) for an interactive session where they will tackle some of the toughest challenges that DBAs and vendors face. Attendees will walk out with a better understanding of what both parties can do to contribute to a successful relationship, as well as a set of fair questions to ask to set the right expectations from the start. 2/5/2011 1:30:00 PM 2/5/2011 2:30:00 PM 3143 Erin Stellato Room 313 Room 313 “The system is slow. It was much faster last week! This is taking forever.” Statements like these from users can be frustrating for any DBA, unless you have the data to prove how the system regularly performs. In this session we will cover some of the tools and techniques freely available to SQL Server DBAs for capturing baselines that can be used for measuring performance, capacity planning and understanding usage patterns. We also discuss how these utilities and their data can be used to identify warning signs and troubleshoot performance issues. Tools covered include: PerfMon, PAL, Profiler, ClearTrace, RMLUtils, who_is_active and SQL Server DMVs 2/5/2011 10:15:00 AM 2/5/2011 11:15:00 AM 3144 Deepak Puri Room 329 Room 329 Starting with Excel 2000, pivot tables have been able to use OLAP cubes as data sources. Since then, Excel has become the most widely adopted OLAP BI client tool for Analysis Services cubes. And new OLAP functionality has been introduced with each successive version of Excel. In this session we'll review Excel OLAP client functionality, survey what's new in Excel 2010 - and see how it all works with Analysis Services 2008 R2. 2/5/2011 10:15:00 AM 2/5/2011 11:15:00 AM 3431 Grant Fritchey Room 330 Room 330 To begin tuning your system and the queries that run on it, you must begin from a position of knowledge. The knowledge I’m talking about is knowing what is occurring on your systems. What kind of load is the server under? How many times is that stored procedure called? This session will present the basics of gathering and interpreting knowledge about your server and the queries running on it. We’ll cover a variety of topics from performance monitor, to server-side traces, to dynamic management objects. We’ll go over how to set these things up to monitor your system and how to interpret the data returned from them. This session is part of a full day of training which will be presented in May at SQL Rally in Florida. 2/5/2011 4:00:00 PM 2/5/2011 5:00:00 PM 3432 Evan Basalik Room 315 Room 315 Evan will discuss and demonstrate how to troubleshoot Reporting Services performance issues. This will cover both tools included in the product plus some real-world scenarios he has dealt with in the past. 2/5/2011 1:30:00 PM 2/5/2011 2:30:00 PM