SQLSaturday #49 - Orlando 201010/16/2010 12:00:00 AMSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat49OrlandoFL32773575Confio Softwarehttp://www.confio.comhttp://www.confio.com/images/assets/ignite_confio_logo.gif60170683Red Gate Softwarehttp://www.red-gate.com/about/community_relations/sql_saturday.htmhttp://www.red-gate.com/images/redgatelogo_black.jpg60170710expressor softwarehttp://www.expressor-software.comhttp://www.sqlsaturday.com/files/f40e6efc-0701-4c6c-b810-c74bccaaf618.png60170820Iderahttp://www.idera.comhttp://www.idera.com/images/Logo.jpg60170816Microsofthttp://www.microsoft.comhttp://www.sqlsaturday.com/files/67f09873-49a0-4327-9cb2-abc1ca2a402c.jpg60170727Quest Softwarehttp://www.quest.com/database-management/http://www.quest.com/images/common/quest_logo.gif60170666Fusion-iohttp://www.fusionio.comhttp://www.fusionio.com/images/fusionio-logo.gif60170615SQL Server Magazinehttp://www.sqlmag.comhttp://img.en25.com/eloquaimages/clients/PentonMediaInc/{4c554f51-5143-4a1c-b3a8-8c9c22203c7c}_ALL_SQL_LOGO_SQLServerMag_175x41.jpg60170640Pragmatic Workshttp://www.pragmaticworks.comhttp://www.pragmaticworks.com/images/l4.gif60170653CozyRoc http://www.cozyroc.com/http://www.cozyroc.com/sites/default/files/down/cozyroc-big.png60170674Soaring Eagle Consulting, Inc.http://www.soaringeagle.bizhttp://www.sqlsaturday.com/images/soaring_eagle.jpg60170696Telerik Inchttp://www.telerik.comhttp://www.sqlsaturday.com/files/0d657790-c91e-416f-9b67-9962443ce835.gif60170720Veredus Corporationhttp://www.vereduscorp.comhttp://www.sqlsaturday.com/files/8267a185-8680-4726-894e-cc2cdca802a4.jpg60170818CA Technologieshttp://www.ca.comhttp://www.ca.com/~/media/css/images/ca-logo-blue.jpg40100743Wiley Publishinghttp://www.wiley.com/http://newsletter.wrox.com/images/usergroups/usergroup_125x125.gif40100824Gerasus Softwarehttp://www.gerasus.com/http://www.gerasus.com/images/logo.png40100810O'Reilly Media, Inchttp://www.oreilly.comhttp://www.sqlsaturday.com/files/b5cb5420-6893-40a0-94e6-3b7f4c045593.gif40100764Apresshttp://www.apress.com/http://www.sqlsaturday.com/files/15cf709f-111e-4a8d-b5e5-be375e3f85f5.jpg40100765SAPIEN Technologies, Inc.http://www.sapien.comhttp://www.sqlsaturday.com/files/6c72676f-d399-4cc1-88ae-12a856445b65.jpg40100783Noel McKinneyhttp://noelmckinney.com/http://noelmckinney.com/wp-content/uploads/2010/09/Noel-seated-compressed-NOTNULL-e1284844743579.jpg40100784Brandie Tarvinhttp://BrandieTarvin.livejournal.comhttp://www.BrandieTarvin.net40100789StraightPath Solutions - Mike Walshhttp://www.straightpathsql.comhttp://www.straightpathsql.com/wp-content/uploads/2010/07/StraightPathFINAL_Small1.png40100791The Grateful DBAhttp://troygallant.comhttp://troygallant.com/wp-content/uploads/2010/09/GDBA.jpg40100798Rafael-salas.comhttp://www.rafael-salas.comhttp://www.rafael-salas.com40100808Bob Pusateri - The Outer Joinhttp://www.BobPusateri.comhttp://img.bobpusateri.com/bt/OJLogoSmall.jpg40100809Jes Borlandhttp://jesborland.wordpress.comhttp://jesborland.files.wordpress.com/2010/06/header.jpg40100828Jason Brimhallhttp://jasonbrimhall.info40100760SQL Lunchhttp://www.sqllunch.comhttp://sqllunch.com/images/SQL%20lunch1-bw.gif40100761SQLRockstarhttp://thomaslarock.comhttp://www.sqlsaturday.com/files/d2fe4cab-f855-4c21-b0c7-0096852f8a14.jpg40100762The Modern Resumehttp://modernresume.blogspot.com/http://1.bp.blogspot.com/_8hTidvPiTuU/TI-_8pNBA8I/AAAAAAAAB9g/NNyNatMqvZM/s320/ModernResume.jpg40100763SQLAndyhttp://www.sqlandy.comhttp://www.sqlandy.com401002202Aaron NelsonAaron Nelson ( @SQLvariant ) is a Senior SQL Server Architect with over 10 years experience in architecture, business intelligence, development, and performance tuning of SQL Server.
He has experience managing enterprise-wide data needs in both transactional and data warehouse environments. Aaron holds certifications for MCITP: Business Intelligence Developer, Database Administrator, Database Developer; as well as MCTS: Windows Server Virtualization, Configuration (meaning Hyper-V).@http://twitter.com/sqlvarianthttp://www.linkedin.com/in/sqlvarianthttp://sqlvariant.com/wordpress/https://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/sqlvariant48482589Adam JorgensenAdam Jorgensen, MBA, MCDBA has been delivering innovative SQL Server and Business Intelligence Solutions for over a decade. Adam is an active member of the Gold Coast User Group in South Florida and is a featured author on sites such as SQLServerCentral.com and JumpstartTV.com and has extensive technical and management experience in industries including automotive, manufacturing, software, education, security, and retail, among others. @adam_Jorgensenhttp://www.linkedin.com/in/wajorgensenhttps://api.twitter.com/1/users/profile_image?screen_name=@adam_Jorgensen48482748Andrew SzalajiAndrew Szalaji and Jyoti Gupta work for Expressorhttp://www.expressor-software.com48481865Andy WarrenAndy Warren is a SQL trainer focusing on basic administration and performance tuning, he runs the free SQLShare.com training site, is currently a SQL Server MVP, blogs daily at SQLAndy.com, started the SQLSaturday franchise, is co-President of the Orlando SQL Server Users Group, serves as a member of the Board of Directors of PASS, and was a founding partner in SQLServerCentral.com. In his remaining free time he’s working on a book for first time managers. @sqlandyhttp://www.linkedin.com/in/sqlandyhttp://www.sqlandy.comhttps://api.twitter.com/1/users/profile_image?screen_name=@sqlandy48481878Argenis FernandezArchitect 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 and MCTS on SQL Server 2008 Database Development.@afernandezhttp://www.linkedin.com/in/argenishttp://www.sqlps.comhttps://api.twitter.com/1/users/profile_image?screen_name=@afernandez48482357Brandie TarvinBrandie Tarvin (MCITPDBA, MCTS, MCDBA) is a senior Database Administrator Developer for Allstate Dealer Services in Jacksonville. She has published several articles on SQLServerCentral.com, trains her co-workers in SQL Server, and has previously presented at several SQL Saturday events and JSSUG meetings. She also writes fiction and freelances for Catalyst Game Labs in her spare time. @WannaBeWriter06http://www.linkedin.com/in/brandietarvinhttp://www.brandietarvin.nethttps://api.twitter.com/1/users/profile_image?screen_name=@WannaBeWriter0648482693Brian McDonaldI am a husband, father of two and a Database Administrator that enjoys to learn (and try) new things. When not working or spending time with friends and family, I enjoy working with others who also constantly try to push themselves to become a better version of themselves as possible.@briankmcdonaldhttp://www.tinyurl.com/BrianKMcDonaldhttps://api.twitter.com/1/users/profile_image?screen_name=@briankmcdonald48482155Chad MillerChad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows Powershell since 2007. In his spare time he is the Project Coordinator/Developer of Powershell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa Powershell User Group and is also a frequent speaker at SQL Server users groups, SQL Saturdays and Code Camps.@cmille19http://www.linkedin.com/in/chadwickmillerhttp://sev17.comhttps://api.twitter.com/1/users/profile_image?screen_name=@cmille1948481848David WaughDavid Waugh is the main man at Confio.@confiohttp://www.linkedin.com/pub/david-waugh/3/9a8/68bhttp://www.confio.comhttps://api.twitter.com/1/users/profile_image?screen_name=@confio48481896Devin KnightDevin is a BI consultant at Pragmatic Works Consulting. He authored the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS, Code Camps and several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is the Vice President of the local users’ group (JSSUG).@https://twitter.com/knight_devinhttp://www.linkedin.com/profile?viewProfile=key=22920224locale=en_UStrk=tab_prohttp://bidn.com/blogs/devinknighthttps://api.twitter.com/1/users/profile_image?screen_name=@https://twitter.com/knight_devin48482244Dmitri KorotkevitchDmitri 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 and 2008 Database Administrator certificates. http://www.actsoft.com48482753Ed WilsonEd Wilson, MCSE, MSCBA, MCT is the Microsoft Scripting Guy. As such, he writes the popular Hey Scripting Guy blog for Microsoft, speaks at conferences such as TechEd and TechReady. He is very active in the community and has spoken to numerous user groups around the world via Live Meeting and in person. Ed has written numerous books about VBScript, WMI, and Windows PowerShell scripting and his latest release is Windows PowerShell 2.0 Best Practices. @ScriptingGuyshttp://www.linkedin.com/in/mredwilsonhttp://ewblog.edwilson.com/https://api.twitter.com/1/users/profile_image?screen_name=@ScriptingGuys48482065Eric WisdahlEric Wisdahl (MCTS - BI, Database Development, Implementation and Maintenance) is a BI Professional Working in the Insurance Industry. He spends what little free time he has reading technical books, playing games, perusing the MSDN SQL Forums, or spending time with his wife and dogs. In a past life he has worked as a Pizza Boy, Patent Examiner, Pro-IV Code Monkey and .Net punching bag. He currently resides in Tallahassee, although he is still a Gator.@EricWisdahlhttp://www.linkedin.com/in/ericwisdahlhttp://ewisdahl.spaces.live.comhttps://api.twitter.com/1/users/profile_image?screen_name=@EricWisdahl48481884Jack CorbettJack is a SQL Server professional currently serving with New Tribes Mission in Sanford, FL. Jack has been working with SQL Server for over 10 years and has worked with versions 6.5 to 2008.
Jack is active in the SQL Server Community as co-President of OPASS, a member of the 2010 PASS Summit Program Committee, and has spoken at several user groups and SQLSaturdays.
Jack also blogs regularly about SQL Server and the SQL Server Community at http://wiseman-wiseguy.blogspot.co@unclebigunshttp://www.linkedin.com/in/jackcorbetthttp://wiseman-wiseguy.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=@unclebiguns48481899Jared NielsenJared 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. @FUZIONAgencyhttp://www.linkedin.com/in/nielsendatahttp://www.FUZION.org/Web_Marketinghttps://api.twitter.com/1/users/profile_image?screen_name=@FUZIONAgency48482099Jeff GarbusJeff has been in the SQL Server business for over 20 years, training and consulting, with an emphasis on performance and tuning. He has written over a dozen books, and hundreds of magazine articles. He has spoken at a week of SQL Saturdays. http://www.linkedin.com/in/jeffgarbushttp://www.soaringeagle.biz48482559John WelchJohn Welch is BI Architect with Varigence. Varigence builds tools and frameworks that enable the creation and management of end-to-end business intelligence solutions with unprecedented ease and speed. John has been working with business intelligence and data warehousing technologies for 9 years, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server BI topics. @john_welchhttp://www.linkedin.com/in/johncwelchhttp://agilebi.com/cs/blogs/jwelch/Default.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@john_welch48481997Jonathon MoormanJon has been developing Sql Server databases since 1997. He has worked on a variety of database projects spanning from high performance OLTP systems to large volume data warehouses. He is currently working with a 5TB database for DMEautomotive in Jacksonville.
When not trying to find a different way to say, 'It depends', Jon can be found hiking in the woods, canoeing in the tidal marshes, or reading a book.
http://www.linkedin.com/in/jonathonmoormanhttp://dbajonm.spaces.live.com48482242Jorge SegarraI’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“. Redgate Exceptional DBA of the Year 2010 Finalist.@sqlchickenhttp://linkedin.com/in/jdsegarrahttp://sqlchicken.comhttps://api.twitter.com/1/users/profile_image?screen_name=@sqlchicken48481892Jose ChinchillaJose 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/sqljoehttp://linkedin.com/in/josechinchillahttp://www.sqljoe.comhttps://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/sqljoe48482184Kathi KellenbergerKathi Kellenberger, former SQL Server MVP, is a Data Technology Specialist with Microsoft in St. Louis. She is author of 'Beginning T-SQL 2008' (Apress) and co-author of 'Professional SQL Server 2005 Integration Services' (Wrox) and 'SQL Server MVP Deep Dives' (Manning) as well as over two dozen technical articles. Before joining Microsoft, Kathi was a DBA for Bryan Cave LLP, an international law firm. She has involved with the PASS community for several years, winning the PASSion award in 2008.@auntkathihttp://www.linkedin.com/in/kathikellenbergerhttp://www.sqlservercentral.com/blogs/kathi_kellenberger/default.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@auntkathi48482214Ken SimmonsKen Simmons is a database administrator, developer, and Microsoft SQL Server MVP. He is the Author of Pro SQL Server 2008 Administration (Apress, 2009), Pro SQL Server 2008 Mirroring (Apress, 2009), and Pro SQL Server 2008 Policy-Based Management (Apress, 2010). He has been working in the IT industry since 2000 and currently holds certifications for MCP, MCAD, MCSD, MCDBA, MCTS for SQL 2005, and MCITP for SQL 2008. @KenSimmonshttp://www.linkedin.com/in/kensimmonshttp://cybersql.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=@KenSimmons48482339Kendal Van DykeKendal began working with SQL Server 7.0 as a VB developer 10 years ago. He has spent the last 8 years as a production DBA working on systems that process hundreds of millions of transactions per day. He is currently Senior DBA at Channel Intelligence in Celebration, FL where he is responsible for the management, monitoring, and performance of over 40 SQL Servers. Kendal is known as @SQLDBA on Twitter and maintains a technical blog on SQL Server topics at http://kendalvandyke.blogspot.com. @http://twitter.com/#!/sqldbahttp://twitter.com/SQLDBAhttp://kendalvandyke.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/#!/sqldba48482197Kevin BolesKevin 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 over 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. @TheSQLGuruhttp://www.linkedin.com/in/thesqlguru https://api.twitter.com/1/users/profile_image?screen_name=@TheSQLGuru48482008Louis DavidsonI have been in the IT industry for 16 years as a corporate database developer and architect. I have been a Microsoft MVP for 5 years and have written 4 books on database design. Currently I am the Data Architect/DBA for the Christian Broadcasting Network supporting offices in Virginia Beach, Virginia and Nashville, Tennessee. I have a bachelor's degree from the University of Tennessee at Chattanooga in computer science with a minor in mathematics. For more information visit drsql.org@drsqlhttp://www.linkedin.com/in/louisdavidsonhttp://drsql.orghttps://api.twitter.com/1/users/profile_image?screen_name=@drsql48481870Maximo TrinidadMax 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. Also, in 2010 got his SAPI@MaxTrinidadhttp://www.linkedin.com/pub/max-trinidad/12/47/775http://www.flpsug.comhttps://api.twitter.com/1/users/profile_image?screen_name=@MaxTrinidad48482089Michael AntonovichMichael Stark MCTS-SQL, has been writing applications using SQL Server since 1993. He has a broad skill set beyond just database skills. His emphasis is user interface design and implementation. He also serves as the roady for his musician wife and son.@MPAntonovichhttp://www.linkedin.com/in/michaelpantonovichhttp://micmin.org/blog.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@MPAntonovich48481915Mike DavisMike 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.@mike_walshhttp://www.linkedin.com/in/mikedavissqlhttp://www.bidn.com/blogs/MikeDavis/https://api.twitter.com/1/users/profile_image?screen_name=@mike_walsh48482171Nathan HeaivilinJust a fellow developer and DBA working to pass along the knowledge that has been passed to me. 48482388Pam ShawPam 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/pshaw1129http://www.linkedin.com/in/pshaw1129http://www.TampaSQL.comhttps://api.twitter.com/1/users/profile_image?screen_name=@http://www.linkedin.com/in/pshaw112948482283Patrick LeBlancPatrick LeBlanc, SQL Server MVP, is currently a Business Intelligence Architect for Pragmatic Works. He has worked as a SQL Server DBA for the past 9 years. His experience includes working in the Educational, Advertising, Mortgage, Medical and Financial Industries. He is also the founder of TSQLScripts.com, SQLLunch.com and the President of the Baton Rouge Area SQL Server User Group. Patrick is a regular speaker at various SQL Server community events, including SQL Saturday’s and User Groups.@patrickdbahttp://www.sqllunch.comhttps://api.twitter.com/1/users/profile_image?screen_name=@patrickdba48481903Plamen RatchevPlamen is an SQL Server MVP and founder of Tangra, specializing in relational database applications analysis, implementation, and tuning. His particular interest is in design patterns, performance and optimization. @PlamenRatchevhttp://www.linkedin.com/in/plamenratchevhttp://pratchev.blogspot.com/https://api.twitter.com/1/users/profile_image?screen_name=@PlamenRatchev48482195Rafael SalasRafael Salas is a MCITP with a Bachelors degree in Computer Engineering and a Masters in Information Technology . Currently, he is a Manager of Professional Services Consulting at Quaero, a CSG Solution. Rafael is a SQL Server MVP with more than 12 years of experience in data warehousing and BI. He is a blog and article author, and is very active in some SQL Server community forums. You can find more about Rafael on his blog: www.rafael-salas.com
@RafSalashttp://www.linkedin.com/in/rafaelsalashttp://www.rafael-salas.comhttps://api.twitter.com/1/users/profile_image?screen_name=@RafSalas48482145Rodney LandrumRodney Landrum has been architecting solutions for SQL Server for over 12 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He is a regular contributor to SQL Server magazine and Simple-talk.com, where he blogs on about things like spiders, beer, somnambulance and SQL. Rodney is also a SQL Server MVP.@SQLBeathttp://www.linkedin.com/in/kylejdoylehttp://www.simple-talk.com/community/blogs/rodney/default.aspxhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLBeat48482350Ron DameronRonald Dameron is a Senior Database Administrator for the largest life insurer in the United States. He is most comfortable with Microsoft SQL Server as a database developer and DBA. He is currently exploring how PowerShell can simplify his life as a DBA and the new features of SQL Server 2005/8. Follow me on Twitter at @RonDBA. New blog at http://ronalddameron.blogspot.com @RonDBAhttp://www.linkedin.com/in/rdameronhttp://www.simple-talk.com/author/ron-dameron/https://api.twitter.com/1/users/profile_image?screen_name=@RonDBA48482207Ronald DameronRonald 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 him on Twitter at @RonDBA.@RonDBAhttp://www.linkedin.com/in/rdameronhttp://RonaldDameron.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=@RonDBA48482266Said SalomonSaid Salomon has over 25 year experience as an IT Professional. He has a vast array of abilities in the field in the areas of Network, Desktop Support, DBA, Staff Project Management, Application Software Development, Business Analysis and Quality Assurance. Said carries Microsoft certifications as a MCTS, MCPS, and MCNPS, and multiple certifications from the Insurance Institute of America. Current Said is a DBA at Unitrin Direct Insurance. Secretary of Philadelphia SQL Server User Group (PSSUG).@http://twitter.com/saidsalomonhttp://www.linkedin.com/in/saidsalomoniihttp://www.timelordshangout.comhttps://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/saidsalomon48481867Scott KleinScott Klein is President of Blue Syntax, a consulting and services firm specializing in SQL Azure. Scott is a Microsoft SQL Server MVP and author of several books including Professional SQL Server 2005 XML, Professional LINQ, Professional Entity Framework 4.0, and Pro SQL Azure. Scott runs the South Florida SQL Server Users Group.@http://twitter.com/ecuityhttp://www.linkedin.com/in/schledwitzhttps://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/ecuity48482747Shawn McGeheeShawn is an experienced DBA who is also a Friend of RedGate@gulfcoastsqlhttp://www.linkedin.com/in/sqlshawnhttp://www.red-gate.comhttps://api.twitter.com/1/users/profile_image?screen_name=@gulfcoastsql48482694Sherri McDonaldNo bio provided.@briankmcdonaldhttp://www.tinyurl.com/BrianKMcDonaldhttps://api.twitter.com/1/users/profile_image?screen_name=@briankmcdonald48482280Thomas LaRockThomas LaRock is a seasoned IT professional with over a decade of technical and management experience. Currently serving as a Senior DBA for Confio Software, Thomas holds a MS degree in Mathematics from WSU. Thomas currently serves on the Board of Directors for the Professional Association for SQL Server (PASS), and is also a SQL Server MVP. Thomas can also be found blogging at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA (http://dbasurvivor.com).@https://twitter.com/#!/SQLRockstarhttp://www.linkedin.com/in/sqlrockstarhttp://thomaslarock.comhttps://api.twitter.com/1/users/profile_image?screen_name=@https://twitter.com/#!/SQLRockstar48481882Tim BeamerTim Beamer has served 17 years in the technology industry in a variety of roles. Whether as a Systems Administrator, Systems Analyst, or Systems Engineer, the solutions developed by Tim have always been in response to mission critical needs either for his customers or the company he worked for. Currently Tim serves as a Technology Evangelist for the Microsoft Consulting Practice at Dell with responsibility for the United States of America and Canada.http://www.linkedin.com/in/tbeamhttp://content.dell.com/us/en/enterprise/by-service-type.aspx?redirect=148481886Timothy McAlileyTim is a Database Administrator on a Business Intelligence Team at Symantec (www.symantec.com, (SYMC). His particular interests are IT operations, information security, project management, and database/application tier high availability solutions. Timothy is a PMP, a CISA, a CISM, a CISSP, and is ITIL V3 Foundations certified. Timothy also holds MCTS, MCITP certifications on Windows Server 2008 and SQL Server 2005/2008. @SysFrameworks http://www.linkedin.com/pub/timothy-mcaliley-pmp-cism-cissp-cisa/10/530/787http://www.sysframeworks.blogspot.com/https://api.twitter.com/1/users/profile_image?screen_name=@SysFrameworks48482053Troy GallantTroy has been a SQL Server professional for over 7 years. The first four were in the role of a developer, and the last three as DBA for several large international organizations. When not working, Troy enjoys MMO's, the Grateful Dead, and whiling away the hours picking his mandolin. (Twitter: GratefulDBA)@GratefulDBAhttp://www.linkedin.com/in/tgallanthttp://troygallant.comhttps://api.twitter.com/1/users/profile_image?screen_name=@GratefulDBA48482243Wes DumeyWes is a Senior Consultant for Durable Impact Consulting, Inc, a Tampa, Florida based business intelligence and data warehousing firm. Wes has over ten years of experience working on enterprise business intelligence applications and portals and enjoys studying economics. http://www.linkedin.com/wesdumeyhttp://www.durableimpact.com484818481848David WaughRoom 9Response Time Analysis of SQL Server PerformanceUsing Response Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Response Time based performance analysis to solve the most difficult performance related issues. Designed for the SQL Server DBA, Developer or anyone concerned with performance. 10/16/2010 1:30:00 PM10/16/2010 2:30:00 PM18651865Andy WarrenRoom 5Introduction to SQL Server StatisticsThis beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you're a DBA or trying to get by without one, this session will give you the information you need to know. 10/16/2010 2:45:00 PM10/16/2010 3:45:00 PM18671867Scott KleinRoom 5Developing Applications with SQL AzureThis session will provide and detailed look at developing applications with SQL Azure. It will begin by providing an overview of existing functionality SQL Azure provides, then delve in to utilizing the features and technology to migrate existing applications as well as develop new applications with SQL Azure.10/16/2010 4:00:00 PM10/16/2010 5:00:00 PM18701870Maximo TrinidadRoom 8Working with SQL Server - SQLPSWill 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.10/16/2010 9:00:00 AM10/16/2010 10:00:00 AM18781878Argenis FernandezRoom 3Multi-Server Management with SQL Server 2008+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 querie, Utility Control Point, Policy-Based Management and SQLPS (the Powershell SQL mini-shell). 3rd party tools will be discussed as time permits.
10/16/2010 10:15:00 AM10/16/2010 11:15:00 AM18821882Tim BeamerRoom 1Designing a highly available SQL EnvironmentSQL Server is the database engine supporting the Line-of-Business applications that run your business, so how do you make sure it is always up and providing those critical services? This session will look at several alternatives for designing and implementing a highly availble architecture for your SQL environment. Options will be presented to give a range of availability scenarios based on Service Level Agreements, as well as budget.10/16/2010 10:15:00 AM10/16/2010 11:15:00 AM18841884Jack CorbettRoom 5Profiling: It's Okay in SQL ServerLearn how to use SQL Server Profiler/Trace to troubleshoot SQL Server performance and errors. This session will cover how to use Profiler to capture SQL Server events, creating server-side traces, creating custom templates, saving trace data, and interpreting trace data.10/16/2010 1:30:00 PM10/16/2010 2:30:00 PM18861886Timothy McAlileyRoom 5ITIL V3 for the Database Administrator 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.10/16/2010 10:15:00 AM10/16/2010 11:15:00 AM18921892Jose ChinchillaRoom 6Learning SSIS under 1 hourIn this session I will cover the most important SSIS control flow and data flow tasks to jumpstart DBAs into SSIS in SQL Server 2008. The session will focus on loading a de-normalized Data Warehouse from different sources.10/16/2010 10:15:00 AM10/16/2010 11:15:00 AM18961896Devin KnightRoom 7Introduction to Analysis ServicesIn 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. 10/16/2010 11:30:00 AM10/16/2010 12:30:00 PM18991899Jared NielsenRoom 5SQL and SEO - Making Money with SQL ServerBringing 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.10/16/2010 11:30:00 AM10/16/2010 12:30:00 PM19031903Plamen RatchevRoom 4Zen and the Art of Writing SQL Query - Part 1Writing 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!10/16/2010 2:45:00 PM10/16/2010 3:45:00 PM19041904Plamen RatchevRoom 4Zen and the Art of Writing SQL Query - Part 2Become a Zen master in the art of writing SQL queries! Explore the advanced topics of grouping, pivoting, and ranking with practical hands-on examples. Aggregating at multiple levels, transposing one or more columns, and isolating ranges may all seem like difficult tasks. Learning the fundamentals and applying simple steps will show you the way to master SQL query writing!10/16/2010 4:00:00 PM10/16/2010 5:00:00 PM19151915Mike DavisRoom 7R2 Reporting Services, The New StuffIn this session Mike shows you the new features in Reporting Services R2. You will learn how to use the Map control, Sparkline, Indicator, and Data Bars. See the new report builder 3.0. Learn about shared Data sets and report parts. Learn how to drill down from the US level to the state level using the map controls.10/16/2010 10:15:00 AM10/16/2010 11:15:00 AM19971997Jonathon MoormanRoom 4Everything you wanted to know about IDENTITY columA look at the various properties of identity columns. We will discuss how identity columns behave in triggers and replication. We will look at the property functions and catalog views to retrieve metadata about identity columns. We will also see how to override default identity information and specify a value, and reseed an identity column.
10/16/2010 1:30:00 PM10/16/2010 2:30:00 PM20082008Louis DavidsonRoom 4Database Design FundamentalsIn this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming 'difficulties' are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently). 10/16/2010 9:00:00 AM10/16/2010 10:00:00 AM20532053Troy GallantRoom 3Log Shipping vs. Replication; the Great DebateMany 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.10/16/2010 1:30:00 PM10/16/2010 2:30:00 PM20652065Eric WisdahlRoom 6SSIS Configurations, Expressions and ConstraintsThis session will look in depth at some of the more powerful aspects of Integrations Services: Expressions, Package Configurations, and Precedence Constraints. A short tutorial will show the users how to build up a package structure to allow logging to a remote location determined through configurations as well as capturing errors, destroying the error file if no errors are present and emailing a configurable user if any errors are found. 10/16/2010 1:30:00 PM10/16/2010 2:30:00 PM20672067Eric WisdahlRoom 6SSIS - Data Flow Buffer BreakdownAn advanced session which will attempt to break down areas of the data flow buffer. In examining how the buffers are built and used, the user will begin to understand if, how and why package performance will be impacted when new transformations or columns are added. The session will further take a look at the effects of parallel package and parallel task execution.10/16/2010 9:00:00 AM10/16/2010 10:00:00 AM20892089Michael StarkRoom 4Spatial Queries in SQL 2008A quick tour of the spatial data features of SQL Server 2008. Will create several different queries to determine geographic proximity between points. The second half of the session is devoted to wiring SQL Server spatial data into Bing Maps using ASP.Net.10/16/2010 10:15:00 AM10/16/2010 11:15:00 AM20992099Jeff GarbusRoom 2Choosing Indexes For PerformanceLearn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session
10/16/2010 1:30:00 PM10/16/2010 2:30:00 PM21202120Patrick ThompsonRoom 5Parts of Facebook: Cassandra and MapReduceApart from Google, Facebook is the 800lb Gorrilla in the internet space. They process 135TB of click data day, 1.2 million images a second. How do they do it? This session will look at two of the tools in the Facebook toolbox and talk about what makes them tick and how they fit with a Sql environment.10/16/2010 9:00:00 AM10/16/2010 10:00:00 AM21452145Rodney LandrumRoom 1DBA Script Thumb 2010This 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 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. 10/16/2010 4:00:00 PM10/16/2010 5:00:00 PM21552155Chad MillerRoom 8ETL with PowerShellIn this session we will look at performing common data loading tasks with Powershell. A basic understanding of PowerShell is helpful, but not necessary. Specific topics covered include importing structured files, XML, WMI objects and ADO.NET data sources.10/16/2010 4:00:00 PM10/16/2010 5:00:00 PM21712171Nathan HeaivilinRoom 2Introduction to Execution PlansThis is an introductory level session on execution plans. You will learn how to read them, what a number of the operators are, and then some real world example of how to use them, things to look for, and ways to make your queries run more efficiently.10/16/2010 11:30:00 AM10/16/2010 12:30:00 PM21842184Kathi KellenbergerRoom 1Optimize Resources with MAP Are you looking for tools to plan and optimize your database resources and investments? See how the Microsoft Assessment and Planning (MAP) Toolkit 5.0 can help you optimize your SQL Server infrastructure and accelerate migration planning to SQL Server 2008 R2. Learn how to inventory your infrastructure for discovery of SQL Server databases and engine instances—information you can use to optimize hardware and database resources, reduce administrative costs and streamline software licensing needs--all essentials for cost effective IT planning and operations.
10/16/2010 9:00:00 AM10/16/2010 10:00:00 AM21862186Michael AntonovichRoom 4XML 101 for the SQL Developer This session defines what XM is and how it differs from regular HTML, It looks at how to define data type variables and columns in SQL to store XML, how to output XML from existing table structures. It also covers how to use OPENXML, how to create and use your own namespaces, and the difference between typed XML and untyped XML. 10/16/2010 11:30:00 AM10/16/2010 12:30:00 PM21882188Michael AntonovichRoom 7BI Pivot Tables Charts, Not a 1 Tool ExerciseThis session begins with a simple SQL database with several related tables. It then shows how to import those tables to create a simp;le cube in Analysis Services. Given a simple, but functional cube, the session then goes into Excel to use the cube in Pivot Tables and Pivot Charts. Finally, you will see how easy it is to publish those Excel Pivot Tables and Pivot Charts into SharePoint using Excel Services to protect the calculation methods while allowing anyone with a browser to see and use your results.10/16/2010 4:00:00 PM10/16/2010 5:00:00 PM21952195Rafael SalasRoom 6Planning your ETL architecture with SSISThe complexity and importance of Extract, Transform and Load (ETL) projects are often underestimated, and the consequences of a poorly planned and executed ETL project will inevitably lead to maintenance nightmares, low reliability of the system, or worse yet, to the failure of the project.
In this session, we will use ETL best practices to make a requirements checklist you can use in your next ETL implementation, and will demonstrate how you can use SSIS to implement and meet such requirements. If you already learned the basics about SSIS and now want to take your ETL solutions to the next level, or if you became an SSIS developer/architect by accident and wonder what do you need to succeed, then this is the right session for you.10/16/2010 11:30:00 AM10/16/2010 12:30:00 PM21972197Kevin BolesRoom 2SQL Server Memory Deep DiveLike 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. 10/16/2010 2:45:00 PM10/16/2010 3:45:00 PM21982198Kevin BolesRoom 2SQL Server Partitioning from A to ZWe 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.10/16/2010 4:00:00 PM10/16/2010 5:00:00 PM22022202Aaron NelsonRoom 8The Dirty Dozen: PowerShell Scripts for Busy DBAsFor DBAs PowerShell provides a simple but powerful way to automate everyday tasks. 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 PowerShell 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.10/16/2010 10:15:00 AM10/16/2010 11:15:00 AM22032203Aaron NelsonRoom 8PowerShell 2.0 Beyond the Dirty DozenNow that you’ve learned the basics of PowerShell we’ll dive a little deeper and learn to develop scripts that help you get the most out of SQL Server. We’ll take a look at advanced functions, event logging and error handling. Then put everything together in a nice package and create our own modules to deploy to profiles across our entire SQL Server environment. 10/16/2010 11:30:00 AM10/16/2010 12:30:00 PM22072207Ronald DameronRoom 8Automate Login Administration Compliance ReportsAre your internal auditors asking that the administration of SQL Server logins be handled by a third party other than the DBAs? Is your Compliance and Audit departments asking you to determine if password policies are being enforced, who are sysadmins on your servers, who owns databases? If so, come to this session to learn how to complete these tasks quickly and efficiently using PowerShell and SQL PowerShell Extensions (SQLPSX). 10/16/2010 1:30:00 PM10/16/2010 2:30:00 PM22092209Brandie TarvinRoom 1SQL Backups RecoveryBacking up SQL Server is not just about database files anymore. This session gives a brief refresher of basic database backup techniques then moves to a discussion about all the other SQL components you should be backing up (and may have forgotten about). Bring your horror stories to share with all. Session also covers the order in which to restore / recovery your database backups.10/16/2010 11:30:00 AM10/16/2010 12:30:00 PM22142214Ken SimmonsRoom 1Configuration Domination: Taking Control of SQL (MWe all know that every environment is different, so how can we expect the default SQL Server installation to be optimized for each one. In this session, we will look at some of the configuration options you can change after you have installed SQL Server to maximize performance, security, and reliability. We will also cover the configuration changes you should make that are often overlooked after your server or your database has been upgraded.10/16/2010 1:15:00 PM10/16/2010 1:30:00 PM22162216Ken SimmonsRoom 3Automating Routine MaintenanceYou have installed SQL Server in your environment, but now what? Unfortunately, far too many servers are neglected after SQL Server has been installed and the applications are up and running. In order to sustain a SQL Server instance that provides optimum performance, it requires constant maintenance. Luckily, you can use the same tools within SQL Server to automate maintenance tasks that you use to meet the business needs of the organization. This session will cover the tasks you need to perform in order to maintain a healthy instance of SQL Server as well as the tools you can use to automate them.10/16/2010 9:00:00 AM10/16/2010 10:00:00 AM22422242Jorge SegarraRoom 3Policy-Based Management in a NutshellWe will be learning an overview of this powerful new feature in SQL Server 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Servers!10/16/2010 2:45:00 PM10/16/2010 3:45:00 PM22432243Wes DumeyRoom 7Data Warehousing with SQL Server 2008In this session you will learn about using Microsoft SSIS and SQL Server 2008 to host a data warehouse. We will work through an introduction to data warehousing and look at how we can use the Microsoft tools to build a small data warehouse. 10/16/2010 1:30:00 PM10/16/2010 2:30:00 PM22442244Dmitri KorotkevitchRoom 2Locking and Blocking for DevelopersLocking, 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.10/16/2010 10:15:00 AM10/16/2010 11:15:00 AM22622262Mike WalshRoom 3As a DBA, Where Do I Start?!Whether you are new to the role of DBA, being 'forced' to take on its responsibility or joining a new company with previous experience, knowing where to start can often mean the difference between success or failure. In this chat, Mike will help us wade through the noise that attacks a DBA and figure out just what our priorities should be. By focusing on the 'itties' of Database Administration (Recoverability, Availability - Health Performance - , Security and Reliability) we can see a natural priority form. Throughout this interactive discussion we will also look at some of the available tools and scripts to help see where our environments rate. Mike emphasizes our role as 'Protector of the Data' as a DBA throughout.10/16/2010 11:30:00 AM10/16/2010 12:30:00 PM22662266Said SalomonRoom 1Data Encryption and Key Management in SQL Overview of data encryptions and key management that is build into SQL 2005 and later. Topics that will be cover include: transparent column data encryption techniques, Transparent Data Encryption (TDE) new in 2008, use of keys (symmetrical and asymmetrical), what is a database master key, use of certificates in combination with key management, how to backup and safeguard keys.10/16/2010 2:45:00 PM10/16/2010 3:45:00 PM22752275Michael MollenhourRoom 7Securing your Data WarehouseIn this Session Mike will demonstrate how to leverage Active Directory Groups and Users to secure your DataWarehouse. He will demonstrate how to secure both Column and row level info in Transactional queries all the way to AS Queries.10/16/2010 2:45:00 PM10/16/2010 3:45:00 PM22802280Thomas LaRockRoom 2What Are You Waiting For?It’s a simple question, right? But how often do you have the answer, especially for your SQL statements? Thomas LaRock from Confio Software will teach you how proper response time analysis plays a key part in the overall performance tuning process. You will learn how to define, measure, and analyze performance issues as well as implementing changes and how to make sure those changes continue to have the desired effects. 10/16/2010 9:00:00 AM10/16/2010 10:00:00 AM22832283Patrick LeBlancRoom 6CDC + SSIS = SCD 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.
10/16/2010 4:00:00 PM10/16/2010 5:00:00 PM22852285Patrick LeBlancRoom 6Speaking, Should I? (MINI)I have been speaking for a while now. My first speaking engagement was at the inaugural Baton Rouge SQL Server User Group in May 2008. Was I nervous? Sure I was, but I quickly realized that I enjoyed it. Should you cross the line of attendee to speaker? Join me as I share my experiences as a speaker and what I think it takes to become a good speaker. You never know, you may realize that you should be speaking instead of in the audience. 10/16/2010 1:15:00 PM10/16/2010 1:30:00 PM23392339Kendal Van DykeRoom 3Transactional Replication: Beyond The BasicsTransactional replication can support synchronizing from as few as a hundred to as many as hundreds of millions or more of changes a day across multiple servers. However, replication is more than clicking your way through wizards; Monitoring and tuning are required to achieve optimal performance and the number of processes involved increase the likelihood that problems can (and usually will) occur. This session is for DBA already familiar with the basics of transactional replication and looking to go beyond the setup wizards to gain a deeper understanding of the technology. We'll cover monitoring techniques, calibrating performance, and troubleshooting common replication problems plus share some tricks and tips.10/16/2010 4:00:00 PM10/16/2010 5:00:00 PM23442344Plamen RatchevRoom 2How to Make a Killer Presentation (MINI)The naked truth about engaging your audience in a lively and entertaining presentation where both speaker and attendees have fun. Note that neither the presenter or the attendees will be naked for this great how-to session!10/16/2010 1:15:00 PM10/16/2010 1:30:00 PM23452345Patrick ThompsonRoom 3Cassandra, Mongo and Mapreduce (MINI)It's not always an all SQL Server world. Come see some benchmarks and tips on when and where they alternatives are best used.10/16/2010 1:15:00 PM10/16/2010 1:30:00 PM23502350Ron DameronRoom 8Why a DBA Should Learn PowerShell (MINI)Powershell is the newest scripting language from Microsoft and it goes across the Windows platform, including SQL Server. So it's new and exciting, but is it ready for prime time? Is it worth the effort to learn? How will it help you? Join PowerShell advocate and user Ron Dameron for a quick discussion of why he things knowing Powershell is a key skill for a SQL Server DBA.10/16/2010 1:15:00 PM10/16/2010 1:30:00 PM23572357Brandie TarvinRoom 4Troubleshooting Tips (MINI)Join ace DBA and troubleshooter Brandie Tarvin for a fast and furious look at some ways you might get to the bottom of a problem in a hurry. Just fifteen minutes and you could learn something that might save the day (or get cheaper car insurance!).10/16/2010 1:15:00 PM10/16/2010 1:30:00 PM23882388Pam ShawRoom 1Tips Tricks for Dynamic SSRS Reports 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.
10/16/2010 1:30:00 PM10/16/2010 2:30:00 PM25592559John WelchRoom 6Moving Data with SQL Azure and SSISSQL Azure allows you to host your data in SQL Server in the cloud. That provides some big benefits in scalability and management. However, it leaves open the question, “How do you get your data into / out of the cloud?” At some point, you are going to need to move data to or from an on-premise store to SQL Azure. In this session, we’ll discuss the available options for this, including SSIS, the Sync Framework, and BCP. We’ll cover the pros and cons for each. We’ll drill into one of the options, SSIS, in detail, and review performance options and potential issues that you may encounter when doing this.10/16/2010 2:45:00 PM10/16/2010 3:45:00 PM25892589Adam JorgensenRoom 7Zero to Dashboard in 60 minutesBuild your first PerformancePoint dashboard along with Adam in this demo rich session. We’ll cover how PerformancePoint works and then build some great content together.10/16/2010 9:00:00 AM10/16/2010 10:00:00 AM26932693Brian McDonaldRoom 7Reporting Services Delivery Mechanisms (mini)On demand reporting is the most common type of report request using SQL Server Reporting Services, but did you know that there are other options available to you? In this mini session, Brian is going to go over all of the delivery mechanisms built into SQL Server Reporting Services that will allow you to take full advantage of Microsoft’s robust reporting platform.10/16/2010 1:15:00 PM10/16/2010 1:30:00 PM26942694Sherri McDonaldRoom 5Documenting BI (mini)Sherri McDonald will be presenting a tool that documents your major SQL Server components and the 'entire' BI stack. Your team can now view historical data from SQL Server Databases, Integration Services, Analysis Services and Reporting Services in a format that is easy to navigate and understand. See a visual snapshot of your environment that includes images of their SSIS packages, ER Diagrams as well as an Impact Analysis Object Lineage. 10/16/2010 1:15:00 PM10/16/2010 1:30:00 PM27152715Kathi KellenbergerRoom 9Women in Technology (WIT)This is a general round table discussion about women in technology. This presentation is open to men as well. 10/16/2010 4:00:00 PM10/16/2010 5:00:00 PM27472747Shawn McGeheeRoom 9Red Gate Software - Ingeniously simple toolsIn this session Shawn McGehee, DBA and former developer and Friend of Red Gate, will illustrate the disk space,processing time and integrated feature benefits of using SQL Backup and show how best to manage database changes within SSMS using Red Gate’s new tool SQL Source Control. Engage in this lunchtime session for your chance to win one of two free licenses for SQL Source Control and other Red Gate swag.10/16/2010 10:15:00 AM10/16/2010 11:15:00 AM27482748Andrew SzalajiRoom 9expressor data integration software product demonsWhat do you do when SSIS can’t handle your data volumes or data sizes? Join expressor software for a discussion and demonstration of their data integration software. expressor software allows organizations to reuse the most labor-intensive elements of data integration projects, deliver superior data processing performance, and reap significant cost savings in both development and project lifecycle management and in hardware and software licensing.10/16/2010 11:30:00 AM10/16/2010 12:30:00 PM27492749Scott SchledwitzRoom 9Information BuildersLearn more about Information Builders10/16/2010 2:45:00 PM10/16/2010 3:45:00 PM27532753Ed WilsonRoom 8Windows PowerShell Best Practices for SQL DBA’sLearn 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.10/16/2010 2:45:00 PM10/16/2010 3:45:00 PM