SQLSaturday #64 - Baton Rouge 2011 8/6/2011 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat64 Baton Rouge LA 40292 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 1290 HP - Microsoft Alliance Platinum Sponsor http://www.microsoft.com/sqlserver/en/us/solutions-technologies/hp-partnership.aspx https://byfiles.storage.live.com/y1p3hZm-fNC9IULoCNdrUw96Co89phnmg7oFECNS31wVSGw3rqRxi1NqGX7oa63GeRPn65rqd7vV_E/hp-ms_alliance.png?psid=1 60 170 1358 Microsoft Platinum Sponsor http://www.microsoft.com http://www.microsoft.com/presspass/images/gallery/logos/web/mslogo-1.jpg 60 170 1383 Perficient, Inc. Platinum Sponsor http://www.perficient.com http://www.perficient.com/media/logos/perficient_HORIZ.jpg 60 170 1228 Antares Technology Solutions, Inc. Gold Sponsor http://www.antaresnet.com http://www.tsqlscripts.com/companylogos/antares.png 60 170 1272 Geocent, LLC Gold Sponsor http://www.geocent.com http://f.cl.ly/items/212s0A0C380y1B0S3n2m/Geocent%20Logo%20Final%20-%203-color.jpg 60 170 1328 Telerik Inc. Gold Sponsor http://www.telerik.com/ http://www.brdnug.org/wp-content/uploads/Telerik-Logo.png 60 170 1356 Sparkhound Gold Sponsor http://www.sparkhound.com/index.asp http://www.sparkhound.com/images/sparkhound_logo.gif 60 170 1385 Red Gate Software Gold Sponsor http://www.red-gate.com/?utm_source=ugutm_medium=uglogoutm_content=sqlsaturday64batonrougeutm_campaign=redgate http://www.red-gate.com/assets/images/logos/RG_simpletools-onwhite515x143.jpg 60 170 1398 K2 (SCNA) Gold Sponsor http://www.k2.com http://dl.dropbox.com/u/20570196/K2identity_4C_RGB_jpg.jpg 60 170 1401 Quest Software Gold Sponsor http://www.quest.com http://www.quest.com/images/common/quest-logo.gif 60 170 1194 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 1293 Fusion-io Silver Sponsor http://www.fusionio.com/ http://www.fusionio.com/images/fusionio-logo.gif 60 170 1342 Idera Silver Sponsor http://www.idera.com http://www.idera.com/images/promos/Idera_40.jpg 60 170 1408 Amedisys Home Health Services Silver Sponsor https://www2.ultirecruit.com/AME1028/JobBoard/searchjobs.aspx?Page=Search__SVRTRID=D6D7412E-88D4-43D4-96CA-34DDDD2B1A24 http://www.amedisys.com/app_themes/Main/images/logo.gif 60 170 1357 Louisiana State University Facility Sponsor http://www.lsu.edu http://www.lsu.edu/pa/identity/images/1colorHorizFNPurp.jpg 40 100 1368 Community Coffee Company Coffee Sponsor http://www.communitycoffee.com http://www.communitycoffee.com/App_Themes/CCC-Red/img/footer-left.gif 40 100 3093 Cade Roux SQL Admin II 1121 Integrated metadata is a required element of all RDBMSs. In addition to ANSI INFORMATION_SCHEMA and metadata on implementation-specific features like indexes, SQL Server also offers a very powerful extended properties feature. In this talk, I cover using the basic metadata combined with extended properties and demonstrate practical usage to organize and document a system's design and monitor the health of a system's compliance with design rules. 8/6/2011 8:30:00 AM 8/6/2011 9:30:00 AM 3125 Ira Whiteside SSIS/SSRS 1112 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. 8/6/2011 9:45:00 AM 8/6/2011 10:45:00 AM 3343 Peter Myers SQL Admin I 1109 This session explores the rich visualization capabilies of Reporting Services 2008 R2. Beyond the standard capabilities to deliver data using grid layouts (tables and matrices), Reporting Services includes Chart, Gauge, Map, Data Bars, Sparklines and Indicators visualizations. Learn what each delivers and how to configure them to produce visually compelling reports. Furthermore, learn how the Chart is also available to developers to embed directly into .NET applications. 8/6/2011 1:30:00 PM 8/6/2011 2:30:00 PM 3347 Peter Myers BI 1111 Analysis Service’s OLAP component allows organizations to implement a cube that is designed for rapid ad hoc information retrieval of their data. The cube, as a single version of the truth, can be enriched to encapsulate business rules and calculations, and advanced Business Intelligence features including KPIs and actions. For organizations that have a Standard or Enterprise SQL Server license, Analysis Services is a possible zero-cost opportunity for your organization today. In the session learn how to exploit the capabilities and features, and the basics of best practice design. Be prepared for numerous compelling demonstrations and to leave the session energized by the potential! 8/6/2011 11:00:00 AM 8/6/2011 12:00:00 PM 3706 Jose Chinchilla SSIS/SSRS 1112 Need to know what is the corresponding SSIS transformation or task to a specific T-SQL statement? How do you accomplish Unions, Joins, and Merges in SSIS? How do you do CASE statements in SSIS? How do you group and aggregate data in SSIS? In this session I will cover the some of the most important SSIS control flow and data flow tasks to jump start DBAs and Developers into SSIS with SQL Server 2008-R2. At the end of this demo, you will be able to identify what control flow tasks and data flow transformations can be used in place of T-SQL statements and scripts. I will also cover how to accomplish in SISS: Basic SELECT, INSERT, DELETE, UPDATE statements, Inner and Outer joins, Union, Aggregates, Merge, CAST, CASE, Sorting, Grouping, etc 8/6/2011 11:00:00 AM 8/6/2011 12:00:00 PM 3826 William Pearson BI 1111 In this presentation, Microsoft BI Architect and SQL Server MVP Bill Pearson explores “self-service BI” as a concept. We then provide a walkthrough of the primary features of PowerPivot, focusing on how we can exploit its capabilities to offer the benefits of BI to decision makers and analysts throughout our organizations. “There’s no service like self-service …” 8/6/2011 4:00:00 PM 8/6/2011 5:00:00 PM 3828 William Pearson SharePoint 1114 Gain exposure to the Server side of PowerPivot with Microsoft BI Architect and SQL Server MVP Bill Pearson. The targeted audience of this session includes professionals who will be planning, deploying and maintaining the server side of PowerPivot. Among other BI architects and developers, this overview will be of particular interest to SharePoint Admins who are new to capabilities for sharing and managing PowerPivot applications created with PowerPivot for Excel. 8/6/2011 1:30:00 PM 8/6/2011 2:30:00 PM 3943 Brian Sullivan .NET II 1110 The whiz-bang visual designer features of the Entity Framework demo well, and may even work for small projects, but anyone who's worked with EF knows that on larger projects, the design surface quickly becomes unusable and a bottleneck to your development process. Thankfully, the Entity Framework team has heard our anguished cries and introduced a new API for defining your EF models, dubbed 'Code-First'. In this presentation, Brian will guide you through building a true POCO model, basic mapping techniques, and leveraging conventions to keep your mappings DRY. 8/6/2011 1:30:00 PM 8/6/2011 2:30:00 PM 3961 Zain Naboulsi .NET I 1119 Created for the seasoned developer, this session explores the features that can, literally, save hours of work. Learn how to create your own templates all the way to special DevEnv switches you can use to quickly reconfigure your environment. These are the super tips that can turn a ten minute task into ten seconds. 8/6/2011 9:45:00 AM 8/6/2011 10:45:00 AM 4260 Ryan Richard .NET I 1119 Silverlight and WPF are new technologies that break from the traditional Windows Forms style of programming. The MVVM (Model-View-ViewModel) pattern can be used to create a robust and testable framework for your new Windows or Web application. 8/6/2011 2:45:00 PM 8/6/2011 3:45:00 PM 4399 Janis Griffin SQL Admin II 1121 SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query. 8/6/2011 4:00:00 PM 8/6/2011 5:00:00 PM 4422 Tim Costello BI 1111 This session will cover the best practices of dashboard design and data analytics as we explore and create data visualizations from the history of SQL Saturday. This session will focus on analyzing trends over time, categorical trending and dashboard design. 8/6/2011 2:45:00 PM 8/6/2011 3:45:00 PM 4459 Victor Chataboon SharePoint 1114 Lessons for the accidental SharePoint administrator In many environments, there's one lucky winner that becomes the SharePoint Administrator or keeper of the system. This session provides some good advice for beginning Administrators seeking to gain a better understanding on how to effectively implement SharePoint in their environment. 8/6/2011 11:00:00 AM 8/6/2011 12:00:00 PM 4468 Stacy Vicknair .NET II 1110 Tired of access or excel 'applications'? Ready to quickly replace those apps with a 3-tier solution based on best practices and the .NET platform? In this session we'll look at how Microsoft's latest Visual Studio SKU, Visual Studio LightSwitch, can help rapidly create data-driven rich Internet applications. Get rid of those legacy nightmares once and for all! 8/6/2011 4:00:00 PM 8/6/2011 5:00:00 PM 4493 Kevin Boles SQL Admin I 1109 We will cover most of the bases in this broad and deep coverage of table/index partitioning in the relational engine. Numerous demonstrations will help gel knowledge you can take back to the office and begin to apply to your environments to reap the many benefits of this fine addition to the product that has been significantly enhanced since SQL 2005. 8/6/2011 2:45:00 PM 8/6/2011 3:45:00 PM 4495 Kevin Boles SSIS/SSRS 1112 The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven't been shown the light you might never realize what is possible. Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques. 8/6/2011 1:30:00 PM 8/6/2011 2:30:00 PM 4498 Michael Moles Bonus Track 1120 An introduction to Agile using the Scrum Process. In the past I’ve done an Agile presentation but soon learned that many people needed the basics, so I’ve created a introduction presentation. Even if you know Agile but don’t know scrum, I think you will find this presentation useful. You will learn about what a Scrum Master is vs. a Product Owner; you will understand the difference between the Team and the Stakeholders. Lots of good stuff. 8/6/2011 9:45:00 AM 8/6/2011 10:45:00 AM 4503 Brian Rigsby .NET I 1119 Learn the philosophy, mindset, and attitude of a professional, principled, disciplined software developer. 8/6/2011 8:30:00 AM 8/6/2011 9:30:00 AM 4510 Kyle Kelin .NET II 1110 Multi-core processors are becoming pretty prevalent for most business user's workstations these days. This trend has increased the benefits for developer's to take advantage of multiple threads in applications. While not every application will benefit from being multi-threaded this programming tool should be in every .NET developers tool belt. Unfortunately in my experience the majority of .NET developers are not comfortable with this programming paradigm and are afraid to ask. This session dives into the basics behind threads, outlines all the different threading options in .NET, and then walks through programming examples using .NET 2.0 and 4.0. 8/6/2011 8:30:00 AM 8/6/2011 9:30:00 AM 4583 Stuart Ainsworth SQL Admin II 1121 Most database professionals know (from firsthand experience) that there continues to be a 'data explosion'. Databases are getting larger, and working with Very Large DataBases (VLDB's) is becoming more commonplace. The focus of this session is to identify some key guidelines for the design, management, and ongoing optimization of VLDB's. Special attention will be paid to the following areas: * query design * logical and physical data structures * maintenance backup strategies 8/6/2011 2:45:00 PM 8/6/2011 3:45:00 PM 4586 Chander Dhall .NET I 1119 Come and see the important components of building an enterprise app with the current best practices on Mvc3 framework. It shows how to integrate Ioc containers, do some smart unit testing and integration testing. Use SOLID principles in practical every day development. Focus on techniques that increase productivity and reduces maintenance costs for the project down the line. And to use repository and unit of work patterns for ORMs like Nhibernate and Entity framework. 8/6/2011 4:00:00 PM 8/6/2011 5:00:00 PM 4587 Eric Trivette SharePoint 1114 Business Connectivity Services (BCS), formerly Business Data Catalog, is a SharePoint 2010 service that allows developers to read and write data to and from external line-of-business (LOB) systems. In this session you will learn best practices in developing BCS solutions, including when to use BCS for your SharePoint projects, choosing the right type of BCS solution, securing your BCS solutions, and development techniques to use when creating your BCS solutions. 8/6/2011 2:45:00 PM 8/6/2011 3:45:00 PM 4613 Justin Yesso SSIS/SSRS 1112 At fist glance, SSRS can seem like an odd fit for .Net reporting. There is a little known side of SSRS that allows it to integrate seamlessly into an application's architecture. This session will introduce the concept of local mode reporting and how this feature allows direct binding to your Data Layer, Entity Model or any other type of object collection in your application. 8/6/2011 4:00:00 PM 8/6/2011 5:00:00 PM 4631 Sean McCown SQL Admin I 1109 One of the most important functions a DBA can perform is the backup. And far too many DBAs rely on the wizard to perform this task. Here I'll take you through everything you need to know about understanding command line backups, writing backup routines, and making the right decisions on how to do what kind of restore and when. I will take you through basic backup syntax and fully explain how things work the way they do and why. If you ever wanted to understand the ins and outs of SQL Server backups then this session will give you what you're after. 8/6/2011 4:00:00 PM 8/6/2011 5:00:00 PM 4632 Sean McCown SQL Admin II 1121 The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started. 8/6/2011 11:00:00 AM 8/6/2011 12:00:00 PM 4638 William Assaf SQL Admin II 1121 In this practical and script-focused session, we'll discuss many best practices regarding SQL Server administration, maintenance, optimizations and monitoring using Dynamic Management Views. DMV's are essential tools for the SQL administrator, but have a wide range of applications by developers, network engineers and DBAs. We will delve into best practices for server maintenance, index fragmentation, XEvents, wait type analysis and future features. This session will be informative and eye-opening to anyone from a junior DBA on up. 8/6/2011 9:45:00 AM 8/6/2011 10:45:00 AM 4641 Steve Jones SQL Admin I 1109 Come learn the ten most important skills that every accidental DBA, developer, or even manager should be able to do in SQL server. If you want to know where to start working with SQL server or which 10 things will get you through most of your days, some see Steve Jones show you how to accomplish these ten important tasks and explain why they are important. These ten skills represent the 80/20 rule in action; if you can do these ten things, you can successfully get through most of your days at work. 8/6/2011 11:00:00 AM 8/6/2011 12:00:00 PM 4646 Rob Vettor .NET I 1119 Design patterns are recurring solutions to software design problems you find again and again in application development. They also serve as a vocabulary for developers to communicate their ideas. Come and walk-through 5 key patterns, with easy-to-follow examples, and a clear explanation of the how and why behind each: • Factory • Strategy • Observer • Template Method • Decorator You’ll walk away with an understanding of each pattern which you can take to the office the next day and implement 8/6/2011 1:30:00 PM 8/6/2011 2:30:00 PM 4647 Rob Vettor .NET I 1119 While most enterprise applications are object-oriented, the data upon which they depend is not. Unfortunately, binding these two platforms together can result in significant amounts of lost productivity and a less than optimal solution. Come see how you can resolve this recurring theme with the Microsoft ADO.NET Entity Framework. In this session, we’ll… • Explore the Entity Framework 4, its components and see how it all works • Generate a business object model with database mappings, demonstrating database-first, model-first and code-only approaches • Walk through a variety of code examples that show how to interact with the model • Show how the Entity Framework automatically tracks data changes and generates updates • Deep-dive 8/6/2011 11:00:00 AM 8/6/2011 12:00:00 PM 4654 Wes Brown SQL Admin I 1109 The most important part of your SQL Server is also the slowest, Storage. This talk will take you through the fundamentals of your server's Disk I/O System. This session should give you a solid foundation over storage systems and help you understand why they are slow and how to overcome some of their limitations. We will cover the basics of computer systems, hard disks and disk controllers. Next, we will move to the fundamentals of RAID and how to configure your arrays for performance and reliability. Later, we will discuss the relationship between SQL Server and the file system, what is required for SQL Server and how to configure the file system for optimal performance. Finally, we will touch on how to monitor the performance and health of 8/6/2011 8:30:00 AM 8/6/2011 9:30:00 AM 4658 John Welch SSIS/SSRS 1112 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 or packages that adhere to a pattern, 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. 8/6/2011 2:45:00 PM 8/6/2011 3:45:00 PM 4666 John Welch BI 1111 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. 8/6/2011 9:45:00 AM 8/6/2011 10:45:00 AM 4722 Cody Gros SharePoint 1114 This informative and demo filled session provides real world examples of using SharePoint Management Shell in SharePoint 2010. This session will demonstrate how to take full advantage of using the SharePoint Management Shell to solve common issues in SharePoint 2010. The session will be presented in a Problem/Solution/Discussion style. This is a must see session for anyone who wants to learn how to take the SharePoint Management Shell to the next level. 8/6/2011 8:30:00 AM 8/6/2011 9:30:00 AM 4753 Latish Sehgal Bonus Track 1120 Are you a big fan of productivity plugins like ReSharper, CodeRush and SSMS Tools Pack? Ever wondered how you can write your own plug-ins for Visual Studio or Sql Server Management Studio? Come to this session to learn about the different ways to extend these editors. We'll see how one can create extensions, add-ins and packages and add new functionality to Visual Studio and Sql Server Management Studio. 8/6/2011 11:00:00 AM 8/6/2011 12:00:00 PM 4779 J Sawyer Bonus Track 1120 Introduced as a part of the Sql Server 2008 R2 platform, StreamInsight is Microsoft's Complex Event Processing (CEP) engine. It allows you to analyze and process large volumes of data - think tens to hundreds of thousands of events per second - with sub-second response time. It's as close to real time as you can get without quantum entanglement! The Sql Server engine may be fast ... but it's just not that fast. This presentation will introduce core CEP concepts and sample uses cases and then dive into kinkiness with real-time data, including hosting StreamInsight, getting data into (and out of) the engine, how time is handled, writing queries in Linq and how to extend the StreamInsight engine. It's a whole new paradigm of looking at data 8/6/2011 8:30:00 AM 8/6/2011 9:30:00 AM 4833 Chris Eargle .NET II 1110 Do you want to learn or have a refresher on the fundamentals of object-oriented programming and C#? This session is perfect for the DBA who must occasionally code and the developer who wants a deeper understanding of C# and OOP. 8/6/2011 2:45:00 PM 8/6/2011 3:45:00 PM 4836 Carlos Bossy BI 1111 Business Intelligence is an essential component for any business today and a successful BI implementation has the power to change the way your organization functions. In this non-technical session Carlos Bossy will show you what a BI project looks like and how it is different from other IT projects, how to determine the ROI of a BI project, the makeup of a good BI team, how to define the success of a BI implementation, and how to fix a BI project gone bad. You will also learn how to evaluate your BI Analytical Strategy and you should leave this session with better knowledge of how to plan, build and deploy effective Business Intelligence solutions. 8/6/2011 8:30:00 AM 8/6/2011 9:30:00 AM 4837 Carlos Bossy Bonus Track 1120 A data warehouse built using star schema dimensional models can be tuned to handle a demanding workload put on it by its users who require fast reports, dashboards, data extracts, and ad-hoc analysis. In this session Carlos Bossy will discuss the unique problems associated with star schema query performance and present strategies that will allow you to handle large query volumes in a dimensional environment. Topics covered will include clustering, indexing and partitioning, and how to treat fact tables different from dimension tables. 8/6/2011 4:00:00 PM 8/6/2011 5:00:00 PM 4875 SQL Sat SQL Admin I 1109 Come early and find out how to navigate through the sessions. Descriptions of Tracks will be given in the morning while you grab a cup of coffee and a morning snack 8/6/2011 8:00:00 AM 8/6/2011 8:30:00 AM 4884 First Vendor SQL Admin I 1109 Vendor 1 8/6/2011 12:30:00 PM 8/6/2011 1:15:00 PM 4885 First Raffle SQL Admin I 1109 End of day raffle 8/6/2011 5:00:00 PM 8/6/2011 5:30:00 PM 4918 Ryan Duclos Bonus Track 1120 During this session we'll explore an introduction to the Windows Azure platform. Covered will be basics of the developer tools, how development differs from traditional ASP.NET development. Also jump into some of the basics about the Azure Storage options (Tables, Blobs, and Queues), and briefly mention SQL Azure. 8/6/2011 1:30:00 PM 8/6/2011 2:30:00 PM 5037 Cherie Sheriff SSIS/SSRS 1112 Have you ever wondered who made a change to your structures or data? Do you need to find out who has permissions to do what in your system? This session will take you on a tour of auditing for internal, SOX or HIPPA Compliance. How much of a summary do you need? Or will this work? I will go into some data forensics as well, but to keep it within the time limit, I will structure it to structural changes, not so much the data itself, though the same techniques apply. 8/6/2011 8:30:00 AM 8/6/2011 9:30:00 AM 5059 Chris Koenig Windows Phone Garage 1116 This session is an introduction to developing for Windows Phone 7. 8/6/2011 9:45:00 AM 8/6/2011 10:45:00 AM 5061 Chris Koenig Windows Phone Garage 1116 During this session we will walk through some of the published sample Windows Phone 7 applications. 8/6/2011 11:00:00 AM 8/6/2011 12:00:00 PM 5157 Chris Koenig Windows Phone Garage 1116 During this session Chris will be available to help you answer any questions that you have in developing your phone application. It is also a great time to bring in your laptop and start working on a sample phone application. Please come with the software pre-loaded to develop phone application. You can find more information at http://msdn.microsoft.com/en-us/library/ff402535(v=vs.92).aspx. 8/6/2011 1:30:00 PM 8/6/2011 2:30:00 PM 5256 Jennifer McCown SQL Admin II 1121 You’re a good SQL professional – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. You’ll learn that Common Table Expressions are, in fact, very cool, and that FOR XML isn’t as scary as it looks. And what’s more, we’ll look and BRAND-new features like SQL Server Denali’s new SEQUENCE object! 8/6/2011 1:30:00 PM 8/6/2011 2:30:00 PM 5257 Jose Chinchilla BI 1111 In this session Jose will do an overview of the different types of hierarchies and how to design user hierarchies in SSAS by defining attribute relationships and key columns the right way. Attendees will learn how to implement natural unnatural hierarchies, balanced and ragged hierarchies, and Parent-Child hierarchies. Jose will show how to optimize SSAS hierarchies by specifying attribute and dimension types, member uniqueness, and aggregations. Jose will also do quick intro on querying hierarchies with MDX. 8/6/2011 1:30:00 PM 8/6/2011 2:30:00 PM 5436 Arnoldo Ruiz SharePoint 1114 Optimizing storage and implementing comprehensive data protection strategies are essential for a highly performant, reliable SharePoint environment. SharePoint and SQL Server natively provide capabilities in this regard, but they prove inadequate for most organizations. In this session, we will discuss key components for a successful SharePoint backup and recovery plan, including extended and archived content. After analyzing SharePoint's native features, we will identify best practices and available solutions for ensuring a reliable, scalable SharePoint platform. 8/6/2011 4:00:00 PM 8/6/2011 5:00:00 PM 5437 Al Manint .NET II 1110 Tired of Web Forms? Interested in why Microsoft is pushing MVC? Want to know what it stands for and why? The basics of the project type and each of the aspects are explored. Come explore a different way to write web applications in ASP.NET. 8/6/2011 9:45:00 AM 8/6/2011 10:45:00 AM 5443 Cory Roth SharePoint 1114 The number one complaint about Enterprise Search is usually summed up by a statement like this: “I can’t find anything!”. Whether you are using SharePoint Foundation with Search Server Express, SharePoint Server 2010, or FAST Search for SharePoint, the quality of the results you receive from search is only as good as the input you give it. Out-of-the-box, SharePoint gives you a very functional search engine, but you need to do some work to really enable the full power it provides. This intro level talk will teach you the basics of Enterprise Search in SharePoint. Here you will learn about the basic building blocks such as content sources, crawled properties, managed properties, and scopes. 8/6/2011 9:45:00 AM 8/6/2011 10:45:00 AM 5495 Ryan Duclos Bonus Track 1120 SQL Azure is part of the Windows Azure platform: a suite of services providing hosted computing, infrastructure, Web services, Reporting services and data services. The SQL Azure component provides the full relational database functionality of SQL Server, but it also provides functionality as a cloud-computing service, hosted in Microsoft datacenters around the globe. We will go over how it works and what it has to offer. 8/6/2011 2:45:00 PM 8/6/2011 3:45:00 PM 5502 Jennifer McCown SQL Admin I 1109 Once upon a time, you inherited an application or a database that was filled with chaos and inconsistencies. The T-SQL code is overly complex and impossible to ken. The architecture is painful to behold, and grueling to code for. One might optimistically say that query performance is “spectacularly mediocre”. If you’re without good documentation or system architects to guide you, how do you break the curse of confusion? In this session you’ll learn several methods for conquering chaotic code, and how to seek and destroy some of the nastier coding mistakes and inefficiencies. We will break complicated queries into key pieces, turn them upside-down, and reform them into something sensible. 8/6/2011 9:45:00 AM 8/6/2011 10:45:00 AM 5531 Mike Huguet .NET II 1110 Take advantage of the Open XML format and the .NET SDK to construct and manipulate documents, allowing for simplified interactions with Office documents. This session covers the Open XML format, the Open XML SDK, and shows some examples of how to apply this in real world solutions. We’ll also discuss the role of some of the SharePoint Office Services. 8/6/2011 11:00:00 AM 8/6/2011 12:00:00 PM