The choice of hard drives is crucial to achieve good performance with SQL Server, all versions: 15000 rpm SAS drives will of course outperform the SATA II 7200 rpm. The first will offer a number of input-output per second and therefore higher rates of larger transfers, which is extremely important for use in a server database where the limiting factor is often the performance of RAID and not the processor.

There is a relatively little known to increase further the number of inputs / outputs per second (IOs / s) on Windows 2003 if you use a RAID partition alignment. Since Windows 2008 partition creation automatically manages this optimization on Windows 2003 but it must be done manually.

RAID 5

continue reading "Aligning partitions for SQL Server"

In this article we will discuss one method to merge two (or more) SVN repositories in a new repository in Ubuntu. This works of course also perfectly in a repository that already exists.

Subversion

continue reading "Merge two SVN repositories on Ubuntu"

Visio is an excellent tool for creating network diagrams to quickly understand the organization of the servers in your company. With a few lines of Visual Basic you can integrate a console and SSH access to Remote Desktop to different servers, which may facilitate the administration of your network.

Visio network diagram example

continue reading "Using SSH and Remote Desktop with Visio"

It's a bit hackneyed to the obvious length of the Internet but the backups, that's fine. Beyond the physical risks incurred by your server (fire, flood, vandalism, Martians ...), it is always good for the heart to have backups in case of error handling ...

I melt, I foooonds!

In this article we'll look back in a simple and important files to a SQL database server to a Ubuntu (or more generally any Linux server).

continue reading "Managing backups files and MySQL on Ubuntu"

Since the update my iPhone 3G version 3.1.3 to iOS 4 I meet many, many delays and jerks, especially in games. As few new features to the iPhone 3G granted to me are not necessary, I decided to downgrade to version 3.1.3 which, without being complicated, however, application instructions are followed.

la mise à jour vers iOS 4. Caution: This method only works without data loss in case you have a backup of your iPhone made ​​before updating to iOS 4. If you have a backup made after you get an iPhone reset and you will lose data, therefore, as your SMS for example.

continue reading "Restoring an iPhone 3G iOS 4 to 3.1.3 Snow Leopard"