SQLSaturday #298 - Jacksonville 20145/10/2014 12:00:00 AM(GMT-06:00) Central Time (US and Canada)SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat2981 UNF DriveBuilding 50JacksonvilleFL322244304SNI TechnologyGold Sponsorhttp://www.snicompanies.comhttps://www.bestofstaffing.com/img/logos/2013/talent/sni-technology.png601704305Pragmatic WorksGold Sponsorhttp://pragmaticworks.com/http://pragmaticworks.com/images/Logo/PragmaticWorksLogo.jpg601704422Microsoft CorporationGold Sponsorhttp://www.microsoft.com/en-us/sqlserver/default.aspxhttp://i.s-microsoft.com/global/onemscomsettings/publishingimages/headerimages/microsoftlogov3.png601704434Fusion-ioGold Sponsorhttp://www.fusionio.comhttp://cdn.fusionio.com/images/fio-logo.png601704482Confio SoftwareGold Sponsorhttps://www.confio.com/http://confio.com/media/492743/confio-logo.jpg601704485University of North FloridaGold Sponsorhttp://www.unf.eduhttp://www.unf.edu/uploadedImages/ia/pr/marketing_publications/UNF_LOGO_HORZ_PMS_BLUEGRAY.jpg601704538PASSSilver Sponsorhttp://sqlpass.orghttp://orlando.sqlpass.org/portals/265/PASS%20Images/PASSLogoBW.jpg601704586DMEautomotiveSilver Sponsorhttp://www.dmeautomotive.com/http://www.dmeautomotive.com/images/logo.png601704322Yash Creations Inc.Silver Sponsorhttp://www.yashcreations.comhttp://s328152883.onlinehome.us/assets/img/logo.png601704407Alluvion Staffing Silver Sponsorwww.alluvionstaffing.comhttp://www.alluvionstaffing.com/img/logo-alluvion.png601704635Code on the BeachSilver Sponsorhttp://www.codeonthebeach.comhttp://www.codeonthebeach.com/assets/img/logo.png601704593iMethodsBronze Sponsorhttp://www.imethods.comhttp://newsletter.imethods.com/images/imethods-logo-170x60.png6017021491Adam JorgensenAdam Jorgensen is the President of Pragmatic Works, SQL Server MVP and Director, EVP of PASS. An accomplished technical strategist, Adam leads one of the most innovative and successful organizations focused on driving client success through a strategic focus on the value of data. Pragmatic Works serves their clients with industry leading tools, training and services that make world-class data solutions rapidly accessible. @wadamjhttp://www.linkedin.com/profile/view?id=6926529locale=en_UStrk=tab_prohttp://www.wadamj.comhttps://api.twitter.com/1/users/profile_image?screen_name=@wadamj484820201Andy WarrenAndy Warren is an independent consultant specializing in SQL Server based in Orlando. Over the course of his career he has written more than 100 technical articles, was a founder of SQLServerCentral.com, relaunched the Orlando SQL Server User Group (oPASS), served for three years on the PASS Board of Directors, and has been a SQL MVP since 2008. @sqlandywww.linkedin.com/sqlandyhttp://www.sqlandy.comhttps://api.twitter.com/1/users/profile_image?screen_name=@sqlandy484821654Bradley SchachtBradley is a senior business intelligence consultant at Pragmatic Works.@sqlbswww.linkedin.com/pub/bradley-schacht/17/66b/b08/https://api.twitter.com/1/users/profile_image?screen_name=@sqlbs484821726Bradley BallBradley Ball is a SQL MCITP with almost 15 years of IT experience. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office Of the President of the United States. Currently the Data Platform Management Lead with Pragmatic Works and a Microsoft VTSP. He has presented at SQL Saturdays, SQL Server User Groups, SQL Rally, DevConnections, SQL Live 360, and the PASS Summit. Bradley can be found blogging on http://www.SQLBalls.com@SQLBallshttp://www.linkedin.com/sqlballshttp://www.sqlballs.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLBalls484820550Brian McDonaldBrian K. McDonald, MCDBA, MCSD, is an author, a BI and data warehouse geek and Sherri is a BI Developer working in Jacksonville, FL. They both are members of their local SQL Server User's Group and have presented for user groups, Code Camps and many SQL Saturday events in the southeast U.S. When not working, Brian and Sherri enjoy 'geeking' out and Brian allows his children to practice their mixed martial arts moves on him.484820152Chad ChurchwellSeasoned SQL Server professional focusing on database engine, HA/DR/ and Replication@chadchurchwellhttp://www.linkedin.com/in/chadchurchwellhttp://www.sqlchad.comhttps://api.twitter.com/1/users/profile_image?screen_name=@chadchurchwell484821251Chris SkorlinskiChris Skorlinski has been with Microsoft for 22 years as a Support Escalation Engineer at the Microsoft Charlotte, NC office specializing in performance tuning and troubleshooting in SQL Server. His MSDN blog http://blogs.msdn.com/ReplTalk/ contain tips for configuring and turning Microsoft SQL Server Replication. Traveling by motorcycle, he volunteers time teaching a wide variety of topics at SQL Saturday workshops, giving Web Casts, and presenting at computer users groups across the country.
@ReplTalkhttp://www.linkedin.com/pub/chris-skorlinski/1b/237/b55https://api.twitter.com/1/users/profile_image?screen_name=@ReplTalk484821614Damu VenkatesanDamu is a Business Intelligence Consultant with over 20 years of IT experience. His experience includes architecting BI/DW solutions using SQL Server. He is the founder and co-leader of PASS Healthcare SQL Virtual Chapter. He has successfully delivered several BI/DW solutions and data migrations to various clients. He is also on the board of DAMA Georgia chapter.@vdamu @NealWaterstreetwww.linkedin.com/in/damuvenkatesan/https://api.twitter.com/1/users/profile_image?screen_name=@vdamu @NealWaterstreet484821560Devin KnightKids Camp@knight_devinhttp://www.linkedin.com/pub/devin-knight/7/814/28http://www.devinknightsql.comhttps://api.twitter.com/1/users/profile_image?screen_name=@knight_devin484821583Devin Knight Devin@knight_devinhttp://www.linkedin.com/pub/devin-knight/7/814/28http://devinknightsql.comhttps://api.twitter.com/1/users/profile_image?screen_name=@knight_devin484819963Dmitri KorotkevitchDmitri Korotkevitch is Microsoft SQL Server MVP and Microsoft Certified Master who is working with Microsoft SQL Server for more than 11 years. He specializes in architecture, design, development and performance tuning of OLTP systems and responsible for implementation of several database backends handling thousands of transactions per second around the clock. Dmitri has Master’s degree in Computer Science and also held MCPD certificate.@aboutsqlserverwww.linkedin.com/pub/dmitri-korotkevitch/5/980/b7/http://aboutsqlserver.comhttps://api.twitter.com/1/users/profile_image?screen_name=@aboutsqlserver484819998Dustin RyanI’ve been working as a Business Intelligence Consultant for Pragmatic Works since 2008 and I’ve loved every second of it! There’s not a day that goes by that I’m not thankful to God for how much fun my work is! Whether I’m designing a data warehouse, overcoming some tricky ETL problems, building an SSAS cube, or coming up with just the right reporting solution, I’m excited to be doing what I do. @SQLDustywww.linkedin.com/pub/dustin-ryan/14/59b/a9b/http://sqldusty.wordpress.com/https://api.twitter.com/1/users/profile_image?screen_name=@SQLDusty484821352Eric WisdahlEric Wisdahl (MCSA, MCSE - Data Platform) is a database engineer working mostly with the BI stack. He spends what little free time he has reading technical books, playing games, perusing the MSDN SQL Forums, or spending time with his wife, son, and dogs. In a past life he has worked as a DBA in the e-commerce industry, an ETL / BI Specialist in the insurance industry, a Pizza Boy, a Patent Examiner, a Pro-IV Code Monkey and a .Net punching bag.@Old_Man_Fishhttp://www.linkedin.com/in/ericwisdahlhttp://ericwisdahl.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@Old_Man_Fish484821557Gareth SwanepoelGareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 20 years. He enjoys solving the complex problems that his clients encounter when deploying SQL in a data warehouse environment. He is an accomplished author and speaker. Current projects include contributing content for the SQL 2014 Extended Events book. He also currently serves as one of the PASS Regional Mentors for the US SouthEast region. @GarethSwanhttp:www.linkedin.com/in/garethswanhttp://www.mygareth.comhttps://api.twitter.com/1/users/profile_image?screen_name=@GarethSwan484821480Jason VirtueJason Virtue works for Microsoft as a BI Technology Solution Specialist. He has worked in the BI industry for 20 years for management consulting firms and Fortune 500 companies. Jason's experience as a BI architect has enabled him to deliver multiple BI systems across different organizations, industries and vendor platforms. He looks forward to sharing his knowledge and learning new ideas during this event.@SQLVirtuewww.linkedin.com/in/jasonvirtue/http://www.microsoft.com/en-us/server-cloud/products/sql-serverhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLVirtue484819960Jason CarterJason's past has included being a developer, a development manager, and accidental DBA, and now a full-time DBA. Having worked with large databases as a developer, he found great interest in tuning, tweaking, and making things run faster. With the support of his wife, he gave up his managerial duties and jumped the Development ship and dove head first into his new career as a Database Administrator.@TampaDBAhttps://www.linkedin.com/in/jasoncarter80http://jason-carter.nethttps://api.twitter.com/1/users/profile_image?screen_name=@TampaDBA484821992Jason StrateJason is a solutions architect with Pragmatic Works with over 15 years experience working with SQL Server. He is Microsoft Certified Master for SQL Server and SQL Server MVP. As a consultant, he has worked on projects encompassing most features of SQL Server and has experience developing, architecting, and managing numerous data platforms. @stratesqlhttp://www.linkedin.com/in/jasonstratehttp://www.jasonstrate.comhttps://api.twitter.com/1/users/profile_image?screen_name=@stratesql484819940Jeffrey GarbusJeff has been in the SQL Server business for over 20 years, training and consulting, with an emphasis on performance and tuning. He has written over a dozen books, and hundreds of magazine articles. He has spoken at a week of SQL Saturdays.http://www.linkedin.com/in/jeffgarbushttp://mssqlperformance.blogspot.com/484821556Joe SalvatoreJoe is an accomplished Business Intelligence Architect with Pragmatic Works. For over 15 years, Joe, has designed complex business intelligence solutions for customers throughout all of North America. His focus on architecting the right hardware and software solution along with implementing best practice dimensional models has earned him high praise from customers.http://www.linkedin.com/in/joesalvatore484820790John WelchJohn Welch works at Pragmatic Works, where he manages the development of a suite of BI products that make developing, managing, and documenting BI solutions easier. John has been working with business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), SSAS Maestro, and a frequent presenter on SQL Server BI topics.@john_welchhttp://www.linkedin.com/in/johncwelchhttp://agilebi.com/jwelchhttps://api.twitter.com/1/users/profile_image?screen_name=@john_welch484819917Jorge NovoJorge Novo is a database developer with more than 10 years of experience in the design, implementation, and maintenance of OLAP, ROLAD database system for the enterprise. Jorge specialize himself on ETL processes using automation, and dynamic programming for SSIS. Currently Jorge is working in the programming and development of Data Master Service for the organization. @ETLDEVDBAhttps://www.linkedin.com/pub/jorge-novo/1/546/b70http://etldevelopernotes.blogspot.com/https://api.twitter.com/1/users/profile_image?screen_name=@ETLDEVDBA484821671Jorge SegarraJorge Segarra (aka SQLChicken) is an author, blogger, speaker, SQL Server MVP and community volunteer currently working as a DBA/BI Consultant for Pragmatic Works. Jorge has co-authored on several books including 'SQL Server 2012 Bible' and “SQL 2008 Pro Policy-Based Management“.He was also a Redgate Exceptional DBA of the Year 2010 Finalist.@sqlchickenhttp://www.linkedin.com/pub/jorge-segarra/7/a23/82bhttp://sqlchicken.comhttps://api.twitter.com/1/users/profile_image?screen_name=@sqlchicken484821839Josh LuedemanJosh is a Senior Consultant with The Glenture Group, focusing on Microsoft Business Intelligence, while expanding in to Big Data Technologies like Hadoop and Lucene. He has worked in IT for over 10 years holding positions in Application Support, Database Administration, and Business Intelligence, in industries like Higher Education, Manufacturing, and Software Development. He was also a tech editor on the book 'Microsoft Big Data Solutions'.@JoshLuedemanWww.linkedin.com/in/joshua.luedemanhttp://www.joshluedeman.comhttps://api.twitter.com/1/users/profile_image?screen_name=@JoshLuedeman484819959Lisa Jackson-NeblettI am a resident of Jacksonville, FL. I have spoke at several venues including but not limited to SQL Saturday, ITPro Camp and SQL Server User Groups. Additionally, I participated in the SQL PASS Clinic 'Ask the Expert'. I am currently a SQL Server Premier Engineer for Microsoft. I specialize in the SQL Server Engine. I also contribute to SQL Twist. http://www.sqltwist.com484819918Mark KromerMark Kromer is a Big Data Analytics architect and technical product manager, currently with Pentaho in Orlando. Mark has spent 20 years in the Data Warehouse, Business Intelligence and database field with Microsoft, Oracle and ATT. He is a frequent speaker, author and blogger at SQL PASS events, Microsoft events and at the SQL Server Magazine BI Blog.@mssqldudehttp://www.linkedin.com/in/markkromer http://mssqldude.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@mssqldude484819912Max TrinidadOriginally from Puerto Rico, since 1979 I’ve work with legacy systems, network infrastructure, databases, and currently working in Data Quality Support for a retail organization. I’m a Microsoft PowerShell MVP since 2008, SAPIEN MVP since 2010, and heavily involve with Florida’s IT Pro/SQLServer Communities.@MaxTrinidadhttp://www.linkedin.com/pub/max-trinidad/12/47/775http://www.maxtblog.com/https://api.twitter.com/1/users/profile_image?screen_name=@MaxTrinidad484819907Michael AntonovichMike Antonovich is the Asst Director Web Services for OCPS in Orlando, FL where he manages the SharePoint portal team. He is also responsible for multiple .Net custom applications used throughout the district. In June of 2010, he published his 7th book: Office and SharePoint 2010 User's Guide. Mike has been using SQL Server since 1998 and SharePoint since 2007. He has spoken at over 2 dozen SQL Saturday, Code Camp, etc. Last November he spoke at the PASS Summit on PowerPivot.@SharePointMikeAhttp://www.linkedin.com/in/michaelpantonovichhttp://sharepointmike.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SharePointMikeA484820191MIchael ReedMichael Reed has a long history of designing innovative solutions to difficult business problems. During the last 14 years he focused on database development and architecture, more recently business intelligence and analytics, and is currently employed by Pragmatic Works as a Senor BI Consultant. Previously he was Director of Insight and Analytics at a healthcare claim processor. Prior to that he held operations, data and information delivery centric roles in Microsoft’s Online Services Division@http://www.iheartbigdata.comhttps://api.twitter.com/1/users/profile_image?screen_name=@484821528Mike LawellMike Lawell is a Principal Consultant and Founding Member of SQL Server Associates, with over 17 years of experience in SQL Server. Mike holds the certification Microsoft Certified Solutions Associate (MCSA): SQL Server 2012.@SQLDiverhttp://www.linkedin.com/pub/mike-lawell/4/ba4/4b7/http://sqlserverassociates.com/https://api.twitter.com/1/users/profile_image?screen_name=@SQLDiver484819995Mike DavisMike Davis, MCITP, is a Managing Project Lead at Pragmatic Works. He is an author of several Business intelligence books. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, and SQL Saturday events. Mike has conducted over 200 interviews in the technology field.@MikeDavisSQLhttp://www.linkedin.com/in/mikedavissqlhttp://MikeDavisSQL.comhttps://api.twitter.com/1/users/profile_image?screen_name=@MikeDavisSQL484819989Mitchell PearsonMitchell Pearson is a Business Intelligence consultant for Pragmatic Works and is experienced developing and supporting business intelligence solutions utilizing SSIS, SSAS, and SSRS.@SqlLittleFriendhttps://api.twitter.com/1/users/profile_image?screen_name=@SqlLittleFriend484820895Nengah MustikaNengah Mustika started developing software in 2001. He earned his B.S. with double major in Computer Science and Business Administration from Shepherd University in 2004, and M.S. in Computer Science from University of North Florida in 2007. He is Microsoft Certified Professional Developer (MCPD .NET 4), and MCTS .NET 2.0. Mustika worked at Idea Integration for more than 9 years as .NET Consultant. In February of 2014, he works for his own consulting company named Agile Tech Consulting, LLC.@https://twitter.com/agile_infohttps://www.linkedin.com/profile/view?id=7646528http://www.agiletechconsulting.comhttps://api.twitter.com/1/users/profile_image?screen_name=@https://twitter.com/agile_info484821378Pam ShawPam Shaw has been in IT for over 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 Hillsborough SQL Users Group - a local chapter of PASS and organizer of SQL Saturday Tampa.@pamshawhttp://www.linkedin.com/in/pshaw1129https://api.twitter.com/1/users/profile_image?screen_name=@pamshaw484820387Robert BiddleRobert is a Data Architect with Hilton Grand Vacations. He's worked with SQL Server since 2004 and has worked on a variety of projects in administration, development, BI and data warehousing. He has MCITP DBA and Database Developer certifications in both 2005 and 2008.@robert_biddlehttp://robbiddle.wordpress.com/https://api.twitter.com/1/users/profile_image?screen_name=@robert_biddle484819934Robert CainRobert 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 4 books. A popular speaker, Robert has presented at events such as SQL PASS Summit, TechEd, SQL Rally, and numerous SQL Saturdays.@arcanecodehttp://www.linkedin.com/in/arcanecodehttp://arcanecode.comhttps://api.twitter.com/1/users/profile_image?screen_name=@arcanecode484820650Ronald DameronLead MSSQL DBA for largest life insurer in the USA. Current interests are: Database automation and database security.
@RonDBAhttps://www.linkedin.com/in/rdameronhttp://ronalddameron.blogspot.com/https://api.twitter.com/1/users/profile_image?screen_name=@RonDBA484819925Sandhya HawaldarTotal about 15 years’ of experience in Business Intelligence. Worked as BI Developer, Architect at corporates. MS certified. Currently Vice President of Yash Creations Inc. Jacksonville FL.http://www.linkedin.com/profile/view?id=30754558authType=OUT_OF_NETWORKauthToken=-t7alocale=en_USsrchid=108235611389717999844srchindex=1srchtotal=18820trk=vsrp_people_res_phototrkInfo=VSRPsearhttp://www.yashcreations.com484820013Shawn HarrisonShawn Harrison is a product specialist and former SSIS trainer with Pragmatic Works. He has extensive knowledge of SSIS and SSRS and has assisted hundreds of customers with BI solutions. Shawn is active in the SQL server community and presents at local SQL Server events.@ShawnBHarrisonhttp://www.linkedin.com/profile/view?id=8412372trk=tab_prohttp://www.bidn.com/blogs/shawnharrisonhttps://api.twitter.com/1/users/profile_image?screen_name=@ShawnBHarrison484821479Steve SchneiderSteve is a Microsoft Certified IT professional SQL Server Database Administrator and Systems Engineer. He has over 20 years experience in the IT field with a primary focus in SQL Server administration. He has focused experience in installation, configuration, performance tuning, disaster recovery and troubleshooting. He has handled single, large databases and multiple smaller databases spread out over multiple servers. Steve has an indepth knowledge of SQL, and is now focused in BI.www.linkedin.com/in/steveschneider1/http://sqlinsight.net/blog/484820156Troy GallantTroy has been a SQL Server professional for over 12 years, and has filled roles as DBA, developer, as well as business analyst. He is currently working as a Sr. SQL Server DBA for a international financial services organization out of New York City. When not DBA'ing, Troy enjoys live music, playing his mandolin, computer gaming, and exploring the craziness that is New York City.@GratefulDBAhttp://www.linkedin.com/pub/troy-gallant/6/202/269http://troygallant.comhttps://api.twitter.com/1/users/profile_image?screen_name=@GratefulDBA484820964Valentin IamandiValentin brings more than 10 years of database experience in tuning, architecture, backup, large data transaction, and more. He has a solid background in database analysis and development and his skills cover SQL Server and Oracle as well as a slew of different operating systems. Valentin fluently speaks English, French, and Romanian.
Valentin has a passion for performance and optimization and shares his experience on the topic in his blog http://logicalreads.wordpress.com/ http://logicalreads.wordpress.com/484819923Vikas HawaldarTotal about 20 years’ of experience in Business Intelligence. Worked as Sr. Architect, BI Manager at various corporates. MS certified. Currently President of Yash Creations Inc. Jacksonville FL.http://www.linkedin.com/profile/view?id=10823561authType=nameauthToken=pzg0locale=en_USpvs=pptrk=ppro_viewmorehttp://www.yashcreations.com48481990319903SQLSatruday 298BI (Auditorium 2)1202 (Building 50)Coffee Break5/10/2014 10:00:00 AM5/10/2014 10:15:00 AM1990319903SQLSatruday 298BI (Auditorium 2)1202 (Building 50)Coffee Break5/10/2014 1:00:00 PM5/10/2014 1:15:00 PM1990319903SQLSatruday 298BI (Auditorium 2)1202 (Building 50)Coffee Break5/10/2014 2:15:00 PM5/10/2014 2:45:00 PM1990319903SQLSatruday 298BI (Auditorium 2)1202 (Building 50)Coffee Break5/10/2014 3:45:00 PM5/10/2014 4:00:00 PM1990319903SQLSatruday 298DBA1406 (Building 50)Coffee Break5/10/2014 10:00:00 AM5/10/2014 10:15:00 AM1990319903SQLSatruday 298DBA1406 (Building 50)Coffee Break5/10/2014 1:00:00 PM5/10/2014 1:15:00 PM1990319903SQLSatruday 298DBA1406 (Building 50)Coffee Break5/10/2014 2:15:00 PM5/10/2014 2:45:00 PM1990319903SQLSatruday 298DBA1406 (Building 50)Coffee Break5/10/2014 3:45:00 PM5/10/2014 4:00:00 PM1990319903SQLSatruday 298BI1402 (Building 50)Coffee Break5/10/2014 10:00:00 AM5/10/2014 10:15:00 AM1990319903SQLSatruday 298BI1402 (Building 50)Coffee Break5/10/2014 1:00:00 PM5/10/2014 1:15:00 PM1990319903SQLSatruday 298BI1402 (Building 50)Coffee Break5/10/2014 2:15:00 PM5/10/2014 2:45:00 PM1990319903SQLSatruday 298BI1402 (Building 50)Coffee Break5/10/2014 3:45:00 PM5/10/2014 4:00:00 PM1990319903SQLSatruday 298BI1002 (Building 39)Coffee Break5/10/2014 10:00:00 AM5/10/2014 10:15:00 AM1990319903SQLSatruday 298BI1002 (Building 39)Coffee Break5/10/2014 1:00:00 PM5/10/2014 1:15:00 PM1990319903SQLSatruday 298BI1002 (Building 39)Coffee Break5/10/2014 2:15:00 PM5/10/2014 2:45:00 PM1990319903SQLSatruday 298BI1002 (Building 39)Coffee Break5/10/2014 3:45:00 PM5/10/2014 4:00:00 PM1990319903SQLSatruday 298DBA1404 (Building 50)Coffee Break5/10/2014 10:00:00 AM5/10/2014 10:15:00 AM1990319903SQLSatruday 298DBA1404 (Building 50)Coffee Break5/10/2014 1:00:00 PM5/10/2014 1:15:00 PM1990319903SQLSatruday 298DBA1404 (Building 50)Coffee Break5/10/2014 2:15:00 PM5/10/2014 2:45:00 PM1990319903SQLSatruday 298DBA1404 (Building 50)Coffee Break5/10/2014 3:45:00 PM5/10/2014 4:00:00 PM1990319903SQLSatruday 298DBA1400 (Building 50)Coffee Break5/10/2014 10:00:00 AM5/10/2014 10:15:00 AM1990319903SQLSatruday 298DBA1400 (Building 50)Coffee Break5/10/2014 1:00:00 PM5/10/2014 1:15:00 PM1990319903SQLSatruday 298DBA1400 (Building 50)Coffee Break5/10/2014 2:15:00 PM5/10/2014 2:45:00 PM1990319903SQLSatruday 298DBA1400 (Building 50)Coffee Break5/10/2014 3:45:00 PM5/10/2014 4:00:00 PM1990319903SQLSatruday 298Big Data (Auditorium 1)1102 (Building 50)Coffee Break5/10/2014 10:00:00 AM5/10/2014 10:15:00 AM1990319903SQLSatruday 298Big Data (Auditorium 1)1102 (Building 50)Coffee Break5/10/2014 1:00:00 PM5/10/2014 1:15:00 PM1990319903SQLSatruday 298Big Data (Auditorium 1)1102 (Building 50)Coffee Break5/10/2014 2:15:00 PM5/10/2014 2:45:00 PM1990319903SQLSatruday 298Big Data (Auditorium 1)1102 (Building 50)Coffee Break5/10/2014 3:45:00 PM5/10/2014 4:00:00 PM1990319903SQLSatruday 298Kids Camp1026 (Building 39)Coffee Break5/10/2014 10:00:00 AM5/10/2014 10:15:00 AM1990319903SQLSatruday 298Kids Camp1026 (Building 39)Coffee Break5/10/2014 1:00:00 PM5/10/2014 1:15:00 PM1990319903SQLSatruday 298Kids Camp1026 (Building 39)Coffee Break5/10/2014 2:15:00 PM5/10/2014 2:45:00 PM1990319903SQLSatruday 298Kids Camp1026 (Building 39)Coffee Break5/10/2014 3:45:00 PM5/10/2014 4:00:00 PM1990419904SQLSaturday 298Kids Camp1026 (Building 39)Lunch Break5/10/2014 11:15:00 AM5/10/2014 12:00:00 PM1990419904SQLSaturday 298Big Data (Auditorium 1)1102 (Building 50)Lunch Break5/10/2014 11:15:00 AM5/10/2014 12:00:00 PM1990419904SQLSaturday 298DBA1400 (Building 50)Lunch Break5/10/2014 11:15:00 AM5/10/2014 12:00:00 PM1990419904SQLSaturday 298DBA1404 (Building 50)Lunch Break5/10/2014 11:15:00 AM5/10/2014 12:00:00 PM1990419904SQLSaturday 298BI1002 (Building 39)Lunch Break5/10/2014 11:15:00 AM5/10/2014 12:00:00 PM1990419904SQLSaturday 298BI1402 (Building 50)Lunch Break5/10/2014 11:15:00 AM5/10/2014 12:00:00 PM1990419904SQLSaturday 298DBA1406 (Building 50)Lunch Break5/10/2014 11:15:00 AM5/10/2014 12:00:00 PM1990419904SQLSaturday 298BI (Auditorium 2)1202 (Building 50)Lunch Break5/10/2014 11:15:00 AM5/10/2014 12:00:00 PM1990519905SQLSaturday 298BI (Auditorium 2)1202 (Building 50)Registrations5/10/2014 8:30:00 AM5/10/2014 9:00:00 AM1990519905SQLSaturday 298DBA1406 (Building 50)Registrations5/10/2014 8:30:00 AM5/10/2014 9:00:00 AM1990519905SQLSaturday 298BI1402 (Building 50)Registrations5/10/2014 8:30:00 AM5/10/2014 9:00:00 AM1990519905SQLSaturday 298BI1002 (Building 39)Registrations5/10/2014 8:30:00 AM5/10/2014 9:00:00 AM1990519905SQLSaturday 298DBA1404 (Building 50)Registrations5/10/2014 8:30:00 AM5/10/2014 9:00:00 AM1990519905SQLSaturday 298DBA1400 (Building 50)Registrations5/10/2014 8:30:00 AM5/10/2014 9:00:00 AM1990519905SQLSaturday 298Big Data (Auditorium 1)1102 (Building 50)Registrations5/10/2014 8:30:00 AM5/10/2014 9:00:00 AM1990519905SQLSaturday 298Kids Camp1026 (Building 39)Registrations5/10/2014 8:30:00 AM5/10/2014 9:00:00 AM1990719907Michael AntonovichBI1402 (Building 50)Putting Quality Back Into Your Data AnalysisThis session introduces Data Quality Services, a feature introduced in SQL Server 2012. One of the challenges in developing Business Intelligence solutions is ensuring that the data does not have inconsistencies, incomplete records, invalid or inaccurate values, and data duplication. Sometimes when consolidating data from more than one source you have to transform data to create one standard set of domain values in a standard format. SQL 2012 answers this need with Data Quality Services (DQS). In this session, you will learn the basics of what DQS is and how it can be used to clean your data. You will see how to build a domain both manually and from an existing data table. You will then see how to use these domains to validate tables in SQL Server and Excel preparing them for use in SSAS and PowerPivot. After this session, you will understand how by putting quality back into your data, you can be your organization's BI hero.5/10/2014 9:00:00 AM5/10/2014 10:00:00 AM1991219912Max TrinidadDBA1404 (Building 50)Powershell Working with Windows Azure SQL Database ServerIn this presentation I will be covering how to subscribe to Azure, setup PowerShell to connect your subscription, use scripting to create a SQL Database Server and then use SMO with PowerShell push data to your SQL Azure tables. All this using PowerShell scripting plus showing some editor, scripting techniques, and tips to avoid issues when working and setting Azure with PowerShell. (Live demo with Windows Azure)5/10/2014 2:45:00 PM5/10/2014 3:45:00 PM1991719917Jorge NovoBI1002 (Building 39)ETL Frameworks using SSIS Programming with .NETEvery organization has to deal with the constant loading of text,csv,excel,pipe, fixed width, and ragged right files in this session we are going to build a metadata driving ETL framework that will dynamically create an standard SSIS template that will encompass the file format, enforce standards, and keep track of data lineage across an organization. 5/10/2014 1:15:00 PM5/10/2014 2:15:00 PM1991819918Mark KromerBig Data (Auditorium 1)1102 (Building 50)SQL Server and Big Data Projects in the Real WorldIn this session, I will skip past the Big Data 101 introductions and talk to you about specific Big Data projects that I have been involved with and how we've used Big Data technologies including Hadoop, MongoDB, Cassandra and Aster Data with SQL Server to create complex Big Data Analytics solutions. I've implemented solutions for Microsoft, Razorfish and Pentaho in this space and we're going to talk about solution architectures.5/10/2014 1:15:00 PM5/10/2014 2:15:00 PM1992319923Vikas HawaldarBI1002 (Building 39)Add power to SSAS Cube Using MDXThe presenter will provide some basic ideas about MDX and will demonstrate developing some commonly required effective calculated measures into an SSAS cube.5/10/2014 4:00:00 PM5/10/2014 5:00:00 PM1992519925Sandhya HawaldarBI1402 (Building 50)SSRS 2012 Introduction and CapabilitiesDuring this session the presenter will present an hands on session on basic steps to develop SSRS reports with some basic features. After this presentation the presenter will present several pre-built examples to show capabilities of SSRS like Conditional Formatting, Linked Reports, Sub Reports etc. as well as some advanced features like Custom Code. 5/10/2014 12:00:00 PM5/10/2014 1:00:00 PM1993419934Robert CainBI1402 (Building 50)So you think MDX is hard?A lot of people have this perception that MDX is difficult. It really isn't, when you understand what it is trying to accomplish under the hood. In this session we'll begin with a fundamental understanding of what MDX will do for you. Then we'll roll up our sleeves and dive into MDX code, starting from the simplest select statement and winding up building calculations you can put into your own SSAS Cubes.
5/10/2014 10:15:00 AM5/10/2014 11:15:00 AM1994019940Jeffrey GarbusDBA1406 (Building 50)Indexing for performanceLearn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session 5/10/2014 9:00:00 AM5/10/2014 10:00:00 AM1995919959Lisa Jackson-NeblettDBA1400 (Building 50)SQL Server Extended EventsThis session will cover extended events and how to use it for troubleshooting performance issues.5/10/2014 2:45:00 PM5/10/2014 3:45:00 PM1996019960Jason CarterDBA1400 (Building 50)Maintenance and Backups: Intro to Ola HallengrenThis session will provide an overview of the critically acclaimed SQL Server Maintenance Solution written and maintained by Ola Hallengren. If you're using Maintenance plans, you're started in the right direction, but Ola's solution is the Gold Standard for Maintenance scripts. We will review the options and show you how these scripts can leave you more at ease with your backup, database and index maintenance duties.5/10/2014 10:15:00 AM5/10/2014 11:15:00 AM1996319963Dmitri KorotkevitchDBA1400 (Building 50)From S to 3XL: Implementing Data Partitioning and Tiered StorageSupport of the large databases is not a trivial task. Large amount of data negatively impacts system performance and make administration and SLA compliance much more complicated. Data partitioning can help to solve those problems and reduce support and hardware cost. This session demonstrates various approaches of data partitioning available in SQL Server. It compares pros and cons of different partitioning techniques from performance, scalability and administration standpoints. The session also discusses how to reduce hardware cost by implementing tiered storage and demonstrates how to move data between filegroups and/or disk arrays keeping the system online in the different versions and editions of SQL Server. 5/10/2014 1:15:00 PM5/10/2014 2:15:00 PM1998919989Mitchell PearsonBI (Auditorium 2)1202 (Building 50)Introduction to SSIS, SQL 2012In this session we will walk through the development of a complete package. This demo heavy presentation will cover the differences between the control flow and the data flow. We will also focus on the most popular and widely used tasks in SSIS. Best practices willed be emphasized and we will also explore how to use variables and expressions to make the package dynamic.5/10/2014 9:00:00 AM5/10/2014 10:00:00 AM1999519995Mike DavisDBA1404 (Building 50)Mastering the Technology InterviewJoin Mike as he shows you how to be prepared for technology job interviews. Learn the do's and don'ts of interviewing for technology jobs. Learn what your resume says about you and your ability to grow. Learn how passion can overcome a lack of skills.5/10/2014 9:00:00 AM5/10/2014 10:00:00 AM1999819998Dustin RyanBI (Auditorium 2)1202 (Building 50)What The Tabular???Knowing how to build a Tabular model is one thing. Knowing how to build a Tabular model the right way is something completely different. In this session we’ll discuss how to decide if building a Tabular model is the right choice, how to build a Tabular model completely from scratch, best practices you should follow, and things to avoid. If you’re new to Tabular Modeling or wanting to learn best practices, this session is for you! 5/10/2014 1:15:00 PM5/10/2014 2:15:00 PM2001320013Shawn HarrisonBI (Auditorium 2)1202 (Building 50)SSIS Performance TuningSSIS is a powerful ETL tool, but by nature ETL developers are always looking for better performance. In this hour long presentation we will cover many basic options and features that you can use to performance tune any SSIS package. Who wouldn’t want better package performance?5/10/2014 10:15:00 AM5/10/2014 11:15:00 AM2015220152Chad ChurchwellDBA1406 (Building 50)Introduction to SQL Server ClusteringThis session s will provide an introductory into failover clustering of SQL Server, including when and why to cluster SQL. We will cover the required components and walk through how clustering works behind the scenes5/10/2014 4:00:00 PM5/10/2014 5:00:00 PM2015620156Troy GallantDBA1400 (Building 50)Indexing your Data WarehouseOne of the primary skill sets most database professionals are initially required to “master” is the art of proper indexing in our databases. We learn early on that an effective indexing configuration will go further in making our databases perform efficiently than probably any other single tuning technique. What’s not so commonly discussed though are the varying approaches one may wish to utilize when indexing your SQL Server enterprise data warehouse. This session will hopefully cause you to take a good look at your current indexing to see if indeed it could be operating even more efficiently.5/10/2014 12:00:00 PM5/10/2014 1:00:00 PM2019120191MIchael ReedBig Data (Auditorium 1)1102 (Building 50)Intro to Big DataThis is a primer for anyone not clear on what Big Data is and the basics of implementing a Big Data solution, focusing on the Microsoft HDInsight offering.5/10/2014 9:00:00 AM5/10/2014 10:00:00 AM2019220192Susan RickmanDBA1404 (Building 50)Can't we all just get along?There comes a point in every career that you will need to talk to people that you do not agree with. It is important to advancement (and well-being) that you are able to make concise points that will draw interest from other teams, as opposed to alienating them.
How do you speak to your leadership team? Your peers? People who depend on you? People on whom you depend?
5/10/2014 12:00:00 PM5/10/2014 1:00:00 PM2020120201Andy WarrenDBA1404 (Building 50)Building Your Professional Development PlanPlan the work and work the plan. Are you doing that when it comes to your professional development? Few of us have a formal approach to professional development and that usually means it gets pushed down the list as other things in life happen. This session is designed to get you thinking about all aspects of your career and from there moves into a discussion about time and money - how much of each are you willing to spend to get where you want to go? At the end of this presentation you'll be ready for spend a couple quiet hours charting all the things you want to do, and then figuring out which ones you really want to do.5/10/2014 10:15:00 AM5/10/2014 11:15:00 AM2038720387Robert BiddleBI1002 (Building 39)Detecting Changes in SQL ServerIn this session we'll look at methodologies for detecting data changes in SQL Server. We'll look mainly at Change Data Capture but will also cover row versioning as well as a few other methodologies.
5/10/2014 12:00:00 PM5/10/2014 1:00:00 PM2055020550Brian McDonaldBI1002 (Building 39)Rapid Data Warehouse Design and ETLSimply loading a data warehouse is only part of an ETL developers role. In this example driven session, Brian and Sherri will show you how to create and load a small data warehouse using SQL Server Integration Services. They will also show you how to make packages dynamic using variables and package configurations along with a few other 'nice to have tricks' to include in your ETL arsenal. At the end of this session, you will be ready to take on the world. Well, maybe not the world, but you will know how to load a data warehouse.5/10/2014 10:15:00 AM5/10/2014 11:15:00 AM2065020650Ronald DameronDBA1400 (Building 50)SQL Server Security Easy ButtonAttendees will learn how to define a permission set with a single script that allows your company’s DBAs to do routine work and how to elevate DBA permissions quickly to respond to production emergencies.
DBAs will leave this session with an easy to implement, low hassle solution that provides DBAs the minimum necessary access required to maintain the server but not be able to view user data.
In addition, I’ll talk about our DBA’s real world experience with reduced permissions
5/10/2014 9:00:00 AM5/10/2014 10:00:00 AM2079020790John WelchBig Data (Auditorium 1)1102 (Building 50)Moving Big Data - SSIS, Pig, and SqoopWondering about Hadoop, and how all that big data is going to be moved around? Or how you are going to move any of it into your SQL Server environment? Come to this session, and learn about some of the familiar and not so similar tools you can use for moving big data. We’ll compare the options, discuss how they can work with your existing Microsoft technologies, and provide some guidance on when to use each of the tools.5/10/2014 12:00:00 PM5/10/2014 1:00:00 PM2089520895Nengah MustikaBI1402 (Building 50)Working with Maps in Reporting ServicesIn this session, we are going to learn how to create Maps using Reporting Services. We will go over the detail of choosing a map file, linking a map to a dataset, visualizing data in a map, and Map elements (Viewport properties, projection, scales, legends, center points, and creating size rules).5/10/2014 1:15:00 PM5/10/2014 2:15:00 PM2096420964Valentin IamandiDBA1400 (Building 50)Ola Hallengren Maintenance - How to and Advanced configurationsOverview
Simple Use for novice DBA
Stored procedures settings and parameters
CommandLog table, why and how to use it to implement further tuning and optimizations
IndexOptimize Stored Procedure modifications for a better statistics maintenance
How to add parameters inline at the maintenance job execution time5/10/2014 4:00:00 PM5/10/2014 5:00:00 PM2125121251Chris SkorlinskiDBA1406 (Building 50)Check Engine LightsProblem with Windows server, IO storage or SQL Server stopped your business dead in its tracks? Together we'll explore 'check engine lights' for your SQL Server warning you of pending doom. I'll cover Performance Monitor, IO STACK, Dashboards, ErrorLogs, and DMVs to keep your server and SQL Server running smooth.5/10/2014 10:15:00 AM5/10/2014 11:15:00 AM2135221352Eric WisdahlDBA1404 (Building 50)Free tools from the SQL Server CommunityNo budget? That's OK! Need Tools? We've get them! Don't know where to go? We'll show you! The SQL Server community is one of the best around and has put out loads of free tools, videos, blogs, and other great ideas and information to help you out. In this session we will show you several great tools, scripts, blogs and other resources to help you out. Best of all, it's all free! But wait, there's more. Order now and we'll include an extra two tips at no additional cost!
5/10/2014 1:15:00 PM5/10/2014 2:15:00 PM2137821378Pam ShawBI1402 (Building 50)Tips Tricks for dynamic SSRS ReportsIn 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/10/2014 2:45:00 PM5/10/2014 3:45:00 PM2147921479Steve SchneiderBI (Auditorium 2)1202 (Building 50)SQL 2012 Empowers SharePoint BII will bring to life how SQL 2012 empowers the BI of SharePoint BI. Meaning...what parts of SQL yield what parts of SharePoint BI. Where are the SQL parts, where can you see and manage them? How does the consumer see them. How can you tell what the consumer is seeing? What tools are used to build what parts of SharePoint BI? Real-life examples of how SharePoint BI is implemented in the City of Jacksonville will be used as examples.5/10/2014 2:45:00 PM5/10/2014 3:45:00 PM2148021480Jason VirtueDBA1406 (Building 50)Breakthrough Data Platform Performance with SQL Server 2014This session covers the following topics: evolution of the data platform, mission critical performance, faster insights from any data, platform for hybrid cloud and complete data platform. SQL Server 2014 will go GA and be the first ones to see the new release.5/10/2014 2:45:00 PM5/10/2014 3:45:00 PM2149121491Adam JorgensenBig Data (Auditorium 1)1102 (Building 50)On-Demand Compute and Analytics with Powershell, Hadoop and AzureThis session will take the beginner in big data and show them how to use powershell, HDinsight and Microsoft's Azure platform to enable on demand analytic and compute. These capabilities are critical in the modern data warehouse environment and can only be delivered by technologies working together to create an analytic fabric that the organization can use. From developers the analysts and operations folks, this session will have something for all of you. 5/10/2014 2:45:00 PM5/10/2014 3:45:00 PM2152821528Mike LawellDBA1406 (Building 50)Performance Tuning for Mere MortalsPerformance tuning is a very large very scary task as an early DBA. This session will tackle the most important steps for getting started and go over some of the best free tools for getting started in the performance tuning specialty. Throughout this session will be demonstrations of how to leverage the free tools to identify performance issues.5/10/2014 1:15:00 PM5/10/2014 2:15:00 PM2155621556Joe SalvatoreBI1002 (Building 39)Fundamentals of Data Warehouse Architecture and DesignThis session will cover key ideas for organizing the hardware and software environment into appropriate logical and physical tiers in order to best support data warehouse extraction, staging, and data mart processes. Additionally the session will cover key differences in leading data warehouse architectures and will finish with a primer on dimensional modeling.5/10/2014 9:00:00 AM5/10/2014 10:00:00 AM2155721557Gareth SwanepoelDBA1406 (Building 50)SQL Server 2014 for the DBA SQL Server 2014 is the newest version of SQL Server available from Microsoft. This session is designed to introduce SQL Server DBA’s to some of the new and exciting features available in that version. Topics covered in this session include AlwaysOn enhancements, Clustered ColumnStore indexes, Memory-optimised tables (In-Memory OLTP, code-named Hekaton) and Extended Events enhancements.
The target of this session is SQL Server DBA’s, developers, architects or IT professionals who are excited about the new SQL Server 2014 features and are looking to learn more about them. This class assumes that you have average to good T-SQL skills already and a good understanding of SQL Server fundamentals. 5/10/2014 12:00:00 PM5/10/2014 1:00:00 PM2155921559Devin KnightBig Data (Auditorium 1)1102 (Building 50)Closing CeremonyClosing Ceremony5/10/2014 5:00:00 PM5/10/2014 5:30:00 PM2156021560Devin KnightKids Camp1026 (Building 39)Kids CampFor SQL Saturday attendees' children only (children 9-17). The students will get to create there own exciting games and robots while learning fundamental concepts or programming. Lunch will be included. The $10 fee holds your place but please email us if you wish to cancel. Parents will need to remain on campus at SQL Saturday while their kids are in the program. Space is limited so you must preregister your kids here. http://www.meetup.com/Jacksonville-SQL-Server-User-Group/events/171054562/5/10/2014 9:00:00 AM5/10/2014 10:00:00 AM2156021560Devin KnightKids Camp1026 (Building 39)Kids CampFor SQL Saturday attendees' children only (children 9-17). The students will get to create there own exciting games and robots while learning fundamental concepts or programming. Lunch will be included. The $10 fee holds your place but please email us if you wish to cancel. Parents will need to remain on campus at SQL Saturday while their kids are in the program. Space is limited so you must preregister your kids here. http://www.meetup.com/Jacksonville-SQL-Server-User-Group/events/171054562/5/10/2014 10:15:00 AM5/10/2014 11:15:00 AM2156021560Devin KnightKids Camp1026 (Building 39)Kids CampFor SQL Saturday attendees' children only (children 9-17). The students will get to create there own exciting games and robots while learning fundamental concepts or programming. Lunch will be included. The $10 fee holds your place but please email us if you wish to cancel. Parents will need to remain on campus at SQL Saturday while their kids are in the program. Space is limited so you must preregister your kids here. http://www.meetup.com/Jacksonville-SQL-Server-User-Group/events/171054562/5/10/2014 12:00:00 PM5/10/2014 1:00:00 PM2156021560Devin KnightKids Camp1026 (Building 39)Kids CampFor SQL Saturday attendees' children only (children 9-17). The students will get to create there own exciting games and robots while learning fundamental concepts or programming. Lunch will be included. The $10 fee holds your place but please email us if you wish to cancel. Parents will need to remain on campus at SQL Saturday while their kids are in the program. Space is limited so you must preregister your kids here. http://www.meetup.com/Jacksonville-SQL-Server-User-Group/events/171054562/5/10/2014 1:15:00 PM5/10/2014 2:15:00 PM2156021560Devin KnightKids Camp1026 (Building 39)Kids CampFor SQL Saturday attendees' children only (children 9-17). The students will get to create there own exciting games and robots while learning fundamental concepts or programming. Lunch will be included. The $10 fee holds your place but please email us if you wish to cancel. Parents will need to remain on campus at SQL Saturday while their kids are in the program. Space is limited so you must preregister your kids here. http://www.meetup.com/Jacksonville-SQL-Server-User-Group/events/171054562/5/10/2014 2:45:00 PM5/10/2014 3:45:00 PM2156021560Devin KnightKids Camp1026 (Building 39)Kids CampFor SQL Saturday attendees' children only (children 9-17). The students will get to create there own exciting games and robots while learning fundamental concepts or programming. Lunch will be included. The $10 fee holds your place but please email us if you wish to cancel. Parents will need to remain on campus at SQL Saturday while their kids are in the program. Space is limited so you must preregister your kids here. http://www.meetup.com/Jacksonville-SQL-Server-User-Group/events/171054562/5/10/2014 4:00:00 PM5/10/2014 5:00:00 PM2158321583Devin KnightBig Data (Auditorium 1)1102 (Building 50)Big Data PanelA panel of Big Data experts will take part in a discussion on the current and future state of Big Data5/10/2014 4:00:00 PM5/10/2014 5:00:00 PM2161421614Damu VenkatesanBI1002 (Building 39)DAX 101In this session, we will look at the new BI query language for PowerPivot and Tabular - DAX. This session will give you an introduction to Data Analysis eXpressions (DAX) and will provide you the necessary understanding to start using in your environment for data analysis. No prior experience with DAX is needed to attend this session.5/10/2014 2:45:00 PM5/10/2014 3:45:00 PM2165421654Bradley SchachtBI (Auditorium 2)1202 (Building 50)Interactive Reporting with Power ViewPower View provides users with the ability to create interactive visualizations inside SharePoint and Excel 2013. It provides users with an easy to use drag and drop interface to quickly and easily create tables, charts, scatter plots and maps. Power View is the go to self-service reporting tool in the Microsoft ecosystem that is full featured enough to provide in depth data exploration and easy enough that a sales person can use it! This session will guide you through the process of creating a Power View report that will leverage all the requirements to get you up and running as well as core functionality including slicers, filtering, animated scatter plots, tiles, cards, maps and cross-filtering data in different objects5/10/2014 4:00:00 PM5/10/2014 5:00:00 PM2167121671Jorge SegarraBI (Auditorium 2)1202 (Building 50)What is a BI DBA?Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment from a DBA perspective then check this session out!5/10/2014 12:00:00 PM5/10/2014 1:00:00 PM2172621726Bradley BallBI1402 (Building 50)Inside the Query OptimizerWhen it comes to SQL Server one of the biggest request you hear is “How can I make my Query Run FASTER!?”. The answer understanding the first step in that process Is understanding the Query Optimizer. Understanding the Optimizer beings with knowing the Rules. The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.5/10/2014 4:00:00 PM5/10/2014 5:00:00 PM2183921839Josh LuedemanBig Data (Auditorium 1)1102 (Building 50)Show me whatcha workin' with: Big Data EditionCongratulations. You've setup your Big Data environment with all the fun toys. You have Pig, Sqoop, and Hive all on your Hadoop cluster. You even got your data flowing in there properly. Now what? In this session we're gonna go over Data Mining tools to help you gain some insight from your data. Then, to bring it all together, we'll go over some easy ways to use common tools to show off all of this Big Data of yours, using tools that most have access to.5/10/2014 10:15:00 AM5/10/2014 11:15:00 AM2199221992Jason StrateDBA1404 (Building 50)Shredding XML in SQL ServerWhether your a DBA or a developer, you will eventually need to write a query transforms XML data into rows and columns. It's there in client data feeds, files shipped from customers, and underneath the covers of SQL Server's own execution plans. The fact is, it's there, and you need query that data. In this session, we’ll explore some of the basic methods for querying XML through XQuery. By the end of the session you’ll be equipped with the tools and understanding needed to tear apart any XML like an old pro.5/10/2014 4:00:00 PM5/10/2014 5:00:00 PM