THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » t-sql » programming   (RSS)
  • Dynamic SQL and Late Binding

    We all know that dynamic SQL runs in its own scope (see here for details), and that if used improperly it can have serious security implications.  But it's also important to realize that dynamic SQL evaluates your SQL statements more like a stored procedure than a regular script.  In stored procedures, if the tables you reference ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on June 23, 2010
  • Please Vote: Windowing Enhancements in SQL Server

    Back in January 2007, SQL guru Itzik Ben-Gan posted a series of MS Connect enhancement requests concerning windowing function enhancements.  Those who have used the ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE() functions on SQL 2005 and 2008, you already know how useful they are.  They simplify code and can improve performance ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on November 19, 2009
  • "Cloning" Symmetric Keys

    It's well-known by now that SQL Server 2005 and 2008 include new encryption-related statements that allow you to create and administer encryption keys. You can use CREATE CERTIFICATE to create or import a certificate or DROP ASYMMETRIC KEY to remove an asymmetric key from the database, for instance.  One of the interesting ommissions ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on June 17, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement