SQL Server Innovators Guild

Welcome to the Greenville, SC Chapter

Welcome

We have meetings on the first Tuesday of most months.  Our group meets at the Greeville Campus of ECPI. Our normal room is room #236 but check the visual displays when you arrive to confirm.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session.  Unless noted in the meeting notes the schedule for each meeting will be:

6:00 - 6:30 - Food and a chance to meet other SQL Server users. Sponsored by FGP

6:30 - 6:45 -
General Q&A session & Announcements

6:45 - 8:15 - Presentation(s)

8:15 - 8:30 - Question & Answer session

Upcoming Events

Next Meeting: Fri, Jul 28 2017

SQL Server Internals and Architecture with Kevin Kline

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.eventbrite.com/e/ssig-sql-server-internals-and-architecture-with-kevin-kline-tickets-35586912413

6:00 – 6:30 Pizza and Networking sponsored by FIND GREAT PEOPLE

6:30 – 8:15  SQL Server Internals and Architecture with Kevin Kline

8:15 - 8:30 Closing remarks and give-a-ways

Title: SQL Server Internals and Architecture

 

Level: 200-300

 

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!

 

Prerequisites: Basic understanding of SQL Server operations and activities – such as transactions, queries, and preventative maintenance tasks like backup and recovery.

 

Goal 1: Learn about the major components within the SQL Server architecture, starting with the relational engine and storage engine, working down to greater and greater detail.

 

Goal 2: See what happens inside the SQL Server query optimizer and how the query optimizer affects transaction execution time, both read-only and read-write transactions

 

Goal 3: Review the major operational processes inside of SQL Server that affect memory management and IO activity.

Kevin Kline:

Kevin (@kekline) is responsible for expanding SentryOne's technical sales and marketing initiatives and is also heavily involved in product design activities. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, Google Author, and long-time blogger at sqlblog.com and at kevinekline.com. As a noted leader in the IT industry, Kevin's blog covers Microsoft SQL Server features and best practices, third-party software, trends in the IT industry, and professional development for IT professionals.

When

iCal
UTC : Fri, Jul 28 2017 22:00 - 00:30
Event Time : Fri, Jul 28 2017 18:00 - 20:30 Eastern Daylight Time
Your Local Time: Fri, Jul 28 2017 22:00 - 00:30

Where

1001 Keys Dr
Greensville, South Carolina

Direction: None

Attachments

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

Red gate 

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