joeblogs.ie

If you need to get the CLSID of an application do the following:

1) Start >> Run >> Regedit

2) Go to HKEY_LOCAL_MACHINE\SOFTWARE\CLASSES\CLSID

3) Within this branch hit ctrl + F to search for the application you require the CLSID for e.g. Excel

4) Hit F3 to go through the results until you find the application you need

Windows excel

From an article by Mohammed Moinudheen on MSSQL tips

SMTP Server Details

Hotmail        SMTP server name: smtp.live.com                    Port number:   587

Gmail          SMTP server name: smtp.gmail.com                  Port number:   587

Yahoo         SMTP server name: smtp.mail.yahoo.com          Port number :  25

AOL            SMTP server name: smtp.aol.com                    Port number :  587

SMTP smtp

Discovered this website at the weekend from Brent Ozar providing tutorials, training videos and even posters. It has some excellent content particularly for query tuning.

SQL Server sql server

QI qi

Reading the interview with Edge website proprietor John Brockman in the Observer, I was struck by how influenced he was by Marshall McLuhan. Did some research on McLuhan and he is described as a media guru, coining such expressions as “the global village” and “the medium is the message”.

Ideas ideas

Interesting piece about Edge website by John Naugton (whom I just found out was Irish…and yes it does matter :) ) in today’s Observer . Had a brief look at some of the articles and conversations, seems like an interesting concept combining expertise from technology and art.

Ideas ideas

A very misleading line in the SQL server 70-431 book states “…keep in mind that indexes are limited to a maximum of 900 bytes.” Was not sure what this meant, but became much clearer after referring to MSDN Just to clarify it is the sum of the lengths of the fixed-size columns that make up the index that cannot exceed 900 bytes. Below is a way of determining the size of a potential index:
SELECT SUM(max_length)AS TotalIndexKeySize FROM sys.columns WHERE name IN (N'AddressLine1', N'AddressLine2', N'City', N'StateProvinceID', N'PostalCode') AND object_id = OBJECT_ID(N'Person.Address');

SQL Server sql server, 70-431

What a difference time can make, below in the left is a headline from the Guardian on December 21st 2001 when Argentina was in the midst of economic turmoil…then fast forward ten years to a story that appeared yesterday:

News news

1) Launch the disk management tool via Start Orb >> “Search programs and files” >> then type in diskmgmt.msc

2) Once it opens right-click on the drive you want to partition and then choose Shrink Volume

3) It will query for the available disk space and then you will then be presented with a window showing you the Size of the Hard drive and the total amount available to Shrink. Enter in the amount you would like to shrink. This will be the size of the new partition. It can’t be more than the amount available to you and remember that Approx 1000 Mb = 1 GB

4) Once you have entered the values to shrink, click on Shrink and when completed, you will see an unallocated space which is the size you just shrunk the volume by. Select it and right click and then select New Simple Volume

5) Assign a drive letter and then on the Format page, Ensure NTFS is selected and then enter a name for your drive and click Next followed by Finish

Windows windows

Music music