SQLSaturday #70 - Columbia 2011 3/19/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat70 Columbia SC 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 1082 Red Gate Software Platinum Sponsor http://www.red-gate.com/?utm_source=ugutm_medium=logoutm_content=sqlsaturday_columbiautm_campaign=ug http://www.red-gate.com/assets/images/logos/RG_simpletools-onwhite515x143.jpg 60 170 1055 Quest Software Gold Sponsor http://www.quest.com/sql-server/ http://www.quest.com/images/common/quest_logo.gif 60 170 968 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 1032 SQL Sentry Silver Sponsor http://www.sqlsentry.net http://www.sqlsentry.net/images/ext/SQLSentryLogo148.jpg 60 170 1077 Fusion-io Silver Sponsor http://www.fusionio.com/ http://www.fusionio.com/images/fusionio-logo.gif 60 170 1078 Intellinet Silver Sponsor http://www.intellinet.com http://www.intellinet.com/media/31199/intellinet_tagline.png 60 170 1095 Microstaff IT Silver Sponsor http://www.microstafffit.com http://www.microstaffit.com/images/microstaff_logo.png 60 170 1103 Data Consulting Group Silver Sponsor http://www.entsoftsol.com http://www.entsoftsol.com/Portals/0/logo.gif 60 170 1118 Varigence Silver Sponsor http://www.varigence.com http://www.varigence.com/images/VarigenceFullLogo.png 60 170 1127 SIOS Technology Corp. Silver Sponsor http://us.sios.com/ http://www.sqlsaturday.com/files/84940541-957b-4878-a5a2-83e065cdd6c0.gif 60 170 1147 SQL Server Magazine Silver Sponsor http://www.sqlmag.com http://www.sqlsaturday.com/files/042dd863-b4e6-4190-a3e2-89c02549e2ed.JPG 60 170 1162 Wrox Silver Sponsor http://www.wrox.com/WileyCDA/ http://media.wiley.com/assets/253/59/wrox_logo.gif 60 170 1166 Apress Silver Sponsor http://apress.com/ http://apress.com/img/masthead_logo.gif 60 170 892 CozyRoc Bronze Sponsor http://www.cozyroc.com/ http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png 60 170 1074 Mariner Bronze Sponsor http://www.mariner-usa.com http://www.sqlsaturday.com/files/6ea24d66-1dab-40b2-9c7f-76a0884ad6f7.jpg 60 170 1092 VC3 Bronze Sponsor http://www.VC3.com http://www.sqlsaturday.com/files/f9225038-cccd-4620-b9e6-4bb72307d9ce.jpg 60 170 1161 Manning Publications Co. Bronze Sponsor http://www.manning.com/ http://www.manning.com/images/masthead.jpg 60 170 1167 Morgan Kaufmann Bronze Sponsor http://mkp.com/ http://mkp.com/wp-content/themes/Reshma_MK/images/mk_logo.jpg 60 170 1081 Gerasus Software Personal Sponsor http://www.gerasus.com/ http://www.gerasus.com/images/logo.png 40 100 1165 Syngress Personal Sponsor http://www.syngress.com/ http://www.syngress.com/images/syngress.jpg 40 100 3107 Tim Radney DB Admin 2 219 You have recently inherited the support of a new or existing database, what are the things you should immediately check and start monitoring and what are the things that you should address over the next few weeks. When taking over support of a database or system, you cannot ASSUME anything. At the end of this session you will have a nice checklist of things you should check and be doing on ALL your databases not just the one you inherited. Whether you are a seasoned DBA or just starting out, this session should be informative and something you can relate to. 3/19/2011 1:15:00 PM 3/19/2011 2:15:00 PM 3157 William Pearson BI 2 217 As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence. 3/19/2011 9:45:00 AM 3/19/2011 10:45:00 AM 3184 Ed Wilson DB Admin 1 216A Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences 3/19/2011 2:30:00 PM 3/19/2011 3:30:00 PM 3217 William E. Pearson III Professional Dev 113 Independent BI consultant, MSSQL Server MVP, and practicing CPA Bill Pearson examines the various options available for organizing and protecting your consulting business. In this section, he covers C Corp, S Corp, LLC, Partnership, and Sole Proprietorship (“Schedule C”) options, as well as other practical advice (trademarks, etc.) useful in forming your business entity. 3/19/2011 1:15:00 PM 3/19/2011 2:15:00 PM 3257 Sandra Mueller DB Admin 3 218 You are about to enter the BIDS Free Zone. Beware! This session is NOT about report design, spatial data, R2 new features or .NET extensions. We will explore what the ReportServer and ReportServerTempDB databases contain. By understanding their purpose we can discuss, for your company, what recovery mode each should be in and select backup strategies. Furthermore, we will talk about two other resources to backup: the ever critical encryption key and XML configuration files. Next, we'll cover the three scalability options: caching, snapshots and scaling out. There are numerous server configurations that are familiar to administrators just hard to find. Some are so hidden you might not know they exist! 3/19/2011 8:30:00 AM 3/19/2011 9:30:00 AM 3274 Mark Tabladillo BI 1 215 This presentation presents SQL Server Data Mining (SSDM) for SQL Server Professionals based on the speaker's past presentations for SQL Saturday. Starting with SQL Server Management Studio (SSMS), the demo includes the interfaces important for professional development, including Business Intelligence Development Studio (BIDS), highlighting Integration Services, and PowerShell. The interactive demos are based on Microsoft's Contoso Retail sample data. Finally we will evaluate where Microsoft data mining can help you in a practical business environment, which may include Oracle and SAS. 3/19/2011 2:30:00 PM 3/19/2011 3:30:00 PM 3376 Steve Wright DB Admin 2 219 This is a session for the SQL DBA that has SSAS in their environment, but is not sure what happens under the hood when it queried, much less how to tell if it's performing at its best. This is not a session on query optimization. But, this session will help you better understand if there is room for query optimization or if some basic configuration changes might provide that needed boost. We'll discuss the basic architecture of SSAS and cover some of the most pertinent metrics to give you a quick and easy view into your SSAS server's performance. 3/19/2011 2:30:00 PM 3/19/2011 3:30:00 PM 3468 Allen White DB Admin 1 216A 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. 3/19/2011 9:45:00 AM 3/19/2011 10:45:00 AM 3470 Allen White DB Admin 1 216A The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment. PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems. This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action. 3/19/2011 3:45:00 PM 3/19/2011 4:45:00 PM 3485 Wayne Snyder BI 3 218 This session will provide you with some surprising and interesting insights into how dashboards should be designed. Called Information Visualization, there is a whole line of thinking which maps how the brain interprets what the eyes see. We will translate this into best (and worst) practices related to visualization in dashboard, scorecard, table, and report design. Both funny and informative, you will probably learn, as I did, that you have been designing your dashboards/scorecards and reports badly. We are going to take a visualization test, and learn how to convey information in a clearer, better way. You will be surprised. Join me - this session is going to be hoot! 3/19/2011 2:30:00 PM 3/19/2011 3:30:00 PM 3488 Cory Loriot BI 3 218 Business Intelligence is a fast growing specialization due to the need of large and small corporations to quickly interpret real-time information for decision making. To meet this growing need, Microsoft has greatly enhanced the Business Intelligence of SharePoint 2010 from MOSS 2007. In this session, you will be provided with an overview of what is possible with SharePoint 2010, include Status Indicators, Chart Web Parts, Performance Point Services, Excel Services, BI Search and Visio Services. We will close the session by building a fast and simple BI Dashboard on a SharePoint Intranet Portal. 3/19/2011 1:15:00 PM 3/19/2011 2:15:00 PM 3491 Andy Leonard BI 1 215 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. 3/19/2011 3:45:00 PM 3/19/2011 4:45:00 PM 3492 Andy Leonard BI 3 218 In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application. 3/19/2011 9:45:00 AM 3/19/2011 10:45:00 AM 3512 Sergey Pustovit DB Admin 3 218 In this session we will go over areas of SQL Server functionality that always raise questions. What is SQLOS, scheduler, worker? How does internal scheduling work? How does Resource Governor work? How does CPU affinity work in SQL Server? What are the preemptive and non-preemptive waits? Should we be afraid of SOS_SCHEDULER_YEILD and CXPACKET waits? 3/19/2011 2:30:00 PM 3/19/2011 3:30:00 PM 3513 Sergey Pustovit DB Admin 2 219 In this session we will go over the new features in upcoming SQL Server release with current code name - Denali 3/19/2011 3:45:00 PM 3/19/2011 4:45:00 PM 3561 Brian K McDonald BI 1 215 SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this deep dive session, I will cover topics like: - What is reporting services and what can it be used for? - New Features included in 2008 R2 - Architectural Overview - Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access. ** This session is SQL Saturday favorite and is always packed full. Don't miss it ** 3/19/2011 11:00:00 AM 3/19/2011 12:00:00 PM 3562 Jason Hall Professional Dev 113 In a world where separation of responsibilities becomes more and more important, the borders between DBAs and developers have grown wider than ever. For the developer seeking to employ the services of SQL Server, Interaction with one or more DBAs at certain stages of the development life cycle is nearly a given. This session discusses tips and techniques to follow that can ensure these interactions are civil, and maybe even pleasant. We will also briefly discuss features included in SQL Server 2008 R2 designed to help abstract DBA and developer division of responsibilities. This topic includes tips on TSQL scripting, deployment techniques, bad habits to avoid beginning execution plan analysis. 3/19/2011 11:00:00 AM 3/19/2011 12:00:00 PM 3583 Plamen Ratchev DB Development 101 Writing a query is an art! Simplicity, focus, and practice is all it takes. Understand the logical processing of a query and discover the art of writing simple and efficient queries. It is a journey that starts with FROM and ends with ORDER BY! 3/19/2011 9:45:00 AM 3/19/2011 10:45:00 AM 3584 Plamen Ratchev DB Development 101 Become a better SQL developer 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. 3/19/2011 3:45:00 PM 3/19/2011 4:45:00 PM 3615 Rafael Salas BI 1 215 With data being the focal point of a data warehouse, its data integration component becomes a critical point of failure of the whole system, and to make matters worse, we, as developers, face increasingly complex scenarios and requirements such as larger number of systems and volumes of data, data quality problems and complex business logic.   In this session Rafael will share a compilation of pitfalls and mistakes he has seen –and made!– across many implementations, and offers recommendations to avoid them. We will look at problems related to metadata, data quality, monitoring, system reliability and some SSIS specific issues among other common problems. 3/19/2011 8:30:00 AM 3/19/2011 9:30:00 AM 3617 Geoff Hiten DB Admin 2 219 How do you tell good code from bad? Bad SQL code makes the system work harder for the same results. Bad SQL does not scale well with larger data sizes, nor does it scale with increased server activity. Extreme Bad SQL can bring a server to a grinding halt. This presentation shows you how and why certain commonly used SQL constructions are Bad SQL. Bad SQL is not very useful by itself so each example includes its Good SQL counterpart. 3/19/2011 11:00:00 AM 3/19/2011 12:00:00 PM 3618 Geoff Hiten DB Admin 1 216A Fast Track Data Warehouse is a single-server BI Repository based on the Microsoft SQL Server Parallel Data Warehouse research and technology, but in single-server sizes. The presentation discusses methods, reference configurations, and best practices maximize your hardware investment for moderately sized (4-48 TB) Data Warehouses. 3/19/2011 8:30:00 AM 3/19/2011 9:30:00 AM 3631 Kevin Goode DB Admin 2 219 Declarative database development has made great strides forward with the Visual Studio 2010 data tools allowing developers to focus on the model instead of the implementation. But once you have the model, what are the options for deployment and what if your solution doesn’t match the Books Online example? The session will demonstrate multiple ways to deploy database projects using TFS Build, MSBuild, VSDBCMD, Powershell and more. For each deployment method, automation and customization techniques will be examined and demonstrated (including the common requirement of deploying one model to multiple targets.) Attendees will leave with a better understanding of database deployment options when using Visual Studio 2010 3/19/2011 8:30:00 AM 3/19/2011 9:30:00 AM 3634 David Taylor Professional Dev 113 When adminstering SQL Server, in SSMS are you a clicker or a typer? This session explores the use of the GUI vs. using scripting in SSMS to get day to day tasks accomplished, with a bent toward scripting for increased accuracy, control and speed. Tasks are illustrated through the use of the Day-to-Day section of Brad McGeehee's Sure DBA Checklist at http://www.bradmcgehee.com , Used with Permission and Great Thanks. 3/19/2011 2:30:00 PM 3/19/2011 3:30:00 PM 3687 Andrew Kelly DB Admin 3 218 Tempdb is used by all kinds of operations in all sorts of ways. In SQL 2005 2008 it has become even more critical to the internal operation of the engine and performance can be affected by a misconfigured or mistuned instance. We will cover the areas that cause the most issues in terms of performance along with demos that illustrate the symptoms. This session will help you ensure your tempdb is up to the task. 3/19/2011 9:45:00 AM 3/19/2011 10:45:00 AM 3744 Javier Guillen BI 2 217 Data Analysis Expressions (DAX) is an expression language used to develop calculations based on PowerPivot data. A lot of its capabilities are very intuitive to Excel power users as it emulates current functionality but over a much larger set of data. However, Its real power emerges with the ability to create aggregations that are evaluated at different contexts on the data stored in-memory. This session will explore DAX formula context, which is of great benefit when developing business calculations like ratios or weighted averages. A brief comparison with MDX will be established in order to contrast the process followed by each language when establishing the context of a calculation. 3/19/2011 3:45:00 PM 3/19/2011 4:45:00 PM 3746 Jessica Moss BI 3 218 Starting in the SQL Server Denali release, data takes on a new life in the business intelligence world. Often forgotten, data management needs to be an integral part of your reporting systems. Learn how Microsoft has made your life easier by incorporating external parameters, environments, and groupings into Integration Services. They have also included impact analysis and data lineage, which can be tied to tables and SSIS packages. Two additional newcomer products, data quality services and master data services, complete the quartet. This session will use the first Community Technical Preview of SQL Server Denali to describe and demonstrate the enhancements to the four products that make up EDIM. 3/19/2011 8:30:00 AM 3/19/2011 9:30:00 AM 3747 Jessica Moss BI 2 217 Producing a good looking report will wow your business users even if your data isn't all that impressive. If you've ever had trouble finding the best way to display that data or how to show trends appropriately, this is the session for you. We will review grouping logic, graphs, gauges, and more in Reporting Services 2008 R2. With the knowledge in this session, you won't ever need to show a plain, boring report again! 3/19/2011 2:30:00 PM 3/19/2011 3:30:00 PM 3751 John Welch BI 1 215 So you’ve used SSIS to populate a simple star schema data mart, and everybody’s happy. But now you have new requirements that require more advanced data warehouse approaches, like late arriving dimensions, bridge tables, parent child dimensions, and Type 3 or Type 6 slowly changing dimensions (SCD). How do you handle those in a scalable, efficient way in SSIS? This session will present some common patterns for handling these scenarios. You’ll learn when to use each advanced approach and the pros and cons associated with each pattern. You will learn how to implement these patterns in SSIS, and how to tune them for high performance. 3/19/2011 1:15:00 PM 3/19/2011 2:15:00 PM 3752 John Welch BI 2 217 SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you'll learn how to automate package creation in SSIS, including the dynamic generation of data flows. We’ll cover some of the free and open source tools available for this, and discuss “roll your own” options. 3/19/2011 8:30:00 AM 3/19/2011 9:30:00 AM 3754 Stuart Ainsworth Professional Dev 113 The role of database administrator has been around for years, but as information collection and storage needs have skyrocketed, a new career opportunity has opened within enterprises: the data architect. This session is intended to give some guidance on the differences between database administrators (and their cousins, the database developer) and data architects, including specific advice on how to transition from one role into the next. 3/19/2011 9:45:00 AM 3/19/2011 10:45:00 AM 3755 Stuart Ainsworth DB Development 101 Relational databases have become storage engines for more than just the traditional datatypes; the inclusion of XML in SQL Server 2005 and SQL Server 2008 opens up a host of new avenues for application development. XQuery is a powerful language for querying XML fragments in conjunction with the relational engine; this session is designed to cover the basic FLWOR syntax of XQuery in an interactive fashion. Participants are encouraged to discuss their own challenges with XML as well as seek out solutions from each other. 3/19/2011 1:15:00 PM 3/19/2011 2:15:00 PM 3758 David Bermingham DB Admin 3 218 With more mission critical databases being deployed in VMs, availability options for SQL Server have grown immensely. Clustering, vMotion, Live Migration, HA, FT, database mirroring and more. Who is responsible to ensure your database is available 24 x 7? Is it the DBA? Is it the server team? Maybe it is the virtualization team? Maybe it is a joint decision among all of those teams. Regardless of who is ultimately responsible, this session will give you a great understanding of the options available and what they do and do not protect against to ensure the availability of your database. 3/19/2011 3:45:00 PM 3/19/2011 4:45:00 PM 3785 Craig Purnell DB Admin 3 218 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. 3/19/2011 11:00:00 AM 3/19/2011 12:00:00 PM 3791 Melissa Coates BI 2 217 As a report developer, you want to ensure your reports are structured for accuracy, performance, maintenance, and reusability. One of your many decisions includes where to perform report-specific calculations when the source is a SQL Server relational database. In this session we will compare and contrast a sampling of functions available in T-SQL and SSRS, with an emphasis on handling aggregation, ranking, dates, and strings. A 'cheat sheet' will be available online for future reference. Session Goal: Identify common situations when performing calculations within SSRS is preferred, versus when the T-SQL source query may be more appropriate. 3/19/2011 1:15:00 PM 3/19/2011 2:15:00 PM 3794 Aaron Nelson DB Admin 1 216A You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool. 3/19/2011 1:15:00 PM 3/19/2011 2:15:00 PM 3834 Brian Davis DB Admin 1 216A Have you heard of Service Broker? Do you know what it is? How about how to use it? This session will answer these questions and more. Service Broker is arguably one of the least known and used features of SQL Server. We'll explore Service Broker and learn what it is and how it works. We'll walk through the setup and configuration along with demonstrating its use. You'll leave this session with a better understanding of Service Broker, its use and implementation, along with ideas of how you can implement it in your own environments. 3/19/2011 11:00:00 AM 3/19/2011 12:00:00 PM 3836 Nathan Mourfield BI 2 217 This session is geared around introducing the SQL Dev or Data Analyst to SQL Server Analytical Services. Topics covered: Intro to SSAS Welcome to the Cube Beginning Cube Ninjary Data Mining Kung Fu 3/19/2011 11:00:00 AM 3/19/2011 12:00:00 PM 3840 Chris Skorlinski DB Admin 2 219 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. 3/19/2011 9:45:00 AM 3/19/2011 10:45:00 AM 3848 Ashton Hobbs DB Admin 3 218 This session will cover everything a good SQL Developer needs to know about indexing. Will cover how to identify when needed indexes are missing, how to find bad indexes and remove them, understanding exactly what data is stored within indexes and much more. Understand why having indexes can be both bad and good by understanding your own data and how it is structured and accessed. Will cover various design patterns, SQL Server DMVs, as well as real world examples of good and bad indexes. 3/19/2011 1:15:00 PM 3/19/2011 2:15:00 PM 3877 Tejas Patel BI 3 218 Session will introduce Microsoft Solver Foundation and its application with Microsoft BI Platform. This is a basic session and intended to target audience with none or limited exposure to Microsoft Solver Foundation. 3/19/2011 11:00:00 AM 3/19/2011 12:00:00 PM 3880 Alex Tocitu DB Development 101 This talk will go over some of the best practices of software engineering as they apply to SQL Server CLR projects. We will also show how to build a small library of utilities, stored procedures, functions, etc., that should help you remove some of SQL Server built-in functional barriers. 3/19/2011 8:30:00 AM 3/19/2011 9:30:00 AM 3890 Julie Smith BI 1 215 This presentation is for absolute beginners to Integration Services, giving the bare essentials to start working in this environment with confidence. We’ll cover basic architecture, basic development, and basic administration in one hour! List of scary acronyms and terms on the list for “demystification”: SSIS, BIDS, ETL, Configurations, Package Deployment, Package Execution, SQL Server Agent. 3/19/2011 9:45:00 AM 3/19/2011 10:45:00 AM 3892 Brett Tomson DB Development 101 With the release of SQL Server 2008 R2, Microsoft also released a powerful though relatively little known tool called StreamInsight. Microsoft StreamInsight is a complex event processing (CEP) engine that allows you to process, filter and aggregate high volumes of data with relatively low latency. This session will cover core concepts related to StreamInsight including events and windows along with examples of of how to incorporate StreamInsight into your environment. Though bundled with SQL Server, a familiarity with .NET is required. 3/19/2011 2:30:00 PM 3/19/2011 3:30:00 PM 3903 Barry Ralston BI 3 218 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. 3/19/2011 3:45:00 PM 3/19/2011 4:45:00 PM 3907 Audrey Hammonds DB Development 101 There’s nothing quite as satisfying as writing a cool bit of T-SQL. Luckily for us, there are some truly awesome ways to make your data do just what you need it to do, while improving performance and/or readability. Come learn three new-school ways to expand your T-SQL repertoire with: • Recursive Common Table Expressions (CTE) • EXCEPT and INTERSECT • CROSS APPLY and OUTER APPLY We will look at data models and scenarios you might encounter that lend themselves to these techniques, see old-school ways to solve T-SQL challenges, and then compare them to newer, leaner ways to get the same result set. Impress your friends and confound your frenemies with your mad T-SQL skills. 3/19/2011 11:00:00 AM 3/19/2011 12:00:00 PM 3909 Jorge Segarra Professional Dev 113 This session is aimed at those who are looking to come fresh into the wonderful world of SQL Server administration. Based off my blog project of the same name, SQL University is aimed at teaching students SQL Server from the ground up. In this session we'll cover some of the essential basics in terminology, tools and general tasks needed to get started in administration. So sharpen your pencils and enroll in SQLU today! 3/19/2011 8:30:00 AM 3/19/2011 9:30:00 AM 3910 Audrey Hammonds Professional Dev 113 Ugly data is the scourge of developers and DBA’s alike. Do your part to rid the world of ugly data models! Beautiful data starts with a beautiful design. In this session we’ll begin with requirements and end with a physical model, discussing how to make sure that your database design equals data integrity, scalability, and good looks. Topics include: --Requirements Analysis --Conceptual Modeling --Logical Physical Modeling --Best Practices 3/19/2011 3:45:00 PM 3/19/2011 4:45:00 PM 4009 Andy Leonard Main Hall / Large Meeting Room TBD In this session, SQL Server MVP Andy Leonard will demonstrate how to manage source code for SQL Server from right in SQL Server Management Studio using Red Gate's Source Control. 3/19/2011 12:15:00 PM 3/19/2011 1:15:00 PM 4013 Staff SQL Saturday Main Hall / Large Meeting Room TBD Logistics and Announcements for SQL Saturday #70 3/19/2011 8:15:00 AM 3/19/2011 8:30:00 AM 4014 Staff SQL Saturday Main Hall / Large Meeting Room TBD Closing Remarks and Prize Raffle 3/19/2011 4:45:00 PM 3/19/2011 5:15:00 PM 4015 Staff SQL Saturday Main Hall / Large Meeting Room TBD On-Site Check-In Begins (registration if space available) 3/19/2011 8:00:00 AM 3/19/2011 8:15:00 AM