February 2008 - Posts

Pulling back the covers on SQL Server

Tuning SQL Server has always been a black art.  Luckily, SQL Server 2005 added a number of tools to give us a glimpse into its inner workings through Dynamic Management Views (DMV). In the MSDN article, SQL Server: Uncover Hidden Data to Optimize Application Performance, Ian Stirk provides an excellent overview of the various DMVs.  "SQL Server 2005 collects data relating to running queries. This data, which is held in memory and starts accumulating after a server restart, can be used to identify numerous issues and metrics, including those surrounding table indexes, query performance, and server I/O. You can query this data via the SQL Server Dynamic Management Views (DMVs) and related Dynamic Management Functions (DMFs)."  More...

Using DMVs directly is great, but various tools have been built on top of them to take your tuning experience to the next level.  Microsoft SQL Server Customer Advisory Best Practices Team has published DMVStats: A SQL Server 2005 Dynamic Management View Performance Data Warehouse on CodePlex.  We're taking a look at this tool over the next couple of weeks.  If anyone else has used it, I'd love to hear your results.

Posted by brian_ritchie | with no comments

Don't Despair...Yet

Is cubicle life making you too happy?  Are you starting to feel motivated?  Have no fear, the folks at Despair.com are here to help.  They are fighting the war against motivation!

"For over two decades, the multi-billion dollar motivation industry has unleashed untold suffering upon the workplaces, schools and civil institutions of the world- in the insidious form of the motivational poster.  In 1998, one company dared to fight back, as Despair, Inc. introduced Demotivators┬«, satirical products reverse-engineered from the most powerful motivational posters ever inflicted upon mankind."

They have lots of good stuff on their site, but if you can't find something you like then generate your own!  They now let you generate and print your own posters.

Here is my addition to the fight against Motivation...

 

Posted by brian_ritchie | 1 comment(s)
Filed under:

Language List Upgrade

The .NET Language List at dotnetpowered.com has become one of the most comprehensive lists of .NET-targeted languages available on the net.  This is thanks in large part to community involvement.  I've wanted to do some upgrades on the page for some time, and the first of them are finally online.  Click on the Enhanced View link to see the new functionality.  You can vote for your favorite language & sort the list different ways.  I'll also be adding the ability to add comment support so you can discuss your the aspects of your favorite language with the community.  Please let me know what you think and how I can make it better.  Also, if you know of a new language, please send it my way.

 

More Posts