dba_spaceused This article presents a stored procedure for convenient reporting of the space consumed by each table. It's uses SQL Server's sp_spaceused to compatibility but includes the schema so that like named tables can be distinguished. User Defined Functions in SQL Server 2005 This presentation brings you up-to-date on UDFs. Examples of both T-SQL and SQLCLR functions are supplied along with the sample database. CSLA: What and Why Presentation on CSLA, the business object architecture that I use. SQL Server 2005 Service Broker Presentation Service Broker is a component introduced in SQL Server 2005. This presentation with an accompanying example script describes Service Broker and discusses how it might be used. Book Review: Murach's ASP.Net 2.0 Upgrader's Guide: VB Edition This is a targeted book for the experienced ASP.Net developer who's ready to move up to ASP.Net 2.0. I recommend it.
Presentation: An Application for Executing Ad Hoc SQL in a Regulated Environment What do you do when the data in an application is incorrect and the application isn't able to correct the situation? You fix it, right? That approach doesn't sit well with the policies required by the regulatory compliance requirements of HIPPA and SOX, nor do auditors look on it favorably. This presentation demonstrates an application built to allow ad hoc changes to data and create an audit trail of changes. Along the way we'll see some interesting T-SQL and use of SQLXML.
