MUSINGS

Category: IT Support

IT Support

SQL date handling, or prior to 2008 the world didn’t begin until 1753
13 Dec
Posted in Database No comments

SQL date handling, or prior to 2008 the world didn’t begin until 1753

If you ever need to transfer data between an Oracle instance and Microsoft SQL Server 2005, you’ll need to be aware of the differences between data types. In some instances this will require massaging the data so it’ll “fit” the schema at the destination, while maintaining the data integrity.

An interesting example of this is the date and time data types. Read more about SQL date handling, or prior to 2008 the world didn’t begin until 1753 …

Cannot edit transport rule in Exchange 2007? This is probably why.
10 Dec
Posted in Exchange 2007 No comments

Cannot edit transport rule in Exchange 2007? This is probably why.

A pretty cool new feature was introduced in Exchange 2007 called transport rules. Transport rules enable the administrator to define rules (funnily enough) which effect message routing or restrict content. For example any incoming message for mailbox Joe Bloggs can be redirected to mailbox Mary Smith. As with any new feature there is always some gotchas, and lucky us came across one. Read more about Cannot edit transport rule in Exchange 2007? This is probably why. …

Google Cloud Print, I’m liking the possibilities
08 Dec
Posted in Cloud Computing No comments

Google Cloud Print, I’m liking the possibilities

The latest development version of Google Chrome (9.0.597.10 dev) has new functionality built in called Google Cloud Print. It’s basically a printer proxy service. It works by identifying the printers available on your PC, and making them available through your Google Account. At the moment you can add your printers and then mange your printers. There is also a simple test print that can be performed.

Currently no applications are Google Cloud Print aware, so the test print is all you can do. According to Google, Chrome OS is to be the first cab off the rank to be Google Cloud Print aware, closely followed by smartphones. Eventually an API will be released to enable integration with various operating systems and applications.

What are the limitations? Read more about Google Cloud Print, I’m liking the possibilities …

SQL strings are screaming at me. How to implement Oracle InitCap in Transact-SQL
01 Dec
Posted in Database No comments

SQL strings are screaming at me. How to implement Oracle InitCap in Transact-SQL

Ever had to deal with series of data which is all in upper case? Corresponding with clients and screaming their name at them isn’t a good look. What is required is function to convert or transform the upper case data into proper names. For example JOE BLOGS should be Joe Blogs. Well if you are usingRead more about SQL strings are screaming at me. How to implement Oracle InitCap in Transact-SQL[…]