Knoxville SQL Server Users Group June Meeting

--====Wednesday, June 23rd 2010====-- 

--=====from 11:30am until 1:00pm=====-- 

at New Horizons Computer Learning Center, 

9115 Cross Park Drive C-100 Knoxville,TN 37923. 

Food and drinks are being provided by Premier Staffing Partners and will arrive at 11:30 and our speaker will go from 12:00 to about 1:00. 

Topic:SQL Server Internals and Architecture 

Speaker: Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS and the author of popular IT books like “SQL in a Nutshell” (O’Reilly & Associates). Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years. 

Overview: 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’s different about 32- and 64-bit systems?

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.

RSVP: Please RSVP to me, arlene [at] knoxsql.com with each person's name and company so we can account for food and name tags. 



 

Knoxville SQL Server Users Group May Meeting

 --====Friday, May 21st 2010====-- 

--=====from 11:30am until 1:00pm=====-- 

at New Horizons Computer Learning Center, 

9115 Cross Park Drive C-100 Knoxville,TN 37923. 

Food and drinks are being provided by Premier Staffing Partners and will arrive at 11:30 and our speaker will go from 12:00 to about 1:00. 

Topic: SQL Server Reporting Services - Dressing Up Data with Report Builder

Speaker: Jesse Wimberley an Instructor at New Horizons 

Overview: Sales performance may be sluggish and forecasts might be trending downward, but the figures can still look pretty.  In the hands of power users and information workers, Report Builder 3.0 brings wizard-driven drag-and-drop love to the authoring of SQL-based reports.  A simple pairing of form and substance, this free download from Microsoft satisfies the data hungry while dazzling executives with sharp, dazzling graphics.  

RSVP: Please RSVP to me, arlene [at] knoxsql.com with each person's name and company so we can account for food and name tags. 

  Knoxville SQL Server Users Group March Meeting