in

SQL Server Blogs

Voices from the UK SQL Server Community

Browse by Tags

  • Good practices - database programming, unit testing

    Jason Brimhall wrote today on his blog that new book, Defensive Database Programming , written by Alex Kuznetsov ( blog ) is coming to bookstores. Alex writes about various techniques that make your code safer to run. SQL injection is not the only one vulnerability the code may be exposed to. Some other...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Mon, May 24 2010
  • COLUMNS_UPDATED() for audit triggers

    In SQL Server 2005, triggers are pretty much the only option if you want to audit changes to a table. There are many ways you can decide to store the change information. You may decide to store every changed row as a whole, either in a history table or as xml in audit table. The former case requires...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Wed, Apr 28 2010
  • Coding standards

    This post will be about coding standards. There are countless articles and blog posts related to this topic, so I know this post will not be too revealing. Yet I would like to mention a few things I came across during my work with the T-SQL code. Naming convention - there are many of them obviously....
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Thu, Mar 11 2010
Page 1 of 1 (3 items)
Powered by Community Server (Commercial Edition), by Telligent Systems