Lewis Bruck's musings on SQL Server and .NET

Please read my first post to understand the goals and security implications of the samples I am presenting. I will assume that you are in the sysadmin role on your SQL2005 server, you are using a program that allows you to execute TSQL commands (like...

One of the many features in SQL2005 is the ability to create stored procedures, functions (UDFs), and user-defined data types (UDTs) in any .NET language. As might be expected, most of the examples available are in C# and Visual Basic. However, I think...

Generating a sequence of integers as a table is a useful utility to have. Historically, this was done either by having a temporary table or falling back to a TSQL while loop. However, the UDT feature in SQL2000 and the CTE (common table expression) feature...

I am an SDET (aka tester) in the SQL Server Storage Engine group. I want to use the blog to share what I find interesting, useful, or exciting about SQL2005, .NET, C#, or databases in general.