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

Guest Columnist: Jonathan Roberts

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Using Certificates to Sign Stored Procedures

How to sign stored procedures with certificates, this is useful if the procedures use dynamic SQL.  Read more...
By Jonathan Roberts 2010/06/21 | Source: SQLServerCentral.com | Category: certificates
Rating: |  Discuss |   Briefcase | 7,628 reads

Use Dynamic SQL to Improve Query Performance

This article by Jonathan Roberts demonstrates how to use dynamic SQL and overcome its downsides.  Read more...
By Jonathan Roberts 2012/02/17 (first published: 2010/05/20) | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 26,340 reads

Version Control your Stored Procedures

This shows a method for generating scripts for SQL Server stored procedures and functions so they can be added to a version control management system (VCMS).  Read more...
By Jonathan Roberts 2010/05/06 | Source: SQLServerCentral.com | Category: version control
Rating: |  Discuss |   Briefcase | 17,898 reads
   Items 1 to 3 of 3