SQLSaturday #22 - Pensacola 2010 6/5/2010 12:00:00 AM A free one day training event for those interested in SQL Server #sqlsat22 Pensacola FL 32504 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 506 Quest Software Platinum http://www.quest.com http://www.quest.com/images/common/quest-logo.gif 60 170 569 Pensacola Junior College - Information Assurance Platinum http://www.pjc.edu http://pensacola.sqlpass.org/Portals/29/images/logos/PJCLogo_small.jpg 60 170 203 End to End Training Gold Sponsor http://www.endtoendtraining.com http://www.endtoendtraining.com/Images/endtoendlogo.jpg 60 170 204 JumpstartTV.com Gold Sponsor http://www.jumpstarttv.com http://www.jumpstarttv.com/images/header_logo.jpg 60 170 445 Red Gate Software Gold Sponsor http://www.red-gate.com/about/community_relations/sql_saturday.htm?utm_source=ugutm_medium=uglogoutm_content=sqlsaturdaypensacolautm_campaign=redg http://www.red-gate.com/images/redgatelogo_black.jpg 60 170 460 O'Reilly Media Gold Sponsor http://oreilly.com/ http://cdn.oreilly.com/images/standard/oreilly-logo-footer.gif 60 170 481 Apress Inc. Gold Sponsor http://apress.com/ http://www.apress.com/img/masthead_logo.gif 60 170 489 Fusion-io Gold Sponsor http://www.fusionio.com http://www.fusionio.com/images/logo-light.png 60 170 525 Confio Software Gold Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 532 Bit-Wizards Custom Softwarwe Solutions, Inc. Gold Sponsor http://www.bitwizards.com http://bitwizards.com/App_themes/Bit-Wizards/images/logos/Logo2.jpg 60 170 534 Microsoft Corporation Gold Sponsor http://www.microsoft.com http://i.microsoft.com/global/sqlserver/2008/en/us/PublishingImages/logo-header-sql08-dg.gif 60 170 576 Antares Technology Solutions, Inc. Gold Sponsor http://www.antaresnet.com http://www.antaresnet.com/PublishingImages/Antares logo beside name2.jpg 60 170 588 Overgroup Consulting, LLC Gold Sponsor http://www.overgroup.com http://overgroup.s3.amazonaws.com/logo/overgroup-small.jpg 60 170 570 Telerik Inc Silver Sponsor http://www.telerik.com http://www.telerik.com/Libraries/Company/TelerikLogoPreview.sflb?Download=true 60 170 586 TeleVox Software, Inc. Silver Sponsor http://www.televox.com http://www.televox.com/graphics/TVOXEmailSig.jpg 60 170 442 WestClinTech Bronze Sponsor http://www.westclintech.com http://westclintech.com/portals/0/images/xldb_logo.jpg 60 170 461 HealthWare Corporation Bronze Sponsor http://healthware.com/ http://healthware.com/images/logo.png 60 170 1082 Brad McGehee Room 2142 - MS TECH 2142 (Auditorium) The focus on this session is on describing best practices every SQL Server DBA needs to know. These are foundational best practices that, if not followed, could have a significant negative effect on the performance and availability of their SQL Servers. As such, this session is targeted towards those who have less than one year’s experience. This session focuses on key fundamentals, such as: Installing Upgrading SQL Server; SQL Server Configuration; User Data and Log File Management; Database Configuration Settings; Configuring Critical Maintenance Jobs; Setting Up Alerts for Critical Errors; Security Basics; Implementing a Backup and Restore Strategy; Creating a Disaster Recovery Plan; Testing; Monitoring; and Documentation. 6/5/2010 9:00:00 AM 6/5/2010 10:00:00 AM 1085 Brought to you by the Institute for Information Assurance Room 2176 - SECURITY 2176 6/5/2010 7:30:00 AM 6/5/2010 8:30:00 AM 1103 Brad Schacht Room 2175 - SSIS 2175 This session will get you past the learning curve of SSIS. Covers creating an end to end package that covers many of the concepts in SSIS. This session will be great for anyone who is a beginner to SSIS. 6/5/2010 9:00:00 AM 6/5/2010 10:00:00 AM 1105 Devin Knight Room 2176 - SECURITY 2176 In this session, you will learn how to split your measure group data in to more manageable pieces using partitions to speed up cube processing time. Then designing aggregations on your partitions will be discussed including how to create aggregations using Usage Based Optimization (UBO) to speed up query time. 6/5/2010 9:00:00 AM 6/5/2010 10:00:00 AM 1193 Sven Aelterman Room 2176 - SECURITY 2176 The first version of the ADO.NET Entity Framework, included in .NET Framework 3.5 SP 1, had several shortcomings. Microsoft has been busy working on the V4 release of the Framework and Entity Framework, to be released with Visual Studio 2010. This session will take a look at how the Entity Framework v4 can be used to develop N-Tier business applications and highlight some of the shortcomings that were fixed and some that haven’t been fixed yet. 6/5/2010 10:15:00 AM 6/5/2010 11:15:00 AM 1194 Sven Aelterman Room 2175 - SSIS 2175 The first version of the ADO.NET Entity Framework, included in .NET Framework 3.5 SP 1, had several shortcomings. Microsoft has been busy working on the V4 release of the Framework and Entity Framework, to be released with Visual Studio 2010. This session will take a look at how the Entity Framework v4 can be used to develop N-Tier business applications and highlight some of the shortcomings that were fixed and some that haven’t been fixed yet. 6/5/2010 3:15:00 PM 6/5/2010 4:15:00 PM 1207 Troy Gallant Room 2172 - DBA 2172 SQL Server replication allows DBAs to distribute data to various servers throughout an organization. Some reasons to employ replication include load balancing, offline processing redundancy. Transactional replication in particular can offer a very flexible solution where data frequently changes. This session will discuss the basics of planning and implementation of a solid transactional replication solution. 6/5/2010 3:15:00 PM 6/5/2010 4:15:00 PM 1268 Adam Jorgensen Room 2175 - SSIS 2175 Lets take your BI implementation to the next level with SharePoint 2010 BI and PowerPivot. We'll go through excel services, performancepoint services, and pulling it all together in SharePoint 2010. 6/5/2010 10:15:00 AM 6/5/2010 11:15:00 AM 1369 Ryan Duclos Room 2175 - SSIS 2175 Having trouble or trying to figure out how you can navigate to your reports through your application, without creating a complete dashboard? This session will show you how to navigate and control your reports through your application using links. SSRS, ASP.NET 6/5/2010 4:30:00 PM 6/5/2010 5:30:00 PM 1402 Robert Cain Room 2142 - MS TECH 2142 (Auditorium) Users have become familiar with the simple search capabilities of tools like Microsoft Live Search and Google. Did you know you can give your users the same ability to search their data with SQL Server? And it's as easy as 1-2-3! Come and learn the how to setup and use full text searching with SQL Server. 6/5/2010 2:00:00 PM 6/5/2010 3:00:00 PM 1408 Ken Simmons Room 2176 - SECURITY 2176 As the demand for data keeps growing and security and compliance keep tightening, the role of the DBA has become an increasingly critical part of maintaining compliance within the organization. This session will cover real world examples you can use with Policy-Based Management to ensure you have the proper server configuration and security settings in place along with the appropriate encryption and auditing options for your environment. 6/5/2010 2:00:00 PM 6/5/2010 3:00:00 PM 1432 Steven Lane Room 2171 - DEV 2 2171 In this session we will be examining Silverlight 4 - yes I said Silverlight 4. The focus of this meeting will be on what new features are available. Some of the new features that we will take a look at are the Printing API, COM interop, RichTextArea Control and many more. All of this in a 90 minute presentation, what more could you ask? Depending on time we will them explore the Silverlight Toolkit and sources that are available for further information. 6/5/2010 3:15:00 PM 6/5/2010 4:15:00 PM 1435 Rodney Landrum Room 2175 - SSIS 2175 I put together the DBA Repository a few years back and have written and spoken about it for as many years with updates and enhancements over time. At it's heart, the solution employs SSIS and SSRS and in late 2009 I updated it for performance and resiliency. You can read about the original solution in SQL Server Magazine. The latest update will be published in 2010. This will be a sneak peak at those enhancements. The session will cover some interesting uses of package variables and MERGE in SSIS with new reports as well. 6/5/2010 12:45:00 PM 6/5/2010 1:45:00 PM 1449 Barry Ralston Room 2171 - DEV 2 2171 This session will share with attendees a methodology for rapid dimensional modeling and protyping user interfaces with PowerPivot for Excel. 6/5/2010 10:15:00 AM 6/5/2010 11:15:00 AM 1451 Joseph Healy Room 2142 - MS TECH 2142 (Auditorium) Joe will cover several new features of VS2010. 6/5/2010 10:15:00 AM 6/5/2010 11:15:00 AM 1454 Marc Matthews Room 2171 - DEV 2 2171 The Debug TalkAbout will review a wide range of tools and techniques used to debug .NET code developed using Visual Studio and other code that may be misbehaving. Most of the tools discussed are either available on your system or as no cost downloads from the Web. Since there is more material in this talk than will fit into the schedule, this talk will be audiance directed. 6/5/2010 4:30:00 PM 6/5/2010 5:30:00 PM 1457 Brian Rigsby Room 2171 - DEV 2 2171 The philosophy, the mindset, the attitude of a professional, principled, disciplined software developer 6/5/2010 2:00:00 PM 6/5/2010 3:00:00 PM 1463 Joe Webb Room 2176 - SECURITY 2176 A good working knowledge of how SQL Server makes use of locking and transaction isolation levels can go a long way toward improving an application’s performance. In this session, we will explore SQL Server’s locking methodology and discover techniques for enhancing query response times. 6/5/2010 3:15:00 PM 6/5/2010 4:15:00 PM 1517 Chris Eargle Room 2169 - DEV 1 2169 C# is no longer a purely object-oriented language. It is no longer just an imperative, class-based, component oriented discipline. It is also a generic, declarative, functional discipline. I will introduce new principles in the context of the classic object-oriented and SOLID principles and show you how to master the C# language to be more declarative, more fluent, and more functionally cohesive. 6/5/2010 10:15:00 AM 6/5/2010 11:15:00 AM 1543 Cody Gros Room 2171 - DEV 2 2171 SharePoint 2010 includes hundreds of PowerShell cmdlets for managing your SharePoint 2010 environment. This session will first provide you with the basics of using PowerShell and then dive into using PowerShell to mange SharePoint 2010. You will learn everything from scripting out deployments to managing sites using PowerShell. This session will also show SharePoint administrators how to automate common SharePoint tasks. 6/5/2010 9:00:00 AM 6/5/2010 10:00:00 AM 1602 Eric Wisdahl Room 2175 - SSIS 2175 Many data integration and ETL projects run over budget and past deadlines because the quality of the data was not known prior to the proposal. This session will attempt to show the users how to get to know their data better through an in depth look at the new data profiling task as well as the data profile viewer in SSIS 2008. 6/5/2010 11:30:00 AM 6/5/2010 12:30:00 PM 1620 Sumeet Bansal Room 2172 - DBA 2172 Solid-state technologies are changing the way that MS SQL users run their databases. DBA’s are achieving significant TCO savings through performance enhancements, reliability improvements, and reduced energy and real estate costs using solid-state technologies. Solid state is changing the way datacenters look and how MS SQL Servers perform. This session will address: 1) On overview of solid state technology options for SQL Server 2) Why solid state makes a difference? 3) An comparison of the different types of NAND Flash-based products and the advantages and disadvantages of each: a. Disk-based SSDs b. Onboard/Embedded PCI Express devices c. Host-based PCI Express devices 4) Customer proof: Wine.com case study 6/5/2010 9:00:00 AM 6/5/2010 10:00:00 AM 1622 William Assaf Room 2172 - DBA 2172 What are DMV's in SQL 2005/2008, and how can you use them to improve query performance, discover indexing needs and more? 6/5/2010 4:30:00 PM 6/5/2010 5:30:00 PM 1645 Tim Costello Room 2171 - DEV 2 2171 SQL Source code control is something you can't afford to ignore. Learn to use open source tools to archive and manage sql objects (tsql scripts, ssis packages, ssis reports). Commit early, commit often. 6/5/2010 11:30:00 AM 6/5/2010 12:30:00 PM 1655 Patrick LeBlanc Room 2172 - DBA 2172 Building dimensions using the Slowly changing dimension wizard in SSIS is simple and quick. However its performance and flexibility is questionable. Even further, when trying to perform incremental loads of your Dimensions using the aforementioned approach or a custom approach prior to Change Data Captured (CDC) offered certain challenges. In this session Patrick will show you how to utilize CDC and SSIS to incrementally load Type I and Type II dimensions using features that are all native to SQL Server 2008. 6/5/2010 2:00:00 PM 6/5/2010 3:00:00 PM 1664 Shawn McGehee Room 2176 - SECURITY 2176 Working with limited resources in the hardware and software fields can be troubling for a DBA. Making things work smoothly when sharing servers among many applications can be a difficult and time consuming task. With SQL Server 2008 a new feature has been given to the DBA world that can make the process much easier. We will take a look at the resource governor from the ground up in this session and build a solution to alleviate some of the issues that come with sharing hardware using SQL Security, Windows Active Directory Security and more. 6/5/2010 4:30:00 PM 6/5/2010 5:30:00 PM 1667 Steve Jones Room 2142 - MS TECH 2142 (Auditorium) Steve Jones, founder of SQL Server Central talks about how to update your resume to fit into today's modern world, and take advantage of the tools offered by blogging, social networking, and more. 6/5/2010 3:15:00 PM 6/5/2010 4:15:00 PM 1668 Steve Jones Room 2142 - MS TECH 2142 (Auditorium) Learn the basics of SQL Server if you are new to working with the product. This high level technical session will introduce the basics of database design, objects in SQL Server, security, and queries as well as an overview of how the product is structured from an IT perspective. 6/5/2010 7:30:00 AM 6/5/2010 8:30:00 AM 1678 DANIEL ROSALES Room 2169 - DEV 1 2169 Come learn how to effectively use UML in your everday implementations. As VS2010 boasts UML support right from within the IDE with an array of UML compliant diagrams, we will stick to the whiteboard and avoid the technology. This is meant to force us to think through a problem together as a team and arrive at a common understanding. If there is time left, Danny will open up the IDE and actually implement whatever design the team arrived at. Come learn UML notation and more importantly, good object design! 6/5/2010 9:00:00 AM 6/5/2010 10:00:00 AM 1699 Joe Healy Room 2142 - MS TECH 2142 (Auditorium) During this session we'll explore an introduction to Cloud Computing and the Windows Azure cloud platform. Covered will be basics of the cloud dev tools, a look at Table, Blob, and Queue storage, and a dive into the specifics of SQL Azure. Time allowing we will also explore some best practices and optimal design patterns around Windows Azure usage. 6/5/2010 12:45:00 PM 6/5/2010 1:45:00 PM 1702 Chris Skorlinski Room 2172 - DBA 2172 This sessions provides a walk through of Microsoft's newest SQL Replication feature called Change Data Capture (CDC). Sessions covers overview of CDC, setting up CDC and using various CDC functions to retrieve list of data changes. CDC is often used by data warehouse applications to retrieve list of SQL insert and updates for a given time window. 6/5/2010 11:30:00 AM 6/5/2010 12:30:00 PM 1707 Rushabh Mehta Room 2142 - MS TECH 2142 (Auditorium) Finally a technology that the Information Worker can use to take raw data and turn it into valuable information in a matter of minutes from the comfort of their own desktop! In this very exciting and interactive session full of exciting demos, we will walk you through taking raw information from a variety of sources and building a powerful analytical model that can then be used for deep analysis and reporting. We will further see how this set of technologies revolving around the Office 2010 platform and SQL Server 2008 R2 will transform the way information workers will become self-sufficient with their ad-hoc BI and reporting needs. 6/5/2010 11:30:00 AM 6/5/2010 12:30:00 PM 1709 Bryan Soltis Room 2169 - DEV 1 2169 Dynamic, continuously changing data drives the internet. Companies are constantly modifying their content to deliver relevant and focused information to their users. A CMS-driven site allows for site owners to keep up with the pace of technology quickly and efficiently. The Kentico CMS Content Management system is a powerful, robust .NET platform for delivering dynamic, content-driven sites. This presentation will be an overview of the Kentico CMS system, an in-depth presentation of content updates using the system, integration of other .NET technologies, SQL Server databases. 6/5/2010 2:00:00 PM 6/5/2010 3:00:00 PM 1716 Tim Mitchell Room 2172 - DBA 2172 In this session, we'll explore some of the useful tasks and data flow components of SSIS. Join in as we review the File System Task and the SSIS looping containers, as well as data flow components including the Lookup Transformation, the Conditional Split, and the Derived Column. This session will include various demonstrations using SSIS 2008. 6/5/2010 10:15:00 AM 6/5/2010 11:15:00 AM 1720 Kevin Boles Room 2142 - MS TECH 2142 (Auditorium) We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some fairly subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. 6/5/2010 4:30:00 PM 6/5/2010 5:30:00 PM 1748 Trevor Barkhouse Room 2175 - SSIS 2175 This introduction to PowerShell is different than most. Instead of starting with a full treatment of the language, you will receive a brief overview then a collection of 'recipes,' stand-alone PowerShell scripts that automate various administration tasks for SQL Server 2000, 2005, and 2008. You will learn by example, and quickly realize why investing a little time into learning PowerShell will make your job a great deal easier. 6/5/2010 2:00:00 PM 6/5/2010 3:00:00 PM 1762 Cory Loriot Room 2169 - DEV 1 2169 We are going to discuss the more technical aspects of cross-site data gathering using the SharePoint Object Model to drive cross-divisional information for rollups. During the presentation, we will design and develop a practical solution for an external facing Mashup of Speaking Engagements with Speaker Biographies, mapped out using Bing Maps, and showing the latest tweets from the Speaker on Twitter. 6/5/2010 4:30:00 PM 6/5/2010 5:30:00 PM 1763 Kevin Grohoske Room 2169 - DEV 1 2169 With SQL Server 2008 R2, Microsoft has added spatial capabilities that provides a developer an very powerful toolset to create dynamic and powerful location aware applications. In this demonstration we will review the available spatial capabilities, objects, and complimentary Bing services used to develop a custom spatial aware Business Intelligence application. 6/5/2010 11:30:00 AM 6/5/2010 12:30:00 PM 1764 Vincent Mayfield Room 2169 - DEV 1 2169 Learn more about Microsoft® Silverlight™ technology that delivers the next generation of media and rich interactive applications for the web. Topics include: evolution of the user interface, cross platform user experience, flexible programming model, low cost delivery of media, and evaluating the technology for your business. This seminar is targeted for non-developers, managers, network administrator, and database administrators, who what to learn more about this new and exciting technology. 6/5/2010 12:45:00 PM 6/5/2010 1:45:00 PM 1765 Vincent Mayfield Room 2169 - DEV 1 2169 Most ASP.NET Developers are able to build ASP.NET Applications. However, few understand the principles of building scalable Enterprise Applications that are deployable in a Network Load Balanced or Clustered Server network configuration. This seminar targets advanced developers who desires to understand the considerations required in designing and building a scalable ASP.NET Applications. Topics covered in this seminar include: The NLB and Clustered Network Topology, Handling State, Inproc versus SQL Server State Management, Sticky Sessions, Programming Considerations, Database Considerations, and Statistics. 6/5/2010 3:15:00 PM 6/5/2010 4:15:00 PM 1782 Ryan Bott Room 2172 - DBA 2172 Check back. 6/5/2010 12:45:00 PM 6/5/2010 1:45:00 PM 1850 Kevin Kline Room 2176 - SECURITY 2176 SQL Injection attacks are one of the most common hacker tricks used on the web. Learn what a SQL injection attack is and why you should be concerned about them. Through demonstrations, witness different types of SQL injection attacks, how to find them, and how to block them so you know your environment is secure. 6/5/2010 12:45:00 PM 6/5/2010 1:45:00 PM 1852 Kevin Kline Room 2176 - SECURITY 2176 Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like: - What’s different about 32- and 64-bit systems? - What are the various areas of memory inside of SQL Server? - How are queries handled behind the scenes? - What does SQL Server do with procedural code, like functions, procedures, and triggers? 6/5/2010 11:30:00 AM 6/5/2010 12:30:00 PM