Wagnerblog

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 you [...]

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