Travis Laborde [http://weblogs.sqlteam.com/travisl/] has a great tip on why not to use @@identity [http://weblogs.sqlteam.com/travisl/posts/405.aspx] in TSQL code and use scope_identity() [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_6n8p.asp] instead. BTW, the…
Werner Vogels [http://weblogs.cs.cornell.edu/AllThingsDistributed/] has gathered some interesting notes [http://weblogs.cs.cornell.edu/AllThingsDistributed/archives/000280.html] on the backend architecture of some largely complex and distributed database-driven systems like those at eBay, Merrill Lynch, Swab, NASDAQ etc.…
Maybe this is old news for some of you guys. Anyways, I’ve been using two such ASP.NET applications which allow remote database administration via a web interface. It’s very useful when you don’t have ready access (specially on client locations) to SQL Server Enterprise Manager or…