SQLCAT Learnings from our Recent Customer Engagements
The SQLCAT Team has worked with a number of customers on SQL Server 2016 through early adoption programs and in our SQLCAT Lab. In this presentation we will share some of the scenarios where customers have deployed and taken advantage of SQL Server 2016, along with learnings from our engagements. Some technologies we will discuss include In-Memory OLTP, Columnstore, Always On Availability Groups, Query Store and more!
Mike (Twitter) is a Program Manager on the SQLCAT (Customer Advisory Team) at Microsoft. SQLCAT’s mission is to be a “voice of the customer” inside the product development organization and is focused on helping customers adopt new SQL technologies both in Azure and on-premises. Mike’s recent focus areas have been around new technology adoption aligned with SQL Server 2016 and 2017 (both on Windows and Linux). He has been at Microsoft working with SQL Server for almost 19 years. Find him on Twitter:@MikeW_SQLCAT
Magical Memory Moments, or,
How In-Memory Objects Can Supercharge Your Data And Bring About World Peace (Well, maybe not both of those fantastical concepts …)
OK, so you’ve been reading about, perhaps even testing out some of the ‘in-memory’ objects now available in SQL Server. Some of the claims are exciting, and some seem overly optimistic. And Yet, you want to know, experience more … Perhaps your situation doesn’t really call out for in-memory tables. But you should consider memory-optimized #Temp tables, memory-optimized table variables, and natively compiled stored procedures.
It’s true. Using memory-optimized tables requires a little more fore-thought, a bit more care, even a few configuration tweaks.
• But what are the real advantages of memory-optimized objects?
• What are the memory-optimized objects you can use?
• How can you best use memory-optimized objects?
In this demo packed session, we will discuss the pros and cons of using memory-optimized objects in ways that will supercharge your SQL Server. You will leave the session with concrete examples and great ideas of how memory-optimized objects in SQL Server can bring about World Peace. Drat, I meant to say the other one!
Arnie is a long serving Microsoft SQL Server MVP (10 years), has been a Subject Matter Expert (SME) working on SQL Server training courses since version 2000, and has been involved as a SME with the development of the SQL Server Microsoft Certification Exams. Arnie has also been a Microsoft Certified Trainer, and has served as a technical editor for several publishers, including multiple SQL Server titles in the Microsoft Official Curriculum. Arnie has served as adjunct faculty at both University and Community College. Clients include Fortune 500 and Multi-National companies, Federal and State agencies, Foreign governments, nationally recognized training facilities, and local enterprises –both public and private.
Refreshments graciously provided.
Featured Sponsor: Red-Gate
Visit our website for more details.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.