K. Brian Kelley - Databases, Infrastructure, and Security - August 2006 - Blogs

Removing SQL Server Express from VS Team System for Database Professionals CTP 5

As I indicated in my previous post, Visual Studio Team System for Database Professionals CTP 5 Out, if you don't already have a default SQL Server Express instance installed, the installer will install one for you. There's not an option to not install it. I did attempt to patch…

0 comments, 373 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 24 August 2006

Visual Studio Team System for Database Professionals CTP 5 Out

If you aren't aware, the Visual Studio Team System for Database Professionals CTP 5 is available for download. It's a significantly larger install package than CTP4, going from 30 MB to 120 MB.

Team System for Database Professionals CTP 5 Download

As with the other CTPs, you have to uninstall…

1 comments, 428 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 23 August 2006

The Importance of Database Coding Standards

I was working with a developer the other day and the question came up of how to return status from a stored procedure. There's basically four ways to do this in SQL Server:

return code from the stored procedure
use an output parameter
return it as a resultset/recordset
indicate errors…

3 comments, 469 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 17 August 2006

Presentation slides and sql scripts up

I have posted the slides for the presentation I gave to the DotNet Columbia User Group. The talk was called, "Something old, something new, something borrowed, something blue." Everything for the presentation is there in the notes, with the exception of the clip I showed from the BlueHat briefings…

0 comments, 117 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 9 August 2006

Visual Studio Team System - Database Professionals: Database Connection Error

If you're like me, you don't have SQL Server 2005 sitting on the default instance because SQL Server 2000 is sitting on the default instance. I actually have several instances installed, one of which is a SQL Server Express instance. I finally got around to downloading and installing Visual Studio…

0 comments, 106 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 6 August 2006

Identifying NTLM vs. Kerberos authentication using Fiddler

I saw this post on using Fiddler to tell the difference between an NTLM and a Kerberos connection to a web server.

Two easy ways to pick Kerberos from NTLM in an HTTP capture

If you aren't aware of what Fiddler is, it's a web proxy that will allow you…

0 comments, 463 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 2 August 2006

Excellent article on SQL Server 2005 Common Table Expressions

SQL Server MVP Nigel Rivett has written an excellent article on Common Table Expressions on Red Gate Software's Simple Talk site:

SQL Server 2005 Common Table Expressions

He goes beyond the basic recursion examples to show several very useful reasons to implement CTEs. If you're developing in SQL Server…

0 comments, 153 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 2 August 2006