Mar 6 2008 3:12AM GMT
Posted by: mrdenny
In Person Events,
SQL,
Query tuning,
Resource Governor
The good folks of the San Diego SQL Server User Group has invited me to come speak to them on March 20, 2008. The meeting starts at 6PM.
If you are in the area I urge you to come and check it out. The topic of my talk will be Query Tuning as well as a bit of Query Governor. If you attended the SoCal Code Camp in January and weren’t able to catch my session then, now is your chance.
The slide deck will be a little different so I’ll be adjusting it a little bit. I’ll try and get the slide deck posted before the meeting, but no promises.
More information about the San Diego SQL Server User Group can be found on thier web site http://www.sdsqlug.org. See you there.
Denny
Jan 28 2008 11:56PM GMT
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
Jan 12 2008 1:26AM GMT
Posted by: mrdenny
SQL Server 2008,
Resource Governor,
SQL
The engineers from Microsoft PSS has posted some excellent information on thier blog about SQL Server 2008’s Resource Governor.
It’s some pretty hard core information but when it comes to SQL 2008 it’s going to be some useful information to have.
Denny
Update 2008.01.14: Now with correct URL. Sorry about that.