Why not to use @@identity in TSQL?

Travis Laborde has a great tip on why not to use @@identity in TSQL code and use scope_identity() instead. BTW, the official Yukon web site is (also) up, with a nice intro article: Top 30 Features of SQL Server “Yukon”.…

High-end Backend

Werner Vogels has gathered some interesting notes on the backend architecture of some largely complex and distributed database-driven systems like those at eBay, Merrill Lynch, Swab, NASDAQ etc.…

WinToolZone

Gaurav Khanna has published some very cool .NET articles, applications, components, presentations, source code, tips and web services on his web site – WinToolZone.com (under the .NET menu option). He has also been working on extensions and enhancements to Rotor. Great content overall!…

Joel on Developers and Exceptions

In his latest article, Joel Spolsky refers to the Empower Program for ISVs: “If you’re a software company willing to commit to developing software for any variant of Windows, you can join the Empower Program for ISVs, which entitles you a huge pile of software at the…

Run .NET Code from SQL Stored Procedures

The CLR Proc Container is free software that enhances the capabilities of SQL Server stored procedures by opening a door to the .NET world. Code written in any .NET language can be invoked from stored procedures, providing stored procedures all the functionality of the full .NET runtime. Named procedures can…

Rules to Better .NET Projects

Rules to Better .NET Projects by SSW.com.au. Some basic but interesting?points discussed there. Some other SSW rules worth reading: Successful Projects, Better Code, Better SQL Server Databases, Better Websites, Better User Interfaces, Better Teams?and many more.…