The Performance Virtual Group's mission is to empower the global Microsoft SQL Server database community with technical content regarding performance related to SQL Server.

Login to Subscribe

Welcome to the Performance Virtual Group

Next Meeting

Reporting and Analysis in Your Transactional Database (You, You CAN Run Reports in Production!)

Thu, Sep 13 2018 18:00 UTC

Reporting and Analysis in Your Transactional Database (You, You CAN Run Reports in Production!)

Everyone wants to run reporting queries in the active transactional database, so they can have access to real-time data. They may not realize the impact this has on performance, but you do. What strategies can you use to combine these workloads and avoid long-running queries, blocking, and frustrated users? In this session, I'll cover using indexes, isolation levels, operational analytics, and even Availability Group readable secondary replicas to deliver the data your users need without negatively impacting transactional performance.

Jes Borland

Jes Borland is a Softaware Engineer with Microsoft who has experience with wide range of SQL Server features from version 2005 through 2019, and is on the cutting edge with Azure technologies. Since graduating Fox Valley Technical College with an IT-Programmer/Analyst degree, Jes has worked as an SSRS developer, DBA, and consultant. Before joining Microsoft, Jes was a six-time Data Platform MVP, recognized for her community work. Jes tackles every project and problem with tenacity and her enthusiasm is unmatched in the SQL Server community. In her free time Jes never stops moving, counting fitness, coffee, cooking, and travel as essentials to life.

Contact the Performance Virtual Group

Are you interested in being a Presenter, getting involved with the Group or simply provide us with some feedback? Please fill in the form below

Your Contact Information

Your Feedback

Thank you for contacting us, we will get back to you as soon as possible!
Back to Top