Category: SQL Server

Who would have thought…

7 July, 2007 (07:22) | SQL Server | No comments

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

Nice article on LINQ to SQL

13 June, 2007 (05:34) | .NET, .NET Tools, SQL Server | No comments

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

Frans is a little peeved at Architectural Astronauts

22 May, 2007 (19:01) | SQL Server, Software Architecture, Software Quality | No comments

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

SSIS Configuration File Issues

16 May, 2007 (20:14) | SQL Server | No comments

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

MySQL Usage Is Up

28 March, 2007 (05:32) | .NET, .NET Tools, SQL Server | No comments

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

Caber Computing - SqlTac

22 March, 2007 (05:02) | .NET Tools, SQL Server | 1 comment

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

Ten Common Database Design Mistakes

8 March, 2007 (05:31) | .NET, SQL Server | No comments

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

Kimberly L. Tripp: The Clustered Index Debate Continues…

15 February, 2007 (06:08) | SQL Server | No comments

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

Wicked Code: The SQL Site Map Provider You’ve Been Waiting For — MSDN Magazine, February 2006

3 February, 2007 (21:11) | Asp.Net 2.o, SQL Server | No comments

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

The most links for one post

21 October, 2006 (19:11) | .NET, .NET Tools, .NET Code Related, Asp.Net 2.o, SQL Server | 34 comments

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

NSQUARED2 - Caching in .NET 2.0

14 April, 2005 (19:58) | Asp.Net 2.o, SQL Server | No comments

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 - undelete for SQL Server

1 April, 2005 (06:37) | SQL Server | No comments

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

I’m 10 times faster in T-SQL as an O/R mapper or a DataSet solution - part #1

5 March, 2005 (06:22) | SQL Server | No comments

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’s Weblog: Where have all the good databases gone

28 February, 2005 (08:31) | General, SQL Server | No comments

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

Microsoft did something right

27 February, 2005 (12:10) | SQL Server | No comments

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

TheServerSide.NET - Heirarchical Queries in SQL Server 2005

8 January, 2005 (16:49) | SQL Server | No comments

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

SQL Server VSS Integration

1 January, 2005 (18:26) | .NET Code Related, SQL Server | No comments

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.

RDL Components - SQL Reporting Services

22 December, 2004 (16:44) | SQL Server | 2 comments

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

MSDN - Walkthrough for RDL Files

22 December, 2004 (16:42) | SQL Server | No comments

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

SQL Reporting Services and the ReportViewer Component

22 December, 2004 (16:39) | SQL Server | No comments

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