SQLSaturday #32 - Tampa 2010 1/23/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat32 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 338 Confio Software Platinum Sponsor http://www.confio.com http://www.sqlsaturday.com/images/Confio_LogoLg_0106.jpg 60 170 340 expressor software Platinum Sponsor http://www.expressor-software.com http://www.sqlsaturday.com/files/c70edc5b-1bd7-4bd6-b079-aa3a9075bde0.png 60 170 346 Quest Software Platinum Sponsor http://www.quest.com http://www.tampasql.com/Assets/Images/Qlogo.jpg 60 170 355 Kforce Platinum Sponsor http://www.kforce.com http://www.sqlsaturday.com/files/90b24ff0-fcf4-4c71-b140-b4057da0c290.JPG 60 170 334 SQLShare.com Gold Sponsor http://www.sqlshare.com http://www.sqlshare.com/sqlshareimages/sqlshare_header_logo.jpg 60 170 347 Pragmatic Works Gold Sponsor http://www.pragmaticworks.com http://www.pragmaticworks.com/images/l4.gif 60 170 361 Soaring Eagle Consulting Gold Sponsor http://www.soaringeagle.biz http://www.tampasql.com/Assets/Images/SoaringEagleLogoHorizontal211.jpg 60 170 366 Microsoft Gold Sponsor http://www.microsoft.com/ http://www.microsoft.com/library/toolbar/3.0/images/banners/ms_masthead_ltr.gif 60 170 369 Apress Gold Sponsor http://apress.com/ http://apress.com/img/masthead_logo.gif 60 170 350 Red Gate Software Silver Sponsor http://www.red-gate.com/about/community_relations/sql_saturday.htm http://www.sqlsaturday.com/files/6721b7f1-2cb3-4ebb-b38d-bb6b54ce5119.jpg 60 170 360 Intellinet Silver Sponsor http://www.intellinet.com http://www.intellinet.com/media/31199/intellinet_tagline.png 60 170 370 VisualGov Solutions Silver Sponsor http://www.visualgov.com http://www.tampasql.com/Assets/Images/VisualGov.jpg 60 170 335 Pearson Education Bronze Sponsor http://www.informit.com/ http://www.informit.com/display/InformIT/images/psts/User_Group_Logo.gif 60 170 363 Pyn Logic Bronze Sponsor http://www.enzoauditperformance.com http://www.pynlogic.com/images/pynlogic_210px.gif 60 170 364 CozyRoc LLC Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 829 Adam Jorgensen Track 5 Room 5 Overcome the barriers of traditional training and seminars with this Quick Start to building a cube. This all demo session will get you started and answer many questions you have about building cubes the right way, the first time. 1/23/2010 4:00:00 PM 1/23/2010 5:00:00 PM 830 Scott Klein Track 4 Room 4 Cloud computing is gaining momentum. Knowing how to develop applications for the cloud is important. This session will discuss how to develop applications with SQL Azure, and It will focus on two areas when developing application for SQL Azure, the .NET side and the SQL side. 1/23/2010 4:00:00 PM 1/23/2010 5:00:00 PM 833 Michael Stark Track 7 Room 7 An overview of the new spatial geography data types in SQL Server 2008. Following the overview will be a demonstration of creating queries with spatial data as input and results. Finally, we will wire up a real world example into Bing Maps using ASP.Net. 1/23/2010 1:30:00 PM 1/23/2010 2:30:00 PM 834 Jack Corbett Track 3 Room 3 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. 1/23/2010 9:00:00 AM 1/23/2010 10:00:00 AM 837 Telmo Sampaio Track 7 Room 7 Participate in an architecture review showcasing the use of SQL Server 2008 Spatial features and the filestream data. The session will focus on a pre-defined solution architecture using SQL Server 2005 with pure relational data and after a brief introduction of new features in SQL Server 2008, changes will be presented and discussed with the group, culminating in a new architecture. 1/23/2010 11:30:00 AM 1/23/2010 12:30:00 PM 839 Jorge Segarra Track 2 Room 2 On my blog I've started a project called SQL University aimed at folks looking to learn SQL Server from the ground up. This session will start at ground level tasks and resources all database professionals should know. This session is aimed at entry-level folks but anyone is welcome to attend to sharpen up their basic skills and resources! 1/23/2010 9:00:00 AM 1/23/2010 10:00:00 AM 843 Dmitri Korotkevitch Track 2 Room 2 You need to know how SQL Server works internally if you want to design the effective solutions. This session will give the overview of how SQL Server stores data internally; what criteria query optimizer uses when choose the index and provide some guidelines how to design tables and indexes to improve the performance of the database solutions. 1/23/2010 11:30:00 AM 1/23/2010 12:30:00 PM 847 Mike Davis Track 1 Room 1 In this session Mike shows parameters in many different ways including stored procedure, cascading, Default Values, Available Values, Multi value with the Split Functions in Stored Procedures. 1/23/2010 4:00:00 PM 1/23/2010 5:00:00 PM 852 Patrick LeBlanc Track 5 Room 5 In this session I will explain SQL Server Data compression (Page and Row), provide scripts and tips that will help you identity the compression state that should be configured in your Warehouse environment and also provide demo scripts showing you how to configure compression at the Table and Index level. 1/23/2010 2:45:00 PM 1/23/2010 3:45:00 PM 855 Herve Roggero Track 4 Room 4 In this session we will discuss SQL Azure at a high level including development lifecycle, production, security, auditing and general limitations. 1/23/2010 2:45:00 PM 1/23/2010 3:45:00 PM 856 Nathan Heaivilin Track 7 Room 7 This session will cover the basics the different types of execution plans, how to generate them, and how to read them. 1/23/2010 10:15:00 AM 1/23/2010 11:15:00 AM 857 Troy Gallant Track 6 Room 6 SQL Server replication allows DBAs to distribute data to various servers throughout an organization. Some of the primary 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. 1/23/2010 9:00:00 AM 1/23/2010 10:00:00 AM 860 Elijah Baker Track 3 Room 3 In this session I will go over some of the techniques that I have used to implement database partitioning in a 2 TB OLTP database. This session will be about now that you have decided to use partitioning how do you determine what partition key to use? If my table is using multiple search criteria at different times how do I choose a partitioning key? What tables should I Partition? How should my partitions be stored? 1/23/2010 4:00:00 PM 1/23/2010 5:00:00 PM 862 Jason Strate Track 4 Room 4 SQL Server stores its execution plans as XML in dynamic management views. The execution plans are a gold mine of information. From the whether or not the execution plan will rely on parallelism to what columns are requiring a key lookup after a non-clustered index seek. Through a the use of XML this information can be available at your finger tips to help determine the value and impact of an index and guide you in improving the performance of your SQL Server databases. Prerequisites Understanding of basic T-SQL coding Understanding of basic XQuery statements Goals: 1. Discuss information available in an execution plan 2. Demonstrate use of XQuery to query execution cache 3. Demonstrate methods to performance tune 1/23/2010 11:30:00 AM 1/23/2010 12:30:00 PM 864 Jason Strate Track 2 Room 2 Common Table Expressions (CTE) aren’t as common as their name implies. CTEs are often seen as a secret part of the dark art of recursion. This session will explore CTEs to show how they can be extremely useful in improving performance and legibility of T-SQL code. And, of course, we will look at their use in returning recursive data. Prerequisites Understand of basic T-SQL coding Goals: Provide an understanding of the purpose and use of CTEs for recursion and derived tables Define the pro’s and con’s to using CTEs in recursion and for derived tables Demonstrate real-world examples detailing methods for using CTEs to solve coding challenges 1/23/2010 4:00:00 PM 1/23/2010 5:00:00 PM 879 Vikas Hawaldar Track 6 Room 6 The session will introduce the attendees to the basics of Data Mining and Predictive analysis. It will go over the basic building blocks of SQL 2008 Data Mining Engine and will provide an example of Data Mining project lifecycle. 1/23/2010 1:30:00 PM 1/23/2010 2:30:00 PM 882 Chad Miller Track 5 Room 5 In this sesssion we will look at performing common data loading tasks with Powershell. A basic understanding of PowerShell is helpful, but not necessary. Specific topics covered include importing structured files, XML, WMI objects and ADO.NET data sources. 1/23/2010 11:30:00 AM 1/23/2010 12:30:00 PM 888 Kevin Boles Track 7 Room 7 We will take a look at SQL Service Broker, the built-in asynchronous messaging subsystem provided with SQL Server. We will examine new terminology as well as get a grounding in how we can setup and use Service Broker for messaging applications. We live in an increasingly interconnected world and having a system that can handle intermittent connections and asynchronous processing can solve many business problems. And if MySpace can use it to pass hundreds of millions of messages around their system per day, it can probably do whatever you need it to do as well! Plenty of code in this presentation too. 1/23/2010 4:00:00 PM 1/23/2010 5:00:00 PM 889 Kevin Boles Track 4 Room 4 EVERY SQL Server uses tempdb, many of them extensively. Suboptimal configuration is a leading cause of poor performance. We will cover how to have an optimal configuration for your environment and also how to effectively monitor various tempdb metrics. 1/23/2010 1:30:00 PM 1/23/2010 2:30:00 PM 891 Janis Griffin Track 6 Room 6 Janis Griffin has over 20 years of DBA experience including design, development and implementation of many critical database applications. Prior to Confio, Janis held DBA positions in the Telecom Industry (15 yrs), working with both real-time network routing databases and OLTP business to business applications. Janis was Principal Architect and Sr. Manager, mentoring other DBAs on best practices in database performance tuning. 1/23/2010 4:00:00 PM 1/23/2010 5:00:00 PM 895 Aaron Nelson Track 5 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. 1/23/2010 10:15:00 AM 1/23/2010 11:15:00 AM 906 Michael Mollenhour Track 5 Room 5 In this session I will demonstrate MDX with SQL Analysis Services. This session will demonstrate the analytic powers incorporated into the SQL AS Engine using MDX. I will start with basic concepts of MDX and move to more Advanced calculations. 1/23/2010 9:00:00 AM 1/23/2010 10:00:00 AM 907 Michael Antonovich Track 7 Room 7 This session is designed as a lead-in to the session by Scott Klein. It defines what XM is and how it differs from regular HTML, It looks at how to define data type variables and columns in SQL to store XML, how to output XML from existing table structures. It also covers how to use OPENXML, how to create and use your own namespaces, and the difference between typed XML and untyped XML. 1/23/2010 9:00:00 AM 1/23/2010 10:00:00 AM 916 Andy Warren Track 4 Room 4 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. 1/23/2010 10:15:00 AM 1/23/2010 11:15:00 AM 923 Plamen Ratchev Track 3 Room 3 Become a better SQL coder by learning the most common pitfalls in the SQL language. Both inexperienced and experienced SQL developers and DBAs can get caught by many of these. Practical examples and internal logical processing explanation will help you understand why mistakes happen and how to develop good SQL coding practices to avoid them. 1/23/2010 11:30:00 AM 1/23/2010 12:30:00 PM 924 Plamen Ratchev Track 3 Room 3 Many people live by the motto “If it’s not broken, don’t fix it”. But if you believe that you are missing all enhancements introduced in newer versions of SQL Server (2005/2008). These new features can help you develop better solutions with improved performance, scalability, and maintainability. Learn how to craft a better query using the new MERGE statement, ranking functions, and more. Practical examples with tips and tricks. 1/23/2010 10:15:00 AM 1/23/2010 11:15:00 AM 930 Jeffrey Garbus Track 2 Room 2 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 1/23/2010 10:15:00 AM 1/23/2010 11:15:00 AM 942 Ronald Dameron Track 5 Room 5 Database Hardening via PowerShell. I will demonstrate how I use PowerShell to handle the issues encountered in a Fortune 50 corporate environment that has over 500 database servers and 3600 databases. 1/23/2010 1:30:00 PM 1/23/2010 2:30:00 PM 981 Scott Gleason Track 1 Room 1 In this session I'll show you how SSIS can use a scripted task or execute task to encrypt or decrypt a file. All examples will be in C#.. 1/23/2010 1:30:00 PM 1/23/2010 2:30:00 PM 982 Bayer White Track 4 Room 4 Let's face it, reading and writing data with SQL Server can be expensive and has scaling this type of architecture has its implications that need to be considered upfront. This is one of the reasons Microsoft has included caching within its future AppFabric Framework. Caching is not a new methodology because we can use it currently in applications built on top of ASP.Net out of the box, however there are still scaling issues that AppFabric Caching (ACF), formerly Velocity addresses. As database developers, it is important to identify with new trends that may affect database integration and this presentation does just that. First we will learn the basics of AFC, how to install, how to scale, and how data driven solutions can benefit from it. 1/23/2010 9:00:00 AM 1/23/2010 10:00:00 AM 984 Patricia (Pat) Baxter Track 6 Room 6 The start of a new year offers us the opportunity to “take stock” of what may or may not be helping us to achieve our personal and professional goals. One thing we may forget to assess is our “professional brand”. Your professional brand can help you to distinguish and position your personal portfolio of experience, skills and knowledge as unique and of value to customers and in the marketplace. This session looks at five actions to take that align your professional brand with your career goals, and can help your clients, peers, and managers see the tangible and intangible benefits of working with you. 1/23/2010 2:45:00 PM 1/23/2010 3:45:00 PM 989 Christian Loris Track 1 Room 1 What are SCDs? How do I manage them? SSIS Provides an SCD Wizard which can make your life easier. It also has problems which we'll show you how to work around. 1/23/2010 2:45:00 PM 1/23/2010 3:45:00 PM 991 Jeffrey Garbus Track 3 Room 3 This session reviews rewriting a bad chunk of data migration code. Your speaker wrote the original code at 1:30 am, rewrote it with disgust at 2am, and wrote it nicely the next evening. We will review why the dozens of reqasons the first 2 passes are bad, followed by some firm coding recommendations. 1/23/2010 1:30:00 PM 1/23/2010 2:30:00 PM 992 Eric Wisdahl Track 1 Room 1 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. In response to previous comments, the majority of the material will be presented via demos. 1/23/2010 10:15:00 AM 1/23/2010 11:15:00 AM 998 Brian Knight Track 1 Room 1 This session will get you past the learning curve of SSIS. Brian covers creating an end to end package that covers many of the concepts in SSIS. He covers, looping over a set of files, processing each file and then archiving. You won't want to miss this if you're new to SSIS. 1/23/2010 9:00:00 AM 1/23/2010 10:00:00 AM 1006 Brian Knight Track 1 Room 1 In this session, you’ll learn how to load a data warehouse using SQL Server Integration Services (SSIS). You'll see a battle between two SSIS experts (Brian Knight and Adam Jorgensen), attempting to load the data warehouse the best way. You'll see varying architectures and best practices from each of the presenters and you decide who wins the Iron Chef competition. 1/23/2010 11:30:00 AM 1/23/2010 12:30:00 PM 1011 David Taylor Track 6 Room 6 Utilizing only T-SQL and algebra, I will engage the attendees in a discussion of teasing trends out of data buried within SQL Server, without having to learn the intricacies of Data Warehousing and MDX Querying. It is my hope that my methods can be used and expanded upon in your field, and I invite those who use SQL Server in any environment to come join the discussion. 1/23/2010 10:15:00 AM 1/23/2010 11:15:00 AM 1067 Mark Landry Track 6 Room 6 Using Analysis Services, ASP.NET, AJAX callbacks for refresh, Dundas grids and charts, and Notification Services for alerts, this session will show how to integrate a variety of MS technologies to create a state-of-the-art dashboard system. This particular dashboard implementation is currently in use by Norfolk Southern railroad to monitor intermodal shipments. The concepts could be applied to monitoring any operational system. It also shows how cubes can be used for more than just decision support. 1/23/2010 11:30:00 AM 1/23/2010 12:30:00 PM 1068 Geoff Hiten Track 2 Room 2 Learn about the major changes in clustering in recent SQL and Windows releases and how clustering is something you can implement that will actually make your work life easier. 1/23/2010 1:30:00 PM 1/23/2010 2:30:00 PM 1069 Jonathan Kehayias Track 2 Room 2 Event Notifications are a hidden gem in SQL Server 2005, 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. 1/23/2010 2:45:00 PM 1/23/2010 3:45:00 PM 1127 Michael Ruland Track 2 Room 2 Microsoft SQL Server Integration Services (SSIS) users who are writing too much complex code to transform data, struggling with application performance or having trouble integrating diverse data sources will benefit from learning about the expressor semantic data integration system -- an affordable, enterprise-class alternative to SSIS. They will learn how American Tower improved the data loading times for its data warehouse and enabled its developers to perform complex data transformations in a single process by migrating from Microsoft SSIS to expressor. 1/23/2010 12:30:00 PM 1/23/2010 1:30:00 PM 1145 Kathy Malone Track 7 Room 7 Hear how Access 2010 and SharePoint 2010 can be used to better manage your Access applications, reducing the load on your SQL Server. SharePoint 2010 manages security, backup, and deployment of the Access aps, and makes it possible to use the Access ap in the browser without having Access on the client machine and in untrusted mode. And because of the way Access now caches, it becomes a tool of choice for large number of records queries and reports (40,000-160,000 records), reducing the load on your SQL Servers. Finally, see a tool for finding the Access applications in your environment so you can prioritize making them more managed. 1/23/2010 2:45:00 PM 1/23/2010 3:45:00 PM 1184 Janis Griffin Track 3 Room 3 Confio Software (Janis Griffin, Sr. DBA Product Architect) and Soaring Eagle Consulting (Jeff Garbus, Principal) will conduct a demonstration of “Real-World Performance Tuning” using the Ignite Suite from Confio. In this demonstration and discussion, Janis Griffin and Jeff Garbus will show the audience how using Response-Time Analysis and Wait-Types in SQL Server to quickly diagnose and identify performance bottlenecks in SQL Server 2000,2005, and 2008. Ignite may also be used for cross-platform monitoring and performance tuning on Oracle, Sybase and DB2-LUW. 1/23/2010 12:30:00 PM 1/23/2010 1:30:00 PM 1185 Brian Knight Track 1 Room 1 In this session, you’ll learn how to use a series of free and pay components in your tool belt to improve the speed of your SSIS development. You’ll learn how to code packages faster with templates in BI xPress and how tasks and transforms built into Task Factory can take hours off your SSIS runtime. 1/23/2010 12:30:00 PM 1/23/2010 1:30:00 PM 1189 Jorge Segarra Track 3 Room 3 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! 1/23/2010 2:45:00 PM 1/23/2010 3:45:00 PM 1190 SQLSaturday Event Track 4 Room 4 Lunch will be provided free to attendees. Lunch will be provided courtesy of LaTam's at Centro Asturiano. 1/23/2010 12:30:00 PM 1/23/2010 1:30:00 PM