Sept 2016 – Kevin Kline Part 2!

When: Thursday, Sep 8th
Networking at 5:30 PM
Meeting at 6:00 PM

Where: FedEx Institute of Technology, Room 315
365 Innovation Drive
Memphis, TN 38152
(View Map)

Kevin Kline Part 2!

We are lucky enough to have Kevin speak twice at MEMPASS in the same year.

Topics:
Top 10 DBA Blunders
SQL Server Internals & Architecture


Top 10 DBA Blunders

Abstract:

Microsoft SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t mean that database administration on SQL Server is problem free. And since SQL Server is constantly growing from small, home-grown applications, many IT professionals end up encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. In fact, wouldn’t you like to learn about those mistakes before they ever happen?

This session will answer questions like:
* What’s the most common Transact-SQL programming mistake and how do I fix it?
* How do database designers cause problems for future generations of application developers and database administrators?
* Why do inexperienced database administrators make their own job more difficult and less efficient?

There is a short list of mistakes that, if you know of them in advance, will make your life much easier. These mistakes are the “low hanging fruit” of application design, development, and administration. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.

Prerequisites: Basic understanding of SQL Server architecture, development, design, and administration.


SQL Server Internals & Architecture

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.


If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RSVP at: http://www.meetup.com/memphis-technology-user-groups/events/233825160/

Comments are closed.