Chicago Suburban SQL Server User Group

Welcome

MEMBERSHIP

If you have not done so already, please register on PASS.  Then update your PASS Profile & Join our Chapter there. All future mailings will be sent out via your SQLPass account:

http://www.sqlpass.org/PASSChapters/LocalChapters.aspx

Quick Search on "Chicago Suburban SQL Server User Group" and make sure you are registered as a member.  Doing so will ensure that you will receive future e-mails from us.

Next Meeting

Tuesday,

February

18

February Meeting

  • In-Person @ 3025 Highland Pkwy Downers Grove, Illinois, United States (map)
  • 18:00 - 20:00 (UTC-06:00) Central Time (US & Canada)
  • Language: English

DATE:
Tuesday, February 18

LOCATION:
Microsoft, Downers Grove

AGENDA:
5:30PM - Doors Open
6:00PM - Meeting Start with Dinner, Networking, & Open Q&A (bring your questions!)
6:30PM - Announcements, Sponsor Presentation, & Main Presentation


REGISTER: DEADLINE IS Feb 17 @ 9AM CDT
https://www.eventbrite.com/e/february-meeting-tickets-93949127369

TITLE:
Performance Improvements in SQL Server 2019

ABSTRACT: 
Microsoft released SQL Server 2019 in November of 2019.  The latest version contains several improvements and new features that improve reliability and performance.  First, Accelerated Database Recovery (ADR) completely redesigns the SQL Server database engine recovery process.  This allows the time spent recovering from a crash or rolling back a transaction to be greatly reduced.  ADR also prevents the transaction log from growing during a long-running transaction.  Second, metadata for temporary tables can be stored in in-memory tables.  For tempdb-heavy workloads, this removes a bottleneck and provides an improvement to performance.  Finally, SQL Server 2019 supports the use of persistent-memory (PMEM) devices.  PMEM can be used to persist the transaction log buffer, effectively removing LOGWRITE waits.  Join me for this session to learn about these new features in SQL Server 2019 and how they can make your workload run faster.

SPEAKER BIO: 
Frank Gill is a Senior Data Engineer at Concurrency   With 20 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. Over the past several years, he has worked extensively with SQL Server solution in Azure, including Managed Instance.  When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.
 

Featured Presentation:

Performance Improvements in SQL Server 2019

Microsoft released SQL Server 2019 in November of 2019. The latest version contains several improvements and new features that improve reliability and performance. First, Accelerated Database Recovery (ADR) completely redesigns the SQL Server database engine recovery process. This allows the time spent recovering from a crash or rolling back a transaction to be greatly reduced. ADR also prevents the transaction log from growing during a long-running transaction. Second, metadata for temporary tables can be stored in in-memory tables. For tempdb-heavy workloads, this removes a bottleneck and provides an improvement to performance. Finally, SQL Server 2019 supports the use of persistent-memory (PMEM) devices. PMEM can be used to persist the transaction log buffer, effectively removing LOGWRITE waits. Join me for this session to learn about these new features in SQL Server 2019 and how they can make your workload run faster.

Frank Gill, Senior Systems Engineer Concurrency

About Frank:
Frank Gill is a Senior Data Engineer at Concurrency With 20 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. Over the past several years, he has worked extensively with SQL Server solution in Azure, including Managed Instance. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.

REGISTER:

https://www.eventbrite.com/e/february-meeting-tickets-93949127369




PASSChapterLogo100.jpg


sql_micro_sm.gif







Andy Yun
E-Mail: SQLBek@gmail.com
Twitter: @SQLBek

Lowry Kozlowski
E-Mail: lowrykoz@gmail.com
Twitter: @lowrykoz

Chapter E-Mail: 
chisuburbanssug@sqlpass.org

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids