Ben Johnston in Blogs Choosing Data Types and Column Options An entire post on choosing the correct data types either seems like overkill or much needed and overdue. The perspective... 31 August 2024 27 min read
Houri Oracle Data Type Implicit Conversion Hierarchy In Oracle, under certain circumstances, an implicit data type conversion precludes the use of indexes. Perhaps you have a vague... 09 January 2017 10 min read
Robert Sheldon How to get Database Design Horribly Wrong Database Design is one of those tasks where you have to carefully get all the major aspects right. If you... 06 March 2015 34 min read
Robert Sheldon Working with SSIS Data Types In order to be able to take data from a variety of sources, manipulate it, and then export it to... 02 July 2012 14 min read
Robert Sheldon Working with the XML Data Type in SQL Server The XML data type, introduced in SQL Server 2005, is a powerful construct. When used wisely, it can provide useful... 07 November 2011 16 min read