To calculate the lenght of a TEXT field the LEN function used to calculate the length of VARCHAR fields won’t work. You need to use the DATALENGTH T-SQL function: SELECT DATALENGTH(myTextField) AS lengthOfMyTextField
Search Engine Rankings – Instant, online reports of web site rankings in 8 top search engines and web directories, including Google, Yahoo! Search, Bing (MSN), AOL, AltaVista, AllTheWeb, Yahoo! Directory, and Open Directory (Dmoz).
Bulk mailbox-enabling users using the Exchange console In Exchange Server 2007 SP1, the Exchange console (EMC) allows you to create mailboxes for existing users. When selecting an existing user in the New Mailbox wizard, you can select multiple users by using the regular SHIFT-Click (to select a continuous list of users) and CTRL-click (to pick […]
Powershell’s get-wmiobject commandlet makes getting the Dell service tag or serial number for (some) other computer models easy. Get-WmiObject win32_SystemEnclosure | select serialnumber This worked for me successfully with Dell and SuperMicro, however it didn’t work on and HP computer I have. Haven’t tried it on IBM or others yet. . .
AD Users & Computers UI lets you list the mail column for each object, which displays the default (SMTP) email address for objects. You can export the list from ADUC as csv/txt. However, any additional email addresses in the proxyAddresses attribute are not exported. There’s no GUI to list/export all email addresses. Here’s a script […]
How do we add email addresses to Public Folders? It should be pretty simple – If Get-Mailbox shows the emailaddresses property for a mailbox, and Set-Mailbox allows you to use the -EmailAddresses switch to add email addresses, one can’t be blamed for believing it’ll work the same way for Public Folders. Objects other than Public […]
How do I find out which service is listening on a specific port? How do I find out what program is listening on a specific TCP Port? Under Linux and UNIX you can use any one of the following command to get listing on a specific TCP port: lsof : list open files including ports. […]
Modifying the Width of Your Blogger Blog Here is a quick step by step tutorial on how to change the width of your Blogger Blog. It will show you how to change the standard template so that the width is the same as this blog. This basically entails 4 things. First you increase the width of […]
Can you explain /etc/shadow file used under Linux or UNIX?/etc/shadow file stores actual password in encrypted format for user’s account with additional properties related to user password i.e. it stores secure user account information. All fields are separated by a colon (:) symbol. It contains one entry per line for each user listed in /etc/passwd […]