Category Archives: Windows

Backing up MS SQL 2005 with SSQL management studio express

Posted on 2010/09/30 by Pete

Problem You have a production database that you need to write SQL reports against. You are an experienced IT professional, and you know that writing SQL against the production data is not advisable. As a result you have decided to … Continue reading →

Posted in Dedicated Servers, Managed Hosting, Services, Windows | Tagged | Leave a comment

DB2 9.7.2 Log files on Windows 7

Posted on 2010/06/12 by Balazs

Problem Since Windows Vista (that includes Windows 7), the place where programs store some of their information has changed. This makes finding the DB2 log files (equivalent of db2diag.log) more difficult. Solution The log files have moved under the directory … Continue reading →

Posted in DB2, Windows | Tagged , , | Leave a comment

Create Explain Tables in DB2 9.7

Posted on 2010/06/01 by Balazs

Problem The explain tables allow to create access plans and visualize them. Before the explain feature of DB2 can be used, the EXPLAIN tables need to be generated. Solution To create the EXPLAIN tables, the following command needs to be … Continue reading →

Posted in AIX, DB2, Linux, Mac OS X, Windows | Tagged , | Leave a comment

NetApp bonded VLAN configuration

Posted on 2010/03/17 by Balazs

Problem To maximize the benefit from the multi-port adapters on a NetApp, it is best to bond the ports together (some vendors refer to this as “trunk groups”). Then over the new bonded trunk, the various networks can be assigned … Continue reading →

Posted in AIX, Linux, Mac OS X, OpenBSD, Windows | Tagged , | Leave a comment

How to add a secure cert to IIS on Windows

Posted on 2009/05/31 by Balazs

To add an SSL cert to IIS 5 on Windows, you need two separate steps: Create a p12 (pkcs12) cert file: cat server.key server.crt > server.pem openssl pkcs12 -export -in server.pem -out server.p12 -name “server” Import the p12 file into … Continue reading →

Posted in Windows | Tagged , | Leave a comment

How to find the full email headers (a.k.a. internet headers) in Outlook?

Posted on 2009/05/31 by Balazs

To be able to report SPAM, Viruses, or any other problem with email, the system administrators need the full email headers. These can be easily found in Netscape or Mozilla Thunderbird, just by viewing the raw message source, or by … Continue reading →

Posted in Windows | Tagged , | Leave a comment

How to set up PPTP on Win2k

Posted on 2009/05/31 by Balazs

Setting up a folder for PPTP access: Right click and select properties Select Sharing tab Check “Share this folder” and give it a share name Click the permissions button, and make sure that only the right user(s) have permission Setting … Continue reading →

Posted in Windows | Tagged , | Leave a comment

Rebuild Postgres for specific platform

Posted on 2009/05/31 by Balazs

# rpm -i postgres-[version number].src.rpm # rpmbuild -bb –target i686 /usr/src/redhat/SPECS/postgresql.spec If you get a problem with unpackaged files, use the following trick: vi /usr/lib/rpm/macros An modify some of the lines as follows: # # Script gets packaged file list … Continue reading →

Posted in AIX, Cloud Computing, Data Warehouse, Dedicated Servers, Linux, Mac OS X, Managed Hosting, OpenBSD, Windows | Tagged | Leave a comment

How to clear the DNS cache on Windows?

Posted on 2009/05/29 by Balazs

To clear the DNS cache on windows, you can either reboot, or open a DOS window, and run: ipconfig /flushdns

Posted in Windows | Tagged | Leave a comment

Permanently map network drive without logon (Win2k/Windows 2000 server)

Posted on 2009/05/29 by Balazs

If your running Windows 2000 server, or newer, you can edit the server gpo “computer logon script” section to map the drive. This script gets processed before anyone logs on. Here are the detailed steps to do that: Start -> … Continue reading →

Posted in Windows | Tagged | 2 Comments