We discovered SQL 2000 full text search required the SQL instance to run as a local admin account. This is not required under SQL 2005 due to changes in the...

Most books have good examples of simple environments, but don't match what we have in the real world. I support multiple environments (dev, qa, prod), for multiple clients (hosted web...

I have "Microsoft SQL Server 2005 Integration Services" (Kirk Haselden) from Sams and "Microsoft SQL Server 2005 Integration Services Step by Step" (many authors) from Microsoft Press. They take a...

[font="Arial"]Consider the following use of the specified "correct answer"[/font]

declare @DateOfBirth datetime

select @DateOfBirth = '2000-03-06'

select getdate() as [Today],

@DateOfBirth as [DateOfBirth],

DATEDIFF(yy, @DateOfBirth, GETDATE()) - CASE WHEN DATEPART(m, @DateOfBirth) >= DATEPART(m, GETDATE()) AND...

I have "Microsoft SQL Server 2005 Integration Services Step by step" and "Microsoft SQL Server 2005 Integration Services" and find both very helpful. Their examples offer slightly different perspectives. We...