-
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?
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…
-
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…