Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

PASSMN March 16, 2010 Monthly Meeting

Posted by denglishbi on March 7, 2010

The next Minnesota SQL Server User Group meeting is coming up in a couple of weeks on Tuesday, March 16 from 3 to 5:30 at the local Microsoft office in Bloomington.  This month we will be looking at common table expressions (CTEs) and database design and both sessions will be done by SQL Server MVPs, Jason Strate and Louis Davidson.  The second presentation will be done remotely by Live Meeting.

In order to RSVP for the event you will need to login to the national PASS site and click on the RSVP link.  This month our sponsor for the event is Idera.

image

PASSMN March 2010 Meeting – ABCs of CTEs & Database Design Fundamentals

Agenda:

2:30 – 3:00 : Networking
3:00 – 3:15 : Announcements
3:15 – 3:25 : Sponsor
3:25 – 4:25 : ABCs of CTEs (Jason Strate)
4:25 – 4:30 : Break
4:30 – 5:30 : Database Design Fundamentals (Louis Davidson)

Presentations:

ABCs of CTEs (presented by Jason Strate) – Common Table Expressions (CTE) aren’t as common as their name implies. CTEs are often seen as a secret part of the dark art of recursion. This session will explore CTEs to show how they can be extremely useful in improving performance and legibility of T-SQL code. And, of course, we will look at their use in returning recursive data.

Database Design Fundamentals (presented by Louis Davidson – session level Intermediate) – In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can’t use an index efficiently).

We also added a new annual sponsor for our user group, Intertech.  We are very excited to be expanding on our sponsor list for our user group and we will have some additional giveaways for this event.

Intertech .NET and Java Training

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: