(Brendan Tierney) In this post I want to show some example of using a new feature in 12c for selecting the first X number of records from the results set of a query. See the bottom of this post for the background and some of the reasons for this post.
Other News
SOA Suite 12c: Bulk Fault Recovery
(Michel van Zoest) In earlier versions of the Enterprise Manager it was already possible to recover faulted instances of web services. Like for instance when a service that the instance depends on is down, the instance will throw a fault and stop processing.
How is OData Doing?
If you were to combine the capabilities of SQL, ODBC, XQuery and REST, stir it up, it might come out like OData. OData has been around for a long time now, and lives as an open systems project that has been widely used by Dot Net and other tools. However, it is not a Microsoft only toolset. Looking much like […]
SSWUGtv: Here are some good tips on how to protect your systems from internal issues.
Video Programming for IT Professionals
DB2 Internals: Simple Query Processing
(Ember Crooks) This is the first in a series of blog entries talking about DB2 internals. I have no intimate knowledge from IBM of how DB2 works internally, just years of watching presentations about the internals and doing my best to understand what DB2 is doing to inform my actions and decisions a
Practical SQL: Listing Based on Group Conditions
(Joe Pluta) If you know me, you know I love Common Table Expressions (or CTEs). In today’s article, we’re going to take advantage of CTEs and aggregate functions to learn how to find data that matches group conditions.
Untrusted Foreign Keys
(Chris Bell) A foreign key is a link between 2 tables that is used to enforce referential integrity in the database.
IDENTITY Crisis
(David Dye) I was recently presented with the task of examining a database, from historic backups, to determine transactions applied over the past 6 years. Unfortunately, the only background/source data available was a few weeks of full backups and, to make this more of a challenge, many conclusion
Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask
(Robert Sheldon) It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as a server. The problem is that there are certain things that aren’t obvious that you need to know about, and you feel awkward about asking su
SQL SERVER – What is the Difference Between An INNER JOIN and WHERE Clause
(Pinal Dave) Just received a question in email: “What is the Difference Between An INNER JOIN and WHERE Clause?”