LISTS
http://www.codinghorror.com/blog/2005/08/microsoft-logparser.html
This is my fav one because of the pretty picture at the top =P
http://www.symantec.com/connect/articles/forensic-log-parsing-microsofts-logparser
This one is second fav because it uses the word 'forensic' and they are doing a scenario track down instead of just a bunch of random queries. This one is usually the first extended stop because it uses actual LogParser commands instead of just listing the sql queries.
http://serverfault.com/questions/45516/recommended-logparser-queries-for-iis-monitoring
This one I find useful every time. Not sure why. I think because of the succinctness of the queries and by this time, I am normally using query files instead of straight up LogParser commands and since generally I am...
I'm a big fan of Fabian Pascal. Here are 10 Articles/Pages/Responses that I like the best. =P You can find tons more from these though. They are almost all pure gold. =)
On Grinding Water: Reply to St. Laurent
NO THEORY, NO RELATIONAL, NO THINKING
On Incompetence
ON CALLING A SPADE A SPADE: REPLY TO CALLAHAN
The Data Exchange Tail - Part 1
ON TRADE MEDIA'S "BALANCE": ANOTHER ONE BITES THE DUST
If You Liked SQL,You'll Love XQUERY
Something “Old,” Something “New,” Neither True
An Old Class of Errors
The XML Bug+ 1 Truth, Fads and Principles: What's Wrong with the Database Industry?
SERIOUSLY too long of an article name, but hey, it covers a large amount of stuff. I basically had some large XML blobs (wordml docs) I needed to store in SQL and I wanted to store them as compressed BLOBs to save space. These are the articles I found most useful at the time when I was working on that.
Using CLR integration to compress BLOBs/CLOBs in SQL Server 2005
CLR Stored Procedures
Passing a DataSet to a SQLCLR Stored Procedure
Storing Binary Files Directly in the Database Using ASP.NET 2.0
How to read and write a file to or from a BLOB column by...