Welcome to AspAdvice Sign in | Join | Help

December 2005 - Posts

Flattening Data into a List in SQL Server

Posted Friday, December 23, 2005 4:06 PM by plitwin
Normalization to 3rd normal form (or higher) is a good thing. For example, in the pubs database, in order to model the fact that a given author can write more than one book, and that a given book can have multiple authors, you have to model the many-to-many Read More...
0 Comments
Filed under:

Resetting an Identity Column in SQL Server

Posted Friday, December 23, 2005 1:33 PM by plitwin
I had the need recently to reset the value of an identity column in a SQL Server 2000 table back to 0 so that the next row added would have a value of 1. I knew this was possible but I could not remember how. (In Access, BTW, this is possible by deleting Read More...
0 Comments
Filed under:

Scott Guthrie's DotNetUsers Talk on How Microsoft Builds Software

Posted Friday, December 09, 2005 12:14 AM by plitwin
I attended a very educational and insightful talk by Microsoft Group Program Manager Scott Guthrie last night (Dec 7th) in Redmond at the DotNetUsers group run by Ruth Walther. For those who don't know, Scott is the co-inventor of ASP.NET and the leader Read More...
0 Comments
Filed under:

Posted Visual Studio 2005 Tips, Tricks, and Random Bits Talk

Posted Tuesday, December 06, 2005 8:54 AM by plitwin
I spoke last night (Dec 5) at the .NET Developer's Association Web Developer meeting in Redmond, WA (Microsoft Headquarters). I counted around 45 people. The talk was quite different from my normal set of talks on ASP.NET and Reporting Services. Instead, Read More...
0 Comments