(connormcdonald) I’m sitting here watching the import of a moderately sized database via transportable tablespaces. You know…the thing you use when a full export / import would be too slow, and this is meant to be … well…fast.
Other News
JDeveloper 12c: Resolving ‘MDS-01368: Variable ‘oracle.home’ used in configuration document is not defined’ error
(Martien van den Akker) When I started up my Integrated Domain I encountered loads of errors in the log regarding the starting of my ADF application:
ODI 12c – Eclipse and Updated Mapping Builder Example
(David Allan) The 12c ODI release offers a full SDK which allows great opportunities for automation. You can reduce development times and work smarter. Here I will show how to use Eclipse to configure and setup the the SDK to start working smarter.
Network design for IBM PureApplication System, Part 1: Connecting the system to the data center network
(Bobby Woolf and Santiago Ortega) Although largely self-contained, you still need to connect IBM PureApplication System to your data center network so that your external users can connect to, manage, and deploy workloads onto the system, as well as connect to those workloads and use applications run
HTML 5 Elements in a Look: Part 1
(Sibeesh Venu) In this article you will learn about HTML 5 Elements.
Dynamicallly writing those pesky Update Statements
(sqlbischmidt) Whenever you are loading a data warehouse, often one of the most time consuming tasks is writing the update statements that you need in order to properly handle changing records coming from your system.
Using ‘msdb.dbo.agent_datetime’ to Simplify Working with sysjobhistory
(Larry Leonard) Just learned about the undocumented msdb.dbo.agent_datetime() function. Where has this been all my life? It takes an 8 digit date and a 6-digit time and converts it to a DATETIME – quite a time-saver.
Pagination in SQL Server
(Kenneth Fisher) It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL Skills insiders video on OFFSET and FETCH by Jonathan Kehayias (b/t) and remembered fondly an interview I did many, many years ago.
Questions About T-SQL Control-of-Flow Language You Were Too Shy to Ask
(Robert Sheldon) Surely, we all know how T-SQL Control-of-flow language works? In fact it is surprisingly easy to get caught out. What, for example, do the BREAK, RETURN and CONTINUE keywords do, precisely, in their various contexts? the answers to this and other questions aren’t all entirely ob
Nulls Cannot Be Ignored!
(Craig S. Mullins) NULLs are one of the more controversial things that a DB2 professional has to deal with. And I do mean HAS to deal with.