Anthony Bloesch's Web Log

A WebLog about SQL Server development.
Posts
  • Anthony Bloesch's Web Log

    T-SQL casing conventions feedback

    • 1 Comments
    Thanks everyone for the great blog and email comments on how we should deal with T-SQL casing conventions. Here is a summary of that feedback....
  • Anthony Bloesch's Web Log

    Uppercase or lowercase T-SQL keywords

    • 10 Comments
    I have been rethinking using uppercase letters for T-SQL keywords. Readability research shows that uppercase keywords are harder to read and experience shows they are harder to type. Is it just tradition that keeps T-SQL developers uppercasing keywords?...
  • Anthony Bloesch's Web Log

    When to use SQL Server 2005's XML data columns

    • 0 Comments
    SQL Server 2005’s support for XML has improved substantially. The new internal representation of XML and XML indexes supports much faster queries and updates. SQL Server 2005 supports querying and updating XML with XQuery, a powerful second-generation DML language for XML. Finally, SQL Server provides good support for converting between and relating relational and XML based data. Now that XML data has such good support in, the choice of when to use an XML column and when to use standard relation...
  • Anthony Bloesch's Web Log

    Surrogate keys

    • 67 Comments
    After you have been building databases for a while, surrogate keys become second nature but many people do not know about them so I thought I should devote some time to them. In addition, a constant challenge is choosing between using an int or a uniqueidentifier (i.e. GUID) as a surrogate key and I thought this would be a great forum to get some feedback on when you should use one or the other....
  • Anthony Bloesch's Web Log

    Database design made easier

    • 80 Comments
    Compared with the development experience for, say, C# and Visual Basic the T-SQL development experience is terrible—no intellisense, refactoring, unit testing, code coverage or even good error reporting. Yet many developers spend large amounts of time building T-SQL code. SQL Server comes with a great set of tools for DBAs and for operational management but the T-SQL development experience is not even close to what I get with C#. ...
Page 2 of 2 (30 items) 12