Cautious Optimism on SQL Server 2005: TDWI

The CLR is definitely a BIG deal. Glad to see it is getting some attention. For those that have been under a rock (and the DBAs that don't have a developing background), the CLR will allow someone to write a stored procedure (if they have permission) using any language that .NET supports, which is just about any language ever made. Java? Perl? C#? You name it, it can be done.

Obviously, there is a hiden message here - if you don't have a developing background, it would pay to get familiar with a little scripting as a DBA...

Wonder what the long term effects of this might be. It IS possible that SQL Server 2005 could become an application server. Smart? probably not, but it is possible.

Cautious Optimism on SQL Server 2005: TDWI: "When Microsoft Corp. finally ships SQL Server 2005, enterprise programmers�many with little or no experience programming directly to a SQL Server database or data warehouse�are going to get a crack at doing just that. That worries some business intelligence (BI) and data management pros, who argue that clumsy programming by inexperienced code jockeys could seriously impact the performance and reliability of SQL Server data warehouses

Today, coding for SQL Server 2000 typically involves one of three approaches: learning Transact-SQL (T-SQL); using ADO.NET clients or other bridging technologies to build middle-tier and front-end applications; or using a third-party Common Language Runtime (CLR) assembly that isn�t natively integrated into SQL Server 2000."