SSIS: Text to ProperCase (derived column)

How to format text to ProperCasing?
Found this SSIS Expression at SQLJunkieShare:


(UPPER(SUBSTRING(TRIM(Name),1,1)) + TRIM(LOWER(SUBSTRING(TRIM(Name),2,FINDSTRING(TRIM(Name),” “,1) – 1 < 0 ? LEN(TRIM(Name)) : FINDSTRING(TRIM(Name)," ",1) – 1)))) + " " + (FINDSTRING(TRIM(Name)," ",1) – 1 < 0 ? " " : UPPER(SUBSTRING(TRIM(SUBSTRING(TRIM(Name),FINDSTRING(TRIM(Name)," ",1),LEN(TRIM(Name)))),1,1)) + TRIM(LOWER(SUBSTRING(TRIM(Name),FINDSTRING(TRIM(Name)," ",1) + 2,LEN(TRIM(Name))))))

Advertisements

SQL Server 2012 Express: Setup Database Mail (sp_send_dbmail)

Guys good news!
SQL Server 2012 Express still supports Database Mail (DB Mail), but it’s well hidden 🙂

The fully licensed editions of SQL Server 2012 do have an easy setup wizard, but (like in SQL Server 2008) the needed components (service, tables and stored procedures) are still present in the Express-edition!

The tables are programmatically set to ‘hidden‘, because I can still query them by using:

select * from msdb.dbo.sysmail_account

The Stored Procedures (SP’s) are visible though:

How to get things working?
Follow the steps in the blogpost (was originally documented for SQL Server 2005, but still applies to the 2012 Editions of SQL Server).

You may skip step 7:
Click here!





Windows 8 Start Menu – want it back? :)

Received a great URL from a colleague today to re-enable (or download) a start menu for Windows 8 🙂
And it actually works (after Microsoft blocked it initially and patched it again)!

There is only one issue…in my case, the Start Menu’s language is set for Dutch (my native language, perhaps it got it from my Microsoft account?) and Windows 8 itself is in English.

Update:

You’re able to change the language setting of ViStart (search for ‘Language Changer’ in ViStart’s install dir):

You still want it?
Get it here for free (for now)!

Press to black ‘Download’-button on the page to download it.