My publisher sent me some copies of our book, Professional SQL Server 2005 Integration Services. I have 5 or 6 copies that I would like to give away. I will sign each copy and make it the collector’s edition, so it is extra valuable 🙂 Here is the deal: 1. Priority will be given to […]

Hopefully your server has separate spindles for your database’s data and log files. Here is the script to define the default directory / folder for database data and log files in Microsoft SQL Server 2005: USE [master] GO EXEC xp_instance_regwrite N’HKEY_LOCAL_MACHINE’, N’Software\Microsoft\MSSQLServer\MSSQLServer’, N’DefaultData’, REG_SZ, N’ChangeThisToDefaultDataDrive:\data’ GO EXEC xp_instance_regwrite N’HKEY_LOCAL_MACHINE’, N’Software\Microsoft\MSSQLServer\MSSQLServer’, N’DefaultLog’, REG_SZ, N’ChangeThisToDefaultLogDrive:\log’ GO

I did manage to work while in Barcelona last month, not just to visit. I delivered a session on sqlcmd, attended other sessions, and learned from others. After the session, fellow PASS volunteer Thomas LaRock asked a great question regarding error handling. Pat Wright also talked about the same issue in this blog entry here. […]

In this post, I talked about some potential permission issues facing average users regarding Sql Server Management Studio (SSMS) reports. When you manage Sql Server 2000 servers with SSMS, those reports will not be available, for the simple reason that most of those reports are based on DMVs, which are newly introduced in SQL Server […]