Tips/How To

Another work related issue I ran into. For Windows XP you have this great tool called TweakUI which helps you set an auto login for Windows. It can be used on domains as well as local. For Windows 7 however, such a tool doesn’t exist. So how do I get my Windows 7 pc to automatically log onto the domain?

To do this you need to mess around in the registry a bit. So click Start and go to Run. Type regedit and press the OK button.

Find the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows...

Some time ago I was looking for a way to export iTunes track information into a platform like MSSQL to be able to create some fun toplists and stuff. Actually I have more plans to use this in a later stage, but for now I wanted to share this.

First go to your My Music/iTunes and copy the Library.xml file, or export your library using iTunes, to the c root of the machine where you have Microsoft SQL installed. Rename the file if needed to Library.xml.

Next we start the Microsoft SQL Server Management Studio and create a database. Next we select New Query and copy-paste the...

Today I had to change values in our database at work. We have Sets here that contain Instruments, each set has a STE value (number of sets that can be put in a washing machine). This was never used and now all of a sudden they needed every net to have such a number, so it was up to me to update 5000+ sets.

The definition of an STE was pretty simple, each set has a basket included in it’s instrument list on which the STE value can be based, but how can I get SQL to fill in the STE based on an instrument. This means using 2 different tables!

Using the code below I was able to...

Another question I got at work, someone wanted to have all instrument sets that remain sterile for 360 days for the operation rooms and all instrument sets that remain sterile for 180 days for other departments in the hospital.

In the application we use there is a table called PSET which has all information for instrument sets, as well as other variations on sets. First I made an easy query showing me everything I can with this table. It looked as follows:

Code:


SELECT    Bezeichnung
FROM       ...

For my work I had to restore one table from a backup. Now SQL doesn't have this function anymore since version 6.5 or so. But what if you can't restore the full database for whatever reason. Well here is how I did it, might not be the best solution, but it worked for me.

First I took the latest complete backup and restored it into a temporary directory, this way the whole database is restored including the table you need. Now first check if the table is indeed the one you need and all data is available, would be a shame to do it for nothing.

Next rename or delete the old table,...

Here I will write about some MySQL query's I have made, some of them might be useful, some might be learnful and other might be complete waste of display space, but just felt like sharing them. I will also be updating it often so check back often for more "nice" new query's.
Change a number in a field with a calculation
For a gameserver (Lineage II) that I run at home I needed to update a field to make it a thousand times larger, some of them had values that where to low. To do this I had to exclude all the 0 values and...

I wanted to make a new and advanced login script for use at my current job. Currently it's a *.bat file. Ofcourse this is very outdated now, so let's see if we can make something nice, new and shiny from it.

Current files/situation

Like told, currently all we have are a bunch of *.bat files. Each person has his/her own login script. An example of one of the scripts in *.bat format (all credit for these go to the person on this spot before me).

Code:

@echo off
cls
net...

When I started working at my current job there where no XP cd's available. We had one on the server but it wasn't bootable and only featured SP2. So I decided to make it bootable and add SP3 to it. And who knows, maybe I will try to add some more in a later stage

Integrating SP3 onto the files for cd

Copied all the files that where available from the SP2 cd to a new folder. Downloaded SP3 from the Microsoft site and downloaded a bootsector...