September 2006 - Posts

• Non-Technical: I'm now a father of two...

  My lovely wife, Claudia, delivered our new baby girl on Monday, 25 September at 2:49 PM CDT. Kate weighed 6 lbs, 5 oz and was 19 inches long. She joins her 3-year-old brother, Christopher, to make us four in total. Katie gave us quite a scare during the Read More... Posted Friday, September 29, 2006 10:54 AM by Peter W. DeBetta | 5 Comments Attachment(s): DSC03375 (Small).JPG

• Another RegEx Trick for SSMS

  So I wanted to have some consistency in some T-SQL code for bracketed identifier use. Objects in the code had bracketed identifiers in some cases, and not in others (sometimes even on the next line of code) and so I saw both TableName and [TableName]. Read More... Posted Tuesday, September 19, 2006 11:53 PM by Peter W. DeBetta | 0 Comments

• Accessors and Case-Sensitivity in T-SQL and CLR

  So in my preparation for the 2006 PASS Community Summit presentation that I will be giving on Managed Types in SQL Server 2005, I was mulling over the statement that "Accessors are case-sensitive" and decided to test out some things. Yes, if you have Read More... Posted Monday, September 11, 2006 5:37 AM by Peter W. DeBetta | 1 Comments Attachment(s): test.sql

• Replacing Quoted Identifiers with Bracketed Identifiers

  So I just generated a DDL script using Visio and it uses quoted identifiers for all object names. But I don't like quoted identifiers and much more prefer bracketed identifiers. So how do I manage to replace all those pesky double quotes? Why, simply Read More... Posted Saturday, September 09, 2006 8:32 PM by Peter W. DeBetta | 7 Comments