SQLSaturday #34 - Boston 2010 1/30/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat34 Boston MA 02451 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 344 expressor software Platinum Sponsor http://www.expressor-software.com http://expressor-software.com/templates/1/images/top_logo.gif 60 170 345 Quest Software Platinum Sponsor http://www.quest.com http://www.quest.com/images/common/quest-logo.gif 60 170 359 Confio Software Gold Sponsor http://www.confio.com http://www.sqlsaturday.com/images/Confio_LogoLg_0106.jpg 60 170 375 Idera Gold Sponsor http://idera.com http://www.idera.com/images/Logo.jpg 60 170 890 Dean Richards Performance Tuning MPR B 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. 1/30/2010 2:30:00 PM 1/30/2010 3:30:00 PM 892 Aaron Bertrand Database Administration TBC A collection of little things you can do with Management Studio so you can start faster, work smarter, prevent mistakes, and present better. 1/30/2010 9:30:00 AM 1/30/2010 10:45:00 AM 902 Mike Walsh Database Administration TBC Whether you are new to the role of DBA, being 'forced' to take on the responsibility of one or are starting at a new role as a DBA, knowing where to start can often mean the difference between success or failure. In this chat, Mike will help us wade through the noise that attacks a DBA and figure out just what our priorities should be. By focusing on the 'itties' of Database Administration (Recoverability, Availability - Health Performance - , Security and Reliability) we can see a natural priority build. Throughout this interactive discussion we will also have a look at some of the available tools and scripts to help us see where our environments rate with the 'itties' of Database Administration. 1/30/2010 8:15:00 AM 1/30/2010 9:15:00 AM 905 Mike Walsh Performance Tuning MPR B In this talk, Mike will show us some of the tools that come with SQL Server and how they can be used to analyze the performance of our database code. We will take a quick walk through indexing, best practices, some quick tips and then have a more in depth look at Execution Plans, IO Statistics and Profiler. Plus as a DBA, Mike can give a few pointers in working with your organization's own 'Dr. No' along the way. Rough Agenda: • Review of Best Practices • Indexing/Table Structure High Level Overview • Will your queries use the index? • Query Plans don’t have to be scary • IO Statistics, Profiler • Put Them Together (Use the tools before you say, 'Done!' • Interaction with the DBA (How to be a partner in performance with the DB 1/30/2010 11:00:00 AM 1/30/2010 12:15:00 PM 914 Scott Abrants Data Development MPR C Leading your database development solution to a leaner, more automated method of development and deployment is an essential step to implementing a successful Agile/SCRUM based methodology. Scott Abrants will take an existing SQL Server database and import it into Visual Studio Team Edition for Database Developers GDR version prepearing it for an automated continous integration build. Lean some of the tips and techniques that will have you well on your way to integrating with an automated build taking advanatge of the power of Visual Studio Team Edition for Database Developers. 1/30/2010 8:15:00 AM 1/30/2010 9:15:00 AM 918 Grant Fritchey Performance Tuning MPR B This session will focus on how best to use and access execution plans. The use of execution plans will focus on identifying and fixing common performance and execution problems within TSQL. The methods defined for using execution plans will follow a problem/solution paradigm in order to show practical ways that execution plans can help solve common problems. Access of execution plans is normally only defined as being from the Management Studio GUI. This session will show methods of access that include direct queries into the procedure cache using dynamic management views and functions and plans captured through the use of trace events defined in Profiler. Access through XQuery against the XML will be demonstrated through several practical a 1/30/2010 9:30:00 AM 1/30/2010 10:45:00 AM 928 Slava Kokaev Business Intelligence MPR A This session explains how to create SSIS packages and defines the basic objects contained in the control flow and data flow. We will work through how to Create SSIS Packages, Data Sources and Package Connections Create Control Flow Tasks Use Control Flow Containers Use Data Flow Adapters and Transformations 1/30/2010 8:15:00 AM 1/30/2010 9:15:00 AM 935 Steve Simon Data Development MPR C How often have our SQL Servers been bogged down with a myriad of users issuing lengthy and poorly constructed or poorly performing queries against our tables and views. More often than not, nearly bringing our systems to their knees. Nowhere is this truer than within the financial world where heavy number crunching is par for the course. This beginners to intermediate level hands-on presentation is aimed at the SQL Server developer and business analyst alike and will show the attendee how we have managed to eliminate 90 % of our poorly performing queries by creating data access layers which provides our end users with a suite of well developed and tuned SQL Server FUNCTIONS with which to render their data. 1/30/2010 1:00:00 PM 1/30/2010 2:15:00 PM 936 Steve Simon Business Intelligence MPR A Over the past few months many financial houses have been severely ‘hit’ by the current slump in the sub prime mortgage market. This has lead to severe losses and considerable client liability. Many firms are now starting to take a ‘serious look’ at the potential utilization of data mining techniques as part of their ongoing efforts to control their risk exposure. This beginner to intermediate level hands-on presentation is aimed at showing the attendee some of the ‘data mining’ prototypes solutions that we are currently developing with SQL Server 2005 / 2008, as a part of our ongoing efforts to manage our risk. 1/30/2010 3:45:00 PM 1/30/2010 4:45:00 PM 937 Ayad Shammout Business Intelligence MPR A In this session, I will cover the new PowerPivot (formerly known as Gemini Project) a data analysis add-in that delivers computational power directly within MS Excel 2010. By combining native Excel 2010 functionality with PowerPivot’s in-memory engine will allow users to interactively explore and perform calculations on large data sets. You can easily streamline the process of integrating data from multiple sources – including corporate databases, spreadsheets, reports, and data feeds. Share and collaborate by easily publishing your analysis to SharePoint 2010 and have other users enjoy the same slicer and fast-query capabilities when working on your Excel Services reports. 1/30/2010 9:30:00 AM 1/30/2010 10:45:00 AM 938 Ayad Shammout Database Administration TBC If you are new to SQL Server environment, you will learn how we are using Clustering and Mirroring technologies together to achieve High Availability and minimize data loss in the event of a disaster. This session is for you if you want to learn techniques we have used to minimize downtime while migrating from SQL Server 2005 to 2008. If you use SQL Server 2005 failover clustering and want to learn about upgrading to Windows Server 2008 and SQL Server 2008, this is the session for you. 1/30/2010 1:00:00 PM 1/30/2010 2:15:00 PM 952 Adam Machanic Performance Tuning MPR B This session is for the Type A DBAs who are serious about managing their servers as efficiently as possible. The Dynamic Management Objects--a set of views and functions that first shipped with SQL Server 2005--are a window into the inner workings of your SQL Server instance. Locked within the objects is the information you need to help you solve virtually any performance problem, quickly debug problems as they're occurring, and gain insight into what's actually happening on your server, right now. This session is a fast-paced tour of the ins, outs, whys, hows, and even pitfalls of 15 of the most important views and functions. You will learn how to understand transaction behavior, locking, wait statistics, sessions, requests, and much more. 1/30/2010 1:00:00 PM 1/30/2010 2:15:00 PM 973 Peter Tassmer Database Administration TBC A critical, but often overlooked step when deploying SQL Server is the design, layout and provisioning of storage. In this talk, Pete will discuss storage design and layout for various SQL workloads, I/O analysis and the methods used to gather storage performance metrics. Other topics such as planning for storage based replication with SQL Server, storage alignment, solid state drives, stress testing and validation prior to deployment will also be discussed. 1/30/2010 3:45:00 PM 1/30/2010 4:45:00 PM 976 Roman Rehak Database Administration TBC This session will cover many common issues, challenges and problems encountered when developing for, or administering SQL Server as well as examining best ways to modify, script and copy database objects from development to production environment. Session materials for the attendees will include custom utility tools and stored procedures written by the speaker for simplifying SQL Server development and database update deployment. 1/30/2010 11:00:00 AM 1/30/2010 12:15:00 PM 983 Sunil Kadimdiwan Business Intelligence MPR A SSRS 2008 R2 has some exciting new features. In this session I will show you how you can use Report Builder 3.0 (new to R2) to consume spatial data and Bing maps in your Reports. I will also show Report Manager look and feel changes with Sharepoint-like interaction and menus; and other features such as Data Bars, Sparklines. 1/30/2010 1:00:00 PM 1/30/2010 2:15:00 PM 1000 Bala Subra Performance Tuning MPR B This session is for you if you want to learn tips and techniques that are used to optimize database development with special emphasis on SQL Server 2005. If you write lot of stored procedures and want to learn the tools of a DBA, this is the session for you. If you are new to SQL Server development environment, you will learn how the various constructs compare to each other and better performance can be produced every time with a brief introduction to understanding Execution Plans. 1/30/2010 8:15:00 AM 1/30/2010 9:15:00 AM 1001 Bala Subra Business Intelligence MPR A This session will be a cornucopia of three sub-sessions. The first part will be to convince the skeptics. Why does every organization should consider SQL Server Reporting as part of its front-end solution? What will SSRS do better than a typical web application/site or a client-server application? The second portion will be a quick demo of the possibility and will be the shortest. The final part will talk about the best practices, tips from the field and will cover the implementation techniques. 1/30/2010 11:00:00 AM 1/30/2010 12:15:00 PM 1050 Charles Hyman Data Development MPR C Basic show-off of how to get the most out of VSTS Database Edition aka 'Data Dude' also a dog-and pony show of 2010 and some TFS thrown in. 1/30/2010 9:30:00 AM 1/30/2010 10:45:00 AM 1056 Jim O'Neil Data Development MPR C At PDC 2009, Microsoft announced 'Dallas', a Data-as-a-Service offering that leverages the Windows Azure cloud computing platform. 'Dallas' makes well-known and vetted public and commercial data sets from entties such as the Associated Press and Data.gov available to the development and data analysis communities. This session explores getting started with 'Dallas' and accessing its data sets programmatically and via Excel 2010's PowerPivot feature. 1/30/2010 2:30:00 PM 1/30/2010 3:30:00 PM 1057 Mike Litchfield Business Intelligence MPR A This session will describe the value of an ETL framework, what should be included in it, and architectural considerations. A production implementation using Sql, SSIS, ASP.Net, and SSRS will be referenced. 1/30/2010 2:30:00 PM 1/30/2010 3:30:00 PM 1058 Matt Van Horn Data Development MPR C This is a high level intro of how to develop for SQL Azure either using traditional ASP.Net IIS or Windows Azure as a host. I will go over the differences between SQL Azure and Azure Storage. Considerations that need to be made if using Azure Cloud Hosting with ASP.Net Authentication and session states as well as how to use SQL Azure as a Sql(Membership,Role,Profile)Provider. I will share the tips and tricks that I have discovered as I worked with SQL Azure. 1/30/2010 11:00:00 AM 1/30/2010 12:15:00 PM 1059 Matt Van Horn Data Development MPR C Live Labs recently released Pivot a tool to visualize data which can allow uses to see patterns in data like never before. In this session I will provide a basic intro to Pivot and discuss how to use you existing database and the pivotcollectiontools(on codeplex) SDK that I have released to dynamically build Pivot Collections. 1/30/2010 3:45:00 PM 1/30/2010 4:45:00 PM 1062 Varsham Papikian Database Administration TBC PowerShell is a relatively new scripting environment from Microsoft and SQLCMD is a replacement of OSQL. Every day we perform many similar database-related tasks. Why not write once and then reuse that code multiple times? I will give an overview of Powershell and SQLCMD. Then we will see how to use them in SQL Server environment to automate repetitive tasks, write a flexible code, perform tasks while away from the computer, and perform many other time-saving activities. 1/30/2010 2:30:00 PM 1/30/2010 3:30:00 PM 1070 Michael Ruland Business Intelligence MPR A 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/30/2010 12:15:00 PM 1/30/2010 1:00:00 PM 1144 Chris Bowen Performance Tuning MPR B ADO.NET Entity Framework (EF) can help you more easily create and maintain data-driven applications using flexible data models featuring entities and relationships. Entity Framework 4, part of .NET Framework 4 and Visual Studio 2010, includes many new features and improvements. This session will start with a brief introduction to EF, then focus on what’s new in EF 4, including designer improvements, persistence ignorance, model-first support, lazy loading, N-Tier, complex types, foreign keys, and more. 1/30/2010 3:45:00 PM 1/30/2010 4:45:00 PM 1192 Bullett Manale Database Administration TBC In this session, we will introduce the cutting edge technology of 'virtual databases' and describe in detail how they work. In addition, we will show how organizations are taking advantage of this new technology in their own environments by providing use examples. No DBA will want to miss this, as this game changing technology will help save many hours of time waiting for restores of databases, as well as saving tons of money on drive space. We will discuss how virtual databases introduce new ways to handle object level recovery, administration of databases, compliance of backups as well as new change control methodologies. 1/30/2010 12:15:00 PM 1/30/2010 1:00:00 PM 1215 Dean Richards Performance Tuning MPR B Confio Software (Dean Richards, Sr. DBA Product Architect) will conduct a demonstration of “Real-World Performance Tuning” using the Ignite Suite from Confio. In this demonstration and discussion, Dean 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/30/2010 12:15:00 PM 1/30/2010 1:00:00 PM