Home > IT Blogs > SQL Server with Mr. Denny > Slide Decks and Sample Code from SoCal Code Camp
>>VIEW ALL POSTS  

SQL Server with Mr. Denny

« Guide to Installing SQL 2000 and SQL 2005 on the same machine
Webcast: ‘Under The Hood of SQL Server - Checking Out Internals’ »
Jan 28 2008   11:56PM GMT

Slide Decks and Sample Code from SoCal Code Camp



Posted by: mrdenny
Cache, Config, In Person Events, CLR, SQL, Resource Governor, SQL Server 2005, SQL Server 2008, SSMS, Query tuning, Beta

The SoCal Code Camp was this last weekend.  I had a great time attending and speaking at the code camp this time around.   I hope that everyone who attended my sessions had as much fun attending the sessions as I did speaking at them.  I did my best to make them as much fun and interactive as I could.

As promised here are the slide decks and sample T/SQL code from the four sessions.  Everything is within a single ZIP file.  I’ve included two copies of each slide deck.  One in the Office 2007 format, and one in the Office 97-2003 format.  They are identical to each other, but I wanted to include both so that people with the older version of Microsoft Office can see the deck without having to download and install the patch which allows Office 2003 to view Office 2007 files.

The sample scripts which I’ve included are all run against the AdventureWorks database or the AdventureWorksDW database (check the USE commands at the top of the scripts).  If they need a different database they will create the new database.

Session 1 - SQL Server Query Tuning (SQL 2000+)

Session 2 - SQL Server 2008 Resource Governor (SQL 2008 CTP5+ only)

Session 3 - SQL Server Service Broker in the Real World (SQL 2005+) (I’ve fixed the problem with the single server script that we were having at the Code Camp.  Turns out I had left the route in place which is why the message never showed up.  The first script didn’t run correctly because I had run the server to server script on my virtual machine and the route was left by accident.)

Session 4 - SQL Server 2008 What’s on the Horizon (SQL 2008 CTP5+)

If you have any questions about these slide decks or sample code feel free to post a comment here, or drop me an email.

Denny

AddThis Social Bookmark Button     Comment     RSS Feed     Email a friend

Comment on this Post


You must be logged-in to post a comment. Log-in/Register

CGarcia26C  |   Jan 30 2008   4:45PM GMT

Hello MrDenny this comment is off-topic but I hope that you like XBox because from the way things are going it looks like you are going to win this contest!!!!

Thanks for your help I find your comments very insightful.

CG._


 

Yahoopap  |   Jan 30 2008   8:49PM GMT

Thank Denny for your thoughts on my question concerning attaching email folders to a group name. Let me explain first, I should had worded the question better. What I’m trying to accomplish first,
1. Take in job leads that are found by using search agent, move the leads
the right inbox jobs folders by using inbox rules.

2. Why zipping will not work, the peoples these leads are being sent to
are not computer literacy. It’s a major effort just to get them to go
out the Internet and reading their emails not along in using the Internet
to find work. these people are homeless veterans trying to get back
living and finding work.

3. Then what I do is attached an item,( the inbox job folders).
I using Outlook 2007 mail service to send all emails using the group list
name(which contain email address of those persons looking for this
category of jobs.

4. What I really would like to do, is to developed a script or something that
would accomplish this in one process. I’m more then willing to learn,
what I need is someone who show me how to take the right steps.
I have a background in software development.

Thank Denny, <a href="mailto:cpattersondp@yahoo.com">cpattersondp@yahoo.com</a>


 

MarlonR  |   Jan 31 2008   7:31AM GMT

Hello Denny,

It’s Marlon Ribunal from the Code Camp. Do you have discussion about SQL tuning? Please point me to the right direction (blogs, screencast, etc). I came in late on Sunday morning when you discussed the SQL Tuning. I have already downloaded the session files.

By the way, thank you for dropping by and commenting on my blog entry at <a href="http://devpinoy.org/blogs/marl/archive/2008/01/28/southern-california-code-camp-2008-day-2-final.aspx." rel="nofollow">http://devpinoy.org/blogs/marl/archive/2008/01/28/southern-california-code-camp-2008-day-2-final.aspx.</a>

Thanks!


 

Mrdenny  |   Feb 1 2008   12:18AM GMT

Marlon,
At some point in the future I’ll be putting out a webcast of the sessions from Code Camp. I’m not sure when that will happen however. I will post on the blog when it does.

Thanks,
Denny