SQLSaturday #698 - Nashville 20181/13/2018 12:00:00 AM500(GMT-06:00) SaskatchewanSQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #SQLSatNashMiddle Tennessee State University (MTSU)1301 East Main Street, MurfreesboroNashvilleTennessee 37132845Microsoft Corporation (GAP)Global SQLSaturday Partnerhttp://www.microsoft.com/en-us/server-cloud/products/sql-server/http://geeks.ms/johnbulla/wp-content/uploads/sites/199/2016/04/Microsoft_logo_2012.svg_.png601702085DataCore SoftwareGold Sponsorhttps://www.datacore.com/maxparallelhttps://2.bp.blogspot.com/-F8tuBkoFZdk/WoWRx6DFK6I/AAAAAAAABfg/OkGDR2OzZesOvgiY5D26FFuCkCdx-MhEwCLcBGAs/s1600/DClogo_Pantone_485C.png601702080Noxigen LLCGold Sponsorhttps://systemfrontier.comhttp://powershellsaturday.com/007/files/2014/01/System-Frontier-Logo-Vertical-Cyan.png601701817SentryOneGold Sponsorhttps://www.sentryone.com/http://sqlcruise.com/wp-content/uploads/2016/11/SentryOne-logo-300px.png601701588QuestSilver Sponsorhttps://www.quest.com/http://www.sqlsaturday.com/images/sqlsaturday/eventsponsors/Quest_170x60.png601701408TEKsystemsSilver Sponsorhttp://www.teksystems.com/https://www.teksystems.com/-/media/teksystems_com/Images/Logos/TEKsystems_logotype_RGB.png?h=35la=enw=174hash=6E1C244A79BA91199AE4E4B401EDBAA8AE9FCD55601701840Vaco NashvilleSilver Sponsorhttp://www.vaco.com/http://vacoorlando.com/home/vacoorlando/images/VACO_GLOBAL_CLR5.gif601702089Think Data Insights, LLCSilver Sponsorhttp://www.thinkdatainsights.comhttp://www.thinkdatainsights.com/wp-content/uploads/2016/04/TDI_logo_forweb60h.png601702002Redgate SoftwareSilver Sponsorhttp://www.red-gate.com/https://www.red-gate.com/assets/events/images/rg-logo.png601701134SQL WatchmenBronze Sponsorhttp://www.sqlwatchmen.comhttp://www.sqlwatchmen.com/images/logo.png601703IderaBronze Sponsorhttp://www.idera.com/Content/Home.aspxhttp://www.sqlsaturday.com/images/SQLSaturday/eventsponsors/IDERA170x60.png601701405COZYROCBronze Sponsorhttp://www.cozyroc.com/?utm_source=sqlviennapage2018utm_medium=bannerutm_campaign=sqlviennahttps://www.cozyroc.com/sites/default/files/cozyroc-big.png601702088SQLGreaseBronze Sponsorhttps://www.sqlgrease.comhttps://www.sqlgrease.com/Images/large-sqlgrease.png60170721InfoWorks, Inc.Bronze Sponsorhttp://www.infoworks-tn.comhttp://www.infoworks-tn.com/wp-content/uploads/2015/03/InfoWorksLogo170.png601701827Rezult GroupBronze Sponsorhttp://www.rezultgroup.com/http://www.rezultgroup.com/images/logo.png601701764Procure SQLBronze Sponsorhttp://procuresql.comhttp://procuresql.com/wp-content/uploads/2016/02/procure_logo-blackwords.png601701837SolidQ North AmericaBronze Sponsorhttp://www.solidq.comhttp://www.solidq.com/wp-content/uploads/2015/06/Logo-SolidQ-Web.gif6017084Pure StorageBronze Sponsorhttp://www.purestorage.comhttp://cdn.purestorage.com/blog/wp-content/uploads/2011/02/PureStorage-Logo-RGB-Small.png6017069580David MaxwellDavid Maxwell has over 15 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. David has been a frequent presenter at SQL Saturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals virtual chapter, the Performance virtual chapter, 24 Hours of PASS and the annual PASS Summit. David participates in his local Columbus Ohio PASS chapter, where he serves on the board of directors as SQL Saturday coordinator.https://twitter.com/dmmaxwellhttps://www.linkedin.com/in/davidmmaxwellhttps://dmmaxwell.wordpress.com/https://api.twitter.com/1/users/profile_image?screen_name=https://twitter.com/dmmaxwell484870429Kevin KlineKevin Kline is a database expert and Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS, author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Authors/KevinKline.@keklinehttp://www.linkedin.com/in/kekline/http://blogs.sentryone.com/author/kevinklinehttps://api.twitter.com/1/users/profile_image?screen_name=@kekline484869539Kevin WilkieKevin has 10+ years experience with SQL Server and has worked with the product since version 6.5, although he remembers with distaste the early versions of the product. He started working with SQL Server as an "Accidental" DBA, and has moved up through the ranks as a SQL Developer, a BI Associate, and Production DBA at various parts of his career. Currently, he works as a data consultant spreading the gospel of how great data can be to any one who will listen.@Oskaruthhttps://www.linkedin.com/in/kevinwilkiehttp://sherpaofdata.comhttps://api.twitter.com/1/users/profile_image?screen_name=@Oskaruth484870240Jon BoulineauJon Boulineau is an IT veteran who currently leads data integration teams for a major healthcare company. He speaks frequently at SQL Saturday events and local user groups in the South East. Primarily focused on data architecture and application development, his current work involves implementation of a real-time streaming data integration framework.@jboulineauhttps://www.linkedin.com/in/jonboulineauhttp://www.newsqlblog.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jboulineau484870102Mike RobbinsMike F Robbins is a Microsoft MVP on Windows PowerShell and a SAPIEN Technologies MVP. He is a co-author of Windows PowerShell TFM 4th Edition and is a contributing author of a chapter in the PowerShell Deep Dives book. Mike has written guest blog articles for the Hey, Scripting Guy! Blog, PowerShell Magazine, and PowerShell.org. He is the winner of the advanced category in the 2013 PowerShell Scripting Games. Mike is also the leader and co-founder of the Mississippi PowerShell User Group. He blogs at mikefrobbins.com and can be found on twitter @mikefrobbins.@mikefrobbinshttp://www.linkedin.com/in/mikefrobbinshttp://mikefrobbins.com/https://api.twitter.com/1/users/profile_image?screen_name=@mikefrobbins484869707Dave MattinglyDave Mattingly has spent thirty years of designing, developing, databasing, documenting, and directing a variety of projects in many industries. In the past, he’s worked on space travel, fraud prevention, data accuracy, and virtual reality for industries such as games, ecology, health, religion, and money. He also writes, publishes, orates, teaches, and preaches.@dave_mattinglyhttp://www.linkedin.com/in/blackwyrmhttp://www.davemattingly.nethttps://api.twitter.com/1/users/profile_image?screen_name=@dave_mattingly484872651John MorehouseJohn Morehouse is currently a Database Architect with Farm Credit Mid-America out of Louisville, KY. He is a blogger, avid tweeter, and a frequent speaker at SQL Saturday#39;s as well as other conferences. He is also heavily involved with the Professional Association of SQL Server (PASS). In his spare time, you can usually find John reading up on SQL Server topics as well as chasing his two young sons around the house.@SQLrUshttps://www.linkedin.com/in/sqlrushttp://www.sqlrus.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLrUs484869881John SterrettJohn Sterrett is a Microsoft Data Platform MVP, MCSE: Data Platform, Principal Consultant and the Founder of Procure SQL LLC. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and founder of the HADR Virtual Chapter.JohnSterretthttp://www.linkedin.com/in/johnsterretthttp://johnsterrett.comhttps://api.twitter.com/1/users/profile_image?screen_name=JohnSterrett484872038Kathi KellenbergerKathi Kellenberger is the Editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for almost 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.@auntkathihttp://www.linkedin.com/in/kathikellenbergerhttp://auntkathisql.comhttps://api.twitter.com/1/users/profile_image?screen_name=@auntkathi484870175Jim DonahoeJim is a Database Administrator with RDX. He lives in Pittsburgh in a small suburb. He loves working with all things Azure(ARM templates, DBaaS, SQL on IaaS). He is an avid collector of retro video games! He is a member of the Idera ACE program for 2018.@SQLFlipFlopsDBAhttp://www.sqlflipflopsdba.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLFlipFlopsDBA484872655Rodrigo MedeirosRodrigo has worked with databases for over 20 years and has designed and implemented MS-SQL Data Platforms and BI Solutions as a consutlant for e-commerce and finance companies. He is currently a Solutions Architect for DataCore Software.@rationalrodrigohttps://www.linkedin.com/in/1rodrigomedeiroshttps://api.twitter.com/1/users/profile_image?screen_name=@rationalrodrigo484869909Janis GriffinJanis Griffin has over 25+ years of DBA experience including design, development and implementations of many critical database applications. Before coming to SolarWinds over 11 years ago, Janis held DBA positions working with both real-time network routing databases and OLTP business to business applications. As a Principal Architect and Senior Manager, Janis has mentored many other DBAs on best practices in database performance tuning.@DoBoutAnythinghttp://www.linkedin.com/pub/janis-griffin/0/914/abahttp://logicalread.solarwinds.com/author/janis-griffin/#.VTkU2ZPs1mJhttps://api.twitter.com/1/users/profile_image?screen_name=@DoBoutAnything484870196Aaron NelsonAaron Nelson is an author, public speaker, blogger, leader in the community. He has over 15 years of experience in architecture, business intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.
Aaron leads the PowerShell Virtual Group of PASS ( SQLPS.io ), is a board member of PowerShell.org, and is a volunteer at his local PASS chapter, AtlantaMDF.@SQLvarianthttps://www.linkedin.com/in/sqlvarianthttp://sqlvariant.com/https://api.twitter.com/1/users/profile_image?screen_name=@SQLvariant484869976Daniel GlennDaniel is a Microsoft MVP and has been building technology solutions for more than 14 years. As Practice Leader for the Nashville-based InfoWorks, a total business solutions provider, he has helped organizations large and small solve complex challenges using every version of SharePoint throughout his career and has multiple technical certifications focusing on SharePoint and Office 365.
Daniel is passionate about building technical community with his roles as the co-founder and current President of the Nashville Office 365 SharePoint Users Group and Director of SharePoint Saturday Nashville. Connect with Daniel on Twitter at http://twitter.com/DanielGlenn and on his blog at https://DanielGlenn.com.DanielGlennhttps://www.linkedin.com/in/danielglennhttps://DanielGlenn.comhttps://api.twitter.com/1/users/profile_image?screen_name=DanielGlenn484869678Louis DavidsonLouis Davidson has worked in the IT industry for over 15 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 10 years and has written five books on database design. He has a bachelor#39;s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.drsqlhttp://www.linkedin.com/in/louisdavidsonhttp://sqlblog.com/blogs/louis_davidson/https://api.twitter.com/1/users/profile_image?screen_name=drsql484872597Jonathan StewartJonathan Stewart is a Business Intelligence Consultant specializing in data visualization, data warehousing and data management technologies. An advocate for educating others, Jonathan is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, Jonathan has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.
Jonathan maintains a blog at sqllocks.net/. He is a frequent speaker at local, national and international events and is a board member of the Columbus SQL Server User Group. In his free time, Jonathan works with the Mid-Ohio Regional Planning commission to help improve central Ohio.@sqllockshttps://www.linkedin.com/in/sqllocks/https://sqllocks.net/https://api.twitter.com/1/users/profile_image?screen_name=@sqllocks484869360Matt GordonMatt has worked with SQL Server since 2000 and has worked with versions up to and including SQL Server 2017. He is the leader of the Lexington, KY chapter of PASS, a frequent community speaker, and speaker at PASS Summit 2017. His original data professional role was as a database developer, but that quickly evolved into query tuning work which further evolved into being a full-fledged DBA in the healthcare realm. He has supported critical systems utilizing SQL Server across multiple data centers and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes those years of real world experience as a data platform consultant helping clients design deployment solutions that meet their ever-changing business needs.sqlatspeedhttps://www.linkedin.com/in/sqlatspeedhttp://www.sqlatspeed.comhttps://api.twitter.com/1/users/profile_image?screen_name=sqlatspeed484871885Josh LuedemanJosh is a Sr Consultant with Premier Support for Developers at Microsoft focusing on Microsoft's Data Platform, Hadoop and Azure. He has worked in IT for over 10 years holding positions in Application Support, Database Administration, and Business Intelligence, in industries like Higher Education, Consulting, Manufacturing, and Software Development.http://www.twitter.com/joshluedemanhttp://www.linkedin.com/in/joshluedemanhttp://www.joshluedeman.comhttps://api.twitter.com/1/users/profile_image?screen_name=http://www.twitter.com/joshluedeman484870220Chris HydeChris Hyde is an independent SQL Server BI and DBA consultant based in Albuquerque, NM, and is the leader of the Albuquerque PASS local user group. He is a part of the Friends of Redgate program and was recently named in the Idera ACE class of 2018. He loves loud music and cricket, but not usually at the same time.@ChrisHyde325https://www.linkedin.com/in/chris-hyde-3803706https://api.twitter.com/1/users/profile_image?screen_name=@ChrisHyde325484870058Tim WarnerI#39;m an IT Pro who#39;s based in Nashville, TN.http://twitter.com/techtrainertimhttps://linkedin.com/in/timothywarnerhttp://timwarnertech.comhttps://api.twitter.com/1/users/profile_image?screen_name=http://twitter.com/techtrainertim484869357Jamey JohnstonJamey Johnston is a Senior Data Scientist for a large independent oil and gas company. He currently works on data gathering, cleansing and statistical/predictive modeling using R, Python, and SAS. For the past 20 years, he has worked for Fortune 500 companies architecting successful databases and BI systems, and on Predictive Analytics. He holds a BS in Spatial Analysis from LSU and a Masters of Science in Analytics from Texas AM. He is active in his local SQL Pass chapter in Houston, speaking and volunteering at SQL Saturdays. He is an MS Data Platform MVP.@STATCowboyhttp://www.linkedin.com/in/jameyjhttp://STATCowboy.comhttps://api.twitter.com/1/users/profile_image?screen_name=@STATCowboy484871796John DeardurffFor over 15 years John has taught Microsoft SQL, Exchange, and Windows Server certification courses. He has been a database and networking consultant for over 20 years and currently holds over 45 Microsoft Certifications. He is an MCT Regional Lead for the Eastern United States and a Data Platform MVP.@John_Deardurffhttp://www.linkedin.com/in/JohnDeardurffhttp://www,ThatAwesomeTrainer.comhttps://api.twitter.com/1/users/profile_image?screen_name=@John_Deardurff484870499Tracy BoggianoTracy is a Database Administrator for ChannelAdvisor. She has spent over 20 years in IT and has been using SQL Server since 1999 and is currently certified as a MCSE Data Platform. She has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a Special Interest Group for Advanced DBA topics. She also is currently leading bring Linux content into the various virtual PASS groups.
Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.
Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org.@TracyBoggianohttps://www.linkedin.com/in/tracyboggianohttp://tracyboggiano.comhttps://api.twitter.com/1/users/profile_image?screen_name=@TracyBoggiano484870689Tim GormanTim Gorman is a technical consultant for Delphix who enable data virtualization to increase the agility of IT development and testing.
Tim has co-authored six books on data warehousing and Oracle database administration, has performed technical review on eight more books, and has an author#39;s page on Amazon.com (http://www.amazon.com/Tim-Gorman/e/B00BKCTO5E).
Tim is an Oracle ACE Director, which is roughly equivalent to an MS MVP, I think?@timothyjgormanhttps://www.linkedin.com/in/timgormanhttp://evdbt.comhttps://api.twitter.com/1/users/profile_image?screen_name=@timothyjgorman484870487Phil EkinsPhil Ekins is a Principal Architect at House of Brick Technologies. With over two decades of experience in SQL Server, Automation, Migrations, Virtualization and HA/DR Solutions. Phil has presented at SQL Saturday's and Local Chapters.@SQLPhilUKhttp://www.linkedin.com/en/philekinshttps://api.twitter.com/1/users/profile_image?screen_name=@SQLPhilUK484870672Luke CampbellSQL Server DBA for over 10 years focusing on the Healthcare industry. Previously a systems administrator, I made the jump to database administration after 6 years and haven't looked back. I enjoy performance tuning and automation.@Luke7621https://www.linkedin.com/in/luke-campbell-0568b75https://api.twitter.com/1/users/profile_image?screen_name=@Luke7621484870729Angela TidwellAngela Tidwell serves as the Marketing DBA for Procure SQL, LLC with a specialty for database performance monitoring and tuning. She's worked for clients with various architectures and volume, presenting various types of issues to be resolved in order to keep their business thriving. When she's not helping her clients resolve their biggest problems, Angela supports SQL Saturdays across the country and blogs about her experience in order to help other data professionals grow. Armed with a zest for life and quick wit; her experiences and unique views on the world provide the backdrop for a plethora of great stories.@angelatidwellhttp://www.linkedin.com/in/angela-tidwell-28a11528https://www.procuresql.com/blog/https://api.twitter.com/1/users/profile_image?screen_name=@angelatidwell484869432Kevin FeaselKevin Feasel is a Data Platform MVP and Engineering Manager of the Predictive Analytics team at ChannelAdvisor, where he specializes in T-SQL and R development, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), a contributing author to Tribal SQL (http://www.tribalsql.com), and one of the contributors behind We Speak Linux (https://wespeaklinux.com). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.@feaselklhttps://www.linkedin.com/pub/kevin-feasel/7/716/504http://www.catallaxyservices.comhttps://api.twitter.com/1/users/profile_image?screen_name=@feaselkl484871921Rowland GoslingRowland is an accomplished technology professional serving the health care, financial services, publishing, manufacturing, agriculture and aerospace industries. Rowland has a multi-platform background that includes UNIX, Linux, Windows and Netware. His focus on data stretches across many data solutions using SQL Server on both on-premises and Azure, Hadoop, Postgres, MySql and Oracle to name a few. @BigSQLhttps://www.linkedin.com/in/rgoslinghttps://gmdatadotcom.wordpress.com/https://api.twitter.com/1/users/profile_image?screen_name=@BigSQL484870601Pat PhelanPat Phelan first joined a computer user group (DECUS) in High School, and has joined many more since then. Pat worked many jobs in high school and college, and over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team. Involta builds, owns and operates world class colocation datacenters and also provides managed services and support staff to clients.@YetAnotherSQLhttps://www.linkedin.com/in/phelanphttps://api.twitter.com/1/users/profile_image?screen_name=@YetAnotherSQL484870193Spencer SwindellSpencer Swindell is a Senior Business Intelligence Architect with Think Data Insights, LLC. Think Data Insights a consulting group based out of Nashville, TN that works with companies to implement and maintain their Enterprise Data Platform. Since graduating from Tennessee Tech in 2011, he has built and delivered solutions for numerous organizations in the Nashville area utilizing SQL Server and the Microsoft BI Toolset. Spencer lives in Mount Juliet with his wife and son.@SpencerSwindellhttps://www.linkedin.com/in/spencerswindell/https://api.twitter.com/1/users/profile_image?screen_name=@SpencerSwindell484872783SQLSaturday NashvilleSQLSaturday Nashville@SQLSatNashhttp://www.sqlsatnash.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLSatNash484869960Karen NelsonMexican psychologist girl with an awesome data nerd husband, mom of 2 incredible boys: David and Teddy. Experienced in corporate word, School system with tons of experience in private practice.@KONelson9https://api.twitter.com/1/users/profile_image?screen_name=@KONelson9484871794Andy YunAndy Yun is a SentryOne Senior Solutions Engineer and a Microsoft MVP. He has been working with SQL Server for over 15 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQL Saturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQL Saturday Organizing Committee.@SQLBekhttp://www.linkedin.com/in/sqlbekhttp://sqlbek.wordpress.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLBek484870654Je'Anna Lanza-AbbottDr. Je’Anna Lanza-Abbott holds the Spec’s Charitable Foundation Endowed Professorship in Social Responsibility at the University of Houston. She has a joint appointment with the Conrad N. Hilton College and the C.T. Bauer College of Business. She teaches primarily in the areas of hospitality business law, organizational behavior/conflict management, and negotiations. She has written multiple refereed articles in these areas, as well as two textbooks.
She has multiple advanced degrees including: JD and LLM from University of Houston (UH), MBA from University of Chicago, MS in Analytics from Texas AM and PhD in Management Science from UH Bauer College of Business.@STATWonderWomanhttp://www.linkedin.com/in/jeannaabbotthttps://api.twitter.com/1/users/profile_image?screen_name=@STATWonderWoman484870721Cathrine WilhelmsenCathrine loves teaching and sharing knowledge. She works as a consultant, technical architect and developer, focusing on Data Warehouse and Business Intelligence projects. Her core skills are ETL, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she's active in the SQL Server and PASS communities as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.@cathrinewhttps://www.linkedin.com/in/cathrinewilhelmsenhttps://www.cathrinewilhelmsen.net/https://api.twitter.com/1/users/profile_image?screen_name=@cathrinew484871791Ben MillerBen has been a member of the SQL Server Community since 2000. He is currently working at MaritzCX revolutionizing the SQL Server environment and loving it. He also consults on SQL Server problems. He is a SQL Server MVP a SQL Server 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 and uses SMO and PowerShell regularly. He teaches DBAs how to use PowerShell as well.@DBAduckhttp://www.linkedin.com/in/dbaduck/https://dbaduck.comhttps://api.twitter.com/1/users/profile_image?screen_name=@DBAduck484870604Geoff HitenMicrosoft MVP Geoff Hiten is a Senior Architect for Intellinet. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in highly available SQL systems, performance tuning, and systems migration. Geoff is heavily involved in the Microsoft SQL Server Community and was initially awarded MVP status in 2004. Geoff was appointed in 2011 to fill an interim Director position at the National PASS organization. SQLCraftsmanhttps://www.linkedin.com/in/geoffhitenhttps://api.twitter.com/1/users/profile_image?screen_name=SQLCraftsman484870711Amy HeroldAmy Herold is currently a Sr. Database Administrator with One Technologies in Dallas, specializing in PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQL Saturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.texasamyhttp://www.linkedin.com/in/aheroldhttp://www.sqlkitten.com/https://api.twitter.com/1/users/profile_image?screen_name=texasamy484870107Arthur Daniels IIIArthur Daniels has worked on SQL Server for four years, spending most of his time focusing on developing queries and improving performance. He focuses on managing indexes and queries for large SQL Server databases.ArthurDanSQLhttp://www.DBA-Art.comhttps://api.twitter.com/1/users/profile_image?screen_name=ArthurDanSQL484869379Anthony NocentinoMeet Anthony Nocentino, Enterprise Architect, Founder and President of Centino Systems, Pluralsight Author, Microsoft Data Platform MVP, Linux Expert, Corporate Problem Solver, and a voracious student of the latest computer science technology. Anthony is only satisfied when he finds the right technology resolution for his client's business needs. He designs solutions, deploys the technology, and provides expertise on business system performance, architecture, and security. Anthony has a Bachelors and Masters in Computer Science and is working towards a PhD focusing on high performance/low latency data access algorithms on solid state disks and spatial database systems.@nocentinohttps://www.linkedin.com/in/nocentinohttp://www.centinosystems.com/blog/https://api.twitter.com/1/users/profile_image?screen_name=@nocentino484871886Josh LuedemanJosh is a Sr Consultant with Premier Support for Developers at Microsoft focusing on Microsoft's Data Platform, Hadoop and Azure. He has worked in IT for over 10 years holding positions in Application Support, Database Administration, and Business Intelligence, in industries like Higher Education, Consulting, Manufacturing, and Software Development.http://www.twitter.com/joshluedemanhttp://www.linkedin.com/in/joshluedemanhttp://www.joshluedeman.comhttps://api.twitter.com/1/users/profile_image?screen_name=http://www.twitter.com/joshluedeman484870524Wendy PastrickWendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.@wendy_dancehttp://wendyverse.blogspot.comhttps://api.twitter.com/1/users/profile_image?screen_name=@wendy_dance484870698Bob PusateriBob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years experience on SQL Server. His interests involve internals, performance optimization and cloud technologies. He is an active member of both Chicago-area chapters of PASS, a community speaker, and maintains a web presence through both twitter (@SQLBob) and his blog (bobpusateri.com).@SQLBobhttp://www.linkedin.com/in/bobpusaterihttp://www.BobPusateri.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLBob484870743Rob VolkRob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. An MCSE, he also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.sql_rhttps://www.linkedin.com/in/rob-volk-134ba81http://weblogs.sqlteam.com/robv/https://api.twitter.com/1/users/profile_image?screen_name=sql_r484870758Mike LawellMike Lawell is an 19 year veteran of SQL Server, working with all versions since 6.5. He specializes in performance tuning and high availability as an independent consultant.
He is a Linchpin People Teammate, he also consults with SolidQ, Intellinet and Microsoft Consulting Services.
He is also a certified Scuba instructor with a long bucket list of dive sites.
He resides in Atlanta, GA and you can catch him at many of the SQLSaturdays in the SE region of the United States.@sqldiverhttps://www.linkedin.com/in/mikelawellhttp://sqlserverassociates.com/Bloghttps://api.twitter.com/1/users/profile_image?screen_name=@sqldiver484871512Dan EvansBio: Daniel Richard Evans is a Data and Analytics evangelist with 25 years’ experience deploying strategic and innovative solutions. He’s spent over two decades working directly on Microsoft technologies dating back to SQL Server 6.5. Current focuses include SQL Server, SharePoint, Office 365, Power Query, PowerPivot, Power View, Power Map, Machine Learning, Cortana Analytics, IoT Suite and many other Azure Data Management assets. Dan presents at many local, regional and national events including SQL PASS, DAMA, TDWI, TechEd and Ignite.@danthebimanhttp://www.linkedin.com/in/drevans02https://api.twitter.com/1/users/profile_image?screen_name=@danthebiman484872864Kevin KlineKevin Kline is a database expert and Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS, author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Authors/KevinKline.@keklinehttp://www.linkedin.com/in/kekline/http://blogs.sentryone.com/author/kevinklinehttps://api.twitter.com/1/users/profile_image?screen_name=@kekline484872367Bradley BallBradley Ball is a SQL MVP with about 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. He is the data platform management lead with Pragmatic Works and a Microsoft VTSP. He has presented at SQLSaturday, SSUGs, SQLRally, DevConnections, SQLBits, SQL Live 360, and PASS Summit. Bradley can be found blogging at http://www.SQLBalls.com.@SQLBallshttps://www.linkedin.com/in/sqlballshttp://www.sqlballs.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLBalls484869386Kellyn Pot'Vin-GormanKellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Oracle ACE Director alumnus. She is the Technical Intelligence Manager at Delphix, a company recognized for it's impressive virtualization and data masking environment capabilities. Kellyn is known for her extensive work with multi-database platforms, DevOps, cloud migrations, virtualization, scripting, environment optimization tuning, automation and architecture design.
Kellyn has spoke at numerous technical conferences for Oracle, Big Data, DevOps, Testing and SQL Server. Her blog, http://dbakevlar.com and social media activity under her handle, DBAKevlar is well respected for her insight and content.@DBAKevlarhttps://www.linkedin.com/in/kellynpotvinhttp://dbakevlar.comhttps://api.twitter.com/1/users/profile_image?screen_name=@DBAKevlar484870732Lance TidwellLance Tidwell works as a multi-hatted DBA for TicketCity.com for the last 10 years in Austin,TX. Where he has had to work on many sides of the database from development to creating backup/restore strategies as well as performance tuning.@Lance_LThttp://lancetidwell.comhttps://api.twitter.com/1/users/profile_image?screen_name=@Lance_LT484870707Hope FoleyHope Foley, a SQL Server MVP with over 13 years of experience in the IT world, has worked across many industries including insurance, health organization, and federal government. She joined team at BlueGranite as a Business Intelligence consultant. She has been a consultant in SQL Server technologies for over 7 years focusing on database administration and architecture. Hope is an active member in the SQL Server and PASS communities speaking at events and organizing them. hope_foleyhttp://www.linkedin.com/in/hopefoley/http://www.hopefoley.comhttps://api.twitter.com/1/users/profile_image?screen_name=hope_foley484870755Jason HornerJason Horner is a Microsoft Certified Master of SQL Server and has worked with it for more than 10 years. He began work as a DBA/Application Developer in 1999. He made the transition to delivering BI solutions in 2002 and began working with spatial data in 2008. Jason’s latest focus has been architecting large-scale spatially enabled BI solutions.@jasonhornerhttp://www.linkedin.com/in/jasonhornerhttp://blog.jasonhorner.comhttps://api.twitter.com/1/users/profile_image?screen_name=@jasonhorner484871892Gareth SwanepoelGareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 25 years. He enjoys solving the complex problems that customers encounter when performance tuning SQL Server or when deploying SQL Server in large data warehouse environments. He is originally from South Africa and is currently a Dedicated Support Engineer (PFE) with Microsoft. He is a passionate member of the SQL Server community and is an accomplished author and speaker having presented at various user groups, SQL Saturdays, the PASS Summit and other technical conferences.@GarethSwanhttp://mygareth.comhttps://api.twitter.com/1/users/profile_image?screen_name=@GarethSwan484870593Elizabeth NobleElizabeth is a SQL Server DBA in the metro Atlanta area where she uses her knowledge of SQL Server development and administration to identify and solve production level issues.@SQLZeldahttps://www.linkedin.com/in/elizabeth-a-noblehttps://api.twitter.com/1/users/profile_image?screen_name=@SQLZelda484870706Lowry KozlowskiLowry Kozlowski is a SR SQL DBA and SR Consultant for SWC Technology Partners. Been involved with SQL for 17 years. Co-Leader of the Chicago Suburban SQL User group. Part of the SQL Saturday team for Chicago. Love SQL, photography, solving problems and trying new food. Goal in life is to minimize off hours calls by proactive work on systems.@lowrykozhttps://www.linkedin.com/in/lowrykoz/https://api.twitter.com/1/users/profile_image?screen_name=@lowrykoz484870751Henry TreftzI have worked with SQL Server since the mid 90's starting with SQL Server 4.21 running under OS/2. I have worked as a developer, designer, and DBA for a variety of organizations, ranging from trading firms, real estate services companies a water testing lab as well as software companies.
As part of my past, I spent 8 years working on systems that were either designed from the ground up to be installed as third-party applications or designed as internal products that were later bundled and sold as applications to customers.
I also spent some time in .com land and though I did not end up a millionaire I did end up with some great stories.@HenryThttps://api.twitter.com/1/users/profile_image?screen_name=@HenryT484871795SQLSaturday NashvilleSQLSaturday Nashville@SQLSatNashhttp://www.sqlsatnash.comhttps://api.twitter.com/1/users/profile_image?screen_name=@SQLSatNash484870480Ed WatsonEd Watson is the Ambassador of Mayhem for Innovative Architects, a full-stack Microsoft consulting firm in Atlanta. Ed is also a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Although he started as a programmer with Delphi, Visual Basic, and Progress 4GL for UNIX and Windows, Ed became a DBA for years before finally making the jump to the Business Intelligence bandwagon. He currently lives in Atlanta and is active with the Atlanta MDF and BI user groups.http://twitter.com/SQLGatorhttp://www.linkedin.com/in/watsonedhttp://sqlgator.comhttps://api.twitter.com/1/users/profile_image?screen_name=http://twitter.com/SQLGator484870656Rie IrishRie is a single Mom raising her beautiful daughter in North Georgia. She has been a SQL Server DBA for the last 14 years. She#39;s worked in many industries including the non-profit sector, big pharma, federal contracting and payment processing. She is very involved with the Atlanta MDF User Group and helps plan their SQL Saturday.@IrishSQLhttp://www.linkedin.com/pub/rie-irish/2/34a/78/https://api.twitter.com/1/users/profile_image?screen_name=@IrishSQL484870727Michael FalMike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently.
Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.@Mike_Falhttps://www.linkedin.com/in/michaelfal/http://mikefal.nethttps://api.twitter.com/1/users/profile_image?screen_name=@Mike_Fal48486938669386Kellyn Pot'Vin-GormanDatabase Administration S316DevOps for the DBADevOps came out of the Agile movement and the idea that operations needed to be part of the solution for agile development to be successful. The DBA was often the most resilient and robust member of the operations team and most resistant to change. This mentality was essential to the protection of company’s critical production data.
This session discusses common database challenges and how they can be minimized or solved with newer DevOps practices without impacting the DBAs “safe zone”. We’ll discuss how to use these vital skills and motivate everyone towards solutions for more success in agile development environments. Development, testing, provisioning, patching, upgrading and managing will become easier with agile tools, virtualization and collaboration.
The take-aways from this session are to embrace DevOps basics with a “DBA twist” such as:
• Develop, Rinse, Repeat
• Test Until Your Five Year Old Can Do It
• Human Intervention Creates Human Error- Automate EVERYTHING.1/13/2018 9:45:00 AM1/13/2018 10:45:00 AM6935769357Jamey JohnstonBI Analytics and Visualization S276Code Like a Snake Charmer - Intro to Python!Python is the one of the most popular programming languages used today and one of the most useful tools in the data scientist's tool belt especially for machine learning. Python is integrated into the Microsoft stack in tools like Azure ML and now SQL Server 2017.
The session will be an introduction to the Python language including:
1.) Installing and Configuring Python
2.) Access and Manipulate Data
3.) Install and Manage Packages
4.) Create and Use Objects/Variables
5.) Control Flows and Functions
6.) Managing the Python installation in MSSQL
Attend this session to learn how to use Python to take your data analytics to the next level. We will use Python, SQL Server and the Anaconda distribution of Python to learn the basics of Python and how it is integrated in the Microsoft stack! We will walk through a simple deployment of a machine learning model to see how it all works together and learns some basic data science fundamentals.
No prior statistics knowledge needed.1/13/2018 9:45:00 AM1/13/2018 10:45:00 AM6967869678Louis DavidsonDatabase Application Development S270How to Implement a Hierarchy in SQL ServerOne of the most common structures you will come across in the real world is a hierarchy (either a single parent "tree" or a multi-parent "graph"). Many systems will implement the obvious examples, such as a corporate managerial structure or a bill of materials. It turns out that almost any many-to-many relationship can be used as a hierarchy to find the relationship of parent rows to child rows (for example, the relationship of actors to movies they’ve been in). In this session, we’ll discuss several different implementations of hierarchies that you can use to optimize your hierarchy implementations, including SQL Server 2017's graph tables, and put into practice immediately, with ready-made T-SQL examples.1/13/2018 11:00:00 AM1/13/2018 12:00:00 PM6958069580David MaxwellDatabase Application Development S274Working with Temporal Data in SQL ServerIn many industries, it is necessary for data professionals to be able to show what a data set looked like at a previous point in time. Whether it's calculating tax or insurance rates based on a contract date, quickly comparing data changes over time for trend analysis or just recovering from an accidental data change, it's useful to be able to look back in time through our data. SQL Server has long offered solutions like Change Data Capture or trigger-based audit tables, though those aren’t always the best solutions for each situation. SQL Server 2016 introduces system-versioned tables, which track data through time with far less overhead than other solutions. In this session, you'll learn how to work with tables for each kind of solution, how SQL Server manages data within those tables, and how to query data at a specific point in time using several real-world examples. Attendees will leave with a fundamental understanding of practical use cases for different types of temporal tables.1/13/2018 1:30:00 PM1/13/2018 2:30:00 PM6990969909Janis GriffinDatabase Administration S213HiHo! HiHo! SQL Server on Linux, We Go!SQL Server has been running on Windows for years. Now Microsoft is making it available on Linux in order to provide a consistent database platform across Window and Linux servers, as well as on-premises and in the cloud. In this presentation, Janis Griffin, database performance evangelist at SolarWinds, will discuss the advantages of using SQL Server on Linux, comparing architecture, cost and performance. Several demonstrations on installing and maintaining SQL Server on Linux will be shown along with an introduction of several useful Linux commands.
The participant will learn:
1. The advantages of using SQL Server on Linux, comparing architecture, cost and performance to Window servers.
2. How to install, maintain and backup SQL Server on Ubuntu Linux systems
3. Several useful Linux commands to monitor/manage SQL Server1/13/2018 9:45:00 AM1/13/2018 10:45:00 AM6988169881John SterrettDatabase Administration S309Successfully Migrating Existing Databases to Azure SQL DatabaseFirst impressions have long-lasting effects. When dealing with an architecture change like migrating to Azure SQL Database the last thing you want to do is leave a bad first impression by having an unsuccessful migration. In this session, you will learn why Azure SQL Database might be for you. Next, you will learn how to test migrations for compatibility issues before you start the migration process. You will learn how to successfully migrate your database schema and data. Finally, you will learn how to determine which performance tier is a good starting point for your existing workload and how to monitor your workload over time to make sure your users have a great experience while you save as much money as possible.1/13/2018 9:45:00 AM1/13/2018 10:45:00 AM6996069960Karen NelsonProfessional DevelopmentS279Why am I able to master several technology languages but I struggle in my own business language?Technology people are well known to be focused, results motivated, introvert, etc. 95% of your time is spent “communicating” successfully with computers: programming, building databases, analizing, etc. If something is wrong an alert window will pop up. The problem is that human interaction doesn’t have any warning sound to do it all over again or make some changes. Most of the time we only have one chance to do it right.
The struggles shows in a workplace filled with employees of different backgrounds or cultures, with different native languages that convey to speak English as the business language. Plus the fact that we don’t have the right skills to communicate appropriately.
The problems will inevitably arise during human interaction; what we can do is try to minimize the frustration that it takes to communicate efficiently. In this session we will be able to learn that communication is not just a given fact, is something that needs to be learnt and taught.1/13/2018 11:00:00 AM1/13/2018 12:00:00 PM7024070240Jon BoulineauBI Architecture Management S279ETL Architecture for Real-Time BIFor decades batch processing has been the defacto standard for Extract Transform and Load. For most of that time 24 hour data refresh cycles were accepted as part of Business Intelligence solutions and developer skill sets have long depended upon the reliable patterns of batch. In recent years, however, demands have begun to shift. New use cases in every industry are now causing leading edge BI solutions to demand much shorter time to realizing value. The old architecture, skills, and tools are proving insufficient to meet this demand. In this session we will look at the fundamentals of architecting real-time BI solutions, including the new categories of problems for which we will now have to solve. Upon completing the session attendees will have a clear picture of the new skills and patterns that must be learned in order to excel in the next phase of Business Intelligence evolution.1/13/2018 9:45:00 AM1/13/2018 10:45:00 AM7017570175Jim DonahoeCloud Database/Application Development Deployment S274Getting started with SQL Azure Database: What you need to knowAzure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore.
In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible.
By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.1/13/2018 11:00:00 AM1/13/2018 12:00:00 PM7042970429Kevin KlineDatabase Administration S334End-to-End Troubleshooting Checklist for SQL ServerLearning how to detect, diagnose and resolve performance problems in SQL Server is tough. Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.
In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:
• XEvents, Profiler/Traces, and PerfMon
• Using Dynamic Management Views (DMVs)
• Advanced Diagnostics Using Wait Stats
• Reading SQL Server execution plan
Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.1/13/2018 11:00:00 AM1/13/2018 12:00:00 PM7048770487Phil EkinsDatabase Administration S275SQL Sprawl - How to get a handle on your InfrastructureThis Session will give you the tools to assess your existing SQL Deployments, physical or virtual.
Determine what’s being installed without (or without) your knowledge.
How are they being utilized resource wise and how are they licensed.
Then determine what can be combined, right sized or retired and does your existing licensing make sense.
This will provide a road-map to make a case for virtualization (if you’re not there yet) or just to get a handle on your SQL Sprawl.1/13/2018 8:30:00 AM1/13/2018 9:30:00 AM7067270672Luke CampbellPowerShell S270Automate your SQL Server installs and configurations using Powershell Desired State ConfigurationDatabase administrators are being tasked with managing a large number of SQL Server instances. These instances can be built on premise, virtualized, physical, or in the cloud. With Powershell Desired State Configuration, DBAs can not only automate the installation of SQL Server, but also any specific configurations needing to be applied to each new instance. Powershell DSC provides a repeatable process to ensure all builds are done in the exact same way. We'll cover what is Powershell Desired State Configuration and how a DBA can take advantage of it. Next, we'll dive straight into a demo of the installation and configuration of two SQL Server instances from scratch.
Some powershell experience is recommended.1/13/2018 8:30:00 AM1/13/2018 9:30:00 AM7060170601Pat PhelanProfessional DevelopmentS272Ethics, Morals, and Laws for the DBA 101Ethics, Morals, and Laws each govern one aspect of our behavior as people and DBAs. They govern which actions we take and which actions we avoid.
Understanding the basics of these guides and how they coordinate (and sometimes conflict) with each other helps you to make choices you can live with from both a personal and professional perspective.
This session presents basic definitions, ideas, and discussion points. It is intended to be an interactive presentation where the audience contributes to the discussion, so no two presentations are exactly the same!1/13/2018 2:50:00 PM1/13/2018 3:50:00 PM7070770707Hope FoleyCloud Database/Application Development Deployment S274AI to the Masses! But How? Pixie Dust?The way you hear about artificial intelligence, it seems like you throw some big data in the cloud and wave a magical AI wand over it and you can predict the future…right? Not exactly. Azure does have some great options to bring data science to your data but you need to weigh the options. In this session we'll discuss those options and some questions to answer if you're being tasked with making magical things happen with your data.1/13/2018 2:50:00 PM1/13/2018 3:50:00 PM7049970499Tracy BoggianoDatabase Administration S334Query Store PrimerThis session will take a look at the new Query Store feature in SQL Server 2016. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse. We will take a hands on look at how to use Query Store to troubleshoot problems new features in 2017.1/13/2018 1:30:00 PM1/13/2018 2:30:00 PM7068970689Tim GormanCloud Database/Application Development Deployment S305Reducing The Surface Area Of Risk in Data SecurityData obfuscation, also known as data masking, is soon a new legal requirement. Masking is the solution for non-production systems (i.e. DEV, TEST, etc) to greatly reduce the surface area of risk for data breach in your organization. Masking should not be confused with encryption, which is an appropriate solution for production applications. Those who believe that encryption solves all security problems are misled.
When done properly, masked data is not noticeable unless you look closely. Masking data well might still be usable for analytic reporting and aggregation, yet utterly useless for revealing confidential data. Masking is important enough that sophisticated software packages have become available.
Come learn about the right way to mask non-production data in order to allow the organization to limit possible exposure only to production. Learn what techniques can be used, why, and what factors should be considered when deciding to secure confidential data.1/13/2018 11:00:00 AM1/13/2018 12:00:00 PM7075570755Jason HornerBI Architecture Management S274Dimensional Modeling Design Patterns: Beyond the BasicsDimensional modeling is one of cornerstones of successful Business Intelligence initiatives. Even with new technologies like PowerPivot and Analysis Services Tabular models, you need to represent your organization’s data in a way that is accessible for end users and IT staff alike. An effective dimensional model will also ensure that your data warehouse or data mart will be responsive and capable of accommodating emerging requirements.
In this session, we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to help make this an interactive and engaging session.1/13/2018 9:45:00 AM1/13/2018 10:45:00 AM7059370593Elizabeth NobleDatabase Application Development S270Making Your List and Checking It Twice: Introduction to unit testing with tSQLtUnit testing allows database code to be consistently tested during the development process, but it can be challenging to get unit testing setup for database development. This session will give an overview on the purpose of unit testing, the installation of the tSQLt framework, and the design of unit tests. I will use general concepts of test driven design to create and run unit tests to confirm that objects exist and to test single and multiple test cases. Learn how to implement unit testing in a development environment and create and run your own units tests.1/13/2018 2:50:00 PM1/13/2018 3:50:00 PM7070670706Lowry KozlowskiDatabase Administration S309SQL Server Take Over: Establishing a BaselineSQL Server Take Over: Establishing a Baseline
Performance assessment and tuning for the beginner DBA
Have you ever inherited a group of servers with not a lot of documentation to accompany them? Do you have a lot of undocumented or new servers in your environment and you want to establish some baseline configuration setting prior to making changes? You need up to date information on the system very quickly.
The server is running slowly... or is it? Slow compared to what? Before you being digging into performance issues, there are some baseline metrics you should have established. Only after the information has been gathered, can a plan of attack be developed to help resolve issues with performance. Attendees in this session will learn how to quickly gather information, review the results and get an action plan on the next step in performance tuning.1/13/2018 2:50:00 PM1/13/2018 4:05:00 PM7075170751Henry TreftzDatabase Administration S316Why Third Party Vendors Do The Things They DoHave you ever installed a third-party application that uses SQL Server, started to use it, and then wondered why does this feature behave this way or what the heck were they thinking when they did it this way.
I at one point was one of those people who designed, developed, and maintained databases for an ISV. This is my chance to explain and atone for my database sins and explain why some decisions seem like good ideas at the time and why some are forced upon an ISV.
This presentation has three main objectives:
1) Explain why vendors make the design, coding, and implementation decisions that they do;
2) Discuss how to make third-party applications run better in your environment;
3) Teach you how to work around those limitations and work with those vendors and get better support.1/13/2018 1:30:00 PM1/13/2018 2:30:00 PM7052470524Wendy PastrickDatabase Application Development S305Why NULL is not a value (and other SQL gotchas)Allowing NULL "values" in your database is simple, but managing them is a whole different story. Learn what NULL really means and why you may want to avoid it in your systems. I will share techniques for overcoming NULL and other SQL idiosyncrasies leading to bad data or incorrect query results.1/13/2018 1:30:00 PM1/13/2018 2:30:00 PM7069870698Bob PusateriDatabase Administration S279Minimizing User Impact with Advanced Restore MethodsWe all know that backups are only half the battle - restores are what really matter when disaster strikes. Standard restores, while effective, may require additional downtime and further affect the business. This session will demonstrate three advanced restore methods you should know: point-in-time restores, piecemeal restores, and page restores, and will discuss when each method is appropriate. Attend this session to learn how to be a better DBA by minimizing downtime and user impact after disaster has struck!1/13/2018 2:50:00 PM1/13/2018 3:50:00 PM7074370743Rob VolkDatabase Application Development S270Tame Your Unruly Data With ConstraintsBad data comes in many forms: duplicate rows, wrong data type, invalid values, and orphaned or missing foreign keys. Time is wasted cleansing, reviewing and correcting data, not to mention the potential hazards bad data can cause. This introductory presentation will explain the data types and constraints available in SQL Server, and how they can replace or augment business rules that would otherwise be written in application or procedure code. Performance benefits provided by constraints will be demonstrated. We will examine the various system views and procedures that describe constraints and how to use them to document your databases. You will be able to apply this knowledge to your database environments and see significant improvements in data quality, performance, and reliability.1/13/2018 1:30:00 PM1/13/2018 2:45:00 PM7019370193Spencer SwindellBI Architecture Management S213Applying Data Warehousing Principles: Going from Descriptive to PredictiveHave you ever had difficulty working with large data sets, or integrating multiple disparate data sources? Would you like present this data in a dashboard and effectively use your data to make more informed decisions? By understanding an applying data warehousing concepts and principles you can take advantage of the value of your data, and lay a foundation for future integrations. During this session we will cover data warehousing concepts with examples and demos to showcase the techniques. After this session you will understand key data warehouse concepts and techniques, as well as how data can be presented in a dashboard and used in an analytical application.1/13/2018 2:50:00 PM1/13/2018 3:50:00 PM7060470604Geoff HitenCloud Database/Application Development Deployment S316ARMed for AzureThe Azure Resource Model (ARM) enables Azure infrastructure automation for both IaaS and PaaS deployments. Using Visual Studio as a management tool enables repeatable, automated, source controlled deployments for test and development environments, enabling true DevOps practices for all aspects of pre-production systems. In this session, I will demonstrate, explain, and deploy a IaaS/PaaS hybrid environment (SQL and BI stack elements) using ARM templates, Visual Studio, source control integration, and PowerShell scripts.1/13/2018 8:30:00 AM1/13/2018 9:30:00 AM7071170711Amy HeroldPowerShell S309Hi, my name is Powershell, let's be friends! An Intro to PoSHPowershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.1/13/2018 1:30:00 PM1/13/2018 2:30:00 PM6937969379Anthony NocentinoDatabase Administration S334Networking Internals for the SQL Server ProfessionalOnce data leaves your SQL Server do you know what happens or is the world of networking a black box to you? Would you like to know how data is packaged up and transmitted to other systems and what to do when things go wrong? Are you tired of being frustrated with the network team? In this session we introduce how data moves between systems on networks and TCP/IP internals. We’ll discuss real world scenarios showing you how your network’s performance impacts the performance of your SQL Server and even your recovery objectives.1/13/2018 8:30:00 AM1/13/2018 9:30:00 AM7188671886Josh LuedemanCloud Database/Application Development Deployment S272Migrating your BI Platform to AzureTalk through moving your BI infrastructure to Azure1/13/2018 1:30:00 PM1/13/2018 2:30:00 PM6943269432Kevin FeaselBI Analytics and Visualization S276Data Cleansing With SQL And ROn a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.1/13/2018 1:30:00 PM1/13/2018 2:30:00 PM7192171921Rowland GoslingCloud Database/Application Development Deployment S275SQL Server Meets Big Data in the Cloud: Weather EditionFrom government agencies and private networks, weather data moves through data platforms and becomes observations and forecasts. We’ll take a look at gathering, transforming and storing weather data using Microsoft Azure, SQL Server, Hadoop and a variety of other technologies (Kafka, Spark, Python, Postgres).1/13/2018 9:45:00 AM1/13/2018 10:45:00 AM7022070220Chris HydeBI Analytics and Visualization S309Python in SQL Server 2017SQL Server 2017 has finally arrived, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!
In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!1/13/2018 11:00:00 AM1/13/2018 12:15:00 PM7019670196Aaron NelsonBI Analytics and Visualization S305PowerShell for BI Professionals: Automating SSIS, SSRS SSASPowerShell has allowed DBAs to manage huge numbers of SQL servers, all automatically. Now BI practitioners can reap the same benefits of scale and automation. Scenarios that are normally extremely time consuming can be done quickly, all with a few lines of PowerShell.
This session will be filled with demos based on real-life scenarios and use-cases. We will demonstrate how to scale and automate your BI solutions, with a minimum of effort. In particular, we will be covering PowerShell cmdlets their integrations with SSRS, SSIS, SSAS.
By the end of the session, you'll be able to accomplish in minutes what would normally take hours or days. You’ll know ways to quickly deploy hundreds of SSRS objects to multiple servers; or instantly identify and process stale SSAS dimensions. Additionally, you will also be able to take care of some pesky ETL tasks, some by automating SSIS, and others using just plain old PowerShell.1/13/2018 8:30:00 AM1/13/2018 9:45:00 AM7065470654Je'Anna Lanza-AbbottProfessional DevelopmentS276Performance Tuning for Salary NegotiationsBecause little in business or life gets done without negotiation, this session has the potential to deliver significant upside in your professional and personal outcomes. In this session, you will be introduced to basic negotiation concepts and tactics, followed by a focus on important aspects of the negotiation process—obstacles to effective communication at the bargaining table, the maximization of multiple interests, and preparation tactics for your next negotiation. We will put it all together by examining a special type of negotiation: YOUR SALARY!
Participants will:
• Learn strategies for negotiation analysis and preparation
• Understand different strategic choices and interpersonal skills necessary for success
• Know what information is needed to negotiate effective outcomes
• Experiment with new techniques and test their effectiveness in a safe environment1/13/2018 8:30:00 AM1/13/2018 9:30:00 AM7072170721Cathrine WilhelmsenBI Architecture Management S316Biml for Beginners: Speed Up Your SSIS DevelopmentAre you tired of creating and updating the same SSIS packages again and again? Is your wrist hurting from all that clicking, dragging, dropping, connecting and aligning? Do you want to take the next step and really speed up your SSIS development?
Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.
In this session we will look at the basics of Biml. First learn how to use Biml to generate SSIS packages from database metadata. Then see how you can reuse code to implement changes in multiple SSIS packages and projects with just a few clicks. Finally, we will create an example project that you can download and start with to speed up your SSIS development from day one.
Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!1/13/2018 2:50:00 PM1/13/2018 3:50:00 PM7048070480Ed WatsonBI Analytics and Visualization S276A Beginner's Guide to Power BIAre you new to Power BI Server? Do you want to learn what all the buzz is about and how to use it from a purely novice standpoint? Do you need to ramp up quickly to be able to build some great visualizations? This session is the session that you need! We will walk you through the basic architecture and nuances of Power BI all the while taking a fun adventure to building your first Power BI report. The attendee will leave the class ready to start using Power BI in the real world.1/13/2018 2:50:00 PM1/13/2018 3:50:00 PM7065670656Rie IrishDatabase Administration S272How to Build Your Disaster Recovery PlanSo your boss asked for a copy of your DR plan. Once you've wiped that deer-in-the-headlights look off your face, you realize "We've got database backups," isn't exactly a plan. You need to come up with a plan to recover your business when disaster strikes. This session will help you build this plan by defining what a disaster could be, documenting the business impact, and identifying your limitations. We will show how to use this information to establish metrics (such as RTO and RPO), document current recovery configurations, and design an effective recovery strategy that meets the needs and budget of your business. Attending this session will give you the knowledge and tools to create an effective disaster recovery plan that will make your boss happy and ensure the continuity of your business.1/13/2018 8:30:00 AM1/13/2018 9:30:00 AM6936069360Matt GordonCloud Database/Application Development Deployment S270Where Should My Data Live (and Why)?Long gone are the days where the only architecture decision you had to make when scaling an environment was deciding which part of the datacenter would store your new server. There is a dizzying array of options available in the SQL Server and Azure ecosystems and those are evolving by the day. Is “the cloud” a fad? Are private datacenters a thing of the past? Could both questions have a kernel of truth in them? In this session I will go over real world scenarios and walk you through real world solutions that utilize your datacenter, cloud providers, and everything in between to keep your data highly available and your customers happy.1/13/2018 9:45:00 AM1/13/2018 10:45:00 AM7188571885Josh LuedemanCloud Database/Application Development Deployment S274Cloud PanelPanel of Consultants for Attendees to ask cloud questions1/13/2018 12:20:00 PM1/13/2018 1:20:00 PM7236772367Bradley BallCloud Database/Application Development Deployment S275Twitter Data Sentiment Analysis: Staring Logic Apps, Azure ML, Twitter Data, Power BI, and PythonSix months ago we went to Spider-man: Homecoming. On the way home I thought “I wonder what the rest of the world thinks of this movie? I wonder what people on Twitter are saying? I wonder if this is that tied to box office performance?” Over the last six months we’ve been building data sets on movies and collecting sentiment analysis of Twitter data. This lead to a journey of data discovery. First to figure out how to capture and analyze social media data from Twitter. Next we needed box office information. After that we wanted to capture sentiment. Then we wanted stock market data. Then we wanted movie information, runtime, rating, Metacritic score, IMDB score, and then how do we get historical data if we want to increase our data set? Once you collect the data how do you store it? How do you display it? All this and more….. but probably just this….because that’s a lot.1/13/2018 2:50:00 PM1/13/2018 3:50:00 PM7286472864Kevin KlineDatabase Application Development S128Top Tools for Tuning SQL: Focus on Plan ExplorerIn this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning to help you with some of the most problematic and troublesome SQL coding issues which you can take home and immediately apply to your SQL code. You’ll learn things like:
1. What are the most popular free tools and scripts for performance tuning in the SQL Server community.
2. A little-known technique to create a tiny version of large production databases, yet deliver query execution behaviors as you would see in production along with a sneaky DBCC commands that helps replicate a full production server on your workstation.
4. Best practices in reading execution plans using the free tool, Plan Explorer.
5. A variety of T-SQL techniques, including the best way to write a cursor, a quick trick that can save you 20-30% processing times on your big stored procedures, and some weird situations where SQL Server doesn’t use cached plans when it should.1/13/2018 12:20:00 PM1/13/2018 1:20:00 PM6970769707Dave MattinglyCloud Database/Application Development Deployment S270Alexa, Talk to MeLearn how to create your own skill (app) for Amazon's Echo / Dot service known as Alexa.
In this session, we'll create a simple skill from scratch, and show how to get into some of the more advanced options.1/13/2018 12:20:00 PM1/13/2018 1:20:00 PM7259772597Jonathan StewartBI Analytics and Visualization S275Data Visualization: How to truly tell a great story!We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…1/13/2018 1:30:00 PM1/13/2018 2:30:00 PM7075870758Mike LawellCloud Database/Application Development Deployment S305Cosmos DB: Planet Earth ScaleIn this session you will be learn what Cosmos DB is and why it is the hottest thing in Azure.
What does massively scalable, mullti-model, globally distributed, well-defined consistency models look like?
Most important, who is going to be using it and why?1/13/2018 9:45:00 AM1/13/2018 10:45:00 AM7010270102Mike RobbinsPowerShell S213Writing award winning PowerShell functions and script modulesTransitioning from writing PowerShell one-liners and basic scripts to creating reusable PowerShell tools with advanced functions and script modules can be a daunting task and with all the different ways that you’ll find on the Internet to accomplish the same task, it can definitely seem overwhelming. During this session, we’ll demystify many of the intricacies of toolmaking while demonstrating the best practices for using parameters, parameter validation, cmdlet binding, supports should process, pipeline input, error handling, module manifests, and custom formatting.1/13/2018 11:00:00 AM1/13/2018 12:00:00 PM7278372783SQLSaturday NashvilleDatabase Administration S126SQL Server Remote Management Best PracticesPanel discussion on remote management, PowerShell and access control best practices for SQL Server. Attendee questions welcome.
Jay Adams
Tracy Boggiano
Kellyn Pot'Vin-Gorman
Rob Volk
Anthony Nocentino
Mike F Robbins
Brought to you by System Frontier1/13/2018 12:20:00 PM1/13/2018 1:20:00 PM7203872038Kathi KellenbergerBI Analytics and Visualization S274Azure Machine Learning 101You have probably heard the buzz about Azure Machine Learning, aka Azure ML, over the past few years. It is a surprisingly easy to use predictive analytic tool that you can learn for free. Attend this session to learn how to get started with Azure ML.1/13/2018 8:30:00 AM1/13/2018 9:30:00 AM6997669976Daniel GlennBI Architecture Management S279Using Your On-prem Data in a Cloud WorldMicrosoft Power BI, Flow, and PowerApps are powerful cloud tools that can take your on-premises data to new heights. Using your data where it is now gives you the ability to invest in improving processes, instead of focusing on a data migration strategy.
In this session, we will discover the benefits of using the cloud tools, how those benefits translate to being on-prem, and how we can use the data in Office 365 as well. We will setup a data gateway, connect to on-prem data sources, and use that data in Office 365 and SharePoint Server 2016.1/13/2018 8:30:00 AM1/13/2018 9:30:00 AM7189271892Gareth SwanepoelCloud Database/Application Development Deployment S276Azure SQL DW Performance Common IssuesAzure SQL Data Warehouse and APS are based on the MPP architecture. Analyzing the workload can be very different than SQL Server and SQL DB. In this session, we will show you what an MPP execution plan is, what to look for, and how to compare them to DMV output to pinpoint performance problems. We will use real customer scenarios to show you the most common causes of slowness and how we improved the performance. Please note: This session is intended for individuals with a 200 level understanding of MPP architecture with some understanding of data movement. There will be a short review of core components, but the discussion will quickly move to more advanced topics.1/13/2018 11:00:00 AM1/13/2018 12:00:00 PM6953969539Kevin WilkieBI Analytics and Visualization S305What could be better than football and R!R -- it's included in SQL Server 2016. What can I do with it? Why do I need to know yet another software language? How can I use it to figure out important things -- like who is the best qb in the league right now, statistically?
We'll go over the basics of R and how to do things with it, plus items such as:
- Installing and managing packages
- Accessing data in various formats
- Basic data visualization functions1/13/2018 2:50:00 PM1/13/2018 3:50:00 PM7072970729Angela TidwellProfessional DevelopmentS279Becoming the MVP: Soft Skills for the Hard MarketWhether you are just starting a career, advancing into senior leadership, or trying to woo a potential client, soft skills can be your ticket to success. Often times we focus on showing how smart we are instead of showing what a good team member we can be. We will discuss the role and types of soft skills needed to showcase your X-factor. Need to hone your skills? We will explore innovative and fun ways in which to do just that!1/13/2018 1:30:00 PM1/13/2018 2:30:00 PM7151271512Dan EvansBI Architecture Management S275Power BI administration made easy(ier)Now that you have Power BI in your organization the fun has just started! Making sure users get the best experience requires some thought and planning though. Come learn the fundamentals of the Power BI architecture and hear about best practices with assigning licenses, delegating roles, audit log analysis, gateway management and overall Power BI administration based on real-world experiences.1/13/2018 11:00:00 AM1/13/2018 12:00:00 PM7005870058Tim WarnerDatabase Administration S213SaaS/IaaS Compromise - Learning Azure SQL Database Managed InstanceAzure SQL Database Managed Instance offers you the best of both worlds: deeper access to the underlying virtual database server (infrastructure-as-a-service, or IaaS), with the high agility of software-as-a-service (SaaS). In this session you'll learn the Managed Instance use case and be equipped to make an informed decision on how you host your SQL Server databases in the Microsoft Azure public cloud.1/13/2018 1:30:00 PM1/13/2018 2:30:00 PM7265572655Rodrigo MedeirosDatabase Administration S272Optimizing SQL Server Instances You Don't ControlWhen you’re responsible for the care and feeding of packaged business apps and the underlying database is struggling to keep up, it can be quite challenging if not impossible to make code adjustments or configuration changes that improve responsiveness.
Learn what could well be the root cause for the problems you are experiencing, ways to identify it and simple solutions you can implement without anyone else’s help.1/13/2018 12:20:00 PM1/13/2018 12:35:00 PM7179571795SQLSaturday NashvilleOtherS128On-Site Registration non-printed SPEEDPASSThis room will be used for printing SPEEDPASS, cutting SPEEDPASSES and any other registration issues. This room will be ready when registration opens at 8 am.1/13/2018 8:30:00 AM1/13/2018 9:30:00 AM7072770727Michael FalPowerShell S334Exploring the new SqlServer PowerShell moduleIf you’ve dabbled in PowerShell, you probably know that there are many ways to use it in conjunction with SQL Server. While using the provided tool set has been a challenge for many data professionals, recent upgrades and improvements to the PowerShell module for SQL server provide a solid tool set for new and experienced users. This session will cover the SqlServer module in detail, exploring the various commands and demonstrating various use cases for the tool set. Attendees will get a solid overview of the module and real world examples of how users can get the most out of their code.1/13/2018 2:50:00 PM1/13/2018 3:50:00 PM7179471794Andy YunProfessional DevelopmentS334Everyone Has a Story to Tell: Developing Your First PresentationEver considered giving a presentation of your own? Pondered how your favorite speakers got their start? Contemplated whether you could ever do that too, but were not sure where to begin?
Well I say you can and will show you how to get started! In this session, I will teach you how to develop your idea and create session content, and share tips tricks that I have learned along the way.
You will leave armed with a wealth of resources (and hopefully some inspiration) to venture forth and develop your first presentation.1/13/2018 9:45:00 AM1/13/2018 10:45:00 AM7010770107Arthur Daniels IIIDatabase Application Development S309Reading Execution Plans SuccessfullyIf you've seen an execution plan but didn't know how to read it, this session is for you.
The goal of this session to learn how SQL Server is interpreting your query into an execution plan. We'll discuss execution plan internals, how SQL Server estimates the cost of your query, and what a graphical execution plan is displaying through its operators.
Learning to read an execution plan is a great way to begin troubleshooting performance. At the end, we will take a look at how SQL Server 2016 provides more tools for exploring execution plans.1/13/2018 8:30:00 AM1/13/2018 9:30:00 AM7073270732Lance TidwellDatabase Administration S272Parameter Sniffing the Good, the Bad and the UglyParameter sniffing is something that more than often helps performance on your servers; however, there are times when it can hinder performance as well. In this session we will define exactly what parameter sniffing is, and examine when it is good and when it is bad. Lastly, we will explore the different options available to fix bad parameter sniffing. After this session, you will be able to locate and fix bad parameter sniffing when it occurs on your servers.1/13/2018 11:00:00 AM1/13/2018 12:00:00 PM7179671796John DeardurffCloud Database/Application Development Deployment S213Cloudy with a Chance of DataThis course is intended as an Introductory look at the Cloud and Azure Data Services. We begin our session explaining what the cloud is and the differences between Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS). Then we turn our attention to Azure and the Microsoft Cloud Data Platform to see what solutions are available for Data Archtitects, Developers, and Administrators. Finally, we close the session with a tour of SQL Server in an Azure Virtual Machine as well as an Azure SQL Database.1/13/2018 8:30:00 AM1/13/2018 9:30:00 AM7265172651John MorehouseDatabase Administration S272Only You Can Prevent Database Fires!Do you find yourself constantly putting out "fires"? Can't take anymore heat in the data center? We as DBAs can easily become burnt out with dealing with these daily blazes. Wouldn’t it be grand to learn how to prevent these fires from scorching us to begin with? In this session, we will jump into things you can start implementing as "fire prevention" to stop the "fire fighting". We will talk about several things that you can take back to your shop and put into action easily ranging from code tuning, backup maintenance, monitoring and performance tuning!1/13/2018 9:45:00 AM1/13/2018 10:45:00 AM7179171791Ben MillerDatabase Administration S316SQL Server EncryptionHave you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? What about encrypting your backups? This session will go over all the steps and caveats that go with this technology. TDE allows you to have your database encrypted on disk and the same Encryption Hierarchy allows you to back up your database and have it encrypt the contents in the backup file. We will discuss the Encryption Hierarchy which is used for encryption in SQL Server and take you through keeping your secrets safe. We will also go over how Always Encrypted works as well. Master the concepts of SQL Server Encryption when you are done with this session.1/13/2018 11:00:00 AM1/13/2018 12:00:00 PM