The top 10 SQL Server 2008 features for independent software vendor (ISV) apps, starting with data and backup compression, with the pain points and limits of each.
SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure
An introduction to CLR in SQL Server 2005 and later, with a simple CLR Stored Procedure built in Visual Studio that prints the current system datetime.
SQLAuthority News – Download – Microsoft SQL Server 2008 Feature Pack, August 2008
Download the 2008 Feature Pack for SQL Server 2008: stand-alone packages with redistributable components, add-on providers and backward compatibility tools.
SQL SERVER – 2008 – Enhenced TRIM() Function – Remove Trailing Spaces, Leading Spaces, White Space, Tabs, Carriage Returns, Line Feeds
Need to remove trailing spaces, leading spaces, tabs, carriage returns and line feeds? Here is an enhanced TRIM function built from a script by Russ and Erik.
SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported – VS SP1 ISO Download
Visual Studio SP1 fixes the server version error with SQL Server 2008. Vidya Vrat Agarwal points out the VS SP1 ISO download, handy for many computers.
SQL Server – 2008 – Cheat Sheet – One Page PDF Download
A one-page SQL Server 2008 cheat sheet PDF with the commands DBAs and developers use every day. Print it on A4 and keep it handy.
SQL SERVER – Guidelines and Coding Standards Complete List Download
Coding standards and guidelines matter for every developer. Here is my Coding Standards Complete List in one document you can download and follow.