MUSINGS

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

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

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

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[…]

Filtering tip for SQL Server Profiler

Filtering tip for SQL Server Profiler

The SQL server profiler is a great tool for tracing and debugging database transactions, stored procedure execution etc. To trace the goings on inside a stored procedure it’s always best to use the TSQL_SPs template as this will provide much more detail than the standard template. Depending on the amount database activity, separating the wheat from theRead more about Filtering tip for SQL Server Profiler[…]