-
Script to set default data and log file folder in SQL Server 2005
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
-
My WordPress backup and restore process
As I am writing and publishing more and more blog entries, it becomes important that I have good and reliable backups. I know that if something happens and I cannot recover my entries and comments, I would be terribly upset. So I want to share my process here. Please feel free to share your backup […]
-
Tunneling http traffic through ssh
James Strassburg gave a great tutorial on tunneling http(s) traffic through ssh with your Linksys WRT-54GL router. Actually, if you have a server that you can ssh to that has web access, like your web host, you can tunnel all your http(s) traffic through that server from your Windows workstation. It is pretty simple to […]
-
sqlcmd error handling
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. […]
-
File type, directory size, free space, disk usage, and tar in Linux
A few quick notes for people who want to know how to do simple things in *nix. This is for Windows users who are making the transition or find themselves dealing with *nix from time to time. Use file FooBar to find out what kind of file FooBar is. This is helpful when you need […]