In response to a newsgroup post, I wrote this quick little tutorial. This tutorial assumes you have the AdventureWorks database installed, but any database will do. 1. Create SQL Server Project in Visual Studio 2. Add a connection to AdventureWorks...

I was browsing the SqlServerCentral.com forums today and came across a post where a user was asking how to write a query to list all the stored procedures that contain a specific string. This might be useful, so I thought I better blog it lest I forget...

This one had me stumped for a little while until I was kicked in the right direction. The Problem You have two tables, Address and State. Address contains an attribute StateId, which is a primary key in the State table. You create a GridView to...

Some background is probably in order. I'm a Software Tester here at Microsoft. I work in the Integration Test Team, Release Release Services, SQL Server. One of my new jobs is to look at how our products integrate. Currently I'm investigating SQL Server...

First off, my hat's off to the ASP.NET team for some very cool new controls. I have been developing web content, on and off, for quite some time (let's just say a long time). Sometimes I really get tired of coding the same thing over, and over, and over...

I was all psyched to install Visual Studio 2005 Beta 1 today. After launching Setup, I got a nice little error message --------------------------- Visual Studio Beta Setup --------------------------- Setup has detected that previous versions of the...

I suppose everyone has to have one of these, so here's mine. Not much to say right now at this late hour, but I wanted to get something up here before the day was up. Will I make it?