This is a FREE group that meets the second Wednesday of every month (usually). We meet at the Microsoft offices at 5 Wayside Road, Burlington, MA. RSVPs to meeting generally open up 1 week prior to meeting. An email will be sent out announcing the meeting. Please RSVP to attend. Look forward to seeing you.
New to Azure or looking to take an Azure exam? This talk will attempt to inspire you into learning, and becoming a better version of your self. Also including lots of awesome Azure resources for learning Azure and for taking an exam. This talk also covers how the speaker went about learning azure from scratch to becoming a Microsoft MVP in Azure.
I am an Azure MVP from Glasgow, Scotland. I have a developer and DevOps background in IT spanning 20+ years. I help run the Glasgow Azure User group and I organize the Azure Global BootCamp Glasgow edition. I blog at https://gregorsuttie.com and you can see I am very active in the Azure community and on twitter I'm @gregor_suttie
Using the right index for the right scenario can be the "go fast" button that keeps queries and customers happy.
Over the years, Microsoft has given us many different indexing options and flavors. Today there are many more considerations beyond "clustered or non clustered". We'll cover all those different flavor options: Filtered, Compressed, Columnstore, included columns, and Partitioning.
We'll cover an overview of what each of these options is, and then dive into some code examples to see how and when each of these work, and when they don't.
You will leave the session with a much better idea of how and when to use each of these special indexing flavors to meet your needs.
Andy is a Data Platform MVP and SQL Server DBA that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. Andy is currently SQL Server Infrastructure Architect at Wayfair.com. He has been supporting high-volume, highly-available OLTP environments with demanding performance needs since 2003.
Andy is the founder of the BostonSQL User Group, and previous co-organizer of SQL Saturday events in Boston.
Andy lives just outside Boston, Massachusetts, USA with his husband and their two dogs.
See more of Andy's work on his site at am2.co
We all have those little things we do in T-SQL, not realizing they are unreadable to other engineers, ticking time bombs, or both. Let’s turn some of those bad habits into best practices, improving both productivity and performance.
About Aaron Bertrand:
An architect at Wayfair who has worked with SQL Server for over two decades, Aaron speaks frequently, blogs at http://sqlblog.org, and has been a Microsoft MVP since 1997.