administration

How Do I Find a File in a Subversion Repository History?

Is it possible to look back through the history of a subversion repository for files of a certain name (even better would be for them to have a wildcard search). I want to see if a .bat file has been committed to the repository at some point in the past but has since been removed in later updates. Even a dump of the file history at each...

Script to backup svn repository to network share

I have a svn repo on my machine. Anyone have a script to back it up to a network share? I'm using the repo locally since I'm disconnected a lot. The network share is on a server with a backup strategy. I'm a perfect candidate for git/hg but I don't want to give up my VS integration just yet. OS: Windows ...

How do I interpret 'netstat -a' output

Some things look strange to me: What is the distinction between 0.0.0.0, 127.0.0.1, and [::]? How should each part of the foreign address be read (part1:part2)? What does a state TimeWait, CloseWait mean? etc. Could someone give a quick overview of how to interpret these results? ...

VBScript/IIS - How do I automatically set ASP.NET version for a particular website

I need to script the creation of app pools and websites on IIS 6.0. I have been able to create these using adsutil.vbs and iisweb.vbs, but don't know how to set the version of ASP.NET for the sites I have just created to 2.0.50727.0. Ideally I would like to adsutil.vbs to update the metabase. How do I do this? ...

Cannot Add a Sql Server Login

When I try to create a SQL Server Login by saying CREATE LOGIN [ourdomain\SQLAccessGroup] FROM WINDOWS; I get this error The server principal 'ourdomain\SQLAccessGroup' already exists. However, when I try this code DROP LOGIN [ourdomain\SQLAccessGroup] I get this error Cannot drop the login 'ourdomain\SQLAccessGroup', because it...

Windows Mobile - What scripting platforms are available?

We have a number of users with Windows Mobile 6 and need to apply minor changes. eg. update a registry setting. One option is push and execute an executable file using our device management software. I'd like this to be a little more friendly for the admins who are familiar with scripting in VBScript/JScript etc. What are the options fo...

Minimalistic Database Administration

I am a developer. An architect on good days. Somehow I find myself also being the DBA for my small company. My background is fair in the DB arts but I have never been a full fledged DBA. My question is what do I have to do to ensure a realiable and reasonably functional database environment with as little actual effort as possible? ...

How do you update your web application on the server?

I am aware of Capistrano but it is a bit too heavyweight for me. Personally I set up two Mercurial repositories, one on the production server and another on my local dev machine. Regularly, when a new feature is ready, I push changes from repository on my local machine to repository on the server, then update on the server. This is prett...

How SID is different from Service name in Oracle tnsnames.ora

Why do I need two of them? When I have to use one or another? ...

What is th easiest way to copy a database from one Informix IDS 11 Server to another

The source database is quite large. The target database, doesn't grow automatically. They are on different machines. I'm coming from a MSSql, MySQl background and IDS11 seems overly complex (I am sure, with good reason) ...

How can I delete a service in Windows?

I have a couple old services that I want to completely uninstall. How can I do this? ...

How do I setup a local CPAN mirror?

What do I need to setup and maintain a local CPAN mirror? What scripts and best practices should I be aware of? ...

ColdFusion Template Request count optimization

In ColdFusion, under Request Tuning in the administrator, how do I determine what is an optimal number (or at least a good guess) for the Maximum Number of Simultaneous Template Requests? Environment: CF8 Standard IIS 6 Win2k3 SQL2k5 on a separate box ...

ColdFusion mail queue stops processing

Our CF server occasionally stops processing mail. This is problematic, as many of our clients depend on it. We found suggestions online that mention zero-byte files in the undeliverable folder, so I created a task that removes them every three minutes. However, the stoppage has occurred again. I am looking for suggestions for diagn...

Restarting ColdFusion mail queue

We are currently experiencing intermittent mail queue stoppages. I'm seeking diagnostic help in another area. In the meantime, is there a way to restart the CF mail queue without restarting the service as a whole? CF8 standard Win2k3 Solution: We are now checking the age of the oldest file in the mail queue. When it exceeds a set a...

CouchDB Backups and Cloneing the Database

We're looking at CouchdDB for a CMS-ish application. I know the database is implemented as a set of files in the file system, what I'm looking for are common patterns, best practices and workflow advice surrounding backing up our production database, and, especially, the process of cloning the database for use in development and testing...

Free (affordable) remote web based administration for Windows/IIS?

I've been using: Webmin Free, Apache only Cpanel Paid, Apache only I believe Plesk Paid, supports IIS Recently managing sites on our Windows/IIS machines have been becoming a chore. Installations, Configurations, Monitoring; have all been mostly done by hand and with a mess of scripts we've put together over time. Does anyone know o...

Preferred protocols to upload static files to your Apache server ?

Hello!If you were the administrator of an Apache web server, what protocol(s) would you prefer to provide, for the web developers to upload static files (html/gif/css/...), with the goal of maximum security ? If you were the web developer/graphic designer, what protocols would you prefer to be available at the Apache server, to upload st...

How to distribute and administer opensource-projects?

There are a lot of websites offering free hosting of opensource projects with bug tracker, version control, discussion boards, ...: Codeplex Sourceforge Codeproject Google Code ...? How would you administer and develop your own projects? When choosing one of those sites what benefits can you get from it? Is it even better to host it ...

php Access violation

I am trying to install Php on Vista (IIS 7). The installation and configuration seems to be fine. Pretty much followed everything mentioned in http://blogs.iis.net/bills/archive/2006/09/19/How-to-install-PHP-on-IIS7-_2800_RC1_2900_.aspx I can even bring up a test.php which is basically and can also connect to mysql db through code. But...