SQLSaturday #220 - Atlanta 2013 5/18/2013 12:00:00 AM (GMT-05:00) Eastern Time (US and Canada) SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat220 Georgia State University – Alpharetta 3775 Brookside Pkwy Alpharetta GA 30022 3092 SIOS Technology Platinum http://us.sios.com/company/about-us/ http://us.sios.com/wp-content/uploads/2011/12/PartnerPortal/Logos_Guidelines/logo-1.png 60 170 3277 Precise Software Platinum http://www.precise.com http://media.marketwire.com/attachments/200809/467269_precise_logo_doc.jpg 60 170 3251 Intellinet Gold Sponsor http://www.intellinet.com http://www.intellinet.com/media/31199/intellinet_tagline.png 60 170 3332 Slalom Consulting Gold Sponsor http://www.slalom.com/ http://www.sqlsaturday.com/files/c6d18833-dc3d-43a4-b2b6-091cb03fa4eb.jpg 60 170 3367 Dell Gold Sponsor http://www.quest.com/ http://i.dell.com/images/global/brand/ui/storm80/logo80.png 60 170 3049 Red Gate Software Gold Sponsor http://redg.at/VPj1Tr http://www.red-gate.com/assets/images/common/logo.png 60 170 3204 Idera Gold Sponsor http://www.idera.com http://www.sqlsaturday.com/files/46ef09ea-ba24-4438-9d9a-15f801070e64.jpg 60 170 3420 Teksystems Gold Sponsor http://www.teksystems.com/ http://timradney.com/wp-content/uploads/2013/05/TEKsystems-logo.jpg 60 170 3077 CTS, Inc. Silver Sponsor http://www.askcts.com http://www.askcts.com/images/CTS_Logo2.png 60 170 3105 Melissa Data Silver Sponsor http://www.melissadata.com http://www.melissadata.com/images/mdlogo-color-tag-170x60.gif 60 170 3123 Confio Software Silver Sponsor http://www.confio.com http://www.confio.com/images/assets/confio_logo.jpg 60 170 3144 Fusion-io Silver Sponsor https://www.fusionio.com http://www.fusionio.com/images/logo.png 60 170 3177 Brooksource Bronze Sponsor http://www.brooksource.com http://brooksource.com/images/logo.png 60 170 3270 RDA Corporation Bronze Sponsor http://www.rdacorp.com/ http://www.rdacorp.com/wp-content/uploads/RDA_Logo_LetsGo-blue-170x60.jpg 60 170 3294 Sql Power Tools, Inc. Bronze Sponsor http://www.sqlpower.com http://www.sqlpower.com/img/spt_logo_sql_saturday.png 60 170 3304 PASS Headquarters Bronze Sponsor http://sqlpass.org http://www.sqlsaturday.com/images/PASS_logo.jpg 60 170 3426 MarkTab Inc Bronze Sponsor http://marktab.com http://marktab.com/images/MarkTab_Logo_170x60.jpg 60 170 3443 Kaminario Bronze Sponsor http://www.kaminario.com http://cdn-ci40.actonsoftware.com/acton/attachment/5595/f-0001/1/-/-/-/-/image.jpg 60 170 3378 Champion Valley Press Personal Sponsor http://www.ChampionValleyPres.com http://championvalleypress.com/header-object.png 40 100 3358 Indicium Resources, Inc. Personal Sponsor http://www.idontneedawebsite.ind http://www.idontneedawebsite.ind/nologo.jpg 40 100 3235 SQLvariant Blog Sponsor http://sqlvariant.com http://sqlvariant.com/BlogSupport/Images/SQLvariant_Logo.png 40 100 14007 Aaron Nelson Aaron Nelson is a Senior SQL Server Architect with over 10 years of experience in SQL Server. 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/sqlvariant http://www.linkedin.com/in/sqlvariant http://sqlvariant.com https://api.twitter.com/1/users/profile_image?screen_name=@http://twitter.com/sqlvariant 48 48 14002 Adam Machanic Adam Machanic doesn't like web sites that only let him put in 500 characters for a bio. If you want to know who he is, visit this link: https://mvp.support.microsoft.com/profile/adam @AdamMachanic http://www.linkedin.com/in/adammachanic http://dataeducation.com https://api.twitter.com/1/users/profile_image?screen_name=@AdamMachanic 48 48 13726 Andy Leonard Andy Leonard is CSO of Linchpin People, an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, blogger, and engineer. He is a co-author of SQL Server MVP Deep Dives, Volume 2 and SSIS Design Patterns. His background includes VB and web application architecture and development; and SQL Server 2000-2012. @AndyLeonard http://www.linkedin.com/in/andyleonard http://linchpinpeople.com https://api.twitter.com/1/users/profile_image?screen_name=@AndyLeonard 48 48 13995 Audrey Hammonds Audrey is a data services consultant for Innovative Architects and a SQL Server MVP. She loves data and making applications happy by designing databases that work. She digs interesting applications of T-SQL and tries valiantly to understand the internals of what makes SQL Server go. She's a wife and a mother to two amazing sons, Chase and Gavin. She finds time to try to learn to play the ukulele or read a book. She blogs at datachix.com with one of her favorite people in the world, Julie Smith. @DataAudrey http://www.linkedin.com/in/audreyhammonds datachix.com https://api.twitter.com/1/users/profile_image?screen_name=@DataAudrey 48 48 13839 Ben Miller Ben has been a member of the SQL Server Community for over 14 years now. He is currently a Enterprise DBA Architect for HealthEquity, a Health Savings Account Provider in Draper Utah. He is a 3 year SQL Server MVP and has spent time in the field using SQL Server since 1997. He has worked at various companies throughout the US as well as at Microsoft for 7 years. He is passionate about SQL Server and automation and integration. @dbaduck http://www.linkedin.com/in/dbaduck http://dbaduck.com https://api.twitter.com/1/users/profile_image?screen_name=@dbaduck 48 48 14924 Blank Blank Blank 48 48 13992 Bobby Dimmick Bobby Dimmick is a Software Architect at VC3, Inc., in Columbia, South Carolina. Between jet-setting around the world and trying to keep up with his 7 year old he acts as a modern-day technology Macgyver - defusing complex situations amongst techies, clients, and everyone in-between. He has a passion for travel, good sushi, languages, and challenging technical problems. @kr4ster http://www.linkedin.com/in/bobbydimmick http://www.bobbydimmick.com https://api.twitter.com/1/users/profile_image?screen_name=@kr4ster 48 48 13609 Carlos Rodrigues Carlos Rodrigues is a Business Intelligence Architect with Recall Corporation and he has expertise in planning, developing, and implementing state of the art information solutions facilitating corporate management and growth. He has been successfully leveraging SQL Server BI tools at Recall since 2004 going through the several SQL Server versions. Lately, we've been leveraging SQL Server 2012 Bi tools such as Power View, PowerPivot, etc. @carlosedr http://www.linkedin.com/in/rodriguesc https://api.twitter.com/1/users/profile_image?screen_name=@carlosedr 48 48 14278 Chris Skorlinski Chris Skorlinski has been with Microsoft for 20 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting in Replication and Windows Azure SQL Database. His MSDN blog http://blogs.msdn.com/ReplTalk/ contain Best Practices, How To, and Inside Replication tips for configuring and turning SQL Server Replication while http://blogs.msdn.com/SQLDatabaseTalk/ covers Windows Azure SQL Database topics. @ReplTalk http://www.linkedin.com/pub/chris-skorlinski/1b/237/b55 https://api.twitter.com/1/users/profile_image?screen_name=@ReplTalk 48 48 13810 Dan Holmes Dan Holmes has been developing in Microsoft technologies for 20 years. He worked as a developer building a warehouse management system as well as custom programming. His current position at RouteMatch software is as a SQL Developer. That all TSQL all the time. http://www.linkedin.com/in/dnhlms http://dnhlmssql.blogspot.com https://api.twitter.com/1/users/profile_image?screen_name= 48 48 15441 Dave Bermingham and Vin Prasad Dave Bermingham is the Senior Technical Evangelist at SIOS Technology Corp. He is a Microsoft Cluster MVP award recipient (2010-2013) with over 25 years IT experience. He specializes in HA clustering and related technologies. Vin Prasad is a leading Sales Engineer for Fusion-io. He has over a decade of experience as an IT Systems Engineer and is specializes in high Performance storage solutions leveraging solid state technologies. @SIOSTech http://www.linkedin.com/company/sios-technology-corp. http://us.sios.com/fusion-io https://api.twitter.com/1/users/profile_image?screen_name=@SIOSTech 48 48 14350 David Klee David Klee (@kleegeek) is a SQL Server performance and virtualization expert. With over sixteen years of IT experience, David spends his days virtualizing mission critical SQL Servers as a Solutions Architect for House of Brick Technologies. His areas of expertise are virtualization and performance. When not geeking out on database and infrastructure technologies, David enjoys anything with a motor and is an avid amateur photographer. You can read his blogs at bit.ly/HoBSA and davidklee.net. @kleegeek http://www.linkedin.com/in/davidaklee http://davidklee.net https://api.twitter.com/1/users/profile_image?screen_name=@kleegeek 48 48 13656 Denny Cherry Denny Cherry has over a decade of experience managing SQL Server and is currently a Sr. Database Administrator and Architect at Awareness Technologies. Denny holds several Microsoft Certifications as well as being a Microsoft MVP. @mrdenny http://www.linkedin.com/in/mrdenny http://www.dcac.co https://api.twitter.com/1/users/profile_image?screen_name=@mrdenny 48 48 13451 Ed Watson Ed Wyatt, Intellinet’s Senior Practice Director of Management Consulting, is a seasoned IT strategist and business executive specializing in building and energizing new organizations and leading the turnaround of under-performing IT organizations. He has served in numerous leadership positions including Senior Vice-President and CIO at Atlanta Casualty / Windsor Group, Managing Director of IT at AXA Equitable, and Assistant Vice-President at Information Systems of America. @SQLGator http://www.linkedin.com/in/watsoned http://sqlgator.com https://api.twitter.com/1/users/profile_image?screen_name=@SQLGator 48 48 14368 Eddie Wuerch Eddie Wuerch is a DBA, developer, and trainer specializing in SQL Server for over ten of the twenty years he has spent in IT. Eddie is currently the tech lead of the DBA team at ExactTarget, a leading SaaS ESP located in Indianapolis. Eddie and his team design and manage the petabyte of 24x7 SQL Server database clusters that form the foundation of the ExactTarget application. He holds MCITP certifications in SQL Server 2005 and 2008 development and administration, and is an MCT. @eddiew http://www.linkedin.com/in/eddiewuerch http://indydba.com https://api.twitter.com/1/users/profile_image?screen_name=@eddiew 48 48 13720 Eric Peterson I have 25+ years of database experience, starting with mainframe databases, moving into Unix and finally to SQL Server. I spent 9 years working for Sybase before the code was converted to windows for Microsoft SQL Server and have 15+ years experience working with Microsoft SQL Server. I have spent 10+ years traveling around the world doing database consulting. I am currently employed as a database architect with BCD Travel in Atlanta. 48 48 14016 Geoff Hiten Microsoft MVP Geoff Hiten is a Principal SQL Server consultant for Intellinet. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in high-availability and high-performance SQL systems. Geoff is heavily involved in the Microsoft SQL Server Community and was initially awarded MVP status in 2004. Geoff was appointed in 2011 to fill an interim Director position at the National PASS organization. @sqlcaftsman http://www.linkedin.com/profile/view?id=5834715trk=tab_pro http://weblogs.sqlteam.com/geoffh/default.aspx https://api.twitter.com/1/users/profile_image?screen_name=@sqlcaftsman 48 48 13974 Jason Thomas Jason Thomas is a Microsoft certified SQL Server Professional with around 6 years of BI experience, mainly in SSAS and SSRS. He currently works as a Business Intelligence Consultant for Mariner in Charlotte, NC and is a constant presence in the Microsoft forums, for which he was recognized with the Microsoft Community Contributor award. @de_unparagoned http://www.linkedin.com/profile/view?id=45468672trk=tab_pro http://www.SqlJason.com https://api.twitter.com/1/users/profile_image?screen_name=@de_unparagoned 48 48 14000 Javier Guillen Javier Guillen is a Senior Business Intelligence developer currently living in Charlotte NC. He has designed and developed BI solutions in Microsoft and SAP environments primarily for a wide variety of organizations. His primary interest is Analysis Services technology – with particular emphasis in MDX and DAX. @javiguillen http://www.linkedin.com/in/javierguillen http://javierguillen.wordpress.com https://api.twitter.com/1/users/profile_image?screen_name=@javiguillen 48 48 15355 Jennifer McCown Jen McCown is an independent conslutant, Microsoft SQL Server MVP awardee, SQL developer, and DBA. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. She is co-creator of DBARoadmap.com. Jen is a member, volunteer, and speaker in NTSSUG, PASS, and the PASS Women in Technology virtual chapter. @MidnightDBA http://www.linkedin.com/in/jennifermccown http://www.MidnightDBA.com/Jen https://api.twitter.com/1/users/profile_image?screen_name=@MidnightDBA 48 48 13980 Jim Christopher Jim gained 18 years of professional experience developing complex software projects in highly regulated industries, including education, gaming, and defense. His professional drive is designing software, systems, and user experiences for automation, a theme that has earned him a two-time Microsoft MVP for PowerShell (2011, 2012). Jim is a frequent speaker at technical user groups and conferences. @beefarino http://www.linkedin.com/profile/edit?trk=hb_tab_pro_top http://www.beefycode.com https://api.twitter.com/1/users/profile_image?screen_name=@beefarino 48 48 13643 Jon Boulineau Jon Boulineau is a 12 year it veteran currently working as a DBA for a Fortune 500 company. In addition to his work as a DBA he has survived phases as a network engineer, systems administrator, and developer in his career. He resides in Columbus, GA with his wife and four children. @jboulineau http://www.newsqlblog.com https://api.twitter.com/1/users/profile_image?screen_name=@jboulineau 48 48 14611 Jonathan Walz Jon Walz is a PowerShell expert and co-host of the PowerScripting podcast. @JonWalz www.linkedin.com/pub/jonathan-walz/11/3a/309 http://powerscripting.net https://api.twitter.com/1/users/profile_image?screen_name=@JonWalz 48 48 13608 Joseph D'Antoni Joey D'Antoni is a frequent speaker at SQL Saturday events. He is a SQL Server Architect at Comcast in West Chester, Pennsylvania with 10+ years of experience working on a wide variety of database platforms. His specialties include DR, HA and Virtualization. @jdanton http://joedantoni.wordpress.com https://api.twitter.com/1/users/profile_image?screen_name=@jdanton 48 48 13993 Julie Smith Julie Smith has spent the last 13 years bending data using varied tools such as MS Access, MySQL, and SQL Server 2000-2012. She is a BI Consultant at Innovative Architects and an active speaker, blogger and writer in the Microsoft SQL Server Community. She is one of the co-founders of The Cloverleaf School of Atlanta, which educates children with ADHD, Autism and other learning differences. In spite of being a SQL Server MVP, she remains 'very simple woman with warm fuzzy secret heart.' @datachix1 http://www.linkedin.com/in/juliesmith0503 http://datachix.com https://api.twitter.com/1/users/profile_image?screen_name=@datachix1 48 48 13529 Kevin Boles Kevin is a SQL Server expert, working exclusively with the product since version 6.5. With almost 20 years of database experience, he holds many SQL Server related certifications and is also an MCT and was a SQL Server MVP from 2007 to 2012. Kevin teaches occasionally and has been a very successful independent consultant for almost 15 years. His passion is the relational engine, especially scalability, performance analysis and tuning. @kekline http://www.linkedin.com/in/kekline https://api.twitter.com/1/users/profile_image?screen_name=@kekline 48 48 13745 Leo Furlong Leo Furlong is the Practice Director of Business Intelligence at Intellinet. He specializes in Microsoft BI, specifically as it pertains to the Front End BI tools like Analysis Service, Reporting Services, and the SharePoint BI tools PerformancePoint, Excel Services, PowerPivot, and Power View. He is a recent graduate of the Georgia State Robinson College of Business where he obtained his Master of Business Administration.He is a father of two young boys. http://www.linkedin.com/in/leoafurlongiv www.intellinet.com 48 48 13905 Louis Davidson Louis has been in the IT industry for 17 years as a corporate database developer and architect. He has been a Microsoft MVP for 7 years and has written 4 books on database design. Currently serves as the Data Architect for the Christian Broadcasting Network supporting offices in Virginia Beach, Virginia and Nashville, Tennessee. For more information please visit his website at drsql.org @drsql http://www.linkedin.com/in/louisdavidson http://drsql.org https://api.twitter.com/1/users/profile_image?screen_name=@drsql 48 48 13472 Mark Tabladillo As you and your team use data mining and analytics, Mark Tabladillo (SAS expert, Microsoft MVP, PhD) increases your confidence in making actionable business decisions. Mark provides training and consulting for companies in United States and around the world. He also teaches part-time with the University of Phoenix, and supervised a dissertation with a graduate student living in Canada. @marktabnet http://www.linkedin.com/company/marktab-consulting?trk=fc_badge http://marktab.net/datamining https://api.twitter.com/1/users/profile_image?screen_name=@marktabnet 48 48 13587 Melissa Coates Melissa Coates is a Business Intelligence developer based in Charlotte, NC. As an Architect with Intellinet, she specializes in delivering BI and Data Warehousing solutions. Formerly a CPA, Melissa is ridiculously proud to be an IT geek. Her background gives her a valuable blend of technical, business, and training skills. When Melissa steps away from the laptop, you can probably find her hanging out with her border collie. Melissa blogs at http://www.sqlchick.com. @sqlchick http://www.linkedin.com/in/melissacoatesprofile http://www.sqlchick.com https://api.twitter.com/1/users/profile_image?screen_name=@sqlchick 48 48 13863 Mike Robbins Mike F Robbins is a Senior Systems Engineer with almost 20 years of experience as an IT Pro. He’s a PowerShell Enthusiast who uses PowerShell on a daily basis to administer Windows Server, Hyper-V, SQL Server, Exchange, SharePoint, Active Directory, EqualLogic SANs, and AppAssure. Mike has written PowerShell guest blog articles for the Hey, Scripting Guy Blog!, PowerShell Magazine, and a chapter for the PowerShell Deep Dives book. Mike is also the founder of the Mississippi PowerShell User Group @mike_walsh http://www.linkedin.com/in/mikefrobbins http://mikefrobbins.com/ https://api.twitter.com/1/users/profile_image?screen_name=@mike_walsh 48 48 13984 Pam Shaw Pam Shaw has been in IT for almost 30 years. Since 2001, 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://sqlpam.wordpress.com/ https://api.twitter.com/1/users/profile_image?screen_name=@http://www.linkedin.com/in/pshaw1129 48 48 13804 Paul Waters Paul has over 16 year of experience working in IT-related fields. Over the past 10 years, he has focused on designing and implementing data warehouses and business intelligence systems. Paul is the President of the SQL Server Innovators Guild in Greenville, SC. He was the Technical Editor for the book 'Microsoft SQL Server 2008 Integration Services Problem-Design-Solution' and contributed to the Wrox book 'Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports.' @pswaters http://www.linkedin.com/in/pswaters http://bimlscript.com/ https://api.twitter.com/1/users/profile_image?screen_name=@pswaters 48 48 14004 Richie Rump Richie Rump is a software developer, data architect and project manager. He currently helps companies solve their data challenges using SQL Server and .Net. He holds the Project Management Professional (PMP), Certified Scrum Master (CSM) and various Microsoft development certifications. Richie is also the founder of the dotNet Miami, a community focused on enterprise development with .NET and SQL Server. His previous experience includes working with Burger King, FPL, Ryder and Walt Disney World. @Jorriss http://www.linkedin.com/in/richierump http://jorriss.net https://api.twitter.com/1/users/profile_image?screen_name=@Jorriss 48 48 13986 Robert Cain Robert C. Cain (http://arcanecode.com) is a Microsoft MVP SQL Server, MCTS Certified in BI, and works as a Senior Consultant for Pragmatic Works. He is also a technical contributor to Plurasight Training, and co-author of 3 (soon to be 4) books. A popular speaker, Robert has presented at events such as SQL PASS Summit, TechEd, SQL Rally, and numerous SQL Saturdays. @arcanecode http://www.linkedin.com/in/arcanecode http://arcanecode.com https://api.twitter.com/1/users/profile_image?screen_name=@arcanecode 48 48 13935 Ryan Duclos Ryan Duclos is a Senior Technical Consultant for Perficient, Inc. (PRFT), where he is passionate about Microsoft development utilizing the .Net Framework, SQL Server, and Windows Azure technologies. He lives and works in LA (Lower Alabama!) and loves spending time with his family, as well as being a Community Influencer for Microsoft. Ryan is the President of the Lower Alabama .NET User Group and is also involved with the Pensacola SQL Server User Group. @rduclos http://www.linkedin.com/in/ryanduclos http://about.me/rduclos https://api.twitter.com/1/users/profile_image?screen_name=@rduclos 48 48 13752 Stacia Misner Stacia Misner has over 25 years of experience with improving business practices through technology and has been providing consulting and education services for Microsoft’s business intelligence technologies since 2000. She is a SQL Server MVP, SSAS Maestro, MCITP, MCTS, and has authored or co-authored multiple books and articles about Microsoft business intelligence technologies. @StaciaMisner http://www.linkedin.com/in/staciamisner http://blog.datainspirations.com https://api.twitter.com/1/users/profile_image?screen_name=@StaciaMisner 48 48 13889 Steve Busby Steve is a Technology Specialist with Microsoft, specializing in SQL Server Parallel Data Warehouse. Steve is a fourteen year Microsoft veteran, having spent time previously in Microsoft’s consulting group (MCS) before moving on to run the Microsoft Technology Center(MTC) in Atlanta. While at Microsoft, Steve’s focus as always been on perf and scale aspects of MSFT’s enterprise solutions. Prior to MSFT, Steve was a developer for Southern Company and has a BS in Electrical Engineering from UAB. @BamaSteveB http://www.linkedin.com/pub/steve-busby/26/589/267 http://www.microsoft.com https://api.twitter.com/1/users/profile_image?screen_name=@BamaSteveB 48 48 13973 Stuart Ainsworth Stuart R Ainsworth, MA, MEd is a Manager of Database Administrators working in Financial Information Security; he's worked as a Research Analyst, a report writer, a DBA, a programmer, and a public speaking professor. In his current role, he's responsible for a data analysis operation that processes nearly a billion rows per day. He's one of the chapter leaders for AtlantaMDF, and is trying to learn something new every day. @codegumbo http://www.linkedin.com/in/stuartainsworth http://www.codegumbo.com https://api.twitter.com/1/users/profile_image?screen_name=@codegumbo 48 48 13540 Sven Aelterman Sven is a lecturer in Information Systems at Troy University in Troy, Alabama. He teaches undergraduate courses in data warehousing and network infrastructure and security. He is also the technology specialist for the Sorrell College of Business and performs a variety of technology roles with a global scope. He continues consulting work through Adduxis, where he assists customers with software development projects using the Microsoft .NET Framework. Co-author of The Art of SQL Server FILESTREAM. @svenaelterman http://linkd.in/svena http://svenaelterman.wordpress.com https://api.twitter.com/1/users/profile_image?screen_name=@svenaelterman 48 48 13976 Tamera Clark Tamera Clark has been involved in the IT industry for over ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter. Tamera is currently a Database Engineer in the Nashville, Tennessee area. When not playing with computers, she enjoys tending her garden and experimenting in the kitchen. @tameraclark http://tameraclark.com https://api.twitter.com/1/users/profile_image?screen_name=@tameraclark 48 48 14925 Teo Lachev Teo Lachev is a consultant, author, and mentor, with a focus on Microsoft Business Intelligence. His Atlanta-based company Prologika helps organizations make sense of data by applying effectively Microsoft Business Intelligence technologies for reporting, analysis, and data mining. @tlachev http://www.linkedin.com/in/tlachev http://www.prologika.com https://api.twitter.com/1/users/profile_image?screen_name=@tlachev 48 48 13459 Thomas LeBlanc Thomas is a Senior DBA in Baton Rouge, LA. Worked in the IT field for 25 years experience w/ COBOL dBase, FoxPro, Visual FoxPro, VB 3 thru 6 and .Net(C#). Designing Normalized Dimensional database has become his passion. Full-time DBA work started about 12 years ago. he has been blessed with speaking at SQLRally(Orlando) and PASS(11-12). Free time is spent helping other improving his relationship with family God. TheSmilingDBA.Blogspot.com @SQLife http://www.linkedin.com/profile/view?id=29648544trk=tab_pro http://sqlsalt.com https://api.twitter.com/1/users/profile_image?screen_name=@SQLife 48 48 13450 Tim Radney Lead System DBA for a top 40 US held bank. Chapter leader for the Columbus GA SQL Users Group, PASS Regional Mentor for Greater South East US. I am a Microsoft Systems Admin turned DBA. Prior to becoming a full time DBA I spent 10 years supporting Citrix, Novell, Windows, IIS, and MSSQL. @http://www.twitter.com/tradney http://linkedin.com/in/tradney http://www.timradney.com https://api.twitter.com/1/users/profile_image?screen_name=@http://www.twitter.com/tradney 48 48 13498 Timothy McAliley I am currently a Microsoft Premier Field Engineer for SQL Server in Washington, D.C. Previously I was a Technical Trainer in the Enterprise Security Group at Symantec (www.symantec.com, SYMC). I have been in IT for over 13 years. My particular interests are IT operations, IT auditing, IT audit frameworks, IT service management (ITSM), ITIL, information security, project management, and database/application tier high availability solutions. Also at Symantec, I was a DBA on a BI/Reporting Team. @SysFrameworks http://www.linkedin.com/pub/timothy-mcaliley-pmp-cism-cissp https://api.twitter.com/1/users/profile_image?screen_name=@SysFrameworks 48 48 14524 Wes Brown Wes Brown is a SQL Server expert specializing in large scale deployments, optimization, and infrastructure. I'm also a community leader and SQL Server MVP @SQLServerIO http://www.linkedin.com/in/sqlserverio http://sqlserverio.com/ https://api.twitter.com/1/users/profile_image?screen_name=@SQLServerIO 48 48 13694 William E Pearson III Bill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill's background as a CPA, Internal Auditor, Management Accountant, SQL Server MVP (BI) and SSAS Maestro enable him to provide value as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise BI systems for many Fortune 500 companies, and focuses his practice upon the integrated Microsoft BI solution. Bill is a member of the Boulder BI Brain Trust. @Bill_Pearson http://mvp.microsoft.com/en-US/findanmvp/pages/profile.aspx?MVPID=02c5cd07-7511-4151-a678-3a4a3451f85e http://mvp.microsoft.com/profiles/02C5CD07-7511-4151-A678-3A4A3451F85E https://api.twitter.com/1/users/profile_image?screen_name=@Bill_Pearson 48 48 13967 Yelena Pavlyuk Lena works at Pinellas County School Board in St.Petersburg, FL. It is the largest employer in Pinellas County with 17,000 staff who serve nearly 104,000 pre-K through 12th-grade students. Lena has been using SQL Server since 2004, she is MCTS certified and has been helping with SQL Saturdays for a few years. http://www.linkedin.com/profile/edit?id=33550360 https://api.twitter.com/1/users/profile_image?screen_name= 48 48 13446 13446 SQLSatruday 220 B/I 1 - Presented by Slalom 220 5/18/2013 10:00:00 AM 5/18/2013 10:15:00 AM 13446 13446 SQLSatruday 220 B/I 1 - Presented by Slalom 220 5/18/2013 2:15:00 PM 5/18/2013 2:30:00 PM 13446 13446 SQLSatruday 220 B/I 1 - Presented by Slalom 220 5/18/2013 3:30:00 PM 5/18/2013 3:45:00 PM 13446 13446 SQLSatruday 220 B/I 2 - Presented by Tek Systems Room-222 5/18/2013 10:00:00 AM 5/18/2013 10:15:00 AM 13446 13446 SQLSatruday 220 B/I 2 - Presented by Tek Systems Room-222 5/18/2013 2:15:00 PM 5/18/2013 2:30:00 PM 13446 13446 SQLSatruday 220 B/I 2 - Presented by Tek Systems Room-222 5/18/2013 3:30:00 PM 5/18/2013 3:45:00 PM 13446 13446 SQLSatruday 220 B/I 3 Room-204 5/18/2013 10:00:00 AM 5/18/2013 10:15:00 AM 13446 13446 SQLSatruday 220 B/I 3 Room-204 5/18/2013 2:15:00 PM 5/18/2013 2:30:00 PM 13446 13446 SQLSatruday 220 B/I 3 Room-204 5/18/2013 3:30:00 PM 5/18/2013 3:45:00 PM 13446 13446 SQLSatruday 220 Zero Level Room-205 5/18/2013 10:00:00 AM 5/18/2013 10:15:00 AM 13446 13446 SQLSatruday 220 Zero Level Room-205 5/18/2013 2:15:00 PM 5/18/2013 2:30:00 PM 13446 13446 SQLSatruday 220 Zero Level Room-205 5/18/2013 3:30:00 PM 5/18/2013 3:45:00 PM 13446 13446 SQLSatruday 220 DBA 1 - Presented by SIOS Room-106 5/18/2013 10:00:00 AM 5/18/2013 10:15:00 AM 13446 13446 SQLSatruday 220 DBA 1 - Presented by SIOS Room-106 5/18/2013 2:15:00 PM 5/18/2013 2:30:00 PM 13446 13446 SQLSatruday 220 DBA 1 - Presented by SIOS Room-106 5/18/2013 3:30:00 PM 5/18/2013 3:45:00 PM 13446 13446 SQLSatruday 220 DBA 2 - Presented by Precise Room-107 5/18/2013 10:00:00 AM 5/18/2013 10:15:00 AM 13446 13446 SQLSatruday 220 DBA 2 - Presented by Precise Room-107 5/18/2013 2:15:00 PM 5/18/2013 2:30:00 PM 13446 13446 SQLSatruday 220 DBA 2 - Presented by Precise Room-107 5/18/2013 3:30:00 PM 5/18/2013 3:45:00 PM 13446 13446 SQLSatruday 220 DBA 3 - Presented by Intellinet Room-113 5/18/2013 10:00:00 AM 5/18/2013 10:15:00 AM 13446 13446 SQLSatruday 220 DBA 3 - Presented by Intellinet Room-113 5/18/2013 2:15:00 PM 5/18/2013 2:30:00 PM 13446 13446 SQLSatruday 220 DBA 3 - Presented by Intellinet Room-113 5/18/2013 3:30:00 PM 5/18/2013 3:45:00 PM 13446 13446 SQLSatruday 220 DBA 4 - Presented by Dell Room-216 5/18/2013 10:00:00 AM 5/18/2013 10:15:00 AM 13446 13446 SQLSatruday 220 DBA 4 - Presented by Dell Room-216 5/18/2013 2:15:00 PM 5/18/2013 2:30:00 PM 13446 13446 SQLSatruday 220 DBA 4 - Presented by Dell Room-216 5/18/2013 3:30:00 PM 5/18/2013 3:45:00 PM 13446 13446 SQLSatruday 220 DBA 5 - Presented by Red Gate Room-213 5/18/2013 10:00:00 AM 5/18/2013 10:15:00 AM 13446 13446 SQLSatruday 220 DBA 5 - Presented by Red Gate Room-213 5/18/2013 2:15:00 PM 5/18/2013 2:30:00 PM 13446 13446 SQLSatruday 220 DBA 5 - Presented by Red Gate Room-213 5/18/2013 3:30:00 PM 5/18/2013 3:45:00 PM 13446 13446 SQLSatruday 220 PowerShell Room-206 5/18/2013 10:00:00 AM 5/18/2013 10:15:00 AM 13446 13446 SQLSatruday 220 PowerShell Room-206 5/18/2013 2:15:00 PM 5/18/2013 2:30:00 PM 13446 13446 SQLSatruday 220 PowerShell Room-206 5/18/2013 3:30:00 PM 5/18/2013 3:45:00 PM 13446 13446 SQLSatruday 220 DBD 1 - Presented by Idera Room-212 5/18/2013 10:00:00 AM 5/18/2013 10:15:00 AM 13446 13446 SQLSatruday 220 DBD 1 - Presented by Idera Room-212 5/18/2013 2:15:00 PM 5/18/2013 2:30:00 PM 13446 13446 SQLSatruday 220 DBD 1 - Presented by Idera Room-212 5/18/2013 3:30:00 PM 5/18/2013 3:45:00 PM 13446 13446 SQLSatruday 220 Twelfth Track! Room-210 5/18/2013 10:00:00 AM 5/18/2013 10:15:00 AM 13446 13446 SQLSatruday 220 Twelfth Track! Room-210 5/18/2013 2:15:00 PM 5/18/2013 2:30:00 PM 13446 13446 SQLSatruday 220 Twelfth Track! Room-210 5/18/2013 3:30:00 PM 5/18/2013 3:45:00 PM 13447 13447 SQLSaturday 220 B/I 3 Room-204 5/18/2013 11:45:00 AM 5/18/2013 12:45:00 PM 13447 13447 SQLSaturday 220 Zero Level Room-205 5/18/2013 11:45:00 AM 5/18/2013 12:45:00 PM 13447 13447 SQLSaturday 220 DBA 2 - Presented by Precise Room-107 5/18/2013 11:45:00 AM 5/18/2013 12:45:00 PM 13447 13447 SQLSaturday 220 DBA 4 - Presented by Dell Room-216 5/18/2013 11:45:00 AM 5/18/2013 12:45:00 PM 13447 13447 SQLSaturday 220 PowerShell Room-206 5/18/2013 11:45:00 AM 5/18/2013 12:45:00 PM 13447 13447 SQLSaturday 220 DBD 1 - Presented by Idera Room-212 5/18/2013 11:45:00 AM 5/18/2013 12:45:00 PM 13447 13447 SQLSaturday 220 Twelfth Track! Room-210 5/18/2013 11:45:00 AM 5/18/2013 12:45:00 PM 13448 13448 SQLSaturday 220 B/I 1 - Presented by Slalom 220 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 13448 13448 SQLSaturday 220 B/I 2 - Presented by Tek Systems Room-222 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 13448 13448 SQLSaturday 220 B/I 3 Room-204 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 13448 13448 SQLSaturday 220 Zero Level Room-205 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 13448 13448 SQLSaturday 220 DBA 1 - Presented by SIOS Room-106 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 13448 13448 SQLSaturday 220 DBA 2 - Presented by Precise Room-107 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 13448 13448 SQLSaturday 220 DBA 3 - Presented by Intellinet Room-113 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 13448 13448 SQLSaturday 220 DBA 4 - Presented by Dell Room-216 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 13448 13448 SQLSaturday 220 DBA 5 - Presented by Red Gate Room-213 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 13448 13448 SQLSaturday 220 PowerShell Room-206 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 13448 13448 SQLSaturday 220 DBD 1 - Presented by Idera Room-212 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 13448 13448 SQLSaturday 220 Twelfth Track! Room-210 5/18/2013 8:30:00 AM 5/18/2013 9:00:00 AM 13449 13449 SQLSaturday 220 B/I 1 - Presented by Slalom 220 5/18/2013 4:45:00 PM 5/18/2013 5:15:00 PM 13449 13449 SQLSaturday 220 B/I 2 - Presented by Tek Systems Room-222 5/18/2013 4:45:00 PM 5/18/2013 5:15:00 PM 13449 13449 SQLSaturday 220 B/I 3 Room-204 5/18/2013 4:45:00 PM 5/18/2013 5:15:00 PM 13449 13449 SQLSaturday 220 Zero Level Room-205 5/18/2013 4:45:00 PM 5/18/2013 5:15:00 PM 13449 13449 SQLSaturday 220 DBA 1 - Presented by SIOS Room-106 5/18/2013 4:45:00 PM 5/18/2013 5:15:00 PM 13449 13449 SQLSaturday 220 DBA 2 - Presented by Precise Room-107 5/18/2013 4:45:00 PM 5/18/2013 5:15:00 PM 13449 13449 SQLSaturday 220 DBA 3 - Presented by Intellinet Room-113 5/18/2013 4:45:00 PM 5/18/2013 5:15:00 PM 13449 13449 SQLSaturday 220 DBA 4 - Presented by Dell Room-216 5/18/2013 4:45:00 PM 5/18/2013 5:15:00 PM 13449 13449 SQLSaturday 220 DBA 5 - Presented by Red Gate Room-213 5/18/2013 4:45:00 PM 5/18/2013 5:15:00 PM 13449 13449 SQLSaturday 220 PowerShell Room-206 5/18/2013 4:45:00 PM 5/18/2013 5:15:00 PM 13449 13449 SQLSaturday 220 DBD 1 - Presented by Idera Room-212 5/18/2013 4:45:00 PM 5/18/2013 5:15:00 PM 13449 13449 SQLSaturday 220 Twelfth Track! Room-210 5/18/2013 4:45:00 PM 5/18/2013 5:15:00 PM 13450 13450 Tim Radney DBA 1 - Presented by SIOS Room-106 It is easy to schedule full backups to run each night, but is that the right decision for your organization? You say you have a backup strategy, but what is your recovery strategy? Do you have a well-executed recovery plan? In this session I will cover several methods for performing much needed backups and how to recover those backups. Full, Differential, File Group, Transaction logs and recovery the tail end of a the log. He will discuss industry best practices and hopefully cause you to validate and test your current strategy. 5/18/2013 9:00:00 AM 5/18/2013 10:00:00 AM 13451 13451 Ed Watson DBA 2 - Presented by Precise Room-107 Every company has a backup strategy. That backup strategy is worthless and will cause your business to fail miserably while losing valuable customer data, protected HIPAA information, and MY social security number. Because of that, Peggy will be bankrupting my credit report. In this session you will learn why backup strategies are for losers, what can I do to keep from being a loser, and how can I build a winning strategy! 5/18/2013 2:30:00 PM 5/18/2013 3:30:00 PM 13459 13459 Thomas LeBlanc Twelfth Track! Room-210 This session will go through some old and new features of Integration Service 2012 to help with loading data into a Data Warehouse/Mart. The GUI has been improved visually during design and execution. The storage of packages has been update with Integration Service Catalogs. The Change Data Capture task helps with incremental updates. Logging has been improved for debugging. A demostration of creating your own Slowly Changing Dimension with current Tasks will be shown with some design hints. 5/18/2013 3:45:00 PM 5/18/2013 4:45:00 PM 13472 13472 Mark Tabladillo B/I 3 Room-204 If you have a SQL Server license (Standard or higher) then you already have the ability to start data mining. In this new presentation, you will see how to scale up data mining from the free Excel 2013 add-in to production use. Aimed at beginning to intermediate data miners, this presentation will show how mining models move from development to production. We will use SQL Server 2012 tools including SSMS, SSIS, and SSDT. 5/18/2013 1:00:00 PM 5/18/2013 2:15:00 PM 13473 13473 Mark Tabladillo B/I 2 - Presented by Tek Systems Room-222 Text mining is projected to dominate data mining, and the reasons are evident: we have more text available than numeric data. Microsoft introduced a new technology to SQL Server 2012 called Semantic Search. This session's detailed description and demos give you important information for the enterprise implementation of Tag Index and Document Similarity Index. The demos include a web-based Silverlight application, and content documents from Wikipedia. We'll also look at strategy tips for how to best leverage the new semantic technology with existing Microsoft data mining. 5/18/2013 3:45:00 PM 5/18/2013 4:45:00 PM 13498 13498 Timothy McAliley DBA 5 - Presented by Red Gate Room-213 In this session, we will start by covering an overview of server and database auditing capabilities of SQL Server 2012. The session will largely focus on the specifics of using the SQL Server Audit feature, and we will step through a demonstration on configuring, maintaining and troubleshooting SQL Server Audit for server and database events. 5/18/2013 9:00:00 AM 5/18/2013 10:00:00 AM 13529 13529 Kevin Boles DBA 2 - Presented by Precise Room-107 Yeah, it has an arcane syntax - but that is why we have templates and snippets! :-P Merge is a very powerful TSQL construct that can both simplify your code and help with some otherwise difficult maneuvers such as the classic 'Upsert'. 5/18/2013 3:45:00 PM 5/18/2013 4:45:00 PM 13530 13530 Kevin Boles DBA 1 - Presented by SIOS Room-106 Spend some time with TheSQLGuru as we learn about and explore the many uses and features of this seldom-used but rather powerful addition to TSQL. It has the ability to allow for elegant set-based solutions to some classes of problems as well as what some consider a clean coding pattern. It also has some nuances that you need to make sure you are aware of as you add this keyword to your TSQL toolbox. 5/18/2013 2:30:00 PM 5/18/2013 3:30:00 PM 13540 13540 Sven Aelterman B/I 1 - Presented by Slalom 220 In SQL Server 2012, the new project deployment model also provides benefits for managing and monitoring your SSIS solutions. This session delves into the SSISDB, the database where your packages and their execution details and results are stored. You’ll learn about the schema of the SSISDB and how to use the provided stored procedures and views to manage your SSIS catalog. 5/18/2013 2:30:00 PM 5/18/2013 3:30:00 PM 13552 13552 Thomas LeBlanc B/I 1 - Presented by Slalom 220 The session explains Attributes and Hierarchies in Analysis Services 2012 Semantic Model. They are used to slice (filter) and dice (group) measures and dimensions used to view analytical data. The slicing and dicing of data involves fields, columns, or whatever you want to labeled them. But, in SQL Server Semantic model these are called Attributes and Hierarchies. The configuration of these slicers and dicers are important in SQL Server Analysis Services. This session will demonstrate the difference between an attribute and columns in a hierarchy in the dimension as well as the configuration of these for best performance and viewing. 5/18/2013 1:00:00 PM 5/18/2013 2:15:00 PM 13587 13587 Melissa Coates B/I 2 - Presented by Tek Systems Room-222 You don't want to settle for being an average Report Developer, right? In this highly interactive session we'll discuss various development, standardization, deployment, and documentation practices that will make your SSRS development life easier, your output of higher quality, increase maintainability, and ultimately save you time. Audience participation and sharing of experiences is encouraged as we cover choices you have for datasets, sorting, grouping, filtering, calculations, parameters, deployment, and delivery. This session focuses primarily on SQL Server Reporting Services 2012, although some concepts may apply to other BI tools as well.  Join us for this this session and take your reporting skills to the next level! 5/18/2013 9:00:00 AM 5/18/2013 10:00:00 AM 13608 13608 Joseph D'Antoni DBA 4 - Presented by Dell Room-216 Back in the old days, compression and databases was a really bad idea. Now, with powerful CPUs we can use to both improve performance and save disk space. We will cover the basics of how all compression and deduplication works, and then we will learn how SQL Server page and row compression work, and the special compression that is used in SQL 2012 Columnstore Indexes. We will demo performance and space savings in using compression. 5/18/2013 10:15:00 AM 5/18/2013 11:30:00 AM 13609 13609 Carlos Rodrigues Twelfth Track! Room-210 you have your star schema beautifully defined. Now what? how can you assure that you physical database design is prepared to receive the amount of data that you are expecting? How can you best utilized your servers, SAN, memory, partitions, SSIS, SSAS, etc? Lets talk about a real case scenario where all of that were applied in order to improve daily process and meet businesses SLA's. 5/18/2013 1:00:00 PM 5/18/2013 2:15:00 PM 13643 13643 Jon Boulineau DBA 3 - Presented by Intellinet Room-113 If you've been writing T-SQL code for a while, but have never delved into what happens after you submit your queries there is a whole world that you are missing. Taking the next step as a T-SQL developer requires understanding the basics of the SQL Server architecture and what it means to use a declarative language. Have you ever wondered why cursors are so slow, why query performance can be unpredictable, or how you can begin to analyze your queries more deeply? In this session we will cover what SQL Server has to do to turn your T-SQL code into the results you expect and how you can use this knowledge to make your code better. 5/18/2013 9:00:00 AM 5/18/2013 10:00:00 AM 13656 13656 Denny Cherry DBA 4 - Presented by Dell Room-216 In this session we will look at the features which are provided with Microsoft SQL Server 2012 as part of the 'AlwaysOn' features including site to site configurations to allow of a large scale high availability solution without the need for any high end SAN storage solution.Additionally we will be looking at the ability to have redundant servers which can be used for reporting or for taking your backups reducing the load from the production database. 5/18/2013 3:45:00 PM 5/18/2013 4:45:00 PM 13657 13657 Denny Cherry DBA 1 - Presented by SIOS Room-106 One of the biggest issues in database performance centers around storage. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as RAID Groups. In addition to theory, we’ll be looking at an actual EMC SAN so that we can translate what we see in the Storage Array with what we see on the actual server. 5/18/2013 1:00:00 PM 5/18/2013 2:15:00 PM 13675 13675 Kevin Kline Zero Level Room-205 Considering a promotion into management? This session will teach you the fundamental skills needed to effectively lead an IT team. Topics include motivational skills, communication skills and project/job tracking skills. Attendees will learn: 1. What are the fundamental ways that a new leader can build credibility and trust with their team? 2. What are the unique ways in which IT people are motivated? 3. How can a leader effectively communicate with their IT team using a variety of communication channels? 4. How steps can a leader take to ensure that their IT team is achieving optimum effectiveness? 5/18/2013 10:15:00 AM 5/18/2013 11:30:00 AM 13694 13694 William E Pearson III B/I 3 Room-204 A Dynamic Dialog session: According to research compiled by Gartner from discussions with many BI clients, a substantial disparity exists, in the implementation of BI, between theory (standard approaches, promises, claims and expectations) and practice (shortfalls, compromises and other realities). In this session, Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog within which we gain an understanding of the general types of discrepancies between the “ideal” approach to BI and the compromised reality that a large number of organizations experience. We’ll then share and class experiences as a group, and discuss ways to avoid these discrepancies in future projects. 5/18/2013 2:30:00 PM 5/18/2013 3:30:00 PM 13720 13720 Eric Peterson DBA 3 - Presented by Intellinet Room-113 A review of higg availability options for SQL Server incliding log shipping, mirroring, clustering and 2012 Always on. The presentation will show all options and give a comparison of each. The majority of the presentation will dive deep into 2012 Always on availability groups. 5/18/2013 1:00:00 PM 5/18/2013 2:15:00 PM 13726 13726 Andy Leonard B/I 2 - Presented by Tek Systems Room-222 Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session. 5/18/2013 1:00:00 PM 5/18/2013 2:15:00 PM 13745 13745 Leo Furlong B/I 2 - Presented by Tek Systems Room-222 With Excel 2013, you can now easily build out a self-service BI solution that tells a complete story of your data. During this session, we will explore new features such as PowerPivot, Power View, Quick Explore, Quick Analysis, Timeline Slicers, and Flash Fill that enable you to rapidly mash-up, explore, analyze, and visualize any data ranging from a few rows to hundreds of millions of rows. 5/18/2013 2:30:00 PM 5/18/2013 3:30:00 PM 13752 13752 Stacia Misner B/I 1 - Presented by Slalom 220 Self-service BI is usually an independent activity. But when individuals discover interesting information that they want to share, they need a centralized location to do that. When people work together, new insights are possible, and that’s what collaboration is all about. As more people see the benefits of the solution, they become more likely to use it. As individual products, SQL Server 2008 R2, SharePoint 2010, and Excel 2010 expand your options for enabling BI in your organization, but collectively they create a solid platform for collaborative BI. Knowing which tool to use for which job can be tricky. Come to this session to learn how to use these tools to foster collaboration. 5/18/2013 11:45:00 AM 5/18/2013 12:45:00 PM 13804 13804 Paul Waters B/I 2 - Presented by Tek Systems Room-222 SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, there are some painful shortcomings that make it difficult to automate package creation, easily reuse patterns and templates, and create packages directly from schema information and other metadata. The free and open source BIDS Helper Add-In offers support for automatically generating SSIS packages using the Business Intelligence Markup Language (Biml). In this session we will start by showing the power of Biml. We will then step back, and start from the beginning of using BimlScript. Once we cover the basics, we will cover practical examples using the BIDS Helper add-in to automate SSIS development. 5/18/2013 10:15:00 AM 5/18/2013 11:30:00 AM 13810 13810 Dan Holmes DBD 1 - Presented by Idera Room-212 Squeezing the last bit of performance out of you application after you have refactored your SQL and tuned your server and indexes can be frustrating. Making it more difficult might be the requirement to keep a single code base for each user and company that can configure your application to work specifically for them. One possible solution is tailoring programmable objects to each user. It will provide SQL specific to the user's needs thereby ensuring they the best possible performance based on their configuration. 5/18/2013 9:00:00 AM 5/18/2013 10:00:00 AM 13839 13839 Ben Miller PowerShell Room-206 Ever wanted to know what happens in SQL Server when you use PowerShell and SMO to manage a SQL Server? How fast can your automation really go? I will take you through the most common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. We will dive deep through the collections that make SMO the powerful tool it is. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come peek behing the curtain and squeeze the speed out of your automation scripts using PowerShell and SMO. You'll be glad you did. 5/18/2013 2:30:00 PM 5/18/2013 3:30:00 PM 13840 13840 Ben Miller DBA 5 - Presented by Red Gate Room-213 Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? This session will go over all the steps and caveats that go with this technology. This is a topic that is an Enterprise Feature, but allows you to have your database encrypted on disk. We will discuss the Encryption Hierarchy as well as how it relates to SQL Server TDE. 5/18/2013 10:15:00 AM 5/18/2013 11:30:00 AM 13863 13863 Mike Walsh Zero Level Room-205 Are you interested in becoming a DBA? Would you consider yourself an accidental DBA? In this talk, Mike Walsh will share some thoughts on the role of DBA - How to become one, What a DBA's priorities should be and what the pros and cons of being one are. He'll look through his 13 years of DBA experience and share some of the lessons he wish he learned before he started out. 5/18/2013 9:00:00 AM 5/18/2013 10:00:00 AM 13889 13889 Steve Busby DBA 4 - Presented by Dell Room-216 This session will provide a technical overview and deep dive into the architecture and features of SQL Server Parallel Data Warehouse 2012, Microsoft's massively scalable data warehousing appliance. 5/18/2013 1:00:00 PM 5/18/2013 2:15:00 PM 13905 13905 Louis Davidson DBA 3 - Presented by Intellinet Room-113 In 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 been 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). 5/18/2013 3:45:00 PM 5/18/2013 4:45:00 PM 13913 13913 Mike Robbins PowerShell Room-206 PowerShell IS where Microsoft is going for the administration of its products. If you’re not actively trying to learn PowerShell today, you’re soon going to be well behind the learning curve of the average IT pro. This session will start from zero and cover the basic fundamentals of PowerShell that will get you started on the right track to becoming a PowerShell Hero. The fundamentals that will be taught in this session are applicable whether you’re a Desktop Admin, Server Admin, SQL Server Admin, Exchange Admin, SharePoint Admin, or even if you’re the Admin of a third party product that supports PowerShell integration such as a SAN Admin. This will be an interactive session full of demos so bring your questions. 5/18/2013 9:00:00 AM 5/18/2013 10:00:00 AM 13935 13935 Ryan Duclos DBA 5 - Presented by Red Gate Room-213 SQL Database is part of the Windows Azure platform: a suite of services providing hosted computing, infrastructure, Web services, Reporting services and data services. The SQL Database component provides the relational database functionality of SQL Server, but it also provides functionality as a cloud-computing service, hosted in Microsoft data-centers around the globe. We will go over how it works and what it has to offer, as well as some of the differences and limitations. ***It is assumed that you have familiarity with SQL Server. 5/18/2013 1:00:00 PM 5/18/2013 2:15:00 PM 13955 13955 Thomas Stringer PowerShell Room-206 Are the number of databases under your responsibility growing and growing? Are you searching for a way to reach across thousands of servers in one fell swoop? Look no further. PowerShell is the tool to handle arduous tasks with simplicity and ease. Through automation and code-reusability your efficiency will be maximized. Now is the time to start using PowerShell. 5/18/2013 10:15:00 AM 5/18/2013 11:30:00 AM 13967 13967 Yelena Pavlyuk B/I 3 Room-204 Report Builder is a free and a powerful tool providing familiar Microsoft Office environment and targeted by Microsoft to business users. See for yourself if you as a developer would like to use this product or convince your power users to give it a try. In this session we'll look at differences between BIDS Report Designer and Report Builder. Then we'll walk through creating some reports to highlight Report Builder features and make a general overview of Report Builder benefits. 5/18/2013 9:00:00 AM 5/18/2013 10:00:00 AM 13973 13973 Stuart Ainsworth DBA 4 - Presented by Dell Room-216 Most database professionals know (from firsthand experience) that there continues to be a 'data explosion', and there's been a lot of focus lately on 'big data'. But what do you do when your data's just kind of 'biggish'? You're managing Terabytes, not Petabytes, and you're trying to squeeze out as much performance out of your aging servers as possible. The focus of this session is to identify some key guidelines for the design, management, and ongoing optimization of 'larger-than-average' databases. Special attention will be paid to the following areas: * query design * logical and physical data structures * maintenance backup strategies 5/18/2013 9:00:00 AM 5/18/2013 10:00:00 AM 13974 13974 Jason Thomas Twelfth Track! Room-210 SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts. This session will explore the functionalities of all the charts as well as some tips and tricks around them. You will also learn to start thinking creatively to make charts that most people think can not be made with SSRS. Come to this session and take your charting skills to the next level. 5/18/2013 2:30:00 PM 5/18/2013 3:30:00 PM 13975 13975 Jason Thomas B/I 1 - Presented by Slalom 220 In this age of big data, location matters more than many people imagine. Almost every set of data has some geographic information tied to it, and it is all the more pertinent to understand and unravel the patterns and trends behind them. This session will start by explaining why GeoSpatial analytics is important in today's world and then continue by exploring how we can share, analyze, and visualize data using the comprehensive Microsoft BI toolset, including Power View, GeoFlow, SQL Server Reporting Services, and more. The session will also feature practical demos for each of these tools, during which we will work on some of the publicly available datasets to uncover some interesting facts. 5/18/2013 10:15:00 AM 5/18/2013 11:30:00 AM 13976 13976 Tamera Clark DBA 3 - Presented by Intellinet Room-113 Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2008 R2 and go interstellar with some space data! 5/18/2013 2:30:00 PM 5/18/2013 3:30:00 PM 13980 13980 Jim Christopher PowerShell Room-206 PSake is a PowerShell module that helps you work with a tree of interdependent tasks. Originally designed for software builds, the simple workflow-as-tasks model lends itself to solving many other complex problems, such as VM provisioning, database setup and migration, even installing software. In this session we will explore the PSake module, specifically learning how we can use the module to make small work out of a versioned SQL database migration. You will learn how to translate a complex problem into a set of reusable and interrelated tasks, how to make your tasks discoverable, and how to manage large numbers of tasks in your workflow. 5/18/2013 1:00:00 PM 5/18/2013 2:15:00 PM 13984 13984 Pam Shaw B/I 1 - Presented by Slalom 220 In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create. 5/18/2013 9:00:00 AM 5/18/2013 10:00:00 AM 13986 13986 Robert Cain Zero Level Room-205 Business Intelligence is one of the hottest job skills in the IT field. DBAs and Database Developers are being asked to implement databases with non-traditional design, and are having a lot of new vocabulary thrown their way. In this talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean. 5/18/2013 3:45:00 PM 5/18/2013 4:45:00 PM 13990 13990 Robert Cain Twelfth Track! Room-210 PowerPivot is an exciting new technology from Microsoft that will allow users to leverage their data to answer many of their business questions. Commonly referred to as 'Self Service Business Intelligence', PowerPivot consists of two components, PowerPivot for Excel 2010/2013 and PowerPivot for SharePoint 2010/2013. This presentation will provide an overview of both components then dig deeper into PowerPivot for Excel 2013. Multiple demos illustrate everything from importing data to creating pivot tables and charts, as well as using techniques such as filters and calculated columns. 5/18/2013 9:00:00 AM 5/18/2013 10:00:00 AM 13992 13992 Bobby Dimmick B/I 2 - Presented by Tek Systems Room-222 Some say that the first step is the hardest.. Sometimes it's the second step that truly knocks us off-balance. Join us in a discussion of taking that next step in your career. Learn about finding your passion, preparing the way, building your resume, and the people who can help along the way.. 5/18/2013 11:45:00 AM 5/18/2013 12:45:00 PM 13993 13993 Julie Smith B/I 1 - Presented by Slalom 220 Matching is the identification of rows which are likely duplicates and is the less well known feature of Data Quality Services. Join me in showing Matching some love. We'll go over the creation of matching rules, how to use the rules with matching activity projects and also work a bit with Master Data Services and the Excel add ins for MDS and DQS. 5/18/2013 3:45:00 PM 5/18/2013 4:45:00 PM 13995 13995 Audrey Hammonds Zero Level Room-205 Interested in understanding the basics of database design? This session is for you! We’ll cover some tried and true rules to follow when designing a new database, as well as how to examine an existing database from a design perspective. By the end of the session, you should be ready to get back to work and tackle any design challenge. 5/18/2013 2:30:00 PM 5/18/2013 3:30:00 PM 14000 14000 Javier Guillen DBD 1 - Presented by Idera Room-212 Data Analysis Expressions (DAX) is an the expression language of PowerPivot and Analysis Services Tabular models. Its power lies on the ability to create aggregations that are evaluated at different contexts over in-memory data. This session will explore the most challenging DAX topic: formula context. A brief comparison with MDX will be established in order to contrast the process followed by each language when establishing the context of a calculation. Attendees will gain a better understanding of how to leverage context manipulation expressions to create powerful business calculations. 5/18/2013 2:30:00 PM 5/18/2013 3:30:00 PM 14002 14002 Adam Machanic DBA 2 - Presented by Precise Room-107 Ever open a huge query plan to track down a performance issue and find yourself overwhelmed by the number of objects on the screen? How do you figure out which part of the plan is causing the problem? What should you do about it? The vast majority of query plan troubles boil down to the same basic causes; solving them is simply a matter of knowing where to look. In this session you will learn how to open a plan and drill in to the most likely problem areas. Once there, a simple analysis of five key indicators will help you diagnose your performance problem faster than you thought possible. Say goodbye to guesswork and game playing. This session will teach you how easy it can be to apply a bit of logic to improve performance of your queries. 5/18/2013 10:15:00 AM 5/18/2013 11:30:00 AM 14002 14002 Adam Machanic DBA 2 - Presented by Precise Room-107 Ever open a huge query plan to track down a performance issue and find yourself overwhelmed by the number of objects on the screen? How do you figure out which part of the plan is causing the problem? What should you do about it? The vast majority of query plan troubles boil down to the same basic causes; solving them is simply a matter of knowing where to look. In this session you will learn how to open a plan and drill in to the most likely problem areas. Once there, a simple analysis of five key indicators will help you diagnose your performance problem faster than you thought possible. Say goodbye to guesswork and game playing. This session will teach you how easy it can be to apply a bit of logic to improve performance of your queries. 5/18/2013 1:00:00 PM 5/18/2013 2:15:00 PM 14004 14004 Richie Rump DBA 4 - Presented by Dell Room-216 With the introduction of SQL Server 2012 data developers have new ways to interact with their databases. This session will review the powerful new analytic windows functions, new ways to generate numeric sequences and new ways to page the results of our queries. Other features that will be discussed are improvements in error handling and new parsing and concatenating features. 5/18/2013 2:30:00 PM 5/18/2013 3:30:00 PM 14007 14007 Aaron Nelson DBA 3 - Presented by Intellinet Room-113 SQL Server Data Tools is an evolving product. Besides revamping database projects this product has also changed the lifecycle in which we receive new features. In this session we will demonstrate features such as database snapshots, localdb, and database unit testing. Most importantly we’ll show the many benefits of the Publish feature, and why you will want to use the built-in refactoring instead of just renaming objects. Throughout this presentation we will also highlight and demonstrate the features that have been added to SSDT in the past year. 5/18/2013 10:15:00 AM 5/18/2013 11:30:00 AM 14011 14011 Tim Radney DBD 1 - Presented by Idera Room-212 You have recently inherited the support of a new or existing database, what are the things you should immediately check and start monitoring and what are the things that you should address over the next few weeks. When taking over support of a database or system, you cannot ASSUME anything. At the end of this session you will have a nice checklist of things you should check and be doing on ALL your databases not just the one you inherited. Whether you are a seasoned DBA or just starting out, this session should be informative and something you can relate to. 5/18/2013 1:00:00 PM 5/18/2013 2:15:00 PM 14016 14016 Geoff Hiten Zero Level Room-205 IT jobs are notoriously short-lived, with most only lasting a few years. Very few people keep a single employer for their entire career. Knowing when, why, and how to leave your job is as important a career step as finding new work. Learn about how to use job transitions as opportunities to develop your career. 5/18/2013 1:00:00 PM 5/18/2013 2:15:00 PM 14278 14278 Chris Skorlinski DBD 1 - Presented by Idera Room-212 Encountered odd problem with SQL Server, something you've not seen before and thinking about calling Microsoft SQL Support? What do you need to collect before you call? How can you make the call a collaborative effort and not an 'enhanced phone interrogation'. 5/18/2013 10:15:00 AM 5/18/2013 11:30:00 AM 14318 14318 Stacia Misner B/I 3 Room-204 There are lots of ways to optimize your Analysis Services environment, but tuning the server or improving the database design doesn't help if your MDX queries are not efficient. Learn how to determine whether a query is the root cause of your performance issues and how to use MDX best practices to improve query performance. 5/18/2013 3:45:00 PM 5/18/2013 4:45:00 PM 14350 14350 David Klee DBA 2 - Presented by Precise Room-107 Sure, your SQL Server is up and running. Anyone can click through a SQL Server install nowadays. But... is it running at its peak potential? Do you have your VMware environment configured properly? Have you measured the performance lately? Your business-critical SQL Server performance does not have to suffer just because it was virtualized. Very specific VMware and SQL Server tuning tips and tricks from David Klee (@kleegeek) will be presented in this session. 5/18/2013 9:00:00 AM 5/18/2013 10:00:00 AM 14368 14368 Eddie Wuerch DBA 1 - Presented by SIOS Room-106 Latching is a necessary function of the database engine. Although latching is a topic is normally presented only in expert-level sessions, a good grasp of the problems excessive latching exposes is important even for novice tuners. This session focuses on the PAGELATCH_* and PAGEIOLATCH_* wait types, explaining what is happening, why it is happening, and how to use the exposed information to tune queries and solve performance problems. If you've seen these wait types in Activity Monitor and wonder what they meant, then this session is for you! 5/18/2013 10:15:00 AM 5/18/2013 11:30:00 AM 14524 14524 Wes Brown DBD 1 - Presented by Idera Room-212 In this talk we will look at squeezing the maximum out of your storage systems. We will work on a live system testing concepts like short-stroking for performance. We will also show how some of these techniques are still valid on systems with SSD’s in the mix. We will cover some basics you need to know then dive into configuring local disk systems and how to test them to measure the gains or loses. This session is geared to the DBA who has a working knowledge of storage and how SQL Server works with the file system. Takeaways: 1. How to configure spinning disk for maximum IO or maximum throughput 2. How to keep your SSD’s from suffering the write cliff and keep performance strong 3. Using the DVD Store 2 benchmark to test with SQL Server installed 4. Using ioMeter to test disks directly 5/18/2013 3:45:00 PM 5/18/2013 4:45:00 PM 14611 14611 Jonathan Walz PowerShell Room-206 Do you listen to podcasts? It's like the radio, but more Internetty. Well, Atlanta just so happens to be the home to the two co-hosts of the PowerScripting Podcast, the first podcast devoted to talking about Windows PowerShell. We have news, interviews, tips and resources that we present every week at powerscripting.net, but this time, the show is coming to you live! We'll come prepared to hit most any general PowerShell topic you want, and we'll probably sneak some SQL + PowerShell experts on stage to help out. This won't be a canned lecture, it will be more of a Birds of a Feather or talk show feel. Audience participation is REQUIRED! 5/18/2013 3:45:00 PM 5/18/2013 4:45:00 PM 14924 14924 Blank Blank DBA 5 - Presented by Red Gate Room-213 Blank 5/18/2013 2:30:00 PM 5/18/2013 3:30:00 PM 14924 14924 Blank Blank DBA 5 - Presented by Red Gate Room-213 Blank 5/18/2013 3:45:00 PM 5/18/2013 4:45:00 PM 14925 14925 Teo Lachev B/I 3 Room-204 Learn best practices to make your organization a center of BI excellence! I’ll walk you through lessons learned during our implementation of an enterprise end-to-end BI solution, which is discussed in the Records Management Firm Saves $1 Million, Gains Faster Data Access with Microsoft BI case study published by Microsoft. Working experience with the dimensional modeling and the Microsoft BI stack is assumed. 5/18/2013 10:15:00 AM 5/18/2013 11:30:00 AM 15355 15355 Jennifer McCown DBA 1 - Presented by SIOS Room-106 Have you checked the databases lately? It could be that you’re new on the job, or you’ve inherited a set of servers from another team. Maybe things have just been busy lately. Any which way, you’ve got a SQL Server instance (or five) that may have issues, may have backups, may have maintenance…or not. How do you start getting to know an instance? We’ll go over scripts and methods to gather and prioritize important information about your server, so you don’t have to be afraid when the server calls. 5/18/2013 3:45:00 PM 5/18/2013 4:45:00 PM 15396 15396 Louis Davidson DBA 5 - Presented by Red Gate Room-213 Louis Davidson, Microsoft MVP, discusses how being observant of the environment you work in can help you make sure that you are aware of the health of your database systems, as well as your career. 5/18/2013 11:45:00 AM 5/18/2013 12:45:00 PM 15441 15441 Dave Bermingham and Vin Prasad DBA 1 - Presented by SIOS Room-106 Powered by Fusion-io, Protected by SIOS: Learn how to eliminate the bottlenecks and costs of SAN-based clustering. Leverage the performance of high-speed Fusion ioMemory and achieve higher levels of availability with SIOS. It is the best of both worlds - performance and protection – at a price you can afford. Join us and you could win a $100 American Express gift card. 5/18/2013 11:45:00 AM 5/18/2013 12:45:00 PM 15512 15512 Ed Wyatt DBA 3 - Presented by Intellinet Room-113 Join us during this lunch session for a discussion around improving team management. We will cover topics such as employee skills and alignment within the organizations structure, work management, communications, and more! 5/18/2013 11:45:00 AM 5/18/2013 12:45:00 PM 15615 15615 Andy Leonard Twelfth Track! Room-210 Integration Services 2012 offers a brand new way to store, log, and execute SSIS packages – the SSIS Catalog. How does the Catalog work? Can it be customized? Can it be extended? Yes it can! In this presentation, Andy Leonard shows you how! 5/18/2013 10:15:00 AM 5/18/2013 11:30:00 AM