Cortana's response to asking "what is rampancy"

Windows Phone, meet Cortana (just watch out for Halo spoilers)

Warning: This post contains spoilers regarding the ending of Halo 4.  You’ve been warned.

 

I’ve been spending some time with a special lady lately.  She’s always with me, and has been helping me organise my life.  She’s not all work though, and has shown that she knows a joke or two, she’s sassy, and she loves to talk about Halo.  I am of course, talking about one of Windows Phone 8.1’s killer features: Cortana. Continue reading “Windows Phone, meet Cortana (just watch out for Halo spoilers)” »

SQL Server example of datetime and datetime2

Mapping C# DateTime to SQL Server datetime2 via SSIS

With SQL Server 2008, Microsoft introduced the new, improved datetime2 format.  This newer time storage format is great, because it takes up less storage space, plus you have control over precision and can define your field to the exact specification required.  Database columns defined as datetime2 can be mapped in SSIS by using the DT_DBTIMESTAMP2 type.  However, in the scenario where you may have a Script Transformation in your SSIS package, and want to assign a .NET DateTime type to a Data Flow column that is mapped to a datetime2 field, you might encounter a DoesNotFitBufferException.

The reason for this is likely down to your specified field precision, and is easily fixed. Continue reading “Mapping C# DateTime to SQL Server datetime2 via SSIS” »