Networking

Misc, PASS
Andy Warren has just posted the last entry in a very interesting set of posts about building and working your own network. I think they're all worth a read, especially if you've been thinking about blogging, Twitter, LinkedIn or just volunteering at your local users group.
Read More

Procedure Cache and Dynamic Management Views

SQL Server 2005, SQL Server 2008, TSQL
I'm just going through the chapter on the procedure cache in the new book and I'm having a blast playing with the dynamic management views and functions that let you access the procedure cache. It's just too much fun and way too easy to get detailed information about the queries in the system, not like the old days. First, you can access the cache itself with the DMV, sys.dm_exec_cached_plans. This shows some of the data describing the plan in cache, but most importantly it provides the plan_handle. You need this for other joins later. You can also use sys.dm_exec_query_stats to get aggregated performance statistics about the plan. It also has the plan_handle and two things new to SQL Server 2008, the query_hash and the query_plan_hash, also known as query fingerprints.…
Read More

Twitter?

Misc
After much discussion in a set of emails between some of the more dangerous people that attend the PASS conference, I've decided to create a Twitter account. I created it under my name for the time being. I may blow it up later & go with something else. I'm not sure. I still don't quite get the point of this one, but I'm hooked in now. If you're interested in "following" me (like I could lead you anywhere), click here.
Read More