SQLSaturday #71 - Boston 2011 4/2/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat71 Boston MA 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 965 Red Gate Software Gold http://www.red-gate.com/ http://www.red-gate.com/assets/images/logos/RG_simpletools-onwhite515x143.jpg 60 170 980 WhereScape Gold http://www.wherescape.com http://www.wherescape.com/forum/forum_images%5Cwherescape_logo_new.gif 60 170 1028 Quest Software Gold http://www.quest.com/sql-server/ http://www.quest.com/images/common/quest_logo.gif 60 170 1036 Axis Technology, LLC Gold http://www.axistechnologyllc.com http://www.axistechnologyllc.com/logoAxis.png 60 170 884 Idera Silver http://www.idera.com http://www.idera.com/campaign_images/idera_logo_tag.jpg 60 170 979 Confio Software Silver http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 989 Telerik Silver http://www.telerik.com http://www.telerik.com/images/Homepage/TelerikLogo.gif 60 170 996 Melissa Data Silver http://www.MelissaData.com http://www.melissadata.com/home/new-2009/melissa-data-logo.gif 60 170 1010 Fusion-io Silver http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 1029 SQL Sentry Silver http://www.sqlsentry.net http://www.sqlsentry.net/images/ext/SQLSentryLogo148.jpg 60 170 1061 Winxnet Silver http://www.winxnet.com http://www.winxnet.com/images/winxnet-med.png 60 170 1119 Bradmark Technologies Silver http://www.bradmark.com http://www.bradmark.com/images/bmlogo_pass.jpg 60 170 1141 Kaminario Silver http://www.kaminario.com http://www.kaminario.com/kaminario_logo.png 60 170 1148 AVID Technical Resources Silver http://www.avidtr.com http://www.avidtr.com/images/avid_home_header.gif 60 170 988 Megahirtz LLC Bronze http://www.sqlha.com http://sqlha.com/Images/MHzD05aR03cP13ZL.gif 60 170 995 Pearl Knowledge Solutions, Inc. Bronze http://www.pearlknows.com http://www.pearlknows.com/sitebuildercontent/sitebuilderpictures/pearl1.jpg 60 170 999 Ntirety Bronze http://www.ntirety.com http://www.tepcucdev.com/ntirety/DL-Logos/Ntirety-Logo.bmp 60 170 1063 SoftArtisans Bronze http://www.softartisans.com/ http://lib.store.yahoo.net/lib/softartisans/header-logo.jpg 60 170 1084 Syncfusion Bronze http://www.syncfusion.com/ http://www.syncfusion.com/Content/img/Syncfusion-Logo-reg.jpg 60 170 1089 Alexander Technology Group Bronze http://www.alexandertg.com http://media.sbwire.com/profiles/companies/12786/atg.gif 60 170 1115 SafePeak Bronze http://www.safepeak.com/downloadtrial http://www.safepeak.com/safepeak-logo.jpg 60 170 3170 Aaron Bertrand Performance/Monitoring Columbia The session will cover a collection of minor bad habits that can occasionally lead to major problems. 4/2/2011 10:15:00 AM 4/2/2011 11:15:00 AM 3177 Jack Corbett Future Directions Thames This session will give a brief overview of the different types of triggers available in SQL Server (DDL DML) and then go into more detail on how and when to use DML triggers. This session will cover misconceptions about how triggers work, when triggers should and shouldn't be used (we will discuss options), common mistakes, and how to fix the most common mistakes. After attending this session a person will: 1. Identify different types of triggers and when to use them. 2. Be able to identify when a trigger is the right solution 3. Be able to write triggers that perform well 4/2/2011 9:00:00 AM 4/2/2011 10:00:00 AM 3246 Ira Whitreside SSIS/ETL St. Lawrence Recently I have had a client that required migrating and re hosting a data warehouse from the Oracle environment to the Netezza Appliance. The application had hundreds of tables and almost 2900 Source to Target Mappings. This would have taken 1000's of hours of manual coding. For this client we implemented a reusable data driven architecture, via SSIS, that rely on a metadata mart. The end result a greatly reduced TCO(development effort) for generating the code required vs manual coding. In addition the process leaves behind a metadata mart to report on for auditing and other Data Governance efforts. We generated over 100,000 lines of code and over 3000 load scripts. 4/2/2011 3:45:00 PM 4/2/2011 4:45:00 PM 3289 John Flannery Data Development Yukon We will discuss the “how to’s” of column encryption from the perspective of the DBA, Performance Analyst, Application Architect, and Programmer. We will actually encrypt the “NationalIDNumber” column of the Personel.Employee table in AdventureWorks – and subsequently the entire AdventureWorks database. I will contrast column encryption with Transparent Data Encryption (TDE). We will also briefly discuss business role changes necessary to support encryption and subsequently DR. 4/2/2011 3:45:00 PM 4/2/2011 4:45:00 PM 3388 Sunil Kadimdiwan BI Hudson PerformancePoint is now part of SharePoint 2010. You can now get a complete view of your business data using SharePoint and Analysis Services Cubes. How do you create interactive and context driven dashboards? In this session I will demo how you can go about doing this. 4/2/2011 10:15:00 AM 4/2/2011 11:15:00 AM 3390 Joseph Dantoni Infrastructure Colorado Interested in high availability, but don't know where to start? This session will start at the ground level and work through all the requirements of building a SQL Cluster environment, including Windows steps, storage steps, and networking needs. Of course, SQL Server will be included in this process. 4/2/2011 10:15:00 AM 4/2/2011 11:15:00 AM 3396 Allan Hirt Infrastructure Colorado Are you confused by the various SQL Server high availability technologies? Do you understand what each one does and where each one may or may not benefit you? Do you know the basics of what you need to implement highly available SQL Server instances and databases? If these burning questions speak to you, so will this session. Whether you are an accidental DBA, new to SQL Server, or looking to brush up your skills, this session will cover the different methods of making SQL Server available, compare and contrast them, as well as and cover the top things both SQL Server and non-SQL Server you need to do to ensure uptime for databases and instances. 4/2/2011 9:00:00 AM 4/2/2011 10:00:00 AM 3471 Allen White Performance/Monitoring Columbia We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly. 4/2/2011 9:00:00 AM 4/2/2011 10:00:00 AM 3472 Allen White Future Directions Thames Service Broker was introduced in SQL Server 2005 to provide asyncronous messaging in your database applications, but it's seldom used because it isn't well understood. In this session we'll walk you through the basics of Service Broker and show how you can use it to build highly scalable applications. 4/2/2011 1:15:00 PM 4/2/2011 2:15:00 PM 3557 Michael Coles SSIS/ETL St. Lawrence Performance-driven SSIS ETL solutions require a mix of both SQL and SSIS developer optimizations. In this session attendees will learn SQL code and SSIS data flow optimizations, tips and best practices that are specifically geared to obtain the best performance from your enterprise ETL solution. This session demonstrates high-speed ETL techniques using dimensional datamarts, but much of the information presented can be applied to any SSIS solution. 4/2/2011 10:15:00 AM 4/2/2011 11:15:00 AM 3576 Andy Leonard SSIS/ETL St. Lawrence This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up. 4/2/2011 1:15:00 PM 4/2/2011 2:15:00 PM 3587 Steve Simon Data Development Yukon Efficient and effective database design is so important that leaving it solely to the DBAs is simply not a solution. We as developers will more than likely have to create applications to access the data stores and as such must ensure that all application related considerations are taken into account within the database design. In this session, (aimed at software developers) we shall be touching upon several concepts of special importance to the developer. These include database development 'patterns and anti-patterns', final proofing of design and creating versatile deployment scripts that can and will be utilized in future endeavors. 4/2/2011 10:15:00 AM 4/2/2011 11:15:00 AM 3599 Ayad Shammout Infrastructure Colorado You may ask yourself, “Who did drop my table? Who altered this Stored Procedure? When did this SQL login grant access to a database? Who inserted, updated or deleted records in a table? Do you need to meet regulatory compliance needs?” If you’d like to know the answers, this session is for you, I will cover the technical details of the new Auditing feature in SQL Server 2008 with lots of demos and how you can leverage it in your SQL server environment. I will show you how to build a Centralized Auditing Solution where you can view all audit events in your environment centrally with rich dashboards and reports to track and view all audit actions by server, database, object and users across all SQL servers. 4/2/2011 3:45:00 PM 4/2/2011 4:45:00 PM 3700 Slava Kokaev BI Hudson If you want to get the most out of your Analysis Services cube it’s essential to know and understand MDX: you need to be able to write MDX queries and calculations. MDX is part of the underlying foundation for the SSAS (OLAP architecture), and it offers detailed and efficient navigation and drill across of multidimensional data. MDX is designed to ease the process of accessing data from multiple dimensions This session aimed at those with little or no previous MDX experience will teach you the basic concepts of the language as well as show you how to write common queries and calculations. 4/2/2011 1:15:00 PM 4/2/2011 2:15:00 PM 3703 Jason Alexander Future Directions Thames Whether you are seeking a new position or working to increase your knowledge-base, career development is a hot topic in the greater Boston area. This session will address tips and tactics that successful SQL professionals are utilizing to further their career and increase their income potential. Jason Alexander is the Managing Partner of Alexander Technology Group, a full service consulting and staffing firm focused exclusively on the greater Boston marketplace. Jason also serves on multiple area boards of directors including the Massachusetts and New Hampshire High Technology Councils and speaks frequently on the topic of career development at area colleges and outplacement events. 4/2/2011 3:45:00 PM 4/2/2011 4:45:00 PM 3756 Rob MacNaughton BI Hudson Wow BI on a budget...or how a DBA can roll out some of Microsoft's vision of Self Service BI using just SQL EXPRESS. In this session we go from a payroll feed in csv to a SQL 2008 Reporting Services Management Report. This report is utilizing windows login as hidden row level secuity. Finance retains control of access to the payroll information. All this can be set up on SBS 2011 4/2/2011 3:45:00 PM 4/2/2011 4:45:00 PM 3774 Jeff Mlakar Future Directions Thames The Cloud is fast becoming the latest hot topic in the technology arena. We need to understand how we as SQL Developers and Administrators can utilize SQL Azure, Microsoft’s platform for relational data storage in the Cloud, to meet our needs. This talk will be a step-by-step demo of how to obtain an Azure subscription, create and administer a SQL Azure database, and work with it from your own SQL Server Management Studio AddIn. You’ll find that Azure is so easy to work with, you’ll get two for the price of one in this talk: you’ll learn Azure and learn how to create a Management Studio AddIn! 4/2/2011 10:15:00 AM 4/2/2011 11:15:00 AM 3792 Bill Wilder Future Directions Thames We live in world where the management of structured data is dominated by relational databases. What happens when we get to the cloud? You may have heard about SQL Azure, Microsoft's take on SQL Server for the cloud. Won't everything be just like the old days? Not so fast... In this talk we will review some of the key differences between SQL Server and SQL Azure, then consider some of the other data storage options offered by Windows Azure. After this talk you will understand the broader picture of storage in Windows Azure and have a basic understanding of how to employ these complementary data storage solutions -- along-side some of the old-school approaches you currently know and love. 4/2/2011 2:30:00 PM 4/2/2011 3:30:00 PM 3841 Chris Skorlinski Performance/Monitoring Columbia Are all your databases backed up? Has SQL reported any errors? Are there critical Windows or SQL patches you need to apply? Are all of your SQL Servers configured to Microsoft 'Best Practices'? This sessions shows how Microsoft Atlanta Tool can be used to provide the CIO or DBA an 'extra set of eyes' to check the health of your SQL Severs. 4/2/2011 2:30:00 PM 4/2/2011 3:30:00 PM 3844 Andrew Kelly Data Development Yukon Understanding the fundamentals of how indexes work and how they are best utilized is an essential part of any DBA or SQL developer’s repertoire. Many people assume if you create an index on a column or columns of a table that it will automatically be used when you reference that column. While that may be true under some conditions the actual usage depends on several key factors and they may surprise you. We will cover the fundamentals of how the indexes work under the covers and why you need to know this in order to ensure your indexes are actually helping and not hurting your performance. 4/2/2011 9:00:00 AM 4/2/2011 10:00:00 AM 3845 Andrew Kelly Data Development Yukon Lack of plan reuse is one of the biggest performance killers in SQL Server and almost everyone has experienced problems in this area before. We will explore exactly how to determine if this is an issue for you and more importantly, how to address it. See what factors determine if a plan gets reused or not and why. We will cover how to issue calls to the database that guarantee reuse and peak performance. Understanding this aspect of SQL Server is something every good DBA should be fully aware of and attending this session will get you the insight to get started immediately. 4/2/2011 1:15:00 PM 4/2/2011 2:15:00 PM 3847 Mike Hillwig Infrastructure Colorado Consolidating SQL Server Instances can be daunting. Virtualizing SQL Server instances can be intimidating. Doing both at the same time can be absolutely frightening. When Mike Hillwig inherited his SQL environment, he had 14 SQL Server instances, running five different versions of SQL, all using local disk. In one project, his team consolidated this down to four servers. And the entire environment is virtual. In this session, MIke will share what they did, how they did it, what worked, and what didn't work so well. 4/2/2011 2:30:00 PM 4/2/2011 3:30:00 PM 3849 Adam Machanic Performance/Monitoring Columbia 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 is the data you need to help solve virtually any performance problem, quickly debug issues, 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--information gleaned from heavy use of the objects in a number of environments. You will learn how to understand transaction behavior, locking, wait statistics, sessions, requests, and much more. Attend this session and you will be the master of your SQL Server instance. 4/2/2011 3:45:00 PM 4/2/2011 4:45:00 PM 3881 Matt Masson SSIS/ETL St. Lawrence Need a fast data integration solution, but don't have the time or budget for heavy performance tuning? Come learn how to maximize your ROI by applying trusted design patterns to your Integration Services packages. We’ll start off by looking at how to set performance expectations, and see how you can easily put together a simple framework to record benchmarks for your ETL process. We’ll then dive into a number of common design patterns, such as surrogate key generation, advanced Lookup patterns, parallel processing, change data capture, and different ways of handling slowly changing dimensions . 4/2/2011 2:30:00 PM 4/2/2011 3:30:00 PM 3900 Barry Ralston BI Hudson This fast-paced session will construct a PowerPivot for SharePoint dashboard, analyzing a humorous, everyday problem-set. Beginning with installing PowerPivot for Excel and concluding with a working, interactive dashboard, this session will prepare attendees to leverage PowerPivot to load data from disparate, related sources. Limitations for creating good relationships, and the construction of good dimensions will be covered. Finally, surfacing the assembled data using slicers, charts and tables. 4/2/2011 9:00:00 AM 4/2/2011 10:00:00 AM 3912 Andy Leonard SSIS/ETL St. Lawrence Matt Masson and Andy Leonard team up to deliver an overview of new and improved features in SSIS Denali. Andy and Matt focus on: 1) Stuff that will continue working as is 2) Stuff you’ll want migrate to use the new features 3) Stuff you’ll develop for Denali from the ground up 4/2/2011 9:00:00 AM 4/2/2011 10:00:00 AM 3914 Karen Lopez Data Development Yukon A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Varchar(1) and other Varying datatypes * Identity Properties * Naming Standards - Who needs them? * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions. 4/2/2011 2:30:00 PM 4/2/2011 3:30:00 PM 3917 Craig Purnell Infrastructure Colorado A review of Database Mirroring in the context of operations at Baker Hostetler, where mirroring has been a cornerstone high availability tool for over 5 years. A high level look at the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a rolling upgrades or to move large databases to a different location. 4/2/2011 1:15:00 PM 4/2/2011 2:15:00 PM 3932 Data Development Yukon Data Masking is the act of replacing sensitive data with fictitious but realistic data in order to eliminate the risk of exposure to unauthorized parties. Implementing a sustainable data masking program in a modern enterprise environment can be surprisingly challenging—not just technically and organizationally, but culturally. The reactions and concerns you’ll encounter from your development and QA teams are understandable. You’re not just introducing new controls over confidentiality exposures in development and testing systems. You’re shutting off developers’ and testers’ unfettered access to live customer Production data—something that’s been quite normal and convenient for them to date, something they think they just can’t do th 4/2/2011 11:30:00 AM 4/2/2011 12:15:00 PM 3933 Performance/Monitoring Columbia TBD 4/2/2011 11:30:00 AM 4/2/2011 12:15:00 PM 3934 SSIS/ETL St. Lawrence Does your Query and Reporting tool ‘work’? Studies show that in most cases the Query Tool is not the problem! Today’s challenge is Data, and no one can help manage your data better than WhereScape RED. We build real data solutions – fast! WhereScape and Microsoft have partnered for the newly announced Microsoft SQL Server Fast Track Data Warehouse 3.0. WhereScape RED provides Native support for Microsoft SSIS, SSAS and T/SQL for the agile production of enterprise-level data integration and transformations solutions. WhereScape RED is an IDE for managing data warehouses, marts, stores and vaults. RED is the only product that supports the entire data management life cycle by integrating source system exploration, schema design, metadata man 4/2/2011 11:30:00 AM 4/2/2011 12:15:00 PM 3935 SSIS/ETL St. Lawrence Eating, drinking, and merriment 4/2/2011 12:15:00 PM 4/2/2011 1:00:00 PM 3936 Karen Lopez SSIS/ETL St. Lawrence · Is the gender disparity actually an issue · Why is this still an issue after all these year · What should we be doing about it · How can we encourage younger women and girls to consider an IT career · How can we encourage women to remain in IT · Other diversity issues · Call to action 4/2/2011 5:00:00 PM 4/2/2011 5:30:00 PM 3937 SSIS/ETL St. Lawrence Welcome to the show. Logistics, thank yous, and a brief discussion on SQL Server community resources. 4/2/2011 8:30:00 AM 4/2/2011 9:00:00 AM 3938 SSIS/ETL St. Lawrence Register, drink a cup of coffee, get ready for the day. 4/2/2011 8:00:00 AM 4/2/2011 8:30:00 AM 3939 SSIS/ETL St. Lawrence Our venue has an on-site pub. Stick around after the event for some drinks and chat with fellow attendees, speakers, and anyone else who decides to show up. 4/2/2011 6:00:00 PM 4/2/2011 8:00:00 PM 3940 SSIS/ETL St. Lawrence During the day you can submit tickets at any vendor table and be eligible to win some great prizes. You must be present to win! 4/2/2011 5:30:00 PM 4/2/2011 6:00:00 PM 4119 Paul White Performance/Monitoring Columbia Writing a query optimizer that produces a great execution plan for every SQL query, on every database, with every hardware configuration, is a hard problem. A really hard problem. Luckily, few of us will be called upon to write an optimizer. On the other hand, most of us have to make use of the SQL Server query optimizer in our everyday work. To write queries that will optimize well, it helps to have a good understanding of how the optimizer translates T-SQL code into an executable plan and how to read those plans. Come to this session and learn how to take full advantage of the optimizer's powerful features, how to avoid some of its limitations, and how to leverage the wealth of information contained in SQL Server's execution plans. 4/2/2011 1:15:00 PM 4/2/2011 2:15:00 PM 4138 Mike Walsh BI Hudson You've always wanted to get promoted into the DBA position. The good news is you got it - the bad news is you have no idea what to do first. What's important, what's not a big deal, and what can get you fired if you're not careful? If your answer wasn’t, “update my resume”, then this session is a good start. We’ll chat about a natural priority for the overwhelming flood waiting in our offices. By focusing on a few words ending in “ity” we’ll realize what is most important. Through the interaction, stories and examples you’ll leave feeling ready to attack your environment. Be warned – along the way to knowing where to start, you may get that feeling in your stomach that makes you log on to the VPN to check a few things out. 4/2/2011 2:30:00 PM 4/2/2011 3:30:00 PM