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 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 892 Aaron Bertrand Aaron holds the position of Senior Data Architect at One to One Interactive in Boston, Massachusetts, responsible for database design and architecture. He has been a Microsoft MVP since the 1997-98 award year, and continues to devote spare time to helping the community - be it on the SQL Server newsgroups, StackOverflow, sqlblog.com, or live events like this one. @AaronBertrand http://sqlblog.com/blogs/aaron_bertrand/about.aspx https://api.twitter.com/1/users/profile_image?screen_name=@AaronBertrand 48 48 952 Adam Machanic Adam Machanic is a Boston-based independent database consultant, writer, and speaker. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including 'SQL Server 2008 Internals' (Microsoft Press, 2009) and 'Expert SQL Server 2005 Development' (Apress, 2007). He is an MVP for SQL Server, MCITP DBA/DBD, and INETA speaker. @AdamMachanic http://www.linkedin.com/in/adammachanic http://sqlblog.com https://api.twitter.com/1/users/profile_image?screen_name=@AdamMachanic 48 48 937 Ayad Shammout I have been involved in IT for 20 years as a Developer, System Engineer, System Analyst and Database Consultant. I worked exclusively with MS SQL Server and Microsoft Applications for the last 14 years. I have extensive experience in System Management and Analysis, Security, High Availability, Disaster Recovery, Database Design, Performance Tuning, Troubleshooting and more. I was awarded “SQL Server Innovators Awards 2006”. I'm an MCDBA, MCSE, MCITP and MCT http://www.linkedin.com/in/ayadshammout 48 48 1000 Bala Subra I have more than a decade of experience in Microsoft technologies but have not presented outside the borwonbag sessions at companies which I consult. @bsubra http://www.linkedin.com/in/bsubra http://twitter.com/bsubra https://api.twitter.com/1/users/profile_image?screen_name=@bsubra 48 48 1192 Bullett Manale Bullett Manale is a Systems Engineer at Idera responsible for helping enterprise customers implement Idera’s suite of SQL Server management and administration tools. Prior to Idera he worked extensively in the Database, Performance monitoring, and disaster recovery disciplines with Shell Oil, British Petroleum, Deloitte and Touch Consulting Group and Iomega. http://idera.com 48 48 1050 Charles Hyman MCT specializing in SQL, BI and Biztalk 48 48 1144 Chris Bowen I am Developer Evangelist for Microsoft's Northeast district, which includes New England and upstate New York. http://blogs.msdn.com/cbowen/ 48 48 890 Dean Richards Dean Richards is a Senior Sales Engineer with Confio Software @confio http://www.linkedin.com/profile?viewProfile=key=18302796locale=en_US http://confio.com https://api.twitter.com/1/users/profile_image?screen_name=@confio 48 48 918 Grant Fritchey Grant Fritchey, SQL Server MVP, works for an industry-leading engineering and insurance company as a DBA. He’s done development of apps in languages such as Visual Basic, C#, and Java, and has worked with SQL Server since version 6.0. Grant spends a lot of time involved in the SQL Server community, including speaking, blogging, and he is an active participant in the SQLServerCentral.Com forums. He is the author of SQL Server Execution Plans, and SQL Server 2008 Query Performance Tuning Distilled @gfritchey http://www.linkedin.com/in/scarydba http://scarydba.wordpress.com https://api.twitter.com/1/users/profile_image?screen_name=@gfritchey 48 48 1056 Jim O'Neil Jim is one of the Microsoft Developer Evangelists in the Northeast District. He joined Microsoft in April 2008 after 12 years working with developer tools and application server technology as a support engineer, evangelist, and principal sales consultant at Sybase. Jim holds an MCPD and is 1/2 of the team that presents the quarterly Northeast Roadshow providing information on the latest Microsoft technologies to the developer communities in New England and upstate New York @jimoneil http://www.linkedin.com/in/jimoneil64 http://blogs.msdn.com/jimoneil https://api.twitter.com/1/users/profile_image?screen_name=@jimoneil 48 48 1058 Matt Van Horn Matt Van Horn specializes in rapid development focused on flexible and dynamic code to leverage maximum results with minimal effort. His development tool of choice is Silverlight which he has use in projects from a clone of space invaders for facebook to back office accounting to dynamic business intelligence visualization system that turned heads at the Global Gaming(casino) Expo this year in Las Vegas. @phpn00b http://www.linkedin.com/in/matttvanhorn http://www.anythingtheycando.com/blog/ https://api.twitter.com/1/users/profile_image?screen_name=@phpn00b 48 48 1070 Michael Ruland Michael Ruland is director of field engineering at expressor software. Michael has more than 30 years’ IT experience, including more than a dozen focused on constructing and maintaining large, complex data warehouse and decision support structures. He has worked as a Global Technical Architect in IBM’s Advanced Technology Group, in addition to application programming, systems programming, and various sales and engineering positions with Amdahl, Informix, Prism Solutions, Ardent and Ascential. 48 48 902 Mike Litchfield Assistant Vice President - IT Architect and Developer Income Research Management @mike_walsh http://www.linkedin.com/in/mikepwalsh https://api.twitter.com/1/users/profile_image?screen_name=@mike_walsh 48 48 973 Peter Tassmer Peter Tassmer is the owner of William Henry Consulting in Burlington, MA. He has worked exclusively with SQL Server since version 6.5 and focuses on SQL Server performance and storage management. http://www.whccorp.com 48 48 976 Roman Rehak Roman Rehak is a Principal Database Architect at MyWebGrocer.com in Burlington, VT. He specializes in SQL Server development and database architecture. He writes articles for Visual Studio Magazine, SQL Server Magazine, SearchSqlServer.com and other technical publications. Roman presents at user groups and conferences in US and Canada. He also serves as the Tech Chair for the SQL Server track at DevTeach conferences in Canada and is the president of the Vermont SQL Server User Group. @bikerdba http://sqlblog.com/blogs/roman_rehak https://api.twitter.com/1/users/profile_image?screen_name=@bikerdba 48 48 914 Scott Abrants Scott Abrants is a principal database software engineer at Iron Mountain Digital. Having worked with SQL Server since 6.5 days, and having close to 15 years IT experience, Scott has always preferred the BI space when it comes to managing data and SQL Server. I’m one of the founding officers of the Southern New England SQL Server Users Group and severed as a past president. 48 48 928 Slava Kokaev Group Leader at Boston Business Intelligence User Group. @SlavaKokaev http://www.linkedin.com/in/kokaev http://www.bostonbi.org https://api.twitter.com/1/users/profile_image?screen_name=@SlavaKokaev 48 48 935 Steve Simon Steve Simon is an AVP with State Street Corporation Boston. He has been involved with database design and analysis for over 20 years. Steve has presented papers at eight PASS Summits and two at PASS Europe 2009. He has just recently presented his PASS 2008 Summit presentation in Johannesburg South Africa. Steve has also presented 5 papers at the Information Builders' (IBI) International Technology Summits. He has also had 2 papers published in IBI Journal is a regular Webinar presenter for IBI http://www.linkedin.com/in/stephenrsimon http://www.infogoldusa.com 48 48 983 Sunil Kadimdiwan Sunil Kadimdiwan is a Data Architect with 20+ years of experience of successfully designing and implementing mission critical Database Reporting solutions. He has deep knowledge of Microsoft BI technology platform. He is well versed in Insurance, High Tech, Capital Market, Publishing, and Non-Profit industries. He is a frequent speaker at code camps, user groups in the New England region http://www.linkedin.com/in/sunilkadimdiwan http://www.infotrove.com/events.html 48 48 1062 Varsham Papikian Varsham Papikian works as a Principal Database Developer at Wolters Kluwer Financial Services. He has 10+ years of experience working with databases and different Microsoft technologies. He is a DBA, database architect, developer, mentor and speaker. Varsham is a member of the New England SQL Server User Group Executive Board. He also helps others in different SQL Server-related online forums like MSDN. http://www.linkedin.com/in/varshampapikian http://www.linkedin.com/in/varshampapikian 48 48 890 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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