(Simon Cooper) If you’ve just joined this series, I highly recommend you read the previous posts in this series, starting here, or at least these posts, covering the CLR metadata tables.
Other News
Validating Data in ASP.NET MVC Applications
(Bipin Joshi) Learn to use various validation techniques of ASP.NET MVC to enforce validation rules on the user input.
Understanding .NET Framework Task Parallel Library Cancellations
(Jeffrey Juday) Microsoft .NET Parallel Computing Task Parallel Library (TPL) includes mechanisms for composing and scheduling work on a ThreadPool. In an ideal software world composing and scheduling would be all that is needed. Unfortunately, a developer must deal with exceptions and may want to i
How To – Convert MSSQL Timestamp/Datetime to Unix Timestamp
(Adam Douglas) I will explain how to convert a DATETIME (data type) value in Microsoft SQL Server to Unix timestamp and how to convert Unix timestamp to DATETIME. A Unix timestamp is a integer value of seconds since January 1, 1970 at midnight.
Our favourite new features in DB2 10 z/OS – part 3
(Laura) Most IT systems need to keep historical as well as current information. Previously, these kinds of requirements would have involved the DBA and application developers spending valuable time creating and testing the code and associated database design to support the historical perspective, w
Subtracting TIMESTAMPS, exactly!
(Serge Rielau) A co-worker just walked in and asked how to subtract timestamps in SQL.
Creating Oracle Database 11g on Amazon RDS (video)
(Joao) In my last post I’ve wrote about the new Oracle Database service provided by Amazon Relational Database Services. Today I’ll demonstrate, with a video, how to create an connect to the Oracle Database service provided by Amazon RDS.
OWB – Invoking SQL*Loader from Process Flow
(Dallan) Quick post on how to execute SQL*Loader from within a process flow. You can use the SQL*Plus activity and invoke the sqlldr command via the SQL*Plus HOST command passing the specific parameters you want.
A Very Cool Project
(Lewis Cunningham) Next tuesday will be the final implementation of one of the coolest projects I have ever worked on. I say final implementation because it is a distributed system that impacts multiple databases and multiple systems. It is also fully redundant, active-active, in two different data
Whether to use UNION or OR in SQL Server Queries
(Dinesh Asanka) Recently I came across with an article on DB2 about using Union instead of OR. So I thought of carrying out a research on SQL Server on what scenarios UNION is optimal in and which scenarios OR would be best.