SQLSaturday #41 - Atlanta 2010 4/24/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat41 Atlanta GA 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 408 Confio Software Gold Sponsor http://www.confio.com http://www.sqlsaturday.com/images/Confio_LogoLg_0106.jpg 60 170 520 Quest Software Gold Sponsor http://www.quest.com/sql-server/ http://www.quest.com/images/common/quest-logo.gif 60 170 537 Attunity Gold Sponsor http://www.attunity.com HTTP://www.attunity.com/images/logo_attunity.gif 60 170 541 Microsoft Gold Sponsor http://www.microsoft.com/sqlserver/2008/en/us/ http://i.microsoft.com/global/sqlserver/2008/en/us/PublishingImages/logo-header-sql08-dg.gif 60 170 546 SetFocus Gold Sponsor http://www.setfocus.com/ http://www.setfocus.com/~/media/Images/logo.ashx 60 170 552 expressor-software Gold Sponsor http://www.expressor-software.com/ http://www.sonetring.net/images/expressor_logo_with_tagline.png 60 170 414 Netserv Applications Inc Silver Sponsor http://www.netserv-appl.com http://www.netserv-appl.com/siteimages/templates/logo.jpg 60 170 464 CozyRoc LLC Silver Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 536 SQL Sentry Silver Sponsor http://www.sqlsentry.net http://www.sqlsentry.net/images/ext/SQLSentryLogo148.jpg 60 170 540 Telerik Silver Sponsor http://www.telerik.com/ http://www.sqlsaturday.com/files/16899d10-841a-4ee1-9c23-9c0e58a8e818.jpg 60 170 544 Intellinet Silver Sponsor http://www.intellinet.com http://www.intellinet.com/media/31199/intellinet_tagline.png 60 170 565 Fusion-io Silver Sponsor http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 438 WestClinTech Bronze Sponsor http://www.westclintech.com http://westclintech.com/portals/0/images/xldb_logo.jpg 60 170 494 Red Gate Software Bronze Sponsor http://www.red-gate.com/about/community_relations/sql_saturday.htm http://www.red-gate.com/images/redgatelogo_black.jpg 60 170 530 Apress Inc. Bronze Sponsor http://apress.com/ http://www.apress.com/resource/weblogo/apresssupportedbanner_small.gif 60 170 533 Manning Publications Bronze Sponsor http://www.manning.com http://www.manning.com/ugprogram/images/banner2.jpg 60 170 550 MATRIX Resources Bronze Sponsor http://www.matrixresources.com http://www.sqlsaturday.com/files/2f24ca14-df2c-4180-a1bc-4d3bdb12bec9.jpg 60 170 1270 Ryan Duclos 1 Grant Room 1 Having trouble or trying to figure out how you can navigate to your reports through your application, without creating a complete dashboard? This session will show you how to navigate and control your reports through your application using links. 4/24/2010 2:15:00 PM 4/24/2010 3:15:00 PM 1271 Ryan Duclos 2 Chastain Park Room 6 Do you need recursive queries, do you want your T-SQL to be easier to read and maintain? 4/24/2010 9:45:00 AM 4/24/2010 10:45:00 AM 1273 Janis Griffin 2 Midtown Room 7 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. 4/24/2010 9:45:00 AM 4/24/2010 10:45:00 AM 1274 Janis Griffin 2 Highlands Room 4 There are many ways to use SQL Server Wait types for performance tuning of a Microsoft database, but often there is confusion on exactly what the data means. The issue typically centers around the fact the wait event data is analyzed at the wrong level or the collected wait event data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using wait type data coupled with Wait-Time based performance analysis to solve the most difficult performance related issues. 4/24/2010 2:15:00 PM 4/24/2010 3:15:00 PM 1279 Aaron Nelson 2 Buckhead Room 5 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. 4/24/2010 1:00:00 PM 4/24/2010 2:00:00 PM 1280 Aaron Nelson 2 Chastain Park Room 6 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 in 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. 4/24/2010 2:15:00 PM 4/24/2010 3:15:00 PM 1309 Glen Gordon 2 Midtown Room 7 Durable data storage is a key component of any cloud computing offering. The Windows Azure Platform offers many options, which can be used alone or in combination. Windows Azure itself offers ready-to-use and lightweight storage in the form of tables, blobs, and queues. Another choice for storage is SQL Azure, a true relational database in the cloud. In this session, we’ll explore the highlights of these implementations and how to both create and use storage in each form. We’ll give you guidance on choosing the right forms of storage for your application scenarios. 4/24/2010 3:30:00 PM 4/24/2010 4:30:00 PM 1379 Troy Gallant 2 Chastain Park Room 6 SQL Server replication allows DBAs to distribute data to various servers throughout an organization. Some reasons to employ replication include load balancing, offline processing redundancy. Transactional replication in particular can offer a very flexible solution where data frequently changes. This session will discuss the basics of planning and implementation of a solid transactional replication solution. 4/24/2010 1:00:00 PM 4/24/2010 2:00:00 PM 1392 Audrey Hammonds 2 Chastain Park Room 6 I had a teacher once who told me that creating a great data model is one part science and two parts art. Boy, was she ever right! This session will be a look at the fundamentals of creating data models to support your business, both transactional and dimensional (warehouses). While we're at it, we'll look at some more advanced concepts and how to model your way out of some tricky situations. Topics include: 1) Normalization is beautiful - now let's discuss it in plain English 2) Raising a well-adjusted database - strategies for creating an adaptable model 3) All Hail Kimball - dimensions, facts, star-schema, and everything in between 4) Yo Olde Bag of Tricks - patterns and ideas for modeling your way out of sticky situation 4/24/2010 3:30:00 PM 4/24/2010 4:30:00 PM 1394 Louis Davidson 1 Piedmont Park Room 2 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). 4/24/2010 8:30:00 AM 4/24/2010 9:30:00 AM 1395 Louis Davidson 1 Piedmont Park Room 2 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. 4/24/2010 2:15:00 PM 4/24/2010 3:15:00 PM 1403 Robert Cain 1 Grant Room 1 Users have become familiar with the simple search capabilities of tools like Microsoft Live Search and Google. Did you know you can give your users the same ability to search their data with SQL Server? And it's as easy as 1-2-3! Come and learn the how to setup and use full text searching with SQL Server. 4/24/2010 3:30:00 PM 4/24/2010 4:30:00 PM 1404 Robert Cain 1 Grant Room 1 Business Intelligence is one of the hot job skills for 2010. In this talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean. You'll also get a peak at the tools available in SQL Server 2008. 4/24/2010 8:30:00 AM 4/24/2010 9:30:00 AM 1405 Robert Cain 2 Highlands Room 4 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. 4/24/2010 1:00:00 PM 4/24/2010 2:00:00 PM 1406 Mark Tabladillo 1 Grant Room 1 Excel provides a compelling and ubiquitous interface for Microsoft Data Mining. With new features available through PowerPivot, business users can apply the technology through a well-designed infrastructure of Microsoft technologies. This presentation will welcome any newcomers to data mining, and provide interactive demos which highlight data mining through these technologies. For advanced statisticians and data miners, the recommended deployment strategy draws from the CRISP-DM Process Model, Jeff Hawkins (Palm Pilot and Treo architect, and author of On Intelligence) and W. Edwards Deming. 4/24/2010 11:00:00 AM 4/24/2010 12:00:00 PM 1465 Noah Subrin 1 Grant Room 1 Have you been asked to deliver a data warehouse project? Do you need to provide access to Production data to end users? Do you see a need (or opportunity) to position data warehousing as a core technology? If you answered yes to any of these questions, a data warehouse assessment will help you increase your chances of success. This session will discuss what factors typically make up a data warehouse assessment, as well as the opportunities and challenges that are presented. 4/24/2010 4:45:00 PM 4/24/2010 5:45:00 PM 1480 Mike Femenella 2 Highlands Room 4 After an overview of partitioning and how to set up partition functions schemes we'll take a look at how to load data and instantly switch it into production without significant impact to your database availability. Topics covered: Partition Functions Schemes, Creating partitioned tables, The $partition function, Switch Statement and system tables for viewing partition information 4/24/2010 9:45:00 AM 4/24/2010 10:45:00 AM 1481 Mike Femenella 1 Centennial Park Room 3 Everything I wish someone had told me when I started with SQL Server years ago. An overview of using profiler to capture events Clustered, non clustered, covering indexes, looking at query plans (rid lookup, key lookup, scans vs seeks) When to use a table variable vs temp table 4/24/2010 8:30:00 AM 4/24/2010 9:30:00 AM 1483 Michael Clifford 2 Chastain Park Room 6 Spatial fields, operators, and functions were introduced in SQL 2008. I will detail how these can be integrated with location-based information in existing data warehouses and marts - and on the cheap. We will briefly discuss the basics (geometry versus geography, geocoding), then move on to the common problems with this task and the remedies. 4/24/2010 8:30:00 AM 4/24/2010 9:30:00 AM 1485 Dave Turpin 1 Centennial Park Room 3 Too often the query plan, or how the SQL Server engine actually implements the logical query, is ignored by developers and DBAs. The reason for not trying to dive into the meaning behind the hyro-glyphic plan is simple: It's not easy to understand what all those icons mean in isolation, never mind as a collection. This session will bridge the gap between the theory of internals, where the details are mentioned but not demonstrated, and the logical query. A series of actual query examples will show how queries are treated by the optimizer and why; what to do to identify slow performing queries, and how to make simple adjustments to allow the query to perform significantly better. 4/24/2010 4:45:00 PM 4/24/2010 5:45:00 PM 1496 David Rodriguez 1 Centennial Park Room 3 SQL Server 2008 R2 is the next release of SQL Server with many enhancements to the Base SQL Server 2008 product. This session will overview the significant features and enhancements in SQL Server 2008 R2. 4/24/2010 11:00:00 AM 4/24/2010 12:00:00 PM 1497 David Rodriguez 1 Centennial Park Room 3 This session will introduce all BI enhancements in SQL Server 2008 R2. 4/24/2010 2:15:00 PM 4/24/2010 3:15:00 PM 1498 David Rodriguez 1 Centennial Park Room 3 This session will introduce all enhancements in SQL Server 2008 R2 relevant to DBAs. These include improvements in manageability. 4/24/2010 3:30:00 PM 4/24/2010 4:30:00 PM 1505 Whitney Weaver 1 Piedmont Park Room 2 Dynamic Management Views were introduced in SQL Server 2005 and exist today as an extremely helpful tool to utilize for problem solving, both proactively and reactively. Come join Whitney Weaver as we run through scenarios where DMVs can improve the quality of your life. This will be a code heavy session with lots of takeaways! 4/24/2010 9:45:00 AM 4/24/2010 10:45:00 AM 1506 Whitney Weaver 1 Centennial Park Room 3 If the words 'regulatory compliance', 'data governance', or 'merger and acquisition' are voiced at your company you know the importance of keeping accurate master data. We have been given a new feature to help manage this in SQL Server 2008 R2, Master Data Services. Come join Whitney Weaver as we explore the business application of this feature. 4/24/2010 1:00:00 PM 4/24/2010 2:00:00 PM 1520 Chris Eargle 2 Chastain Park Room 6 REST is an architectural style that allows for a layered, scalable, and cacheable enterprise information system. With WCF Data Services, a database can be surfaced to a service as a REST-style resource collection that is addressable with natural URIs and can be interacted with using the usual HTTP verbs: GET, POST, PUT, and DELETE. This session will describe OData (the Open Data Protocol), the benefits it conveys, and its uses. Then we will set up a data service using an existing database that developers would then access rather than accessing the database directly. 4/24/2010 11:00:00 AM 4/24/2010 12:00:00 PM 1529 Chris Skorlinski 2 Buckhead Room 5 This sessions provides an overview of Merge Replication. Areas covered include setting up Merge Replication, configuring dynamic filtered subscribers, performing sychronization over the Internet. 4/24/2010 3:30:00 PM 4/24/2010 4:30:00 PM 1530 Chris Skorlinski 2 Buckhead Room 5 This sessions provides a walk through of Microsoft's newest SQL Replication feature called Change Data Capture (CDC). Sessions covers overview of CDC, setting up CDC and using various CDC functions to retrieve list of data changes. CDC is often used by data warehouse applications to retrieve list of SQL insert and updates for a given time window. 4/24/2010 2:15:00 PM 4/24/2010 3:15:00 PM 1536 Jennifer McCown 1 Piedmont Park Room 2 Learn the best of what NOT to do when writing Transact-SQL. Comment, format, and streamline your way to a happy and virtuous coding life! 4/24/2010 3:30:00 PM 4/24/2010 4:30:00 PM 1537 Jennifer McCown 2 Chastain Park Room 6 An introductory T-SQL course for those just beginning to use SQL Server. 4/24/2010 4:45:00 PM 4/24/2010 5:45:00 PM 1538 Meredith Ryan-Smith 2 Midtown Room 7 Many of us started our IT careers in the exact same way: 80-hour work weeks, routine overnight gigs, no life outside the office—this was simply what we considered “normal.” Today, with our careers underway, how do we build a life outside of our IT world? We will share the tips, tricks and tools we’ve discovered and used to create a work/life balance that allows us to feel fulfilled and refreshed outside the office while maintaining our effectiveness as successful data professionals. 4/24/2010 1:00:00 PM 4/24/2010 2:00:00 PM 1545 Geoff Hiten 2 Buckhead Room 5 failover Clustering is the fundamental technology for High Availability in the Microsoft SQL world. Windows 2008 and SQL 2008 make Clustering easier than ever. 4/24/2010 9:45:00 AM 4/24/2010 10:45:00 AM 1549 Jonathan Kehayias 2 Highlands Room 4 Event Notifications are a hidden gem in SQL Server 2005/2008, just waiting to provide you with real time information about problems inside of SQL Server. This session will provide a brief overview of the Service Broker components used by Event Notifications and then dive into how to build a monitoring solution for common problems in SQL Server like blocking and deadlocks that capture the needed information for troubleshooting in real time and provide email notification that a problem exists. 4/24/2010 3:30:00 PM 4/24/2010 4:30:00 PM 1550 Jonathan Kehayias 2 Buckhead Room 5 Auditing user activity in SQL Server has become a hot topic lately. From SOX and PCI to HIPPA, the security of personal data, and the ability to track who accessed the data and how has become extremely important. In this session, SQL Server MVP Jonathan Kehayias covers the various methods available in SQL Server 2000, 2005, and 2008 to accomplish this task including SQL Trace in SQL Server 2000 and 2005, and the new Server Audits in SQL Server 2008. 4/24/2010 8:30:00 AM 4/24/2010 9:30:00 AM 1555 Dan Murray 2 Highlands Room 4 Using MS SQL in conjunction with a visual analysis tool like Tableau can leverage can expand the use of your data. This session will demonstrate how rapid-fire visual analysis can enhance the value of your data stores and provide information consumers with ad hoc query capability along with easy interactive dashboard building. 4/24/2010 8:30:00 AM 4/24/2010 9:30:00 AM 1564 Tejas Patel 1 Grant Room 1 Session is intended to exhibit beginners, how to use data mining capabilities of SQL server. 4/24/2010 9:45:00 AM 4/24/2010 10:45:00 AM 1589 Kevin Boles 1 Centennial Park Room 3 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. 4/24/2010 9:45:00 AM 4/24/2010 10:45:00 AM 1594 Evan Basalik 2 Midtown Room 7 Evan will show you how to diagnose and solve common connectivity issues. This will include covering GNEs, Kerberos, and completely inaccessible SQL Servers. He will demonstrate how to use UDLs and network traces to easily identify the problem, plus provide tips that often solve the problem in seconds. 4/24/2010 4:45:00 PM 4/24/2010 5:45:00 PM 1595 Evan Basalik 2 Midtown Room 7 Evan will talk about how SQL Azure works behind the scenes, plus demonstrate how to use the cloud-based sibling of SQL Server. He will also discuss how to best design your applications to take advantage of the power of SQL Azure. 4/24/2010 2:15:00 PM 4/24/2010 3:15:00 PM 1596 Evan Basalik 1 Grant Room 1 Evan will demonstrate how to identify the bottlenecks in your SSRS environment, plus provide solutions to these same issues. He will discuss using the built-in SSRS diagnostics, plus show how to use other publically available tools to address issues the built-in tools cannot solve. 4/24/2010 1:00:00 PM 4/24/2010 2:00:00 PM 1605 Jack Corbett 1 Piedmont Park Room 2 With the proliferation of ORM Tools like Linq To SQL, NHibernate, there has been a move to no longer use stored procedures for Data Access, I personally disagree. This will be a professional and polite open discussion starting with why I believe stored procedures are the best way to access data in SQL Server. Alternate view points welcome. 4/24/2010 4:45:00 PM 4/24/2010 5:45:00 PM 1607 Kevin Boles 1 Piedmont Park Room 2 We are going to examine a variety of oopsies MANY developers fall prey too, some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. 4/24/2010 1:00:00 PM 4/24/2010 2:00:00 PM 1610 Kevin Boles 1 Piedmont Park Room 2 The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven't been shown the light you might never realize what is possible. Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques. 4/24/2010 11:00:00 AM 4/24/2010 12:00:00 PM 1617 Tejas Patel 2 Highlands Room 4 Intent of this session is to capabilities and functionalities of Streaminsight. 4/24/2010 4:45:00 PM 4/24/2010 5:45:00 PM 1641 Kendal Van Dyke 2 Midtown Room 7 Are you thinking of starting a blog? Or are you interested in presenting at events like SQL Saturday but not sure what to do to get started? This panel style session with established SQL bloggers will give you tips on blogging platforms, choosing topics, techniques for giving presentations, and sage advice from years of experience. 4/24/2010 8:30:00 AM 4/24/2010 9:30:00 AM 1642 Kendal Van Dyke 2 Midtown Room 7 Solid State Drives are being heralded as game changers in the world of SQL IO. What was once was a costly technology only available to those with deep pockets is now becoming affordable for mainstream use. This session look at how SSDs work, how they perform compared to traditional hard drives, and highlight the things you need to consider when implementing SSDs on your SQL Servers. Be sure not to miss a live demonstration of solid state technology in action! 4/24/2010 11:00:00 AM 4/24/2010 12:00:00 PM 1643 Kendal Van Dyke 2 Buckhead Room 5 This session will demonstrate the ways that ASP ASP.NET applications can be configured to make connections to SQL Server from different versions of IIS so that we can keep our servers secure and our DBAs happy. Session Goals: - Learn when to use SQL logins and when to use Windows Authentication - Understand the concept of impersonation - Learn how ASP and ASP.NET applications can be configured to use impersonation to make secure connections to SQL Server - Learn how to configure IIS 5, 6, 7 and Windows XP, 2003, and 2008 to support impersonation 4/24/2010 4:45:00 PM 4/24/2010 5:45:00 PM 1756 Chris Skorlinski 2 Highlands Room 4 Here is your chance to meet face-to-face is MS SQL Support. Meet Chris Skorlinski, member of Microsoft SQL Server Escalation Service Team for QA. Learn how MS Support approaches problem solving and look into some 'behind the scenes' work it takes to provide answers to your challenging problems. 4/24/2010 11:00:00 AM 4/24/2010 12:00:00 PM 1786 Geoff Hiten 2 Buckhead Room 5 Policy-Based Management, Central Management Server, Enterprise Policy Management Framework, and Powershell combine to allow automation of DBA tasks more than ever before. Put these pieces together to do more with less. 4/24/2010 11:00:00 AM 4/24/2010 12:00:00 PM