CincyPASS

Welcome to the Cincinnati Professional Association for SQL Server!

CincyPASS is a professional organization/user group dedicated to all aspects of SQL Server from database administration to application development and business intelligence.

Our meetings occur every month on the 3rd Tuesday, in the Microsoft office located at 4605 Duke Drive, Suite 800, Mason, OH. Please ensure to register to help us plan for food. Unless noted otherwise the monthly meeting agenda will be

  • 6:30 - Welcome and Announcements
  • 6:45 - Featured Presentation
  • 7:45 - Q&A Session / Door Prizes

 

Next Meeting: Thu, Sep 07 2017

SQL Server Internals and Architecture

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/CincyPASS/events/242221152/

Abstract: Let’s face it.  You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works.  Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes.  But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture.  This session will answer questions like:

-  What are the various areas of memory inside of SQL Server?

-  How are queries handled behind the scenes?

-  What does SQL Server do with procedural code, like functions, procedures, and triggers?

-  What happens during checkpoints?  Lazywrites?

-  How are IOs handled with regards to transaction logs and database?

-  What happens when transaction logs and databases grow or shrinks?

This fast paced session will take you through many aspects of the internal operations of SQL Server and, for those topics we don’t cover, will point you to resources where you can get more information.  So strap on your silly, as we cover all these topics and more at speed with tongue planted firmly in cheek!

When

iCal
UTC : Thu, Sep 07 2017 22:00 - 00:00
Event Time : Thu, Sep 07 2017 18:00 - 20:00 Eastern Daylight Time
Your Local Time: Thu, Sep 07 2017 22:00 - 00:00

Where

4445 W Lake Forest Drive
Blue Ash, Ohio

Direction: None

Featured Presentation

SQL Server Internals and Architecture

Speaker: Kevin Kline, Principal Program Manager SentryOne

Summary: Abstract: Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like: - What are the various areas of memory inside of SQL Server? - How are queries handled behind the scenes? - What does SQL Server do with procedural code, like functions, procedures, and triggers? - What happens during checkpoints? Lazywrites? - How are IOs handled with regards to transaction logs and database? - What happens when transaction logs and databases grow or shrinks? This fast paced session will take you through many aspects of the internal operations of SQL Server and, for those topics we don’t cover, will point you to resources where you can get more information. So strap on your silly, as we cover all these topics and more at speed with tongue planted firmly in cheek!

About Kevin: Kevin Kline is a database expert and Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS, author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends & Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Authors/KevinKline.

Attachments

PASSChapterLogo100.jpg

 

sql_micro_sm.gif

 




 

sql_micro_sm.gif

 

 

 

 

 

 

 

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