SQL Clone
SQLServerCentral is supported by Redgate
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 | 8,021 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,699 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...
Rating: |  Discuss |   Briefcase | 18,152 reads
   Items 1 to 3 of 3