SQLSaturday #241 - Cleveland 20142/8/2014 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. #sqlsat241Hyland Software - Building 128500 Clemens Rd.WestlakeOH441453391Hyland SoftwarePlatinum Sponsorhttp://www.hyland.comhttp://www.sqlsaturday.com/files/ee969ae0-5be7-43a9-8089-d195b0059d82.png601704113Confio SoftwareGold Sponsorhttp://www.confio.comhttp://www.sqlsaturday.com/files/64352f9b-8668-434b-8f85-4d431b1b016d.png601704115SQL SentryGold Sponsorhttp://www.sqlsentry.nethttp://www.sqlsentry.net/images/ext/SQLSentryLogo148.jpg601704173IderaGold Sponsorhttp://www.idera.comhttp://www.idera.com/campaign_images/logo_Idera_tag_170x60.png601704188TMW SystemsGold Sponsorhttp://www.tmwsystems.comhttp://www.sqlsaturday.com/files/ab78cb72-6ed4-49bf-929c-685b3d51976c.png601704204DigineerGold Sponsorhttp://www.digineer.comhttp://minnesota.sqlpass.org/Portals/70/digineer_Logo.jpg601704242Dell SoftwareGold Sponsorhttp://software.dell.com/platforms/sql-server/http://i.imgur.com/2Faa7ba.jpg601704256Tegile SystemsGold Sponsorhttp://www.tegile.comhttp://www.sqlsaturday.com/files/1459eb3a-a358-40e0-b4d6-3bd6027a347a.jpg601704328MicrosoftGold Sponsorwww.microsoft.com/sqlserverhttp://www.sqlsaturday.com/files/b9ecb68b-15ec-4f9a-a8df-2649b7e0bbaf.png601704345BlueGraniteSilver Sponsorwww.blue-granite.comhttp://cdn2.hubspot.net/hub/257922/file-313503022-png/images/bluegranite170x60.png601704306UpSearchSilver Sponsorhttp://upsearch.com/functional-practices/microsoft-sql-server/http://upsearch.com/wp-content/uploads/2014/01/sqlSat_170x60.png601704264Red GateSilver Sponsorhttp://rd.gt/1d9Mt1rhttp://www.red-gate.com/assets/images/common/logo.png601704284Pyramid AnalyticsSilver Sponsorhttp://www.pyramidanalytics.comhttp://www.pyramidanalytics.com/wp-content/uploads/2013/11/pyramid-analytics-logo-color-cropped.jpg601704190RDXSilver Sponsorhttp://www.rdx.comhttp://i44.tinypic.com/2d8iedg.jpg601704198PASSSilver Sponsorhttp://sqlpass.orghttp://orlando.sqlpass.org/portals/265/PASS%20Images/PASSLogoBW.jpg601704091Oxford AssociatesSilver Sponsorhttp://www.oxfordcorp.com/http://oadistribution.com/filehosting/2013/oxford/CustomLogo170x60px-color.jpg601704092O'ReillySilver Sponsorhttp://oreilly.comhttp://oreilly.com/images/orn_logos/oralogo_bk200.gif601703817Akron Canton AITPBronze Sponsorhttp://www.akron-aitp.orghttp://www.akron-aitp.org/images/aitp_sqlsaturday.jpg601704007COZYROCBronze Sponsorhttp://www.cozyroc.comhttp://cozyroc.com/sites/default/files/down/cozyroc-big.png601704287EmbarcaderoBronze Sponsorhttp://www.embarcadero.com/http://www.sqlsaturday.com/files/818071ec-6c41-43fc-a981-b30c34f61c9a.JPG601704255VarigenceBronze Sponsorhttps://www.varigence.comhttps://varigencecom.blob.core.windows.net/blogimage-d61ad1c2-4400-4283-a5d8-328c6bd02c29/VarigenceFullLogo.png601704233ApexSQL LLC Bronze Sponsorhttp://www.apexsql.com/http://www.apexsql.com/images/ApexSQL_Logo_170x60-01.jpg601704346KforceBronze Sponsorhttp://www.kforce.comhttp://www.sqlsaturday.com/files/b1d63f6a-4f81-4834-81a8-10910687b4c9.jpg601704347CLV CreationsBronze Sponsorhttp://www.clvcreations.net/http://www.sqlsaturday.com/files/74c6ebf7-4a5a-4741-b0ac-283bdd7fae45.png6017018414Adam BelebczukAdam Belebczuk is a Developer, Analyst, and Accidental DBA that works for a software company in Cleveland, Ohio. Adam is an MCSE: Data Platform, MCITP DBA 2005/2008, and belongs to the Ohio North SQL Server User Group Professional Association for SQL Server (PASS). In addition to all things technological, he also loves to make electronic music, cook, go skiing, read, help educate his fellow geeks whenever the opportunity presents itself.@SQLDiablohttp://www.linkedin.com/in/itacbhttp://www.SQLDiablo.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLDiablo484818845Allen WhiteAllen is a Practice Leader for Upsearch in Northeast Ohio. Allen has spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last seven years. He's President of the Ohio North SQL Server User's Group and maintains a blog at http://sqlblog.com/blogs/allen_white/default.aspx.@SQLRunrhttp://www.linkedin.com/profile/view?id=16846136locale=en_UStrk=tab_prohttp://www.upsearch.com/sqlhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLRunr484816092Argenis FernandezArgenis Fernandez is a Database Monkey for SurveyMonkey. He has worked with SQL Server for over 15 years and enjoys large SQL Server farms, high-end OLTP databases, managing Windows environments, performance troubleshooting, high availability, disaster recovery, best practices, and PowerShell scripting. Argenis is also a Microsoft Certified Master on SQL Server 2008, an avid Twitter user (you can follow him at @DBArgenis), and occasional blogger on SQL Server topics at SQLBlog.com.@DBArgeniswww.linkedin.com/in/argenishttp://www.sqlblog.com/blogs/argenis_fernandez/https://api.twitter.com/1/users/profile_image?screen_name=@DBArgenis484819041Ben MillerBen has been a member of the SQL Server Community for over 14 years now. He is currently a Director of Databases at Natures Sunshine Products in Lehi Utah. He is a SQL Server MVP and a SQL Server 2008 MCM 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. @dbaduckhttp://www.linkedin.com/in/dbaduckhttp://dbaduck.comhttps://api.twitter.com/1/users/profile_image?screen_name=@dbaduck484817746Brandon LeachBrandon is a veteran of IT in the healthcare industry. Originally starting out his career as a web developer, he fell in love with SQL Server and database development and administration. Currently he manages 89+ SQL Servers for Network Health in Medford, Ma. He works closely with the development and infrastructure teams as well as management in and out of IT to make sure the needs of the business and its future goals are met. He is also the Chief organizer for SQLSaturday Providence, RI SQLServerNerdhttps://www.linkedin.com/in/brandonleachhttps://api.twitter.com/1/users/profile_image?screen_name=SQLServerNerd484819122Brian DavisBrian Davis is a SQL Server Consultant with UpSearch and has over 14 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands on experience with SQL Server 2000/2005/2008/2008R2/2012. Brian is also an active member and leader of the Ohio North SQL Server User Group. @Brian78http://www.linkedin.com/in/briandavis78/https://api.twitter.com/1/users/profile_image?screen_name=@Brian78484818842Colleen MorrowColleen Morrow is a Database Engineer for a software company in Westlake, OH. She has worked in the IT industry for 15+ years, doing everything from technical support to development to database administration on Informix, Oracle, and SQL Server platforms. @ClevelandDBAhttp://www.linkedin.com/pub/colleen-morrow/2a/95a/651http://colleenmorrow.comhttps://api.twitter.com/1/users/profile_image?screen_name=@ClevelandDBA484818299Cory StevensonCory Stevenson is a Business Intelligence Consultant with BlueGranite, Inc. With over 8 years of experience in IT, his interests include Integration Services, Reporting Services, PowerShell, coffee, and keeping up with the latest Microsoft BI features.You can follow Cory on Twitter @CoryGStevenson.@CoryGStevensonhttp://www.linkedin.com/in/corygshttps://api.twitter.com/1/users/profile_image?screen_name=@CoryGStevenson484819166Craig PurnellCraig Purnell is a career database professional, trainer, and community activist. He has spent over 10 years as the Database Administrator at a large Midwestern law firm. He has been in IT for 14 years and has spent his entire career working with enterprise databases and ERP systems. Craig is an active member of the Ohio North SQL Server User Group and has presented at many user groups, SQL Saturdays, and the PASS Summit in 2012.@CraigPurnellhttp://www.linkedin.com/pub/craig-purnell/14/665/9a7http://www.craigpurnell.comhttps://api.twitter.com/1/users/profile_image?screen_name=@CraigPurnell484817180David MaxwellDavid Maxwell has over 10 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has had experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. His occasional writings can be found at http://dmmaxwell.wordpress.com/@dmmaxwellhttp://www.linkedin.com/pub/david-maxwell/70/a20/b6/http://dmmaxwell.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@dmmaxwell484819739Erin StellatoErin Stellato is a Senior Consultant with SQLskills and lives in Cleveland, OH. She has over 13 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery.
Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.@erinstellatohttp://www.LinkedIn.com/in/erinstellatohttp://www.sqlskills.com/blogs/erinhttps://api.twitter.com/1/users/profile_image?screen_name=@erinstellato484819025Grant FritcheyGrant Fritchey is a SQL Server MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. He joined Red Gate Software as a Product Evangelist in January 2011.@gfritcheyhttp://www.linkedin.com/in/scarydbahttp://www.scarydba.comhttps://api.twitter.com/1/users/profile_image?screen_name=@gfritchey484819127Hope FoleyHope Foley, a SQL Server MVP with over 13 years of experience in the IT world, has worked across many industries. She recently joined team at BlueGranite as a Business Intelligence consultant. She has been a consultant in SQL Server technologies for over 6 years focusing on database administration and architecture. Hope is an active member in the SQL Server and PASS communities speaking at events and organizing the SQLSaturday event in Indianapolis. @hope_foleywww.linkedin.com/in/hopefoley/http://www.hopefoley.comhttps://api.twitter.com/1/users/profile_image?screen_name=@hope_foley484819154Jeff MlakarJeff Mlakar is a native Clevelander, a passionate and inquisitive SQL designer. Educated at the University of Michigan (pause for ‘boo’s from local crowd), Jeff has spent the last decade working heavily in Microsoft’s BI stack. He currently works as an Enterprise Architect on the BI team at the consulting firm of Bennett Adelson.@JeffMlakarhttps://www.linkedin.com/pub/jeff-mlakar/8/10a/a4ahttp://jeffmlakar.wordpress.com/about/https://api.twitter.com/1/users/profile_image?screen_name=@JeffMlakar484818152Jeff ModenSQL Server MVP Jeff Moden is a long time member of and one of the leading posters on SQLServercentral.com. He has logged nearly 30,000 posts (as he says, some are actually useful! ;-) ) and has written nearly 30 mostly five star articles for the site. Jeff's ability to teach complex SQL “Black Arts” methods (such as the Tally Table and it's uses) using simple techniques have earned him worldwide acclaim.http://www.linkedin.com/pub/jeff-moden/6/b90/344484818742Joseph D'AntoniJoey D'Antoni is an Architect with over a decade of experience working in both Fortune 500 and smaller firms. He is currently solutions architect for SQL Server and Big Data for Anexinet in Blue Bell, PA. He holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University. He is a frequent speaker at events such as PASS Summit and TechEd.@jdantonhttp://joedantoni.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jdanton484818743Joseph D'AntoniJoey 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.
@jdantonhttp://joedantoni.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jdanton484819007Julie SmithJulie Smith has spent the last 13 years bending data using varied tools, mostly SQL Server 2000-2012. She is an MCTS in SQL Server 2008 BI and a SQL Server MVP. A Business Intelligence Consultant at Innovative Architects in Atlanta, GA, she remains a 'very simple woman with warm secret heart.'@juliechixhttp://www.linkedin.com/in/juliesmith0503http://datachix.comhttps://api.twitter.com/1/users/profile_image?screen_name=@juliechix484815491Kathi KellenbergerKathi Kellenberger is a Sr. Consultant with Pragmatic Works. She the author or co-author of 'Beginning T-SQL 2008', 'Beginning T-SQL 2012', 'Professional SQL Server 2005 Integration Sevices' and 'SQL Server MVP Deep Dives'. When not working, teaching or writing about SQL Server, you will find her at the local Karaoke bar.@auntkathihttp://www.linkedin.com/profile/view?id=1216685trk=tab_prohttp://www.bidn.com/blogs/kathiKellenberger/https://api.twitter.com/1/users/profile_image?screen_name=@auntkathi484819168Kendal Van DykeKendal Van Dyke is a practiced IT professional with over a decade of experience in SQL Server development and administration. Kendal is currently a Principal Consultant with UpSearch SQL, where he helps companies keep their SQL Servers running in high gear. Kendal is also a Microsoft MVP for SQL Server and President of the PASS chapter MagicPASS in Orlando.@SQLDBAhttp://www.linkedin.com/in/kendalvandykehttp://www.kendalvandyke.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLDBA484819169Kendal Van DykeKendal Van Dyke is a practiced IT professional with over a decade of experience in SQL Server development and administration. Kendal is currently a Principal Consultant with UpSearch SQL, where he helps companies keep their SQL Servers running in high gear. Kendal is also a Microsoft MVP for SQL Server and President of the PASS chapter MagicPASS in Orlando.@SQLDBAhttp://www.linkedin.com/in/kendalvandykehttp://www.kendalvandyke.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLDBA484819121Kerry TylerKerry Tyler started his SQL Server career when he debuted as an accidental DBA in 2005. It wasn't all bad, as he had been hoping for such an opportunity. Seeing Reporting Services 2005 demoed for the first time sealed the deal, and it has been all data ever since, leaving the worlds of networking and system admin behind. After being a full-time dev/operational DBA with everything since SQL 2000, Kerry is now back to BI, as a Senior BI Engineer with Aptera Software, Inc in Nashville, Tennessee.@AirborneGeekhttp://www.linkedin.com/in/kerrytylerhttp://airbornegeek.comhttps://api.twitter.com/1/users/profile_image?screen_name=@AirborneGeek484818532Kevin BolesKevin is a SQL Server expert, working exclusively with the product since v6.5. With over 20 years of database experience and 40000+ man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin teaches occasionally and has been a very successful independent consultant for over 15 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.@TheSQLGuruhttp://www.linkedin.com/in/thesqlguruhttps://api.twitter.com/1/users/profile_image?screen_name=@TheSQLGuru484819093Konstantin MelamudKonstantin Melamud is a Manager of SQL Server Performance and Tuning for Remote DBA Experts. He works with over 200 customers on solutions within the SQL Server environment and leads code tuning team within Remote DBA experts. He is passionate about educating users on SQL Server by speaking at user groups, conferences, and labs.@kmelamudhttps://api.twitter.com/1/users/profile_image?screen_name=@kmelamud484818057Lisa GardnerLisa Gardner is a Premier Field Engineer for Microsoft. Her areas of expertise are performance tuning and high availability and has worked with SQL Server since version 6.5. She is also a lifelong central Ohio resident, mother, and amateur winemaker.@SQLGardnerhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLGardner484819115Mark VaillancourtMark is an Information Management consultant for Digineer, a Microsoft partner based in Plymouth, MN. He has been working with SQL Server since 2007 and holds the MCITP – Business Intelligence Developer 2008 certification. With a background in Theater and Improvised Comedy, Mark makes sure that his presentations are both informative and fun.@markvsqlhttp://www.linkedin.com/pub/mark-vaillancourt/8/a24/667/http://www.markvsql.comhttps://api.twitter.com/1/users/profile_image?screen_name=@markvsql484819116Mark VaillancourtMark is an Information Management consultant for Digineer, a Microsoft partner based in Plymouth, MN. He has been working with SQL Server since 2007 and holds the MCITP – Business Intelligence Developer 2008 certification. With a background in Theater and Improvised Comedy, Mark makes sure that his presentations are both informative and fun.@markvsqlhttp://www.linkedin.com/pub/mark-vaillancourt/8/a24/667/http://www.markvsql.comhttps://api.twitter.com/1/users/profile_image?screen_name=@markvsql484818133Mindy CurnuttMindy Curnutt is currently the Director of Database Architecture for TMW Systems, supporting nearly 2,000 customers using SQL Server. At Unisys from 2000-2007, she focused on VLDBs, scalability, performance, DR/HA , migration, and training. Recently, she wrote the log shipping chapter in the MS Press book “SQL Server 2012 – Step by Step' and served as a Subject Matter Expert for Microsoft SQL Server cert exams. Mindy has been a presenter at the SQL PASS Summit in 2005, 2006, 2012 and 2013.@sqlgirlhttp://www.linkedin.com/in/mindycurnutthttps://api.twitter.com/1/users/profile_image?screen_name=@sqlgirl484819134Paul HilesPaul has over 20 years of experience in the IT field which includes: programmer, system administrator, technical manger and both an operational and application DBA. He has been working with SQL Server since 2000 starting with version 7.0. He specializes in automation, and high availability, and performance troubleshooting and tuning.@PaulGHileshttp://www.linkedin.com/in/paulghileshttps://api.twitter.com/1/users/profile_image?screen_name=@PaulGHiles484815280Sam NasrSam Nasr has been a software developer since 1995, focusing mostly on Microsoft technologies. Having achieved multiple certifications from Microsoft (MCAD, MCTS(MOSS), and MCT), Sam develops, teaches, and tours the country to present various topics in .Net Framework. He is also actively involved with the Cleveland C#/VB.Net User Group, where he has been the group leader since 2003. In addition, he also started the Cleveland WPF Users Group and the Cleveland .Net Study Group.@SamNasrhttp://www.linkedin.com/in/samsnasr http://clevelanddotnet.blogspot.com/https://api.twitter.com/1/users/profile_image?screen_name=@SamNasr484818780Stacia MisnerStacia 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.@StaciaMisnerhttp://www.linkedin.com/in/staciamisner http://blog.datainspirations.comhttps://api.twitter.com/1/users/profile_image?screen_name=@StaciaMisner484818781Stacia MisnerStacia 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.@StaciaMisnerhttp://www.linkedin.com/in/staciamisner http://blog.datainspirations.comhttps://api.twitter.com/1/users/profile_image?screen_name=@StaciaMisner484817961Steve HoodI have been working with SQL Server since 2000, but never in an environment that threw me deep into the internals of SQL Server until 2010. Now I'm starting to get obsessed with taking what I learned in the last couple of years and throwing that information out there. It should be noted that I'm presenting to specific person in everything I do... the 2008 or earlier version of me. If I knew what I know now 10 years ago, my career would have been very different.@SimpleSQLServerhttp://www.linkedin.com/pub/steve-hood/15/2a1/84bhttp://SimpleSQLServer.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SimpleSQLServer484818906Steve JonesSteve Jones has been working with SQL Server since 1991 and been a DBA in a variety of large and small companies and industries. In 2001 Steve founded SQLServerCentral with two partners and has been publishing technical articles and facilitating discussions among SQL Server professionals ever since. He currently is the full time editor of SQLServerCentral, owned by Red Gate Software.@way0utwesthttp://www.linkedin.com/way0utwesthttp://www.voiceofthedba.comhttps://api.twitter.com/1/users/profile_image?screen_name=@way0utwest484818907Steve JonesSteve Jones has been working with SQL Server since 1991 and been a DBA in a variety of large and small companies and industries. In 2001 Steve founded SQLServerCentral with two partners and has been publishing technical articles and facilitating discussions among SQL Server professionals ever since. He currently is the full time editor of SQLServerCentral, owned by Red Gate Software.@way0utwesthttp://www.linkedin.com/way0utwesthttp://www.voiceofthedba.comhttps://api.twitter.com/1/users/profile_image?screen_name=@way0utwest484819163Tamera ClarkTamera 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 Women in Technology, Regional Mentor for Mid Atlantic, and apart of Nashville leadership team. Tamera is currently a Database Engineer in the Nashville, TN.@tameraclarkwww.linkedin.com/in/tameraclark/http://tameraclark.comhttps://api.twitter.com/1/users/profile_image?screen_name=@tameraclark484819035Thomas 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 MCM and 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).@SQLRockstarhttp://www.linkedin.com/in/sqlrockstarhttp://thomaslarock.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLRockstar484818561Thomas LaRockThomas LaRock is a Microsoft Certified Master, a SQL Server MVP, a VMWare vExpert, and a Microsoft Certified Trainer with over 15 years experience in the IT industry in various roles such as programmer, developer, analyst, and database administrator. He is also the author of 'DBA Survivor: Become a Rock Star DBA' and has participated in the technical review of several other books.
Currently, Thomas is a Technical Evangelist for Confio Software. @SQLRockstarhttp://www.linkedin.com/in/sqlrockstarhttp://thomaslarock.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLRockstar484819009Tim ChapmanTim Chapman is a Microsoft Certified Master (MCM) and works as a dedicated field engineer (PFE) at Microsoft specializing in performance tuning and high availability. Originally from Louisville, KY Tim now resides in Chapel Hill, NC. Tim has over 12 years of database architecture, programming, and administration experience. @chapmandewhttp://www.linkedin.com/pub/tim-chapman/5/242/896https://api.twitter.com/1/users/profile_image?screen_name=@chapmandew484819268Tim RadneyLead 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.@tradneytradneyhttp://www.timradney.comhttps://api.twitter.com/1/users/profile_image?screen_name=@tradney484819269Tim RadneyLead 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.@tradneytradneyhttp://www.timradney.comhttps://api.twitter.com/1/users/profile_image?screen_name=@tradney484819802Wendy PastrickWendy is an active member of the PASS organization, serving on the Board of Directors and involved in the Women In Technology Chapter, as well as being an organizer for SQL Saturday in Chicago. She has been a DBA for 10+ years, primarily working with development teams and support of the application lifecycle. Working with SQL versions 7.0 to 2012 she has gained experience with migrations and upgrades which included support for transactional replication setup and monitoring. @wendy_dancehttp://www.linkedin.com/in/wendypastrickhttp://wendyverse.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=@wendy_dance48481518815188SQLSaturday 241 AuditoriumAuditoriumRegistration Opens (Front Entrance)Please remember to bring your SpeedPass with you, and head to the main reception area at the front of the building to check-in at registration. Once you've checked-in, feel free to head to the Diner for refreshments and a light breakfast, and then meet us in the Atrium for the opening remarks.2/8/2014 7:30:00 AM2/8/2014 8:00:00 AM1518815188SQLSaturday 241Training 3Training 3Registration Opens (Front Entrance)Please remember to bring your SpeedPass with you, and head to the main reception area at the front of the building to check-in at registration. Once you've checked-in, feel free to head to the Diner for refreshments and a light breakfast, and then meet us in the Atrium for the opening remarks.2/8/2014 7:30:00 AM2/8/2014 8:00:00 AM1518815188SQLSaturday 241Training 6Training 6Registration Opens (Front Entrance)Please remember to bring your SpeedPass with you, and head to the main reception area at the front of the building to check-in at registration. Once you've checked-in, feel free to head to the Diner for refreshments and a light breakfast, and then meet us in the Atrium for the opening remarks.2/8/2014 7:30:00 AM2/8/2014 8:00:00 AM1518815188SQLSaturday 241Training 2Training 2Registration Opens (Front Entrance)Please remember to bring your SpeedPass with you, and head to the main reception area at the front of the building to check-in at registration. Once you've checked-in, feel free to head to the Diner for refreshments and a light breakfast, and then meet us in the Atrium for the opening remarks.2/8/2014 7:30:00 AM2/8/2014 8:00:00 AM1518815188SQLSaturday 241Training 1Training 1Registration Opens (Front Entrance)Please remember to bring your SpeedPass with you, and head to the main reception area at the front of the building to check-in at registration. Once you've checked-in, feel free to head to the Diner for refreshments and a light breakfast, and then meet us in the Atrium for the opening remarks.2/8/2014 7:30:00 AM2/8/2014 8:00:00 AM1518815188SQLSaturday 241Training 4Training 4Registration Opens (Front Entrance)Please remember to bring your SpeedPass with you, and head to the main reception area at the front of the building to check-in at registration. Once you've checked-in, feel free to head to the Diner for refreshments and a light breakfast, and then meet us in the Atrium for the opening remarks.2/8/2014 7:30:00 AM2/8/2014 8:00:00 AM1518815188SQLSaturday 241Training 5Training 5Registration Opens (Front Entrance)Please remember to bring your SpeedPass with you, and head to the main reception area at the front of the building to check-in at registration. Once you've checked-in, feel free to head to the Diner for refreshments and a light breakfast, and then meet us in the Atrium for the opening remarks.2/8/2014 7:30:00 AM2/8/2014 8:00:00 AM1528015280Sam NasrTraining 4Training 414 New T-SQL FunctionsThe 2012 release of SQL Server introduces 14 new functions for developers. This list includes functions for conversion, date/time calculation, enhanced logic, and string manipulation. In this session we’ll cover the ins and outs of these new functions, making you a better T-SQL developer.2/8/2014 8:45:00 AM2/8/2014 9:45:00 AM1549115491Kathi KellenbergerTraining 3Training 3Writing Better Queries with T-SQL Window FunctionsSQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could. This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.2/8/2014 10:00:00 AM2/8/2014 11:00:00 AM1609216092Argenis FernandezTraining 1Training 1Code-Less Securing of SQL ServerLearn from a Microsoft Certified Master how to secure your SQL Server infrastructure and your Windows installations to enhance resiliency and minimize exposure to attacks—all without touching any of your code!2/8/2014 1:30:00 PM2/8/2014 2:30:00 PM1718017180David MaxwellTraining 4Training 4DBA 911 - Database CorruptionDatabase corruption is simply a fact of a DBA's life - if you haven't seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it.
2/8/2014 1:30:00 PM2/8/2014 2:30:00 PM1774617746Brandon LeachTraining 6Training 6Wrangling performance with Resource GovernorIn this introductory session we'll delve into the basics of the resource governor feature in SQL Server. We'll look at the types of issues this feature can help resolve. We'll then delve into various components of the feature, such as a classifier function, workload groups and resource pools. Finally we'll bring all this together with an example implementation. From there, if time allows, we'll look at best practices and questions to answer to ensure a successful implementation. 2/8/2014 1:30:00 PM2/8/2014 2:30:00 PM1796117961Steve HoodTraining 4Training 4Monitoring and BaselinesCovers monitoring OS Perf Counters, Wait Stats, Traces, Blocking, Query Stats, Index Stats, Database Sizes and Table Sizes, all presented in a format of what you should be watching and how it will help you. How to watch them is covered in my blog at SimpleSQLServer.com.
This will give you a great starting point for finding root causes to incidents, trending database growth, and a better way to find the queries in most need of tuning.2/8/2014 10:00:00 AM2/8/2014 11:00:00 AM1805718057Lisa GardnerTraining 4Training 4Code Management with SQL Server Data ToolsIn this session, I will introduce you to SQL Server Data Tools. With SSDT, you can create database projects to act as the system of record for your database schema. You can also utilize SSDT to automate SQL code deployments into multiple environments. And did I mention the tool is free? Your SQL code can finally be treated as a first class code citizen.2/8/2014 11:15:00 AM2/8/2014 12:15:00 PM1813318133Mindy CurnuttTraining 2Training 2SQL Server Bingo – Install, Migration ConfigGet ready to play SQL Buzzword Bingo with the subject matter being SQL Install, Migration Configuration. Are you preparing to move a database from one SQL Server to another? Whether it's your first SQL install, a SQL Server Upgrade or changing from physical to virtual, there is a lot to consider. In some areas of the setup, you get only one chance to 'get it right.' Come to this session and find out all about the process - and have some fun while you're at it. First one to hit BINGO! will win a copy of the book SQL Server 2012 - Step by Step.2/8/2014 11:15:00 AM2/8/2014 12:15:00 PM1815218152Jeff ModenTraining 6Training 6Hierarchies... on Steroids the No RBAR WayHierarchical data sets are everywhere. If you haven't worked with one yet, you will. If you're already working with them, you know they can be horribly complex, slow performing, difficult to maintain resource hogs that can really take the steam out of any GUI or batch process. This simple but code intensive 'black arts' session shows you how to quickly and easily get around all of that using all 3 common hierarchical structures and includes a very high performance method (100,000 nodes in less than 4 seconds and 1 Million nodes in less than a minute) for converting Adjacency Lists to Nested Sets that even a beginner can understand. As a finale`, we'll cover a new 'pre-aggregated' Hierarchical table structure that answers most of the questions you'd ask of a Hierarchy. You just have to know that a Tally Table is involved somewhere in this. ;-)2/8/2014 11:15:00 AM2/8/2014 12:15:00 PM1829918299Cory StevensonTraining 6Training 6SSIS OlympicsDid you know that 38 hundredths of a second separated gold and silver in the 4-man bobsledding race at the Vancouver Winter Olympics? What did the right setup mean for the US bobsled team in Vancouver? Everything!!! Choosing the right components and settings can make all the difference in the world. The same holds true for the setup and performance of SSIS. In this session, we will glide through parts of SSIS that, when used correctly, will make your packages gold medal contenders.2/8/2014 4:00:00 PM2/8/2014 5:00:00 PM1841418414Adam BelebczukTraining 2Training 2XML Without Xanax: How to Handle XML in SQL ServerDo you cringe whenever you have to look at an XML document? Does the very thought of XML data living in your database make you scream? Do you have a panic attack any time you have to parse XML? If you answered yes to any of these questions, then this session is for you!
We'll start with reasons why having XML in SQL Server might be a good thing, then we'll face our fears and turn tabular data into XML, and finally we'll confront the true source of our anxiety by parsing XML back into tabular data using xQuery.
If you survive this session, you'll have faced your fears about XML in SQL Server, you'll have a solid understanding of creating XML from tabular data, and you'll know how to use xQuery to parse XML.2/8/2014 4:00:00 PM2/8/2014 5:00:00 PM1853218532Kevin BolesTraining 4Training 4SQL Server 2014 New FeaturesThere is MUCH more to SQL Server 2014 than just Hekaton and Updatable Column Store Indexes!! This session will be a medium-to-high-level overview of many of the new features and enhancements coming in SQL Server 2014. We will take a look at some of the new functionality via demos as well.2/8/2014 4:00:00 PM2/8/2014 5:00:00 PM1856118561Thomas LaRockTraining 1Training 1Database Design: Size DOES MatterGreat database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency. 2/8/2014 11:15:00 AM2/8/2014 12:15:00 PM1874218742Joseph D'AntoniTraining 3Training 3SQL 2012 -- All About HA and DRHave you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start? In this session we will walk through the process of creating a disaster recovery plan for your organization, all of the HA and DR options within SQL Server (even the ones that aren't in Enterprise Edition), and finally a demonstration of the new Availability Groups feature in SQL Server 2012 and see them in practice2/8/2014 1:30:00 PM2/8/2014 2:30:00 PM1874318743Joseph D'AntoniTraining 3Training 3In-Memory Columnstore Indexes--Make Your Data Warehouse Fly Columnstore indexes were introduced in SQL Server 2012, along with a new type of query processing 'batch mode'. In SQL 2014 they get even better--we can use a Columnstore index as a clustered index and update it. In this session we will explore the basics and beyond of Columnstore indexes and how they can help your warehouse performance. 2/8/2014 2:45:00 PM2/8/2014 3:45:00 PM1878018780Stacia Misner AuditoriumAuditoriumReduce, Reuse, Recycle: Automating Your BI FrameworkQuite frankly, some aspects of building out a business intelligence solution are tedious. As you cycle through iterations of your star schema, you’ll find that even a simple data type change in the data warehouse requires you to make corresponding changes to staging tables, SSIS packages, and SSAS multidimensional or tabular models that take a considerable amount of time to implement. But there’s a better, faster way!In this session, we’ll explore lessons from a project that required implementation of a framework to easily generate BI objects based on reusable patterns. We’ll walk through the decision points in the framework design, review the implementation steps, and see demonstrations of how easily you can make iterative changes to your BI solution’s design by using reusable design patterns. Whether you simply want to accelerate change management or reproduce objects in bulk on demand, this session will give you practical tips for automating these processes.2/8/2014 10:00:00 AM2/8/2014 11:00:00 AM1878118781Stacia MisnerTraining 1Training 1A Big Data PrimerThe term 'big data' dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.2/8/2014 2:45:00 PM2/8/2014 3:45:00 PM1884218842Colleen MorrowTraining 2Training 2SQL Audit - auditing doesn't have to be boringLet's face it, auditing isn't fun. But if you're a DBA, you need to know what's going on in your SQL Server instance. Fortunately, SQL Audit makes it easy. In this session, we'll cover what you can and can't audit using SQL Audit, enhancements in 2012, configuring database and server audits, ways to process output, and ideas for how to implement SQL Audit on a larger scale. Auditing doesn't have to be hard. And with the help of a little custom coding, it can even be fun. 2/8/2014 2:45:00 PM2/8/2014 3:45:00 PM1884518845Allen White AuditoriumAuditoriumAutomate Your ETL Infrastructure with SSIS and PowerShellMuch of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it's easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we'll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.2/8/2014 11:15:00 AM2/8/2014 12:15:00 PM1890618906Steve JonesTraining 3Training 3The Encryption PrimerLearn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.2/8/2014 8:45:00 AM2/8/2014 9:45:00 AM1890718907Steve JonesTraining 3Training 3Branding Yourself for a Dream JobEveryone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.2/8/2014 11:15:00 AM2/8/2014 12:15:00 PM1900719007Julie SmithTraining 1Training 1BIML--Step by Step BIML--Business Intelligence Markup Language is your key to faster development of SSIS Packages. This session will guide you through an introduction to BIML. We'll explore the capabilities of BIML and BIMLScript, available through the free Codeplex BIDSHelper download. We'll move through basic syntax of plain BIML, and progress to BIMLScript, using LINQ, and Lambda expressions to access enterprise metadata, speeding SSIS development exponentially.2/8/2014 8:45:00 AM2/8/2014 9:45:00 AM1900919009Tim ChapmanTraining 1Training 1SQL Server Transaction Log InternalsThe transaction log plays the most critical role in any SQL Server database. In this talk I will discuss the importance of transaction log and the roles it plays inside the database engine. We’ll look at how logging and recovery works, the checkpoint process, write-ahead logging, and steps you need to take as a DBA to ensure proper management of the transaction log for a SQL Server database. 2/8/2014 4:00:00 PM2/8/2014 5:00:00 PM1902519025Grant FritcheyTraining 1Training 1Statistics and Query OptimizationThere are any number of tricks and traps around getting the query optimizer to provide you with an optimal execution plan that gets you your data quickly and efficiently. But, at the end of the day, the principal driving factor of the optimizer, and therefore of your queries, are the statistics that define your data. This session teaches you how those statistics are put together and maintained by SQL Server. Different types of maintenance results in different levels of accuracy within statistics so we detail what the structures and information looks like after this maintenance. Your understanding of how the optimizer works with statistics will better enable you to understand why you’re getting the performance and types of execution plans that you are getting. Understanding enables you to write better t-sql statements and deal with performance problems such as bad parameter sniffing.2/8/2014 10:00:00 AM2/8/2014 11:00:00 AM1903519035Thomas LaRock AuditoriumAuditoriumQuery Performance Tuning: A 12 Step ProgramHave you ever had a query handed to you for the first time and you are expected to make it perform better before you are through with your morning cup of coffee? Attend this session where SQL Server MCMs Thomas LaRock and Tim Chapman will share their 12 steps to better query performance tuning.2/8/2014 8:45:00 AM2/8/2014 9:45:00 AM1904119041Ben Miller AuditoriumAuditoriumBe Friendly to SQL Server with TSQL Best PracticesThis session will take a look at things that you should regularly know and use when coding TSQL. How can you be really friendly to SQL? The items covered will show you things that will help ensure that your code is readable, efficient and maintainable. We will look at query semantics, datatypes, things to avoid as well as how to be super friendly to the SQL Engine and allow things to work well.2/8/2014 4:00:00 PM2/8/2014 5:00:00 PM1909319093Konstantin MelamudTraining 2Training 2Performance Tuning - Analyzing Execution PlansDid you ever get woken up at night from a call from a user screaming about poor query performance, but didn’t really know how to begin attack the problem? In this session, we will explore the basics of execution plan analysis and how to single out issues that pertain to base table operations.
In this presentation, we will identify what indexes are being used by the SQL Optimizer, the different type of index operations that are performed by SQL Server and which operations are generally considered the preferred method of data retrieval. We will discuss how to determine if the indexes used by the Optimizer are optimal, according to best practices, and the exceptions to those cases. Finally, we will cover the relationships between different types of index operations and joins within SQL Server, including how the SQL Optimizer determines which join type it will use, along with the pros and cons of each join operation
2/8/2014 1:30:00 PM2/8/2014 2:30:00 PM1911519115Mark VaillancourtTraining 5Training 5MDX Trek: First ContactCube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment. 2/8/2014 8:45:00 AM2/8/2014 9:45:00 AM1911619116Mark VaillancourtTraining 5Training 5DANGER: The Art and Science of PresentingIs there a great difference in the brain chemistry of someone fleeing a hungry mountain lion and someone presenting to a group of colleagues in a corporate board room? The answer is: NO. Over the past decade, a lot has been learned about the chemistry of the brain and why humans react the way we do to events in our environment. The concept of EQ (Emotional Intelligence) is a compelling and growing concept that applies this knowledge in a set of learnable, improvable skills for leading human beings. While EQ is often applied to corporate leadership, the parallels to presenting are fantastic. This session will explain the basics of EQ and demonstrate how you can apply it to make your presentations better in the following areas: * Crafting better slide decks * Preparing yourself for presenting * Delivering your content * Dealing with the unexpected Understanding and practicing the concepts of EQ can make your presentations a better experience for everyone in the room--including you.2/8/2014 1:30:00 PM2/8/2014 2:30:00 PM1912119121Kerry TylerTraining 6Training 6Manageable SSAS Deployment StrategiesWhen it comes to making changes to your production Analysis Services databases, do you simply open the SSAS DB in SQL Server Data Tools (or BIDS) and click through creating the changes? Does this method lead to problems keeping everything in sync and the right changes deployed to the right environment at the right time? Have you, the BI developer, had to fight to get Production access to do your own deployments?
If you've answered 'yes' to any of these questions, and are in search of a better way, I have the solution! In this demo-heavy session, will look at five steps to more robust, controllable, and flexible Tabular and Multidimensional SSAS deployments.2/8/2014 10:00:00 AM2/8/2014 11:00:00 AM1912219122Brian DavisTraining 2Training 2Getting Started with Hekaton (In-Memory OLTP)So you've heard of Hekaton (In-Memory OLTP) but you aren't sure where to start or if it's for you or not. Maybe you've heard or read some information and not sure what's true or not. There's a number of misconceptions out there about Hekaton. By the end of this session you'll have a better understanding of what Hekaton is and how it may be able to help you. We'll discuss the basics of Hekaton and more as well as walking through some demos to show you how to use Hekaton and what it can do as well as help you get started diving into Hekaton on your own.2/8/2014 10:00:00 AM2/8/2014 11:00:00 AM1912719127Hope FoleyTraining 4Training 4Spatial Data: Cooler Than You'd Think!Spatial data has been around since 2008 but it should fire it's PR person. It's too bad that spatial data gets no love, it's actually something that pretty much all SQL Server shops could use. This session will focus on utilizing these native types to store, analyze, and retrieve spatial data. I will use some real world examples to help get the wheels turning on how you can use it within your organization and show how powerful it can be to see your data visually on a map. 2/8/2014 2:45:00 PM2/8/2014 3:45:00 PM1913419134Paul HilesTraining 6Training 6The Evils of Cursors We have all heard that cursors are evil, but most of the time we are not told why they are evil and how to replace them. The goal of this session is to fix that problem. We will be reviewing a number of types of cursors and explain why they are being used, why are bad and then show better ways to write them. This session will include lots of actual scripts and demos comparing these different examples of cursors and then better ways to rewrite the code to replace the cursor.2/8/2014 8:45:00 AM2/8/2014 9:45:00 AM1915419154Jeff MlakarTraining 5Training 5A Tour of Power BI: Pivot, View, Query, and MapIn this session, we’ll show you how you can expose your reportable data in the cloud and use Microsoft’s Power BI in different ways to empower your business users to Self-Service BI. Equal demo time will be given to all 4 of Power BI’s pillars: Power Pivot, Power View, Power Query, and Power Map.2/8/2014 10:00:00 AM2/8/2014 11:00:00 AM1916319163Tamera ClarkTraining 5Training 545 min to build your first SSRS reportDoes 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) 2012. The query makes no difference, this time it's all about the output. 2/8/2014 11:15:00 AM2/8/2014 12:15:00 PM1916619166Craig PurnellTraining 6Training 6Simplify your infrastructure with Managed Service AccountsWe will review what are Managed Service Accounts, and their newer cousin, group Managed Service Accounts (gMSA) and why they are important for SQL Server DBAs. We will then implement a gMSA and explain some of the tips and tricks a DBA should know about in implementing this game changing way to simplify your service account management.2/8/2014 2:45:00 PM2/8/2014 3:45:00 PM1916819168Kendal Van Dyke AuditoriumAuditoriumDiscover, Document, Diagnose Your Servers on Your Coffee BreakDocumentation is the bane of every DBA's existence. We all know we should do it but it's time consuming; by the time you're finally done it's probably out of date. Throw in the new servers you just found out about last week and keeping documentation up to date can turn into a full time job. And with everything we have to do in our day, who has time for that?
You need a way to work smarter, not harder, and automate your documentation. It can be done, and in this session you'll learn how to discover all the SQL Servers on your network, document their configuration from top to bottom (including OS details), and diagnose common problems before they turn into big headaches - all while you're on a coffee break. You'll look like a rock star without writing a line of code on your own or having to ask management to sign a check.
Attend this session and walk away with everything you need to generate documentation for your entire SQL Server environment on your first day back at the office2/8/2014 1:30:00 PM2/8/2014 2:30:00 PM1916919169Kendal Van DykeTraining 5Training 5Building Your Own SQL Server Virtual PlaygroundAs the number of SQL Server versions and features grow over time so does the the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn't enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up a cluster? Or maybe you want to try out the latest features in SQL 2012...virtualization offers a convenient way to do any or all of these. In this session we'll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual playground on your own machine.2/8/2014 2:45:00 PM2/8/2014 3:45:00 PM1926819268Tim RadneyTraining 2Training 2Know Backups and Know RecoveryIt 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.2/8/2014 8:45:00 AM2/8/2014 9:45:00 AM1926919269Tim Radney AuditoriumAuditoriumYou Inherited a Database, Now What?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. 2/8/2014 2:45:00 PM2/8/2014 3:45:00 PM1973919739Erin StellatoTraining 3Training 3Making the Leap from Profiler to Extended EventsIf you’re like me, you’ve been using SQL Trace and Profiler since you started using SQL Server. They’re like old friends, tried and true. You know how they work, you know what you can capture, you know how to find the data you need. But now you’ve been told that your good friends have been deprecated in SQL Server 2012, and you need to become best friends with Extended Events. What is THAT all about? It’s ok. Really. In this session we’ll look at Profiler and Extended Events side by side to see how easy it is to transition to Extended Events. We’ll step through real world examples using Extended Events to do what you’re used to doing with Trace, and even more. You can find the time learn Extended Events…today.2/8/2014 4:00:00 PM2/8/2014 5:00:00 PM1977019770SQLSaturday 241Training 3Training 3Opening Ceremonies (Atrium)Once you've checked-in at registration (don't forget your SpeedPass) and grabbed some refreshments from the Diner, join us in the Atrium for the Opening Ceremonies. Allen White, President of the Ohio North SQL Server User Group, will get things started, followed by a keynote from Thomas LaRock, President of the Professional Association for SQL Server, and finally Adam Belebczuk, SQL Saturday Event Coordinator, will go over some logistics for the day.2/8/2014 8:00:00 AM2/8/2014 8:30:00 AM1977019770SQLSaturday 241 AuditoriumAuditoriumOpening Ceremonies (Atrium)Once you've checked-in at registration (don't forget your SpeedPass) and grabbed some refreshments from the Diner, join us in the Atrium for the Opening Ceremonies. Allen White, President of the Ohio North SQL Server User Group, will get things started, followed by a keynote from Thomas LaRock, President of the Professional Association for SQL Server, and finally Adam Belebczuk, SQL Saturday Event Coordinator, will go over some logistics for the day.2/8/2014 8:00:00 AM2/8/2014 8:30:00 AM1977019770SQLSaturday 241Training 2Training 2Opening Ceremonies (Atrium)Once you've checked-in at registration (don't forget your SpeedPass) and grabbed some refreshments from the Diner, join us in the Atrium for the Opening Ceremonies. Allen White, President of the Ohio North SQL Server User Group, will get things started, followed by a keynote from Thomas LaRock, President of the Professional Association for SQL Server, and finally Adam Belebczuk, SQL Saturday Event Coordinator, will go over some logistics for the day.2/8/2014 8:00:00 AM2/8/2014 8:30:00 AM1977019770SQLSaturday 241Training 6Training 6Opening Ceremonies (Atrium)Once you've checked-in at registration (don't forget your SpeedPass) and grabbed some refreshments from the Diner, join us in the Atrium for the Opening Ceremonies. Allen White, President of the Ohio North SQL Server User Group, will get things started, followed by a keynote from Thomas LaRock, President of the Professional Association for SQL Server, and finally Adam Belebczuk, SQL Saturday Event Coordinator, will go over some logistics for the day.2/8/2014 8:00:00 AM2/8/2014 8:30:00 AM1977019770SQLSaturday 241Training 5Training 5Opening Ceremonies (Atrium)Once you've checked-in at registration (don't forget your SpeedPass) and grabbed some refreshments from the Diner, join us in the Atrium for the Opening Ceremonies. Allen White, President of the Ohio North SQL Server User Group, will get things started, followed by a keynote from Thomas LaRock, President of the Professional Association for SQL Server, and finally Adam Belebczuk, SQL Saturday Event Coordinator, will go over some logistics for the day.2/8/2014 8:00:00 AM2/8/2014 8:30:00 AM1977019770SQLSaturday 241Training 4Training 4Opening Ceremonies (Atrium)Once you've checked-in at registration (don't forget your SpeedPass) and grabbed some refreshments from the Diner, join us in the Atrium for the Opening Ceremonies. Allen White, President of the Ohio North SQL Server User Group, will get things started, followed by a keynote from Thomas LaRock, President of the Professional Association for SQL Server, and finally Adam Belebczuk, SQL Saturday Event Coordinator, will go over some logistics for the day.2/8/2014 8:00:00 AM2/8/2014 8:30:00 AM1977019770SQLSaturday 241Training 1Training 1Opening Ceremonies (Atrium)Once you've checked-in at registration (don't forget your SpeedPass) and grabbed some refreshments from the Diner, join us in the Atrium for the Opening Ceremonies. Allen White, President of the Ohio North SQL Server User Group, will get things started, followed by a keynote from Thomas LaRock, President of the Professional Association for SQL Server, and finally Adam Belebczuk, SQL Saturday Event Coordinator, will go over some logistics for the day.2/8/2014 8:00:00 AM2/8/2014 8:30:00 AM1977119771SQLSaturday 241Training 1Training 1Closing Ceremonies (Atrium)Join us in the Atrium for some prize giveaways and the closing ceremonies!2/8/2014 5:00:00 PM2/8/2014 5:30:00 PM1977119771SQLSaturday 241Training 4Training 4Closing Ceremonies (Atrium)Join us in the Atrium for some prize giveaways and the closing ceremonies!2/8/2014 5:00:00 PM2/8/2014 5:30:00 PM1977119771SQLSaturday 241Training 5Training 5Closing Ceremonies (Atrium)Join us in the Atrium for some prize giveaways and the closing ceremonies!2/8/2014 5:00:00 PM2/8/2014 5:30:00 PM1977119771SQLSaturday 241Training 6Training 6Closing Ceremonies (Atrium)Join us in the Atrium for some prize giveaways and the closing ceremonies!2/8/2014 5:00:00 PM2/8/2014 5:30:00 PM1977119771SQLSaturday 241Training 2Training 2Closing Ceremonies (Atrium)Join us in the Atrium for some prize giveaways and the closing ceremonies!2/8/2014 5:00:00 PM2/8/2014 5:30:00 PM1977119771SQLSaturday 241 AuditoriumAuditoriumClosing Ceremonies (Atrium)Join us in the Atrium for some prize giveaways and the closing ceremonies!2/8/2014 5:00:00 PM2/8/2014 5:30:00 PM1977119771SQLSaturday 241Training 3Training 3Closing Ceremonies (Atrium)Join us in the Atrium for some prize giveaways and the closing ceremonies!2/8/2014 5:00:00 PM2/8/2014 5:30:00 PM1980219802Wendy PastrickTraining 5Training 5Navigating the Options for Data RedundancySQL Server has so many options for data redundancy, how do you know when you should use replication, or log shipping or AlwaysOn, etc? We will use real world examples where data redundancy is needed and discuss which is the appropriate technology and why. This is more than just a high availability vs disaster recovery discussion. If you have ever been confused or overwhelmed by all of the options, they will be broken down and made clear in this session.2/8/2014 4:00:00 PM2/8/2014 5:00:00 PM2032920329SQLSaturday 241Training 3Training 3Lunch Vendor Sessions - TegileGrab your lunch and find a Vendor Session to attend while you eat. Please show your support to those who make our SQLSaturday event possible!
Vendor: Tegile
Title: The world of storage options: Supercharging your SQL Server Deployments
Abstract: SQL Server performance and usability is largely dependent on the performance of your storage. The world of storage is going through a dramatic transformation. A barrage of options are available to solve your “storage” pain points. Learn about the features and options which are available to solve your challenges. We will cover the choices and implications of those choices for: (a) Tierd Disk, (b) PCIe Flash, (c) All Flash Arrays and (d) Hybrid Arrays.2/8/2014 12:15:00 PM2/8/2014 1:15:00 PM2033020330SQLSaturday 241 AuditoriumAuditoriumLunch Vendor Sessions - SQL Server 2014 (Microsoft)Grab your lunch and find a Vendor Session to attend while you eat. Please show your support to those who make our SQLSaturday event possible!
Vendor: Microsoft
Topic: SQL Server 20142/8/2014 12:15:00 PM2/8/2014 1:15:00 PM2033120331SQLSaturday 241Training 6Training 6Lunch Vendor Sessions - TMW SystemsGrab your lunch and find a Vendor Session to attend while you eat. Please show your support to those who make our SQLSaturday event possible!
Vendor: TMW Systems
Topic: TMW Systems—Trucking, Logistics, and Beyond2/8/2014 12:15:00 PM2/8/2014 1:15:00 PM2033220332SQLSaturday 241Training 1Training 1Lunch Vendor Sessions - SQL SentryGrab your lunch and find a Vendor Session to attend while you eat. Please show your support to those who make our SQLSaturday event possible!
Vendor: SQL Sentry
Title: Tips for Query Tuning with SQL Sentry Plan Explorer
Abstract: Learn how SQL Sentry Plan Explorer can help you explore and tune the most difficult query plans, from the team that made this fantastic free tool. Scott Fallen, Sales Engineer at SQL Sentry, will cover the key differences between Plan Explorer and SQL Server Management Studio, plus what to look for in estimated and actual plans. During this session you will learn how to use the revolutionary FREE tool, SQL Sentry Plan Explorer, to wrangle even the scariest query plans.2/8/2014 12:15:00 PM2/8/2014 1:15:00 PM2033320333SQLSaturday 241Training 2Training 2Lunch Vendor SessionsGrab your lunch and find a Vendor Session to attend while you eat. Please show your support to those who make our SQLSaturday event possible!2/8/2014 12:15:00 PM2/8/2014 1:15:00 PM2033420334SQLSaturday 241Training 5Training 5Lunch Vendor Sessions - ConfioGrab your lunch and find a Vendor Session to attend while you eat. Please show your support to those who make our SQLSaturday event possible!
Vendor: Confio2/8/2014 12:15:00 PM2/8/2014 1:15:00 PM2033520335SQLSaturday 241Training 4Training 4Lunch Vendor Sessions - DigineerGrab your lunch and find a Vendor Session to attend while you eat. Please show your support to those who make our SQLSaturday event possible!
Vendor: Digineer2/8/2014 12:15:00 PM2/8/2014 1:15:00 PM