THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Adam Machanic

Adam Machanic, Boston-based independent database consultant, writer, and speaker, shares his experiences with programming, performance tuning, and optimizing SQL Server 2000, 2005, and 2008, in conjunction with related technologies such as .NET.

Celko on SQL CLR: "database design is a totally different skill from application development"

Originally posted here.

 


More fun CLR conversation, this time from SQL advocate Joe Celko.

Surprise, surprise, Celko is not a big fan of CLR integration. Yet he mentions the SQL/PSM standard as a better alternative, even though it has the same issues he mentions. But it's open-source (Java-based), so it must be better. Right?

Why is the CLR integration getting so much attention? Oracle, DB2, PostgreSQL, and other DBMSs have had these kinds of features for a long time. Where was Celko when those were being added? Why argue with Microsoft now? And how much damage has been done by the inclusion of these features in those database systems?

That said, I do agree with a lot of what Celko has to say; application developers will be able to do a lot of damage with these features, if DBAs let them. If management lets them. If they don't get appropriate training. These are all very valid points. Watch this space in the coming months for a lot of discussion on best practices for using these new tools. I think that MS marketing has taken things too far (see my post from yesterday on the related topic of "CLR replacing T-SQL"), but at the same time I do believe these tools have their place and with very careful use will prove to be extremely valuable.

I think it's time for DBAs to accept the fact that they're not going to be able to get by any longer as just database geeks. Learn about application architectures. Learn how and why applications are using your databases. And most importantly, learn enough to argue with the application developers who might otherwise bring ruin to your pristine database systems. But do not, like Celko, fear change. Instead, learn how to wisely integrate these new tools into your arsenel.



Published Wednesday, July 12, 2006 10:40 PM by Adam Machanic
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(optional)
(required) 
Submit

About Adam Machanic

Adam Machanic is a Boston-based independent database consultant, writer, and speaker. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and has optimized data access layer performance for several data-intensive applications. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "Expert SQL Server 2005 Development" (Apress, 2007) and "Inside SQL Server 2005: Query Tuning and Optimization" (Microsoft Press, 2007). Adam regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server and a Microsoft Certified IT Professional (MCITP).
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement