Aaron's space

Magenic in conjunction with the Chicago .NET User Group is sponsoring a free day of technical sessions called CODEapalooza, so mark your calendars for Saturday September 6th 8:30 to 5:00 pm CST.  The site just went live, but you can view info and register to attend, or if you're interested in speaking let us know! http://www.codeapalooza.com/

Share this post :

Resource Governor enables you to manage SQL Server workload and resources by specifying limits on resource consumption by incoming requests.

In an environment where multiple distinct workloads are present on the same server, Resource Governor enables you to differentiate these workloads and allocate CPU and/or memory as they are requested, based on the limits that you specify. Resource Governor is designed to address the following types of resource issues which are commonly found in a database environment:

· Run-away queries on the server

· Unpredictable workload execution

· Setting workload priority

Check out a screencast about the new Resource Governor feature in SQL Server 2008 via MSN Video below, or if you prefer Youtube or download.

Well the Magenic Technology Summit is officially over.  We actually maxed out our registration for the event and had some great sessions on Friday.  On Thursday all the members (30 or so) sat in a room to discuss the current and future state of technology.  It was a really great time hanging out with what we started to affectionately (or not so much) call the "Magenic Nerd Herd" and there was a lot of good discussion.

Also Dan English and I presented our webinar entitled "Make Better Decisions with Your Data".  If you missed it and would like to see it, you can take a look here.

Well it's been about 6 weeks since the last Cumulative Update so it must be time for a new one.  So as of today (6/16/08) we now have 8 Cumulative Updates for SQL 2005 SP2 which you can get here.  I haven't downloaded it yet, but I can tell you that I can't wait until SP3 comes out.  I've installed all of them from CU1 through CU7 so far and actually found something interesting with CU6 and CU7.  CU1 through CU5 got progressively larger to the point that CU5 was around 200 MB if I remember correctly, however when I downloaded CU6 and then CU7 it was significantly smaller (under 20 MB) each, so not sure what happened there.

Anyway, as always the best place I have found to look for SQL version information is SQLSecurity.com.  Although Microsoft also keeps one for 2005 here and SQL Server Central also keeps a list here.

Share this post :

The Transact-SQL debugger in SQL Server Management Studio enables you to find errors in Transact-SQL scripts, stored procedures, triggers, and functions by observing their run-time behavior. You can start the debugger when you are using the Database Engine Query Editor window.

By using the Transact-SQL debugger, you can do the following:

• Step through the Transact-SQL statements in the editor line by line, or set breakpoints to stop at specific lines.
• Step into or over Transact-SQL stored procedures, functions, or triggers that are run by the code in the editor window.
• Watch the values that are assigned to variables, and observe system objects such as the call stack and threads. 

Check out a screencast about the new T-SQL Debugger in SQL Server 2008 via MSN Video below, or if you prefer Youtube or download.