SQLSaturday #40 - South Florida 2010 7/31/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat40 South Florida FL 33027 621 Red Gate Software Platinum Sponsor http://www.red-gate.com/about/community_relations/sql_saturday.htm http://www.red-gate.com/images/redgatelogo_black.jpg 60 170 622 expressor software Platinum Sponsor http://www.expressor-software.com http://www.expressor-software.com/collateral/images/english-us/logos/exp_logo_color.jpg 60 170 623 SwiftKnowledge Platinum Sponsor http://www.swiftknowledge.com will send via email 60 170 600 Fusion-io Platinum Sponsor http://www.fusionio.com http://www.fusionio.com/images/fusionio-logo.gif 60 170 662 Confio Platinum Sponsor http://www.confio.com http://www.confio.com/images/assets/ignite_confio_logo.gif 60 170 499 Quest Software Gold Sponsor http://www.quest.com n/a I'll have to send you a file 60 170 609 SQL Server Magazine Gold Sponsor http://www.sqlmag.com http://img.en25.com/eloquaimages/clients/PentonMediaInc/{4c554f51-5143-4a1c-b3a8-8c9c22203c7c}_ALL_SQL_LOGO_SQLServerMag_175x41.jpg 60 170 618 TekPartners Gold Sponsor http://www.tekpartners.com 60 170 627 QQ Solutions, Inc. Gold Sponsor http://www.qqsolutions.com http://www.qqsolutions.com/assets/images/qqsolutions.jpg 60 170 1467 @ccatto Catto Catto enjoys the .NET community. He currently is employed by MovieTickets.com located Boca Fla as a Software Engineer. Catto uses many technologies to provide solutions for team members, management customers. Catto graduated from Florida Atlantic University with bachelors in Computer Science has continued his education by his involvement in the .NET community recently became a MCP. @ccatto http://www.linkedin.com/in/catto http://www.ChrisCatto.com https://api.twitter.com/1/users/profile_image?screen_name=@ccatto 48 48 1218 Aaron Nelson Aaron Nelson is a Senior SQL Server Architect, Database Developer, DBA, and Business Intelligence Developer with over 10 years of architecture, design, development and maintenance of SQL Server. He is experienced managing enterprise-wide data needs in both transactional and data warehouse environments. @http://twitter.com/sqlvariant http://www.linkedin.com/in/sqlvariant http://sqlvariant.com/wordpress/ https://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/sqlvariant 48 48 1269 Adam Jorgensen Adam Jorgensen, President – Pragmatic Works Consulting - has over a decade of experience leading organizations around the world in developing and implementing enterprise data solutions. Adam is also very involved in the community as a co-founder of BIDeveloperNetwork.com, a featured author on many other community sites, and a regular contributor to SQLPASS User Groups and other organizations. He can usually be spotted at industry events, Code Camps, and SQLSaturdays. @adam_Jorgensen http://www.linkedin.com/in/wajorgensen http://www.pragmaticworks.com https://api.twitter.com/1/users/profile_image?screen_name=@adam_Jorgensen 48 48 1839 Argenis Fernandez Architect for a mid-size SaaS company headquartered in South Florida. He has over 12 years of experience in the IT industry, and has been working with SQL Server since version 6.5. He thoroughly enjoys working with SQL Server, managing large, geographically dispersed server farms and Powershell scripting. He hates manual work. He is a MCITP on SQL Server 2008 Database Administration, 2005 Database Administration, and a MCDBA on SQL 2000. @afernandez http://www.linkedin.com/in/argenis http://www.sqlps.com https://api.twitter.com/1/users/profile_image?screen_name=@afernandez 48 48 1813 Brent Ozar Brent Ozar is a SQL Server expert with Quest Software, a Microsoft Certified Master of SQL Server 2008, and a Microsoft MVP. Brent has a decade of broad IT experience, including management of multi-terabyte data warehouses, storage area networks and virtualization. He is a regular speaker at PASS events, editor-in-chief of SQLServerPedia.com and co-author of the book, 'Professional SQL Server 2008 Internals and Troubleshooting.' @BrentO http://www.linkedin.com/in/brentozar http://www.brentozar.com https://api.twitter.com/1/users/profile_image?screen_name=@BrentO 48 48 1849 David Corrales David Corrales has a Masters in Computer Engineering from FIU. He has been Senior Software Engineer for SAPIEN Technologies for two years bringing you such software advancements as PrimalSQL, PrimalXML and PrimalForms. You can read his blogs at blog.sapien.com. @dave_levy http://www.linkedin.com/pub/david-levy/8/595/17b http://adventuresinsql.com https://api.twitter.com/1/users/profile_image?screen_name=@dave_levy 48 48 2055 Dmitri Korotkevitch Dmitri Korotkevitch is Director of Development at Actsoft - Tampa based company developing GPS Tracking and Mobile Management solutions. Back-end database handles around 2000 TPS during the peak time. Dmitri holds MCPD and MCITP - Sql Server 2005 2008 Database developer certificates. http://www.actsoft.com 48 48 1914 Don Gabor Don Gabor is a professional speaker, communications trainer, networking expert and author of eight conversation books. He presented two networking programs at the PASS Summit 2009 and has been invited back for the PASS Summit 2010. Don has been presenting communication programs to corporations, associations, businesses and individuals since 1980. @DonGabor@DonGabor http://www.linkedin.com/profile/edit?id=10426492trk=hb_side_pro http://www.dongabor.com https://api.twitter.com/1/users/profile_image?screen_name=@DonGabor@DonGabor 48 48 2220 Elijah Baker Elijah is currently the Director of Database Architecture and Operations for the Payformance Corporation in Jacksonville, Florida. In this position he works with multiple strategies inside of SQL server to optimize a 2+ TB OLTP primary database. One of the strategies that has played a major role in helping optimize this database has been partitioning. 48 48 1927 Hector Hernandez Career and Life Changing Champion, Hector Hernandez career has expanded for over 31 years of corporate experience with IBM as a Global Enablement Technology Executive. Today he is a Career Life changing Champion, and has done 100s of inspirational career and life changing talks based on his personal success starting at the bottom of the corporate ladder. He’s an inventor and has a B.S. in Management from Barry University and Executive MBA from FAU. @http://twitter.com/careerandlife http://www.careerandyourlife.com https://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/careerandlife 48 48 2225 Herve Roggero Herve Roggero is co-founder of Pyn Logic (SQL Server Security) and Blue Syntax Consulting (Azure Consulting). Herve is the VP of the SQL Server User Group in South Florida, co-runs the South Florida SQL Saturday and is the co-author of Pro SQL Azure with APress. For more information about Herve visit his company's websites at www.pynlogic.com or www.bluesyntax.net or send an email to hroggero@bluesyntax.net. @hroggero http://www.linkedin.com/profile/view?id=5997132trk=tab_pro http://www.herveroggero.com https://api.twitter.com/1/users/profile_image?screen_name=@hroggero 48 48 1972 Jack Corbett Professional who has worked with SQL Server for 10 yrs (6.5-2008) and experience in .NET development as well. Author of several articles for SQLServerCentral and video author for SQLShare.com. Speaker at several SQLSaturday's and Florida User Groups. Co-President of OPASS/ MCITP: Database Administration 2008 @unclebiguns http://www.linkedin.com/in/jackcorbett http://www.wiseman-wiseguy.blogspot.com https://api.twitter.com/1/users/profile_image?screen_name=@unclebiguns 48 48 1900 Jared Nielsen Jared Nielsen is a frequent lecturer at Code Camps, Marketing Events, and Trade Shows with a focus on packaged goods, e-business, and exclusionary dominance web marketing techniques. He is the inventor of the Atomic Data Model that incorporates the best of fifth normal data modeling techniques and the latest SQL Server technologies. His past projects include WorldATPTour.com, WTATour.com, Yahoo! Sports, FootballFanatics.com, BigOTires.com, AOL TV, Barnett Brass and Copper and more. @FUZIONAgency http://www.linkedin.com/in/nielsendata http://www.FUZION.org/Web_Marketing https://api.twitter.com/1/users/profile_image?screen_name=@FUZIONAgency 48 48 2230 Joe Healy Microsoft Employee 48 48 2130 Jorge Segarra My name is Jorge Segarra. I’m an MCTS (SQL Server 2005) currently working as a DBA in Jacksonville, Florida. In addition to being a member of the Tampa SQL Server, Tampa SQL Server Business Intelligence, and VMware user groups I am also a Hypervisor for the PASS Virtualization Virtual Chapter and chapter leader of the PASS Professional Development Virtual Chapter. I have also co-authored the book from Apress “SQL 2008 Pro Policy-Based Management“. @sqlchicken http://linkedin.com/in/jdsegarra http://sqlchicken.com https://api.twitter.com/1/users/profile_image?screen_name=@sqlchicken 48 48 1889 Jose Chinchilla Jose Chinchilla is a Microsoft Certified Database Administrator and Business Intelligence Developer working for JWB Children Services Council of Pinellas County with over 12 years of experience in the Information Technology field. His latest career focus has been in OLTP and OLAP database design, administration and performance and specializes in Datawarehousing and Multidimensional Analysis using SQL Server 2008 tools. @http://twitter.com/sqljoe http://linkedin.com/in/josechinchilla http://www.sqljoe.com https://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/sqljoe 48 48 1726 Kevin Boles Kevin is a SQL Server expert, working exclusively with the product since version 6.5. With over fifteen years of database experience, he holds virtually every SQL Server related certification including MCT and MVP. Kevin teaches occassionally and has been a very successful independent consultant for the past ten years. He is also a Mentor with Solid Quality Mentors, a top-tier global SQL Server consulting firm. His passion is the relational engine, especially performance analysis and tuning. @TheSQLGuru http://www.linkedin.com/in/thesqlguru https://api.twitter.com/1/users/profile_image?screen_name=@TheSQLGuru 48 48 1887 Maximo Trinidad Max Trinidad is a native of Puerto Rico and has been working with computers since 1979. Work for many years as a Senior IT/Developer has provided support for Windows Servers 2003/2008, Windows 7, SQL Servers Applications, Microsoft Virtualization Technologies, and building Visual Studio solutions. In 2009/2010 got his Microsoft MVP award in Powershell in 2010 got his SAPIEN MVP. @MaxTrinidad http://www.linkedin.com/pub/max-trinidad/12/47/775 http://www.flpsug.com https://api.twitter.com/1/users/profile_image?screen_name=@MaxTrinidad 48 48 2218 Michael Mollenhour Mike is currently a SQL BI Architect for Pragmatic Works in Jacksonville FL. He started his career in databases over 15 years ago with DBase. He later progressed to Sybase and started working with SQL Server 6.5 in the late 1990’s. Since then he has worked with many clients in multiple sectors with High Availability, data warehousing, SSIS, SSAS, SSRS, Data Mining, and performance tuning. Mike has spoken at several events including SQL Saturday and several Microsoft launch events. http://www.linkedin.com/in/mikemollenhour http://www.bidn.com/people/MikeMollenhour 48 48 1238 Mike Davis Mike Davis, MCTS, is a Senior BI consultant and Trainer at Pragmatic Works. He is an author on Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups across the US, Code Camps, SQL Server Launches, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL. @MikeDavisSQL http://www.linkedin.com/in/mikedavissql http://www.bidn.com/blogs/MikeDavis https://api.twitter.com/1/users/profile_image?screen_name=@MikeDavisSQL 48 48 2224 Pam Shaw Pam Shaw has been in IT for over 28 years. For the last 9 years, Pam has been working with SQL Server, first 2000, then 2005 and now 2008. Pam is currently an independent contractor. Pam is also the Chapter Leader of the Tampa Bay SQL Users Group - a local chapter of PASS and organizer of SQL Saturday Tampa. @http://www.linkedin.com/in/pshaw1129 http://www.linkedin.com/in/pshaw1129 http://www.TampaSQL.com https://api.twitter.com/1/users/profile_image?screen_name=@http://www.linkedin.com/in/pshaw1129 48 48 1630 Rodney Landrum Rodney Landrum has been architecting solutions for SQL Server for over 15 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has authored three books on Reporting Services and published The SQL Server Tacklebox in 2009. He is a regular contributor to SQL Server magazine and simple-talk.com where he occasionally blogs, and is a SQL Server MVP. @SQLBeat http://www.linkedin.com/in/kylejdoyle http://www.simple-talk.com/community/blogs/rodney/default.aspx https://api.twitter.com/1/users/profile_image?screen_name=@SQLBeat 48 48 1907 Ronald Dameron Ronald Dameron is a Senior Database Administrator for the largest life insurer in the United States. He is currently exploring how PowerShell can simplify his life as a DBA. He is a previous speaker at SQL Saturday Tampa, Orlando, and the Tampa SQL User group. He has published articles at www.simple-talk.com, sqlserverpedia.com and RonaldDameron.blogspot.com on his PowerShell experience. Follow me on Twitter at @RonDBA. @RonDBA http://www.linkedin.com/in/rdameron http://RonaldDameron.blogspot.com https://api.twitter.com/1/users/profile_image?screen_name=@RonDBA 48 48 2088 Sam Abraham Sam Abraham is a Microsoft Certified Professional and Microsoft Certified Technology Specialist. He currently lives in South Florida where he leads the WPB .Net User Group and actively participates in various local .Net Community events as organizer and/or technical speaker. Sam is also an active committee member on various initiatives at the South Florida Chapter of PMI. Sam can be reached through his blog: http://www.geekswithblogs.net/wildturtle @wildturtle21 http://www.linkedin.com/in/FLabraham http://www.geekswithblogs.net/wildturtle https://api.twitter.com/1/users/profile_image?screen_name=@wildturtle21 48 48 2232 Scott Klein Microsoft MVP @SQLScott https://api.twitter.com/1/users/profile_image?screen_name=@SQLScott 48 48 2231 Shervin Shakibi Microsoft MVP @shervsherv http://www.linkedin.com/pub/shervin-shakibi/1/563/174 https://api.twitter.com/1/users/profile_image?screen_name=@shervsherv 48 48 2312 Telmo Sampaio Great guy! 48 48 1836 Timothy Ford Tim Ford is the Principal DBA for Spectrum Health Hospital System. He has been working with SQL Server since 1999. He is also an author of SQL-centric articles for MSSQLTips.com, SQLServerCentral, and Simple-Talk.com and is currently finishing a book on the topic of SQL Server DMVs with Louis Davidson. He is the host for the annual Quizbowl at the PASS Summit each Fall and is a Microsoft SQL Server MVP. @sqlagentman http://www.linkedin.com/pub/timothy-mcaliley-pmp-cism-cissp-cisa/10/530/787 http://thesqlagentman.com https://api.twitter.com/1/users/profile_image?screen_name=@sqlagentman 48 48 1219 Troy Gallant Troy has been a SQL Server professional for over 6 years The first four were in the role of a developer, and the last two as DBA for an international organization of over 900 employees. When not working, Troy enjoys MMO's, the Grateful Dead, and whiling away the hours picking his mandolin. (Twitter: GratefulDBA) @GratefulDBA http://www.linkedin.com/in/tgallant http://troygallant.com https://api.twitter.com/1/users/profile_image?screen_name=@GratefulDBA 48 48 1218 1218 Aaron Nelson DBA4 Room 6 In this session we will learn to perform several everyday DBA tasks like backing up user databases, scripting table objects and evaluating disk space usage with PowerShell. For each tasks we will explore the benefits is using PowerShell over the standard method. Only a basic understanding of PowerShell or DOS is needed. This session should serve as a good introduction to PowerShell for database users. The goal is to get data professionals feet wet about PowerShell. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 1219 1219 Troy Gallant DBA3 Room 5 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. 7/31/2010 8:30:00 AM 7/31/2010 9:30:00 AM 1238 1238 Mike Davis BI1 Room 1 In this session Mike shows parameters in many different ways including stored procedure, cascading, Default Values, Available Values, Multi value with the Split Functions in Stored Procedures, and custom code. 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 1239 1239 Mike Davis BI1 Room 1 In this session, you’ll learn how to control your SSIS packages in a more powerful way by using expressions. The expression language is a bit of an elusive language that can be used to make any component in SSIS dynamic. Then, you’ll learn how to use configuration files to externalize the configuration of your package and lastly how to pass variables into a package. Also learn how to use parent child packages and environment variables. 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 1241 1241 Mike Davis BI1 Room 1 In this session Mike will show you how to build a data flow using many different sources, transforms and destination. Learn how to use the some of the most commonly used transforms in SSIS. You will also learn how to troubleshoot a data flow using Data Viewers. 7/31/2010 3:30:00 PM 7/31/2010 4:30:00 PM 1269 1269 Adam Jorgensen BI1 Room 1 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. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM 1467 1467 @ccatto Catto Dev Room 8 In T-SQL 0 - 60 we'll discuss Transact SQL for SQL Server. We'll discuss four major sections: 1 IDE (SSMS) Queries http://tinyurl.com/cattotsql1 2 Query View vs. Design View http://tinyurl.com/cattotsql2 3 Stored Procedures http://tinyurl.com/cattotsql3 4 Sky is the Limit (advanced topics). http://tinyurl.com/cattotsql4 At the end of the seesion we'll understand how to query data in SSMS using T-SQL 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 1630 1630 Rodney Landrum DBA1 Room 3 This session will present a top 10 (maybe 20) list of queries and tools that DBAs can use daily. The idea is that everything is included on a single 1G or less thumb drive to be portable. From simple T-SQL statements to full blown SSIS packages, the session demonstrates how to interogate, diagnose, report on, and resolve issues that are most prevalent for DBAs: disk space, security, backup locations, database and server documentation, performance and much more. All queries, which are SQL 2000, 2005 and yes even 2008 tried and true will be made available in the session to copy to your own thumb drive. If you are lucky you might even receive a free coveted thumb to store the queries. 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 1631 1631 Rodney Landrum BI2 Room 2 At it's heart, the DBA Repository solution employs SSIS and SSRS and in late 2009 was updated for performance and resiliency. This session will cover the original solution, published in SQL Server Magazine, plus the latest enhancements which will delve into some interesting uses of package variables and MERGE in SSIS along with some new reports. 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 1726 1726 Kevin Boles BI2 Room 2 Like the title says, be prepared to get really down and dirty with memory allocations and usage in SQL Server. RAM is one of the three pillars of server performance and understanding how it is used, how you can analyze what is going on with it and how to properly adjust the the few knobs you have at your disposal are very important topics for both your server's health and performance. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 1727 1727 Kevin Boles BI2 Room 2 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. 7/31/2010 3:30:00 PM 7/31/2010 4:30:00 PM 1728 1728 Kevin Boles BI2 Room 2 What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM 1813 1813 Brent Ozar DBA2 Room 4 Brent will cover the basics of SQL Server’s DR options including log shipping, mirroring, replication and more. He’ll explain the pros and cons of each, and teach you how to pick the right method for your application. You'll also learn some of the things that burned him during several hurricanes and role swaps. No DRP experience required - Brent will show you the ropes. 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 1814 1814 Brent Ozar DBA2 Room 4 You're minding your own business in your corner office - well, no, you're a DBA, so it's just your cubicle - when somebody says, 'Did you know about this SQL Server over here?' Suddenly, you have to find out what the server's doing, how it was set up, and whether things are working correctly. In this real-time session, Brent will show you how he tackles unknown servers in 60 minutes to find problems, take an inventory, and set the server up for easier management down the road. 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 1836 1836 Timothy Ford DBA1 Room 3 Identify and remdiate index fragmentation. Gather information about unused indexes that may be causing your instances unnecessary overhead and impacting performance. Even find out what indexes you may want to create to make your databases perform better: all with the use of SQL Server Dynamic Management Objects. 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 1838 1838 Timothy Ford DBA1 Room 3 Join this beginner-level session in which we'll go over common mistakes made by new and seasoned SQL Server Professionals alike. Learn how to avoid these issues before they happen. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM 1839 1839 Argenis Fernandez DBA1 Room 3 Learn how to manage multiple instances of SQL Server with the different tools that SQL Server 2008 and 2008 R2 offer. We will discuss Central Management Servers, multiserver queries, SQL Server Control Point, Policy-Based Management and SQLPS (the Powershell SQL mini-shell). 3rd party tools will be discussed as time permits. 7/31/2010 8:30:00 AM 7/31/2010 9:30:00 AM 1849 1849 David Levy DBA1 Room 3 The days of hiding amongst rows of servers, focusing purely on operational tasks are quickly coming to an end. This presentation will provide a high level overview of how to boost your value to your organization by automating the mundane operational tasks and focusing on supporting new development. Topics covered will include tools and techniques available for automation, integration with development teams and relationship management. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 1885 1885 Timothy McAliley DBA3 Room 5 Information Technology Infrastructure Library (ITIL) Version III is a public/non-proprietary framework that describes Best Practices in IT Service Management. Conducting database administration within an ITIL framework can improve change management, reduce operational risks, stabilize your environment and pose challenges. Learn the conceptual basics of the Information Technology Infrastructure Library, Version 3 (ITIL V3), the responsibilities and deliverables of DBAs in an ITIL shop, and review a few examples of scaled deployments of the ITIL V3 process framework. 7/31/2010 3:30:00 PM 7/31/2010 4:30:00 PM 1887 1887 Maximo Trinidad DBA4 Room 6 Will demo a series of way to take advantage of SQL Server 2008 - SQLPS to work with you different version so SQL Servers. See how powerfull the POSH command prompt can be to monitor and manage your SQL Servers. I will also demo the Invoke-SQLCmd cmdlet. There will be lots of samples. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM 1888 1888 Maximo Trinidad DBA4 Room 6 Come over and see how to work with SQL Server Agent using PowerShell. Lot's of sample, tips and tricks. Displaying jobs, their properties, and creating PowerShell steps. We are going to see the difference between SQLPS, SMO, and PowerShell V2. Also, I will be show some scripting tools very useful for the DBA's. 7/31/2010 3:30:00 PM 7/31/2010 4:30:00 PM 1889 1889 Jose Chinchilla DBA3 Room 5 Change Data Capture (CDC) is one of the newest features available for SQL Server 2008 which allows you to easily track and keep history of all DML (Data Manipulation Language) changes on user tables such as INSERT, DELETE, and UPDATE without additional overhead. One of the most important benefits of this feature is that it allows you to see the data before after an UPDATE statement which allows you to recover data overwritten or deleted quickly without the need of a database restore. On this presentation we will go over the steps necessary to configure CDC and do an overview of some real world scenarios where this feature can be applied such as Business Intelligence, Disaster Recovery, Auditing, Debugging, Documentation and more. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 1900 1900 Jared Nielsen Misc Room 9 Bringing marketing together with technology is a fine art that involves high tech tools, real life solutions, and most important human buy-in from the marketing and IT departments. This lecture will delve into the use of the latest SQL Server 2005 and SQL Server 2008 technologies including recursive common table expressions (CTE), hierarchical data models, and CLR stored procedures for the IT side of the house while also delving into the use of analytics, webmaster monitoring tools, web marketing tactics and search engine optimization techniques for the more marketing minded. Neither SQL nor SEO are four letter words and they go together perfectly! So too can your IT and marketing departments as you tackle the new age of IT Marketing. 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 1907 1907 Ronald Dameron DBA4 Room 6 I will demonstrate how I automated ID provisioning using PowerShell, SQLPSX, and our corporate standard job scheduler. 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 1908 1908 Ronald Dameron DBA4 Room 6 I will detail my reasoning why a DBA would benefit from learning PowerShell. I will demonstrate how a DBA can use PowerShell in conjunction with SQL, WMI, and SMO to automate repetitive tasks and better manage their workload. 7/31/2010 8:30:00 AM 7/31/2010 9:30:00 AM 1914 1914 Don Gabor Misc Room 9 Networking can be tough for many technical people, but approaching and talking to colleagues is one of the most valuable take-aways you can get at an IT conference. In this 1-hour SQLSaturday workshop you’ll learn to make professional connections that will pay off for years to come. Best-selling author and networking expert, Don Gabor will guide you through the conversation process to make networking will be easier and more productive. Networking can be tough for many technical people, but approaching and talking to colleagues is one of the most valuable take-aways you can get at an IT conference. In this 1-hour SQLSaturday workshop you’ll learn to make professional connections that will pay off for years to come. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 1927 1927 Hector Hernandez Misc Room 9 You don't need Talent to Succeed, but Everything else Counts This session helps you trigger our natural abilities that go unused for years. Once you discover that these are already part of you (us), you will be able to apply them to advance your career, your relationships and your life. You can manage your career and your life—it’s not about balance. Talent is overrated. 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 1972 1972 Jack Corbett DBA1 Room 3 Triggers can be a handy tool in the toolbox, but many times they are used improperly because of a lack of understanding of how they work. This session will give an overview of the different types of triggers available in SQL Server and then will focus on specifically on the safe use of DML triggers. We will talk about when to use triggers and touch on other options. I will demonstrate of both safe and unsafe triggers. 7/31/2010 3:30:00 PM 7/31/2010 4:30:00 PM 2048 2048 Troy Gallant DBA3 Room 5 Many SQL Server DBA's are tasked with the responsibility of choosing an appropriate disaster recovery, reporting, or failover solution for their organization. Much of the time the choice comes down to replication versus log shipping. And while both solutions can be extremely effective, there are both subtle major differences between them that can guide you to choose one over the other. This presentation gets to the nuts and bolts of the two technologies, and helps you make an educated recommendation and implementation. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM 2055 2055 Dmitri Korotkevitch DBA2 Room 4 Locking, blocking, waits.. Why developers should care? Those things are for DBA. But what if you don't have DBA in the team? What if DBA complaints directly to your boss? This session will provide you an overview how SQL Server Lock Manager works; how different isolation levels affect the system; gives you bird-eye view of SQLOS and Sql Server Waits; provide you the guidelines how to minimize the locking, avoid deadlocks and improve concurrency of the system. It also shows you a couple of basic methods how to troubleshot problems related with locking and concurrency. 7/31/2010 8:30:00 AM 7/31/2010 9:30:00 AM 2056 2056 Dmitri Korotkevitch DBA2 Room 4 One of the biggest benefits of SQL Server is simplicity. Developer creates a database, write a few T-SQL statements and everything is up and running.. until the system grows up and starts to introduce performance problems. And infinite loop begins: Refactor -> Deploy -> Refactor -> Deploy ->.. In a few years developer has gray hairs and ton of experience. The purpose of this session is sharing this experience helping to avoid some of the typical issues for the systems working under heavy load. The session gives the overview of how SQL Server stores data, what criteria Query Optimizer uses choosing the index, how data is locking - essential knowledge when you expect system to handle thousands transactions per second. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM 2057 2057 Dmitri Korotkevitch DBA2 Room 4 Why my queries are so slow? Why SQL does not use that index? What 'Hash Match' means? Do we really need to upgrade the hardware? It's essential to know how query optimizer works if you want to design effective solutions. This session will give you an overview of how query optimizer generates query plans, how to read them, how SQL Server executes queries and show a few optimization tricks. 7/31/2010 3:30:00 PM 7/31/2010 4:30:00 PM 2088 2088 Sam Abraham Dev Room 8 SSIS enables us to quickly create deployable packages to move/manipulate data. Things do however get a bit challenging when source and destination tables are not known at package design time or when a requirement exists to have an already-deployed package support schema changes in source tables. One solution to this problem is to leverage our ability to create and execute an SSIS package dynamically in code. In this session we will take a look at a complete project for a C# Runtime SSIS Package Designer, taking as input a set of table names and dynamically generating both destination Access tables then creating, validating, saving and executing an SSIS Package at runtime with logging enabled to demonstrate the various package steps. 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 2098 2098 David Corrales DBA4 Room 6 Preview SAPIEN Technologies’ new dedicated PowerShell editor: Visual PowerShell 2011 The next generation in PowerShell graphical user interface (GUI) creation. Visual PowerShell 2011 builds upon PrimalForms 2009 and adds a plethora of new features and enhancements. New additions include Script Debugging, Multi-Form Support, Built in Console, Snippets and more. The demonstration will cover: - Creating GUIs for PowerShell - Creating SQL Query GUIs using the Database Browser - Packaging your GUIs and scripts into executables - Cover new features such as Snippets, PowerShell Console, WMI Browser and more - Creating Projects for Multi-Form GUIs - Integrated Help and PrimalSense 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 2130 2130 Jorge Segarra DBA3 Room 5 On my blog I've started a project called SQL University aimed at folks looking to learn SQL Server from the ground up. This session will start at ground level tasks and resources all database professionals should know (we won't be covering basic T-SQL in this session, just tasks and concepts). This session is aimed at entry-level folks but anyone is welcome to attend to sharpen up their basic skills and resources! 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 2131 2131 Jorge Segarra DBA3 Room 5 In our 101 session we did a high level overview of the world of SQL Server and how things work within that environment. In this session we'll dive a little deeper and talk about important tasks expected of a DBA such as backups and restores, general maintenance, understanding various resources and virtualization of SQL Server. Attending the 101 session is not a pre-requisite so feel free to join us and continue our SQL Server education! 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 2218 2218 Michael Mollenhour BI2 Room 2 In this session you will learn some of the basics to getting you started with Analysis Services. Key terms and as well as best practices will be discussed for developing an Analysis Services Cube. 7/31/2010 8:30:00 AM 7/31/2010 9:30:00 AM 2219 2219 Michael Mollenhour BI2 Room 2 This session will show you some of the more complex feature available in SSIS. These features can help your packages run more smoothly and handle problem areas better. See how to enable features like checkpoints and transactions on your packages. You will also learn how to use the native logging features to track package executions. 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 2220 2220 Elijah Baker DBA2 Room 4 In this session I will go over what database partitioning is and what the structures are to implement it. I will present all of the basic SQL structures that it takes to implement partitioning as well as some general discussion of how to choose the right partitioning key, use of file groups in partitioning, partitioned index alignment, and multi-partitioning. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 2224 2224 Pam Shaw BI1 Room 1 This session we will present methods to create very dynamic reports. We will demonstrate data driven formatting and layouts. We will review how to setup data sources that are more portable as well as see how templates make it easier to have more consistent report formats. We will review emailing reports and how this can be integrated into your current application. 7/31/2010 8:30:00 AM 7/31/2010 9:30:00 AM 2225 2225 Herve Roggero Azure Room 7 Let's talk Azure!!! SQL Azure is the Microsoft SQL Server database in the cloud and it comes packed with cool capabilities. Let's review its performance footprint and how to go about designing high performance applications with SQL Azure. We will discuss Sharding, network latency, asynchronous operations and much more! Some of this content is taken directly out of the upcoming book on Pro SQL Azure, from APress. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 2226 2226 Herve Roggero Azure Room 7 In this session I will discuss what it takes to build a shard against SQL Azure. Shards allow developers to access data across a farm of SQL Server or SQL Azure databases transparently. This session places a strong focus on C# and evaluates .NET 4.0 and shows you how to leverage the Task Parallel Library (TPL) and the new Caching namespace to achieve greater performance access SQL Azure. View http://enzosqlshard.codeplex.com/ for information about this shard. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM 2230 2230 Joe Healy Azure Room 7 This session will provide an introduction to the Azure platform and 7/31/2010 9:45:00 AM 7/31/2010 10:45:00 AM 2231 2231 Shervin Shakibi BI1 Room 1 This session will provide a great detailed look at SSRS. 7/31/2010 11:00:00 AM 7/31/2010 12:00:00 PM 2232 2232 Scott Klein Azure Room 7 This session will dive into what it takes to develop application for SQL Azure. 7/31/2010 1:00:00 PM 7/31/2010 2:00:00 PM 2312 2312 Telmo Sampaio Dev Room 8 Learn how to use the spatial data types in SQL Server, load spatial data from the web, and display your geographic information using Bing Maps and Silverlight. 7/31/2010 2:15:00 PM 7/31/2010 3:15:00 PM