SQLSaturday #10 - Tampa 2009 1/24/2009 12:00:00 AM Free training event for SQL Server professionals #sqlsat10 Tampa FL 33605 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 129 KForce Platinum Sponsor http://www.kforce.com http://www.tampasql.com/images/KForce.gif 60 170 114 DevFish Gold Sponsor http://www.devfish.net http://www.tampasql.com/images/dfbanner30.jpg 60 170 84 End to End Training Gold Sponsor http://www.endtoendtraining.com http://www.endtoendtraining.com/Images/endtoendlogo.jpg 60 170 85 JumpstartTV.com Gold Sponsor http://www.jumpstarttv.com http://www.jumpstarttv.com/images/header_logo.jpg 60 170 111 Perpetual Technologies, Inc. Gold Sponsor http://www.perptech.com http://www.tampasql.com/images/2008PTIclrlogo.gif 60 170 119 Idera Gold Sponsor http://www.idera.com http://www.idera.com/images/Logo.jpg 60 170 125 BakBone Software Gold Sponsor http://www.bakbone.com http://tampasql.com/images/BakBone_COLOR_logo_150_dpi.jpg 60 170 126 Wrox Gold Sponsor http://www.wrox.com/WileyCDA/ http://media.wiley.com/assets/253/59/wrox_logo.gif 60 170 128 Confio Software Gold Sponsor http://www.confio.com http://www.sqlsaturday.com/images/Confio_LogoLg_0106.jpg 60 170 133 Apress, Inc. Gold Sponsor http://www.apress.com http://apress.com/img/masthead_logo.gif 60 170 134 Red Gate Gold Sponsor http://www.red-gate.com http://tampasql.com/images/Red-Gate_logo_v4_1.gif 60 170 137 VisualGov Solutions Gold Sponsor http://www.visualgov.com http://www.tampasql.com/images/VisualGov.jpg 60 170 116 NEC Americas Silver Sponsor http://www.necam.com/servers/enterprise http://www.necam.com/images/slogan/slogan_web.gif 60 170 120 TARGIT US Silver Sponsor http://www.targit.com http://www.targit.com/gfx/targit_logo.gif 60 170 121 Solid Quality Mentors Silver Sponsor http://www.solidq.com http://www.tampasql.com/images/SolidQ.jpg 60 170 122 Soaring Eagle Consulting Silver Sponsor http://www.soaringeagle.biz http://www.tampasql.com/images/soaring_eagle2.jpg 60 170 127 Quest Software Silver Sponsor http://www.quest.com http://www.quest.com/images/common/quest_logo.gif 60 170 132 SQL Server Magazine Silver Sponsor http://www.sqlmag.com http://windowsitpro.com/Common/adforceimages/062607_email_SQLLogo.gif 60 170 136 Durable Impact Consulting Silver Sponsor http://www.durableimpact.com http://www.tampasql.com/images/DurableImpactLogoForCC.jpg 60 170 115 Dell Bronze Sponsor http://www.dell.com http://i.dell.com/images/global/brand/ui/logo62.gif 60 170 124 Edgewood Solutions Bronze Sponsor http://www.edgewoodsolutions.com http://www.edgewoodsolutions.com/image/logo.jpg 60 170 256 Jonathan Kehayias Track 2 Track 2 Being a DBA consists of a number of repetative tasks that are both monotonous and mundane. Learn how to automate a number of the tasks a DBA does on a daily database to simplify management of large environments and free time up for other important tasks such as planning upgrades and identifying performance problems before they actually occur. 1/24/2009 9:45:00 AM 1/24/2009 10:45:00 AM 284 Nikita Polyakov Track 3 Track 3 SQL Compact Data Sync. Windows Mobile and beyond to a laptop or server near you. Come find out why SQL Compact and Sunc Services are your ticket to quick and easy local data cache. 1/24/2009 11:00:00 AM 1/24/2009 12:00:00 PM 290 John Magnabosco Track 2 Track 2 Databases often contain sensitive data. Without protection this data can fall into the hands of those who have less than honorable intentions. This can be disastrous for not only the business but also the client. In this session the encryption and hashing features of SQL Server will be explored as well as some guidance in determining what data should be considered sensitive. 1/24/2009 8:30:00 AM 1/24/2009 9:30:00 AM 292 Eric Wisdahl Track 4 Track 4 This session will look in depth at some of the more powerful aspects of Integrations Services: Expressions, Package Configurations, and Precedence Constraints. A short tutorial will show the users how to build up a package structure to allow logging to a remote location determined through configurations as well as capturing errors, destroying the error file if no errors are present and emailing a configurable user if any errors are found. 1/24/2009 9:45:00 AM 1/24/2009 10:45:00 AM 293 Andy Warren Track 1 Room 1 This is a beginner to intermediate level session that will show you how and why statistics are created, how the impact query plans, how to maintain statistics, and what to do when statistics works against you due to uneven data distribution. 1/24/2009 11:00:00 AM 1/24/2009 12:00:00 PM 295 Suzanne Meehle Track 6 Track 6 Damned If You Do, Damned If You Don't: Legal Liability Data Retention. You may be liable for the data you keep. You will be liable for the data you destroy. We will discuss the brave new world of e-discovery, liability, and effective database and data retention policies. In addition, you will receive practical guidance on protecting yourself and your company from legal liability and your data from theft and inadvertent disclosure. 1/24/2009 4:00:00 PM 1/24/2009 5:00:00 PM 296 Rodney Landrum Track 4 Track 4 This session will demonstrate the numerous ways to quickly and efficiently import and export large data volumes to SQL Server. Using BCP, BULK INSERT, OPENROWSET and third party tools, you will learn how to 'minimally' log transactions to avoid run away log file growth as well as the best method to backup and restore large databases, 300GB or more. We will see how much we can fill a database in the course of the hour and discuss why we (or your business) would want to store so much data in the first place. 1/24/2009 1:30:00 PM 1/24/2009 2:30:00 PM 297 David Hayden Track 3 Track 3 You have optimized and tuned your SQL Server Database and now you need to access the data from your application. Learn and explore the variety of ways you can access the data using the Data Access Application Block, LINQ To SQL, ADO.NET Entity Framework, ADO.NET Data Services, Subsonic, and the ASP.NET 3.5 Dynamic Data Framework. In this session we will walk-thru and build several examples for each technique as well as discuss tips, strengths, and weaknesses. Come with your questions and explore the wonderful world of data access to SQL Server! 1/24/2009 9:45:00 AM 1/24/2009 10:45:00 AM 298 Max Trinidad Track 3 Track 3 Learn some differences between PowerShell and the SQLPS 'SQL Server PowerShell'. See how you can use PowerShell to manage, and/or manipulate data in your SQL Engine and their Databases. 1/24/2009 1:30:00 PM 1/24/2009 2:30:00 PM 299 Plamen Ratchev Track 2 Track 2 This session will present new T-SQL enhancements in SQL Server 2008 including MERGE, table valued parameters, new data types (Date and Time related, FILESTREAM, HIERARCHYID), table value constructors, sparse columns, filtered indexes, delighters, and more. 1/24/2009 11:00:00 AM 1/24/2009 12:00:00 PM 301 Jeffrey Garbus Track 2 Track 2 This session describes everything you ever wanted to know about physical index structures, as well as how the optimizer chooses indexes for performance. (Join performance in separate session!) 1/24/2009 1:30:00 PM 1/24/2009 2:30:00 PM 303 Ronald Dameron Track 3 Track 3 I will detail my reasoning why a DBA would benefit from learning PowerShell. I will demonstrate how a DBA can use PowerShell in conjunction with SQL, WMI, and SMO to automate repetitive tasks and better manage their workload. 1/24/2009 2:45:00 PM 1/24/2009 3:45:00 PM 304 Kent Waldrop Track 1 Room 1 MVP Kent Waldrop takes a quick tour of a few of the SQL issues that come up frequently in the MSDN Transact SQL forum. Some of the topics covered include set oriented processing, pitfalls of user defined functions, working with string lists, filtering by date and time and more. 1/24/2009 2:45:00 PM 1/24/2009 3:45:00 PM 305 Tim Mitchell Track 4 Track 4 In this session, we will explore the Script Task and Script Component tools within SSIS. Learn how to break out of the traditional flat-file ETL mold and, using VB.NET or C#, create custom scripts to address unconventional transformations and related tasks. 1/24/2009 8:30:00 AM 1/24/2009 9:30:00 AM 307 Vikas Hawaldar Track 5 Track 5 Introduction to Data Mining using SQL Server Basic concepts and lifecycle of a Data Mining project using SQL Server 2005/2008 1/24/2009 9:45:00 AM 1/24/2009 10:45:00 AM 310 Brian Knight Track 5 Track 5 Learn how to use Analysis Services 2008 to better analyze and visual your data. In this session, Brian will introduce you quickly to data warehousing and then dive quickly in SSAS and how to present your data as cubes. 1/24/2009 8:30:00 AM 1/24/2009 9:30:00 AM 311 Brian Knight Track 4 Track 4 In this session, you'll see common ways that DBAs can use SSIS to make their lives easier. In one example, Brian shows how to gather common metrics from your servers using SSIS and in another example, you'll see how to create an archiving solution for your backups. 1/24/2009 11:00:00 AM 1/24/2009 12:00:00 PM 312 Arie Jones Track 6 Track 6 With the release of SQL Server 2008 this year Microsoft also releases its flagship reporting system piece, SQL Server Reporting Services, with more of the oh so delightful reporting features we have been craving. Come see some of the new features and interacting with some of the web services to allow you to take your reporting services skills to the next level! 1/24/2009 11:00:00 AM 1/24/2009 12:00:00 PM 317 Arie Jones Track 3 Track 3 Running .NET code within SQL Server 2008 has been a major controversy in the past couple of years. Do you allow it or not? What are the implications? Does this mean that the .NET developers can run amok in my database?! Don’t miss out on a golden opportunity to implement this within your infrastructure because you simply don’t know the answers! This session will go over everything that you need to know in order to implement SQLCLR code within your database environment as well as showing you how to create your own user-defined functions, types, and aggregates. Along the way, I will show you some tips and tricks that will ensure you have a successful implementation. 1/24/2009 8:30:00 AM 1/24/2009 9:30:00 AM 318 Chris Rock Track 6 Track 6 This session will show the attendee how easy it is to quickly display your data on a web page with a minimum amount of code. We will cover displaying, editing, deleting and inserting data. 1/24/2009 8:30:00 AM 1/24/2009 9:30:00 AM 319 Mike Wells Track 5 Track 5 Are you looking to get certified in 2005 or 2008? Do you want to upgrade a certification you already have? Join us for this dive into the new MS Certification paths for Visual Studio 2005 and SQL Server 2005 and see what's changing for 2008. 1/24/2009 11:00:00 AM 1/24/2009 12:00:00 PM 320 Ryan Dorrell Track 5 Track 5 Adding test data into your database can be a time-consuming, boring exercise - but you need valid data scenarios, a range of inputs, and the ability to easily generate large volumes of test data rapidly. With Visual Studio 2008 Database Edition ('Data Dude') find out how you can leverage the powerful tools available to fine-tune your test data, and rapidly generate the data you need to fully test your apps! 1/24/2009 4:00:00 PM 1/24/2009 5:00:00 PM 321 Roger Doherty Track 1 Room 1 Hear how the Media Advertising Platform Initiatives team at Microsoft used technology and a key hosting partner to monitor the health of the largest online video event in history, the 2008 Summer Olympic Games on NBCOlympics.com. Learn how we used dynamic instrumentation in Silverlight 2 to monitor application and video quality health information for 400,000 simultaneous users, how we leveraged a hosting partner to rapidly deploy and manage an episodic data center, and how we built the data collection and analysis components using Windows Server 2008, Visual Studio 2008, .NET Framework 3.5, and SQL Server 2008. 1/24/2009 4:00:00 PM 1/24/2009 5:00:00 PM 322 Jean-Claude Armand Track 1 Room 1 This session will cover SQL Server 2008 adoption momentum in addition to the scheduled 2 SQL Server release that are currently schedule to be release during the next 36 months. As part of this session we will discuss in details of the upcoming release of SQL Server Kilimanjaro release and schedule around SQL11. 1/24/2009 9:45:00 AM 1/24/2009 10:45:00 AM 323 Rushabh Mehta Track 4 Track 4 As more and more organizations and teams within organizations have started adopting SQL Server Integration Services for data processing and other management task automation, there is increasing need for standardization early in the process to avoid common management problems that arise from lack of standardization and good management techniques. In this session, we will help you identify areas of standardization and pitfalls that arise from lack of standards, reviews some common standardization approaches and best practices and finally walk you through a standardized template example that can be customized, deployed and used as a starting point for an SSIS project. 1/24/2009 2:45:00 PM 1/24/2009 3:45:00 PM 324 Rushabh Mehta Track 4 Track 4 As more and more organizations and teams within organizations have started adopting SQL Server Integration Services for data processing and other management task automation, there is increasing need for standardization early in the process to avoid common management problems that arise from lack of standardization and good management techniques. In this session, we will help you identify areas of standardization and pitfalls that arise from lack of standards, reviews some common standardization approaches and best practices and finally walk you through a standardized template example that can be customized, deployed and used as a starting point for an SSIS project. 1/24/2009 4:00:00 PM 1/24/2009 5:00:00 PM 325 Dean Richards Track 2 Track 2 Using Wait Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Wait-Time based performance analysis to solve the most difficult performance related issues. 1/24/2009 2:45:00 PM 1/24/2009 3:45:00 PM 326 Chad Miller Track 5 Track 5 Provide an overview using simple tools that generate standard RSS feeds containing information regarding SQL Server jobs; ad-hoc queries and database size and space allocation information. This session will demonstrate using RSS to automate a daily DBA morning checklist by aggregating error logs, backup and additional information across multiple servers/databases. 1/24/2009 2:45:00 PM 1/24/2009 3:45:00 PM 329 Michael Antonovich Track 1 Room 1 Perhaps you inherited a database with one or more tables having duplicate potential keys or maybe even entire duplicate records or maybe you generated a recordset from a SELECT statement that has duplicate records. In any case, you have a problem. You need to identify which tables have duplicate records or duplicate index values, isolate those records, and then delete only the duplicate records from the table. This session will focus on the functions and methods that you can use to identify and remove duplicate data from your tables. 1/24/2009 8:30:00 AM 1/24/2009 9:30:00 AM 330 Sam Nasr Track 3 Track 3 SQL Server has been around for many years with each version bringing more features, and for 2008 it's no different. The latest version has many new features specific for developers aimed at producing more efficient code. Some of those features include Table Value Parameters, Hierarchy ID, and Grouping sets. Attend this session and be among the first to leverage the new features of SQL Server 2008. 1/24/2009 4:00:00 PM 1/24/2009 5:00:00 PM 331 Jessica Moss Track 6 Track 6 Are you frustrated with building reports in SQL Server Reporting Services? Tired of telling your users that you can't give them the perfect report due to limitations in the product? If so, this session will calm your nerves and make you a guru by showing how to utilize custom code and expressions to shine up your new or existing reports. Specifically, we will show how to create dynamic data groups, use paging techniques, add color and formatting, and more. This session is best suited for people with some knowledge of either SSRS 2005 or SSRS 2008. 1/24/2009 1:30:00 PM 1/24/2009 2:30:00 PM 335 Andreas Etelkozi Track 1 Room 1 Data Scrambling is aimed to assist DBA-s to represent schema, data volume and characteristics of data without divulging PII and other real data. Data scrambling provides a realistic data environment for demonstration, training or testing purposes. This presentation will give an understanding of the levels, problems and possible solutions of Data Scrambling, together with a practical demonstration. 1/24/2009 1:30:00 PM 1/24/2009 2:30:00 PM 336 James McAuliffe Track 2 Track 2 Bring application changes and database changes together at last! This session will discuss the tools recently provided in the newest Visual Studio Database Edition GDR - RTM for comparing schemas and data, and building deployment scripts. The recent architectural changes made for this release make it a brand new product, and bring a little bit of Rosario to the 2008 team system today. The following areas will be explored: • Schemas, DML and metadata can be versioned • Build and deploy as separate processes. • DDL code can be automatically reviewed using static analysis • Unit tests can be created and executed to ensure data quality and integrity • Comparisons can be made with test and production systems prior to deployment • Tool 1/24/2009 4:00:00 PM 1/24/2009 5:00:00 PM 337 Jessica Moss Track 6 Track 6 Improving the experience for users of your .NET application can be as simple as adding a SQL Server Reporting Services report. In a few easy steps, you can create an SSRS report, embed the report, and allow users to interact with it. This session will discuss best practices and show demos for different reporting and application scenarios. 1/24/2009 2:45:00 PM 1/24/2009 3:45:00 PM