Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Programming, SQL Server 2005 Rss

   Items 1 to 5 of 5   
 

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,631 reads

PowerSMO At Work Part I: DBA Scripts and Functions

Dan Sullivan delves deeper into PowerSMO, the versatile command line utility for managing SQL Server databases. Using a certificate strategy, he provides a step-by-step guide to creating and deploying secure, signed DBA scripts. He then describes how to use PowerSMO functions to manage the extended properties of SQL Server objects.  Read more...
By Additional Articles 2007/03/13 | Source: SimpleTalk | Category: sql-dmo
Rating:  Rate this |   Briefcase | 2,818 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,767 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 | 2,699 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 | 3,892 reads
   Items 1 to 5 of 5   
 
Tags
.net (4)    
development (2)    
performance tuning (1)    
smo (1)    
sql clr (1)    
sql-dmo (1)