Gartner named the top 10 strategic technologies for 2009, from virtualization to cloud computing. Here is the list with a short note on each one.
SQL SERVER – Interesting Interview Questions – Revisited
Readers took my Interesting Interview Questions test seriously. See who got the correct answer, and why good T-SQL mattered more than the schema.
SQL SERVER – Top 10 SQL Server 2008 Features for Independent Software Vendor Applications
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.
SQLAuthority News – SQL Server White Paper: SQL Server 2008 Compliance Guide
The SQL Server 2008 Compliance Guide white paper shows how to use SQL Server 2008 features to meet regulatory needs, alongside the compliance SDK.
SQLAuthority News – TOP Downloads – Bookmark
My top downloads in one post to bookmark, since the sidebar does not show in RSS: SQL Server interview questions and answers and the SSMS keyboard shortcuts.
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.
SQL SERVER – Downgrade Database to Previous Version
Can you downgrade database files from SQL Server 2005 to 2000? No tool does it. Install the old version, recreate the schema and move the data yourself.