Blog

Have you ever imagined what would happen if a medium to large business suffers massive data loss due to a hardware failure, and no backup procedures were in place? Tens of thousands of dollars – even millions – could be lost. The worst part of this situation is that network administrators know they should backRead more

A normal” SQL installation on a standard Windows Server will usually run without performance or bottleneck issues. However, a 32-bit server with 4 processors or less uses only 256 worker threads, which is predefined by the SQL installer. But if your system will be generating a fairly large load of data, the number of MaxRead more

[:en]We’re often asked about how to move SQL databases from one server to another. Here are some quick and easy guidelines to help out you out. Assuming you already installed SQL on your new server, your next step would be to start detaching the database from the SQL application on the old server.  –  Stop allRead more

SQL is installed on your server but not all is as it seems. You begin to notice performance related issues and a delay in the transmission of data. This can be the result of having the configuration manager of SQL configured to use invalid IP addresses. Example: SQL is installed on server 192.168.0.182, however, inRead more

Your corporate data center is hit with a power outage. All UPS systems are running and operational or are they? You soon realize that a faulty UPS system supporting your networks database environment has not done its job. All data are still intact and there does not seem to be any corruption, except for theRead more