http://www.sqlservercentral.com/Content tagged .Net, SQL Server 2005 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)This article shows the reader how to construct a library of scalar and table valued functions for SQL Server 2005 to perform regular expression analysis.http://www.sqlservercentral.com/redirect/articles/3099/2007/07/25http://www.sqlservercentral.com/redirect/articles/3099/Keeping track of the performance of your SQL Servers requires metrics. There are many methods for doing this, but some type of automated process is essential these days with DBAs managing many servers. New author Allen White brings us a technique for doing this using SMO, the replacement for DMO in SQL Server 2005. http://www.sqlservercentral.com/articles/Performance+Tuning/2692/2006/11/22http://www.sqlservercentral.com/articles/Performance+Tuning/2692/One of the most interesting features that I'll explore is that you can now create WebServices in the database tier directly, without resorting to "add ons" or even the use of IIS at all. One of the many extensions to Transact SQL is the new CREATE ENDPOINT statement, which allows the developer to create an endpoint directly from SQL Server 2005, which hooks right into the Kernel Mode HTTP.SYS driver, exposing functions and stored procedures written either in T-SQL or native CLR methods/classes.http://www.sqlservercentral.com/redirect/articles/1564/2004/11/04http://www.sqlservercentral.com/redirect/articles/1564/Are you tired of struggling with T-SQL to encapsulate the logic your applications need to get data into and out of SQL Server? Now you can bypass SQL altogether, and write logic that runs directly within SQL Server in your favorite .NET language.http://www.sqlservercentral.com/redirect/articles/1563/2004/11/01http://www.sqlservercentral.com/redirect/articles/1563/