SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Programming, SQL Server 2005, .Net Rss

   Items 1 to 4 of 4   

A T-SQL Regular Expression Library for SQL Server 2005

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.  Read more...
By Additional Articles 2007/07/25 | Source: CodeProject.com | Category: .net
Rating:  Rate this |   Briefcase | 3,904 reads

Gathering Metrics with SMO

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.   Read more...
By Allen White 2006/11/22 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 5,798 reads

WebService - Enabling SQL Server 2005 Procedures

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.  Read more...
By Additional Articles 2004/11/04 | Source: Other | Category: .net
Rating:  Rate this |   Briefcase | 3,001 reads

Writing Managed Stored Procedures in SQL Server 2005

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.  Read more...
By Additional Articles 2004/11/01 | Source: DevX | Category: .net
Rating:  Rate this |   Briefcase | 4,242 reads
   Items 1 to 4 of 4   
development (2)    
performance tuning (1)    
sql clr (1)