Author Archives: jacob

Using Mediawiki as a documentation tool

Some years ago, a coworker introduced me to using Mediawiki as a documentation tool and I got immediately hooked on it. The biggest pro is that it’s very easy to use and install (millions of people already use it on … Continue reading

Posted in Linux, Mediawiki, Tips | 1 Comment

Distribution database causing high disk IO, many reads / sec.

Playing around with VMWare performance data, i found a server with unusual high disk IO, and by that I mean registering around 300 MB/sec all the time. This server was a SQL Server 2008 R2 with some tables being replicated … Continue reading

Posted in DBA, SQL Server | Leave a comment

Review of Ola Hallengren’s Scripts

Ola Hallengren is a Swede (I presume) who have developed these nifty scripts for performing backups, index maintenance and database checks. I’ve been using them for some years now and really favour them opposed to the built in Maintenance jobs … Continue reading

Posted in DBA | Leave a comment

SQL Server 2008 R2 failed to install

I recently got this error when trying to install SQL 2008 R2 Developer edition (64 bit) on my Windows 7  Enterprise (64 bit) workstation: SQL Server setup has encountered the following error: msigetproductinfo failed to retrieve productversion for package with … Continue reading

Posted in SQL Server | Leave a comment

Change default Collation in SQL Server 2005

I recently had some trouble selecting the proper Collation/Sort order when setting up a new SQL 2005 installation. There was a small number of Collations/Sort Orders but not the one I needed. The official webpage for that didn’t give much … Continue reading

Posted in SQL Server | Leave a comment

Query WSUS server

On a regular basis we patch our Windows Servers and it would be nice to get a realtime view of just how patched our servers are – which servers are not yet patched and how many patches are about to … Continue reading

Posted in SQL Script, Tips, WSUS | Leave a comment

Attaching database that wasn’t detached

I recently had an interesting issue where a Virtual SQL Server was deleted from VMWare, just like that with no nice shutdown and certainly no last backup & detach database commands. We were fortunate to locate and mount the data … Continue reading

Posted in DBA, SQL Server, VMWare | Leave a comment

DKIM + MailMan = Trouble

I have a couple of mail lists running on a virtual Linux box. I set them up a while ago and they kept on running for couple of years until a thing called DKIM came in through the cat door … Continue reading

Posted in Linux | 1 Comment

Memory running low on SQL Server

Looking at performance counters for a SQL Server, I noticed that the Page Life Expectancy (PLE) counter was very low for this server. A quick description of PLE is how long data is stored in the memory of SQL Server … Continue reading

Posted in SQL Server | Leave a comment

New MySQL database

Here is the syntax for creating a new db in MySQL with a login and full permissions for that user. Perfect for setting up that L.A.M.P. :-) CREATE DATABASE verity_db; CREATE USER ‘verity_user’@’localhost’ IDENTIFIED BY ‘password’; GRANT ALL ON verity_db.* … Continue reading

Posted in MySQL | Leave a comment