SQLServerCentral - Guest Columnist: Jonathan Roberts

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...

By Jonathan Roberts 2010/05/06 | Source: SQLServerCentral.com | Category: version control systems (vcs)

Rating:

|

Discuss |

Briefcase | 18,152 reads