Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

K. Brian Kelley - Databases, Infrastructure, and Security

IT Security, MySQL, Perl, SQL Server, and Windows technologies.

Archives: August 2006

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…

Read more

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…

Read more

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…

Read more

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…

Read more

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…

Read more

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…

Read more

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…

Read more

Does your organization need a DBA? (part 2)

This is a follow-on to Does your organization need a DBA? and Andy Leonard's Database Professionals: An Enterprise Requirement.

I was doing my morning reading and came across this nugget from Jose Barreto:

Maintaining your MOSS 2007 SQL Databases


Mr. Barreto's point is that while Microsoft Office Sharepoint…

Read more