-
Setting sqlcmd environment variables
In this post, I talked about how you can set your default editor for sqlcmd. At the end of that post, I asked how to make that variable persist. To do that, you can create an environment variable. For example, you can create an environment variable called sqlcmdeditor, and give it the value of your…
-
DotNetNuke 3.1.0 initial setup
My own experience of setting up DotNetNuke (DNN) 3.1.0. Hopefully somebody will find it useful. 1. Installed a standard Windows 2003 server. Through Manage Your Server wizard, chose custom and installed as an Application Server (IIS and ASP.NET). FrontPage extension and ASP.NET were installed. Install media was required during IIS install; 2. Downloaded DNN 3.1.0.…
-
Don’t over do it, Sql Server; Watch out, Oracle
SQL Server 2005 was released in November, 2005. I actually played with it much earlier than that. Overall, I am pretty happy with it. I think it is a great product, and will give Oracle’s namesake RDBMS a run for its money. Previously, there were a lot of arguments against Sql Server for its perceived…
-
Do you want a free book on Sql Server Integration Services?
-
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