(Shemeer NS) SQL Server 2012 comes with two new scalar functions under the newly created logical functions category. A scalar logical function performs a logical operation or comparison on objects and expressions and returns a Scalar value.
Author: SSWUG Research
Obtaining a SQL Server’s Name
(Richard Carr) In some situations it is necessary to obtain the server and instance names for a SQL Server instance, either for informational purposes or to modify the behaviour of stored procedures. These names can be obtained using configuration functions.
SQL Access to the DB2 Diagnostic Log
(Ember Crooks) In recent releases, DB2 has offered more and more opportunities for using SQL to get to data we need to maintain our databases. I’m a big fan of some of this new functionality, particularly the mon_ stuff (see My New Best Friend – mon_ Part 1: Table Functions and My New Best Friend –
Useradd in Linux – Not copying any file from skel directory into it
(Jack Vamvas) When creating a new local user on Linux with the useradd and the directory already exists , the following error warning message appears:
Tracing in ASP.NET MVC Razor Views
(Tom Dykstra) System.Diagnostics.Trace can be a useful tool for logging and debugging, and sometimes it would be handy to be able to call one of the tracing methods from a Razor view.
Storing Native XML in a DB2 Table Column
(Kurt Struyf) In the world of data exchange, XML has become the global standard. Data professionals should know the basics of XML processing to be able to take advantage of its flexibility and understand how it interacts with their database systems.
SQLTXPLAIN under new administration
(Carlos Sierra) With great pleasure I am announcing here that SQLTXPLAIN (SQLT) is “under new administration”. What does it mean? In short, almost nothing to you. Under the covers, it means you will start seeing a new (and younger) face associated to SQLT.
User-Friendly Sort Of Alpha-Numeric Data In JavaScript
(Ben Nadel) At InVision, we deal with a lot design files. And, when you deal with a lot of design files, you deal with a large number of user-created naming conventions. Unfortunately, a standard alphabetical sort of file names doesn’t usually behave in alignment with the user’s intended sorting.
ODI – Loading MongoDB (API as Target)
(David Allan) In this post I will show how to load documents into a MongoDB collection. The interface design looks just like all other ODI interfaces, but behind the scenes the KM configured in the physical design uses the MongoDB SDK (see MongoDB SDK here) to insert the documents.
Oracle 12c – incremental backup for DataGuard over network
(Marcin Przepiorowski) If you have DataGuard or standby database in your organization you probably will love that new RMAN feature. Since 12c it is possible to catchup standby database using incremental backup using one command.