wagnerblog.com

Linchi Shea reports that running stored procedures on SQL server without the Owner qualifier - as in dbo.xxx for example - can impact the performance of that server and database in drastic ways. Depending on which version of SQL Server you are running just adding an owner qualifier can get you anywhere from 5% to […]

Roger Jennings has a nice summary and various links to a great article by Ian Cooper that looks at LINQ from the point of view of DDD, TDD and PI.
Roger notes another voice in the chorus that reiterates we need support for more db’s than simply the ones by MS. He says “….He then goes […]

Who can blame the guy. He has a product that supports a bunch of different database servers. So consequently he is very familiar with his subject matter.
He says: “…Scientists should stick with science. What they invent and discover should be moved to the real world by engineers, not by scientists as well. Because, if […]

Here is an odd situation I came across today. This probably wont happen to many other people because it is so specific to certain network settings. But if it happens to you, maybe I can save you the 4 hours I spent on hold today with MS SQL Server PSS… whilst paying $250 for the […]

SD Times reports : “…Evans Data today released statistics that showed MySQL usage growing among developers over the past two years. The results of this two-year survey showed that 40 percent of American developers are using databases in their work, and among those, 25 percent more are using MySQL than were two years ago. A […]

Speaking of LINQ, Caber Computing offers a beta for a product called SqlTac which hopes to do several interesting things. First it attempts to provide a graphical representation of the “soundness” or efficiency of your db. Secondly it allows you to cretae  versioned set of scripts plus a test database containing – you guessed it […]

Louis Davidson at simple-talk has an article by the same name. I’ve pulled the following section from it, because I am currently faced with EXACTLY this problem. One of our Architecture Astronauts thought it would be good to store differing types of data in one table.
One of the hardest things in our industry is […]

In the years since the storage engine was re-architected (SQL Server 7.0+) there’s been constant debate on how to appropriately choose the clustered index for your tables. I’ve generally recommended an ever-increasing key to use as a clustered index and many find that counterintuitive. The primary reason people feel it’s counterintuitive is that it creates […]

This is really very useful in larger sites. Now I only wonder if having a SiteMap provider can increase SEO. It even includes a nice little example of SQL 2005 cache dependency

The one drawback to site navigation is that XmlSiteMapProvider is the one and only site map provider included in the box with ASP.NET 2.0, […]

My collection of interesting links has been growing for weeks and I haven’t had the time to post them. So here they are in one massive list.

Daniel Zeiss is on rev 9 of his major Ajax framework comparison. Great stuff.
Today I installed ScrewTurn Wiki in 10 minutes (as opposed to an hour for […]

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 […]

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 […]

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