Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Jonathan Roberts 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: | Category: certificates
Rating: |  Discuss |   Briefcase | 7,865 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: | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 26,620 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,121 reads
   Items 1 to 3 of 3