Basilik II – Open Source 68k Macintosh Emulator

Basilik II is an open source Mac emulator, emulating 68k Macs. Recently I’ve set up a virtual Mac running System 7.5.3 using Basilik II. Once I had the right files / images, it was relatively straight forward to set up and configure virtual Mac.

To set up a Mac using Basilik II, you’ll need:

Emaculation also has great installation guides which you should also read through:

Here is a few screenshots of Basilik II running under OS X.

Advertisements

MS SQL – Find number of open connections

If you need to find out how many connections are open, use the following script:

SELECT 
    DB_NAME(dbid) as DBName, 
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
FROM
    sys.sysprocesses
WHERE 
    dbid > 0
GROUP BY 
    dbid, loginame

This will list all databases, number of open connections and DB logins under which those connections are open.