Remove White Space and Special Characters in your T-SQL strings

Handling White space in T-sql is very annoying. When you are comparing strings it is crucial that you remove any white space or special characters that could interfere with your results.  You can user rtrim(ltrim () but the problem is rtrim(ltrim () does not catch special characters such as  Hexadecimal X09.

Since we are not able to see the whitespaces it creates a challenge when we  implement our queries so please use this t-sql to create a function or a stored procedure to remove any whitespace and special characters from your T-SQL strings.

select
ltrim(rtrim(
REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(
' Enter The string you want to
sanitize here'
,char(1),'')	,char(2),'')	,char(3),'')	,char(4),'')
,char(5),'')	,char(6),'')	,char(7),'')	,char(8),'')
,char(9),'')    ,char(10),'')	,char(11),'')	,char(12),'')
,char(13),'')	,char(14),'')   ,char(15),'')	,char(16),'')
,char(17),'')	,char(18),'')	,char(18),'')   ,char(20),'')
,char(21),'')	,char(22),'')	,char(23),'')	,char(24),'')
,char(25),'')	,char(26),'')	,char(27),'')	,char(28),'')
,char(29),'')   ,char(30),'')	,char(32),'')   ,char(32),'')
))

Char () T-sql
http://msdn.microsoft.com/en-us/library/ms187323.aspx



Insert CheckBoxes In Microsoft Word

This article is just a quick reference not a duplication of Microsoft’s work. For more details about checkboxes please visit :
(http://office.microsoft.com/en-us/word-help/make-a-checklist-in-word-HA001162451.aspx)

"On the View menu, point to Toolbars, and  then click Forms. On the Forms toolbar, click Check Box Form Field
 Button image. Note  If the  check box has a gray background, click Form Field Shading
 Button imageon the  Forms toolbar to remove the gray shading.

Click the next cell where you want to insert a check box, and then press  CTRL+Y to insert another check box.

After you insert a check box for each item that you want, click the top  right cell and type the text for the first item. Repeat this step for each item  in the list."

Microsoft.com (http://office.microsoft.com/en-us/word-help/make-a-checklist-in-word-HA001162451.aspx)

Change VirtualBox Boot Order

Changing the boot order in VirtualBox (3.2.8…) is not hard but if you expect to log into the BIOS to change it  GOOD luck!.

It is because only two ways  to change the boot order are the followings:

Via the VirtualBox Interface (you can also manually change the config file).


or by Hitting F12 on Boot
you will access a screen that looks like this

Download VMWARE Infrastructure Client (viclient)

How to download Vmware Vsphere Client? (Damn it!)  

The other day,  I re-did my machine and wanted to get the vmware infrastucture client back  and to my surprise, it was not that easy to find on Vmware ‘s Website. So naturally I turned to Google and searched “download vsphere client” , I ultimatelly found how to download vmware vsphere client but I had to put the pieces together. 

Here are two common ways you can get the vsphere client:

1. The faster way is to type your vmware internal IP in the browser something like (https://192.168.2.45), it will redirect you a page that looks like this:

2.  The second way is to log into  VMWARE’s website (login required)
(https://www.vmware.com/tryvmware/p/activate.php?p=free-esxi&lp=1)
and download it there