SQLSaturday #21 - Orlando 2009 10/17/2009 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat21 Orlando FL 32773 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 280 SQLShare.com Gold Sponsor http://www.sqlshare.com http://www.sqlshare.com/sqlshareimages/sqlshare_header_logo.jpg 60 170 292 Seminole Community College Gold Sponsor http://www.seminolestate.edu/ http://www.seminolestate.edu/media/2009/seminole-state-college.gif 60 170 309 Confio Software Gold Sponsor http://www.confio.com http://www.sqlsaturday.com/images/Confio_LogoLg_0106.jpg 60 170 296 Red Gate Software Silver Sponsor http://www.red-gate.com/about/community_relations/sql_saturday.htm http://www.sqlsaturday.com/files/982e5c8b-8a32-47f4-b11a-61cc91b99e7a.jpg 60 170 281 Pearson Education Bronze Sponsor http://www.informit.com/ http://www.informit.com/display/InformIT/images/psts/User_Group_Logo.gif 60 170 298 DevFish Bronze Sponsor http://www.devfish.net http://www.devfish.net//images/dfbanner1.jpg 60 170 308 Quest Software Bronze Sponsor http://www.quest.com/ http://www.quest.com/images/common/quest-logo.gif 60 170 317 O'Reilly Media, Inc Bronze Sponsor http://oreilly.com/ http://oreilly.com/images/oreilly/oreilly.gif 60 170 318 Apress, Inc. Bronze Sponsor http://www.apress.com http://www.sqlsaturday.com/files/15cf709f-111e-4a8d-b5e5-be375e3f85f5.jpg 60 170 320 Soaring Eagle Consulting Bronze Sponsor http://www.soaringeagle.biz http://www.sqlsaturday.com/images/soaring_eagle.jpg 60 170 329 SQL Server Magazine Bronze Sponsor http://www.sqlmag.com http://windowsitpro.com/Common/adforceimages/062607_email_SQLLogo.gif 60 170 625 Joe Homnick Design (V101) V101 Microsoft SQL Azure Database is a cloud-based relational database platform built on SQL Server technologies. With SQL Azure Database, you can easily provision and deploy relational database solutions to the cloud, and take advantage of a globally distributed data center that provides enterprise-class availability, scalability, and security with the benefits of built-in data protection, self-healing and disaster recovery. There is a huge investment going on in moving the infrastructure to the cloud. Come check out the future.at this session. 10/17/2009 2:45:00 PM 10/17/2009 3:45:00 PM 627 Jack Corbett SSRS (V107) V107 Beginning with SQL Server 2005 Microsoft included a Default Trace auditing many events. This trace is used by many of the reports included with SSMS and can be mined for information about who has logged into your server, who created/changed/dropped objects, and much more! Learn how to use this resource to audit and manage your SQL Servers! 10/17/2009 4:00:00 PM 10/17/2009 5:00:00 PM 628 Nathan Heaivilin Security (J107) J107 An introductory session on the different types of execution plans, how to generate each of them, the pro's and cons of each of them, and how to read an execution plan. 10/17/2009 10:15:00 AM 10/17/2009 11:15:00 AM 629 Michael Stark Development 1 (J108) J108 A walkthru of the Geometry and Geography Data Types in SQL Server 2008. Demonstration will include Geographic points and shapes. After discussing the features in SQL Server there will be a demonstration of using Virtual Earth to display the data from SQL Server interactively. 10/17/2009 10:15:00 AM 10/17/2009 11:15:00 AM 640 Dmitri Korotkevitch Design (V101) V101 The session shows some tips and tricks useful for the database design of the highly loaded OLTP systems. 10/17/2009 11:30:00 AM 10/17/2009 12:30:00 PM 642 Ken Simmons Administration (V006) V006 In order to sustain a SQL Server instance that provides optimum performance, it requires constant maintenance. Luckily, you can use the same tools within SQL Server to automate maintenance tasks that you use to meet the business needs of the organization. This session will cover the tasks you need to perform in order to maintain a healthy instance of SQL Server as well as the tools you can use to automate them. 10/17/2009 11:30:00 AM 10/17/2009 12:30:00 PM 643 Jorge Segarra Administration (V006) V006 We will be learning an overview of this powerful new feature in SQL 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Servers! 10/17/2009 10:15:00 AM 10/17/2009 11:15:00 AM 647 Jeffrey Garbus Performance (V003) V003 Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session 10/17/2009 10:15:00 AM 10/17/2009 11:15:00 AM 648 Jeffrey Garbus Performance (V003) V003 Everything you wanted to know about join optimization but were afraid to ask... Join types, indexing, and how the optimizer makes its selections 10/17/2009 11:30:00 AM 10/17/2009 12:30:00 PM 651 Andy Warren SSRS (V107) V107 Should you be networking? In this session we'll talk about why you should be building a network now, how to build it, and how to keep track of and quantify your network. Along the way we'll talk about the most common social networks, why you should consider blogging, and some exercises you can do to strengthen your networking skills. 10/17/2009 2:45:00 PM 10/17/2009 3:45:00 PM 652 Chris Eargle Development 1 (J108) J108 REST is an architectural style that allows for a layered, scalable, and cacheable enterprise information system. With ADO.NET 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 RESTful Data, 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. 10/17/2009 2:45:00 PM 10/17/2009 3:45:00 PM 657 Max Trinidad Development 2 (V105) V105 Learn how DBA's and Developers can take advantage of this new .NET scripting technology - PowerShell 2.0. This is a 'most' to learn IT/.NET skill. In this session will discuss the difference between using SMO and the new integrated SQLPS in assisting managing your SQL Server 2000/2005/2008. Covering SMO samples and other third-party PowerShell tool. 10/17/2009 1:30:00 PM 10/17/2009 2:30:00 PM 659 Devin Knight SSIS (J105) J105 This is part 1 of a session that will get you past the learning curve of SSIS. Devin will cover the basics of the development environment that is used to build SSIS packages. He will show how to create an end to end package that covers many of the concepts in SSIS. This session will be great for anyone who is a beginner to SSIS. 10/17/2009 10:15:00 AM 10/17/2009 11:15:00 AM 660 Devin Knight SSIS (J105) J105 This is part 2 of a session that will get you past the learning curve of SSIS. Devin will cover additional beginner level SSIS topics. You will learn the basics of using variables/expressions and different deployment techniques. This session will be great for anyone who is a beginner to SSIS. 10/17/2009 11:30:00 AM 10/17/2009 12:30:00 PM 663 Herve Roggero Security (J107) J107 This presentation will focus on SQL Server security, specifically focusing on encryption. We will first take a tour of different encryption methods including hashing and encryption then move into specific examples on how to implement encryption at different levels. Parts of this presentation will include C# code. 10/17/2009 4:00:00 PM 10/17/2009 5:00:00 PM 667 Chad Miller Development 2 (V105) V105 In this sesssion we will look at automating common DBA tasks through Powershell. An overview of the CodePlex project SQL Serer Powershell Extensions will be provided. Specific topics covered include PowerGUI, SQL Server security/permissions reporting, SSIS administration, replication and agent tasks, performing ETL with Powershell. 10/17/2009 2:45:00 PM 10/17/2009 3:45:00 PM 679 Kevin Boles Administration (V006) V006 Lets get down and dirty on some fundamentals and a few details of how SANs work and how we can best utilize and tune them to improve SQL Server's IO performance and reliability. 10/17/2009 9:00:00 AM 10/17/2009 10:00:00 AM 682 Patrick Thompson Design (V101) V101 This talk will look at the implications of cloud computing for Sql databases. Topics covered will include: What’s in the cloud, data processing or both? Running Sql in the cloud. Sql alternatives in the cloud, SimpleDB, DIY indexing. Stuff that definitely won’t work in the cloud (not at the moment anyway). The talk will be focused mostly on the use of Amazon’s S3, SimpleDB and EC2 with a bit of Rackspace Mosso thrown in. It will demo setting up S3 buckets and EC2 instances. What’s involved in getting Sql Server running on them (including licensing implications) and discuss some of the speaker’s experience in working with the Amazon environment. 10/17/2009 4:00:00 PM 10/17/2009 5:00:00 PM 683 Brian McDonald SSRS (V107) V107 Reporting Services Rocks! If you haven't seen it yet, this is one you will not want to miss. In this session, I will introduce the audience to Reporting Services 2008. An overview of the new and improved architecture will be given. Demo's will show how to create a report using the built in wizard and from scratch with a blank report canvas. I will also show the user how to deploy the report for general usage. 10/17/2009 9:00:00 AM 10/17/2009 10:00:00 AM 684 Dean Richards Development 1 (J108) J108 Many DBAs and Developers are faced with tuning poorly performing SQL statements. 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 time data, indexing strategies, column selectivity and several more that will help the you succeed on future tuning projects. 10/17/2009 11:30:00 AM 10/17/2009 12:30:00 PM 685 Telmo Sampaio Development 1 (J108) J108 Learn about the new features in SQL Server 2008 that support non-structured and semi-structured data. You will learn about filestreams, sparse columns, hierarchy ids, and geo spatial data and be exposed to these technologies with comprehensive demos of each as well as technical insight on when and how to use them. This session is based on a real project and how it took advantages of the new technology in SQL 2008 compared to its first version in SQL 2005. 10/17/2009 9:00:00 AM 10/17/2009 10:00:00 AM 688 Michael Antonovich Development 1 (J108) J108 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 10/17/2009 1:30:00 PM 10/17/2009 2:30:00 PM 690 Adam Jorgensen SSAS (V111A) V111A Want to find out how to decrease processing time, improve query performance and leverage the real scale of your analysis services environment? Check out this session for can't miss tips for these topics and more !! 10/17/2009 1:30:00 PM 10/17/2009 2:30:00 PM 691 Brian Knight SSAS (V111A) V111A In this session, you’ll learn how to build a highly efficient analytical platform by using Analysis Services (SSAS). You’ll learn the how to create and configure a cube to pre-aggregate your data and then how to create hierarchies to make your users more effective. Lastly, Brian will cover the basic tabs that are available to you in SSAS. 10/17/2009 9:00:00 AM 10/17/2009 10:00:00 AM 692 Brian Knight SSAS (V111A) V111A The MDX query language is one of the toughest and most powerful languages in your arsenal as a business intelligence developer. In this session, you’ll start from the ground-up learning how to create a basic MDX statement and then quickly how do you solve complex business problems with this well-structured language. 10/17/2009 11:30:00 AM 10/17/2009 12:30:00 PM 694 John O'Shea Design (V101) V101 When storing SSIS connection strings using SQL accounts in a database, how do you keep the passwords secure? One method is to encrypt the column in the table SSIS Configurations are stored in present that table to your users as a view with built-in logic to either show or obscure the password data based on their role. This session will take you through a complete solution, including code to encrypt or not based on whether a password is present. 10/17/2009 1:15:00 PM 10/17/2009 1:30:00 PM 695 Christian Loris SSIS (J105) J105 An explanation of Slowly Chaning DImensions in a data model and how SSIS can help you maintain them. 10/17/2009 9:00:00 AM 10/17/2009 10:00:00 AM 696 Andy Leonard Design (V101) V101 Based on the popular Example of Test-Driven Development series at SQL Server Central, this session focuses on Database Development as part of the Application Lifecycle Management (ALM) process. Examples demonstrate how to test, but the session focuses on the benefits of testing database scripts. T-SQL error trapping, database projects, test artifacts, and source control are also discussed. 10/17/2009 9:00:00 AM 10/17/2009 10:00:00 AM 699 Rodney Landrum Administration (V006) V006 The SQL Server Error Logs contain vital information for the day to day DBA. For 1 to 10 servers, reviewing the error logs can be an enlightening experience done manually. For 200+ servers it is more than a chore and automating the consolidation and analysis of the error log contents is essential to be a successful DBA. From failed login attemtps to data corruption, this session will show you how to maintain error log history, raise errors in code that will write to the error log and most importantly, centralize and report on specific errors across multiple servers. The solution will use several different technologies including SSIS and the MERGE statement, new to SQL Server 2008. 10/17/2009 2:45:00 PM 10/17/2009 3:45:00 PM 703 Jonathan Kehayias Security (J107) J107 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. 10/17/2009 11:30:00 AM 10/17/2009 12:30:00 PM 704 Jonathan Kehayias Development 2 (V105) V105 Understanding when and how SQL Server waits to continue executing can be a powerful tool for troubleshooting problems with SQL Server. In this session SQL Server MVP Jonathan Kehayias dives into how to look at and use wait statistics to determine the cause of performance problems inside of SQL Server. Learn what wait types mean, which types are signs of trouble, and how to determine the root cause of your performance problems in the shortest time possible. 10/17/2009 4:00:00 PM 10/17/2009 5:00:00 PM 706 Kevin Kline Administration (V006) V006 Learning how to detect, diagnose and resolve performance problems in SQL Server can be very difficult. It often takes years of on-the-job experience to learn how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. This hands-on session will take you from the very start of a problem situation on SQL Server, showing you how to use the native tools that help you keep SQL Server at top performance. 10/17/2009 1:30:00 PM 10/17/2009 2:30:00 PM 707 Ronald Dameron Performance (V003) V003 Database Hardening - Standardization, Optimization, and Automation. I will cover how I handle these issues in a very large environment that has over 500 database servers and 3600 databases. My talk will touch on my use of PowerShell, Policy Based Management, the Enterprise Policy Management Framework, and an internally development DBA utility database to manage this inventory. 10/17/2009 1:30:00 PM 10/17/2009 2:30:00 PM 708 Mike Davis SSIS (J105) J105 Learn how to make your SSIS packages dynamic, by using Configuration Files, Configuration Tables, Parent to Child Package Relationships. You will see how to use variables and expression together in all areas of a package and understand how to update multiple packages with a single change without having to redeploy packages multiple times. 10/17/2009 1:30:00 PM 10/17/2009 2:30:00 PM 709 Jorge Segarra Development 2 (V105) V105 This is a quick 15-minute presentation on how you can leverage the power of Twitter, one of the hottest social networking tools, to help you become a better SQL professional. 10/17/2009 1:15:00 PM 10/17/2009 1:30:00 PM 710 Mike Mollenhour SSAS (V111A) V111A In this session I will demonstrate datamining with SQL Analysis Services. This session will demonstrate the analytic powers incorporated into the SQL AS Engine, and show how these can be integrated with Reporting Services and Excel.This session will mainly focus on new features available for SQL 2008 10/17/2009 10:15:00 AM 10/17/2009 11:15:00 AM 711 Wes Dumey SSAS (V111A) V111A In this session you will learn the fundamentals of data warehousing and how to effecively design and build a data warehouse system using a real-world example. The tools of choice will be SQL Server 2008 and SQL Server Integration Services. 10/17/2009 2:45:00 PM 10/17/2009 3:45:00 PM 713 Jim Blizzard Development 2 (V105) V105 Ever make a bunch of changes to your database then lose track of what you’ve changed? Frustrated with trying to come up with consistent, “meaningful” test data to test your applications? Wish you could unit test your database? Ever forget to make a backup copy of your stored procedure before you made that one line change (that happens to crash the system)? Tired of feeling like you’re not part of the team? We’ll take a look at how Team System can help ease the pain of database development and change management. 10/17/2009 11:30:00 AM 10/17/2009 12:30:00 PM 714 Buck Woody Administration (V006) V006 SQL Server 2008 introduces a new feature called the 'Resource Governor'. It allows you to set limits (both minimum and maximum) on your SQL Server Instance's use of CPU and Memory - helping to prevent runaway queries, shoring up your Service Level Agreements, and aiding in consolidating your SQL Server databases onto fewer Instances or even in Virtualization. Come hear Buck Woody, Microsoft's 'Real World DBA', present an introduction to this feature, and show you an overview of its functionality and flow. 10/17/2009 4:00:00 PM 10/17/2009 5:00:00 PM 717 Elijah Baker Design (V101) V101 In this session I will go over what database partitioning is and what the structures are to implement it. There will be some general information on partitioning strategies. 10/17/2009 10:15:00 AM 10/17/2009 11:15:00 AM 719 Kathy Malone Security (J107) J107 There may never have been a better time since the start of the Internet to launch that technology business you've always wanted! With Microsoft having the largest product launch in its history between now and next April, plus awesome Microsoft support tools for startups, students, and partners, you have no excuse not to! Whether you are thinking part or full time, software, SaaS, S+S, consulting, hosting, or any other variation, there is something new on the horizon to help your new business take off! Come hear about the free tools Microsoft is making available, hear about 'gotchas' you need to think about as you go forward, and hear about different business models. Focus is on building a business sustainably. 10/17/2009 9:00:00 AM 10/17/2009 10:00:00 AM 720 Patrick LeBlanc Development 1 (J108) J108 In this session I will demonstrate how to use a couple of CLR Stored Procedures and the SQL Server Agent to monitor disk space in an Enterprise with several SQL Servers. 10/17/2009 4:00:00 PM 10/17/2009 5:00:00 PM 721 Eric Wisdahl SSIS (J105) J105 Most developers would agree that every SSIS solution will have the same fundamental outline. A basic framework will expedite the process by handling the common tasks between the systems while allowing the developer to concentrate on the task at hand. This framework will consist of many items, including but not limited to setting up package configurations, logging, audit trails, error handling, naming standards, etc. This session will present an example framework which can be used as the basis for future SSIS Package development. 10/17/2009 2:45:00 PM 10/17/2009 3:45:00 PM 722 Eric Wisdahl SSIS (J105) J105 Most developers would agree that every SSIS solution will have the same fundamental outline. A basic framework will expedite the process by handling the common tasks between the systems while allowing the developer to concentrate on the task at hand. This framework will consist of many items, including but not limited to setting up package configurations, logging, audit trails, error handling, naming standards, etc. This session will present an example framework which can be used as the basis for future SSIS Package development. 10/17/2009 4:00:00 PM 10/17/2009 5:00:00 PM 728 Todd Holmes Performance (V003) V003 This session will review recovery models, backup types and restore procedures. 10/17/2009 1:15:00 PM 10/17/2009 1:30:00 PM 729 Kendal Van Dyke Security (J107) J107 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 10/17/2009 2:45:00 PM 10/17/2009 3:45:00 PM 730 Kendal Van Dyke Security (J107) J107 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, featuring SQL bloggers Andy Warren, Jack Corbett, and Kendal Van Dyke, will give you tips on bloging platforms, choosing topics, techniques for giving presentations, and sage advice from years of experience. 10/17/2009 1:30:00 PM 10/17/2009 2:30:00 PM 732 Kendal Van Dyke Performance (V003) V003 DMVs offer a wealth of information about how your SQL Server is performing, yet are often an underutilized resource. This session will offer a brief tour of the DMVs available in SQL Server 2005 2008 and show how they can be used to take performance baselines, tune indexes, analyze hardware performance, troubleshoot problems, and more. 10/17/2009 9:00:00 AM 10/17/2009 10:00:00 AM 733 Brandie Tarvin Development 2 (V105) V105 Beginning T-SQL, part 1. The things every DBA needs to know to translate a user request into a workable Select statement. 10/17/2009 9:00:00 AM 10/17/2009 10:00:00 AM 734 Brandie Tarvin Development 2 (V105) V105 Beginning T-SQL part 2. This session builds on the lessons of 'English Requests to SQL Query', teaching beginners how to filter their result sets with some of the most common T-SQL constructs. 10/17/2009 10:15:00 AM 10/17/2009 11:15:00 AM 736 Jonathon Moorman Design (V101) V101 A look at the Sql Server catalog views to understand the contents of your database. From there we'll utilize the catalog views to generate templates that help uncover potential issues within our database. We will also use the catalog views to create useable templates and enforce local T-SQL coding standards. 10/17/2009 1:30:00 PM 10/17/2009 2:30:00 PM 737 Bob Blaydes Administration (V006) V006 Requirements elicitation is often where success in a Business Intelligence (BI) deployment lives or dies. In this Mini session we will take a quick look at how business process driven requirements can mean the difference between standard reporting and true BI. 10/17/2009 1:15:00 PM 10/17/2009 1:30:00 PM 738 Pam Shaw SSRS (V107) V107 This session we will present methods to create very dynamic reports. We will demonstrate data driven formatting and layouts. We will review how to setup data sources that are more portable as well as see how templates make it easier to have more consistent report formats. We will review emailing reports and how this can be integrated into your current application. 10/17/2009 1:30:00 PM 10/17/2009 2:30:00 PM 745 Joe Webb SSRS (V107) V107 Providing information to those that need it when they need it is key for many businesses. But, being able to automatically disseminate critical information in a timely fashion can be a challenge. In this session, we will discover how data-driven subscriptions in SQL Server Reporting Services can be used to effectively deliver reports to a varying list of subscribers. 10/17/2009 11:30:00 AM 10/17/2009 12:30:00 PM 746 Joe Webb Performance (V003) V003 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. 10/17/2009 2:45:00 PM 10/17/2009 3:45:00 PM 759 Scott Klein SSAS (V111A) V111A TBA 10/17/2009 4:00:00 PM 10/17/2009 5:00:00 PM 762 Kendal Van Dyke Security (J107) J107 Thought about trying a third party backup tool but haven't found the time? Looking for some insight from someone that has used it to see if it works as well as the advertising says it does? In this mini presentation Kendal Van Dyke will discuss installing and using SQL Backup by Red Gate. Great session to get a better look at what this product has to offer. 10/17/2009 1:15:00 PM 10/17/2009 1:30:00 PM 805 Joe Celko Performance (V003) V003 This is a placeholder, final topic description coming soon! 10/17/2009 4:00:00 PM 10/17/2009 5:00:00 PM 809 Delbert James Development 1 (J108) J108 An introduction to the SQL for a beginner. The session will cover the basic DML (Data Manipulation Language) statements = INSERT, SELECT, UPDATE, and DELETE. This will be a demo driven session. 10/17/2009 1:15:00 PM 10/17/2009 1:30:00 PM