Wagnerblog

Frederik has a small note about the much anticipated SQL Dependency Cache in ASP.NET 2.0 / SQL Server 2005
read more

SQL Log Rescue is a simple tool for viewing and recovering lost SQL Server data. If you have accidentally deleted, inserted or modified your database then SQL Log Rescue will help you get the data back.
read more

Klaus Aschenbrenner is quantifying the speed that some operations gain by being moved into the db. I love ORM’s like LLBLGen but just as Klaus clearly saw, you can’t simply throw any old ORM at an app. LLBLGen happens to be able to deal with this. But sometimes it may take judicious tuning and [...]

Adam Bosworth has som thougths on what a database ought to do.
“… If open source, I wonder if the software itself, should cost at all? Open Source solutions would undoubtedly get hacked more quickly to be robust and truly scalable across nice simple software. It wouldn’t be as pointwise fast, but the whole point is [...]

For the past 3 months I’ve been working on a project that uses Oracle 8i. It made me appreciate what MS has done right with SQL Server. Beginning with a free limited version of the bits that developers can use, all the way up to the Enterprise product that comes in at what [...]

Hmmm someone had a little spelling problem at The ServerSide
Nonetheless, here is what was discussed in Dan Sullivans article:
In summary a CTE can be used to implement a hierarchical query. The SELECT statement before the UNION ALL is executed first and just once. The SELECT statement after the UNION ALL is executed recursively [...]

This post originaly appeared in my now defunct Radio blog.
Have I ever mentioned Bill Wunder’s SQL Server Page?? Its a good reference page to have.

A component that can be used to aid in the generation of report templates / rdl files. It looks a bit raw but the idea has some promise.
Link here

This MSDN article outlines how to build a Reporting Services RDL file in code. I have a feeling that ultimately many folks will choose this approach as opposed to some of the management components of Reporting Svs.

read more

Just a brief description with screenshots that explains how to set up a report in Reporting Services.
read more