Oracle vs. SQL, the War of the Indices by Kellyn Pot'Vin-Gorman

Organizer: Triangle SQL Server User Group
Click here for registration info

• What we'll do
This session is for the love of technology and learning. Its based off research performed on objects, design and code built as similar as possible to see how Oracle and SQL Server compare in performance, usage and storage of indices. Environments were built on-prem and in the cloud to view differences in different cloud support of database engines and based off trusted measurements in each platform so as to dig into how the use case was built, the similarities and the differences in each. Based off this use case, enhanced builds of more advanced index features and discussions of the advantages, reasons for the introduction and how it's effected the direction of each product, the DBAs who are responsible for them and resources. Takeaways are: 1. Receive a strong education on platform differences between Oracle and SQL Server. 2. Discover hidden insight on index storage and costs. 3. Learn about great tips on maintaining index health.

Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Oracle ACE Director alumni. She is the Technical Intelligence Manager and Evangelist for the Office of CTO at Delphix, a company recognized for it's impressive virtualization and data masking environment capabilities. Kellyn is known for her extensive work with virtualization, Enterprise Manager, shell and python scripting, environment optimization tuning, automation and cloud initiatives. Her blog, and social media activity under her handle, DBAKevlar is well respected for her insight and content.

She is the lead author on a number of technical books, hosts webinars for numerous technical groups and has presented at numerous Microsoft SQL Server, Oracle and DevOps, like Microsoft Summit, Oracle Open World, Data Summit, Collaborate and KSCOPE. She also speaks at regional events like Oracle user groups and SQL Saturdays, along with other technologies, including, but not limited to- Agile, Makersfaire and Big Data in the US and Europe.

Kellyn volunteers extensively in her technical community, providing leadership as the president of the largest regional Oracle User Group in the US, the Rocky Mountain Oracle User Group, (RMOUG) and liaison to the Denver SQL Server User Group. She's volunteered with other regional and international groups, sponsored WIT events and mentored women in tech worldwide. Kellyn has been a significant advocate, mentor and sponsor for those entering the technical industry, (specifically women in technology, aka WIT) and technical education for the next generation, (STEAM/STEM) working with the Raspberry Pi and code to instruct kids of all ages to embrace a passion for the technology that runs our world!

• What to bring

• Important to know
We are located on the bottom floor on the right hand side in the back in the ChannelAdvisor Cafe.


Poster: triangletech