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
Month: October 2009
Gutenberg Project – free audio files legally
http://www.gutenberg.org/browse/categories/1
Free Search Engine Rankings Check
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).
Exchange Server 2007: Bulk mailbox-enabling users using Exchange Shell
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 […]
Getting Dell Service Tag using PowerShell
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. . .
HOW TO: Export all email addresses from a domain
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 […]
Exchange 2007 HOW TO: Add Email Addresses To Public Folders
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 […]
Linux / UNIX Find Out What Program / Service is Listening on a Specific TCP Port
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. […]
How to Change the Width of Blogger Blogs
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 […]
Understanding the Linux /etc/shadow file
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 […]