Viewing the disk space usage (size) of all the tables in a SQL Server 2005/2008 database

I spent a couple of hours searching for a script that returns the size of all the tables in a database. Most of the ones that you find use sp_msforeachtable but that is just for one table and you then need to use temporary tables to hold the values.

This article on the Database Journal by Ananth Kumar (AKA MAK) had this handy script that simply works by copy-pasting it as is. Read the linked article for details on viewing the size by schema.

How to Enable or Disable Hibernate in Windows 7

Hibernate feature allows operating system to save and write the running state and contents of RAM as a file or partition to non-volatile storage such as a hard disk, before powering off the computer. Hibernation allows system to quickly restart and restore to original state when hibernation was invoked, instead of having to close down and start up all the running programs again.

In Windows 7, hibernate option should be enabled and turned on by default, However, if you can’t find Hibernate option in the Start menu power button, the steps to enable Hibernate in Windows 7 is easy, and is the same with Windows Vista.
How to Turn On and Enable Hibernate in Windows 7

Make your own VGA cord of CAT5 cable!

i

As most of you know, getting a descent length of VGA monitor cable is a costly thing. With this instructable I'll show you how to make a 15m long VGA cable, out of plain ol' CAT5 network cable.

How to Re-brand Your Zimbra

Zimbra Collaboration Suite is an enterprise-class open source email, calendar and collaboration server. With the most innovative web application available today, Zimbra boosts the productivity of users on any desktop and dramatically reduces TCO compared to legacy platform vendors.
Other key advantages include advanced compatibility with existing desktop email clients, over-the-air sync to smart phones (iPhone, Android, BlackBerry) as well as better server scalability and more efficient administration.
This is an article that  that I have written to highlight some of the areas which one can customize to give the server a better look and feel. Note that you should apply this in compliance with the Zimbra license depending on the version your are using.


a.) To change the favicon:
The favicon is usually located in /opt/zimbra/jetty/webapps/zimbra/img/logo. You will need to overwrite this with your own icon! Simple!

How to configure Windows 7 to connect it to an iSCSI SAN.

First off, if you are looking for information on how to create your own FREE iSCSI SAN or to connect other operating systems to an iSCSI SAN, checkout the following articles:
Note:
This article assumes that you have already have an iSCSI SAN up and running. Besides that, I assume that you (or your SAN Admin) have already created an iSCSI share on that SAN and that the iSCSI volume has not yet been formatted with any OS /Operating system.
So, you have Windows 7 up and running but what do you do if you want to connect it to either the free SAN IiSCSI or OpenFiler from the instructions above. You could even just want to connect it to an existing iSCSI SAN and your storage admin has already created out a LUN for you.
Now that we have some background, let us configure Windows 7 to connect to an iSCSI SAN…

Configuring iSCSI in Windows 7

To get started, you need to run the iSCSI Initiator that is installed by default in Windows 7. You can access it in a couple of different ways.
One option is to access it through the Windows 7 Control Panel. Once inside control panel, on the address bar navigation, click on All Control Panel Items, then Administrative Tools, as seen in Figure 1.

List of Windows and DOS Command Prompt Environment Variables

Windows and DOS (Command Prompt) have several environment variables which provides a set of dynamic values that points to important system locations or settings. Environment variables provided a way for running programs and batch command script to access the true discrete values, system paths or user management settings for configuration and processing purposes, avoiding the use of hard-coded values which may fail on some systems due to great variety of system configuration.

Tip: Batch file (.bat or .cmd) also uses environment variables to store temporary values for reference later in the script, and also to communicate data and preferences to child processes.
The table lists the common built-in environment variables in Windows operating system, together with their brief explanations and default values. All environment variables is not case-sensitive.