(DAVEMCG) MapForce 2014 now supports mapping of XML wildcards that create a designed-in extension mechanism for XML Schemas, implemented as or .
Author: SSWUG Research
Transactions: Rolling back a transaction
(Kenneth Fisher) Transactions are great and wonderful things. They make sure that our work stays atomic, consistent, isolated and durable (yes ACID). And if we use an explicit transaction (created by BEGIN TRANSACTION) and we make a mistake we can always roll the transaction back.
Oracle 12c background processes
(Venzi) Here is yet another Oracle 12c post to add to all those out there and this one starts with a question: How many background processes exist in an Oracle DB environment to date? Just take a moment and take a guess, if you haven’t already seen the bold number coming up. The answer is: 108!
Adaptive Plans in Active Session History
(Christian Antognini) Yesterday, during the talk “The Query Optimizer in Oracle Database 12c – What’s New?” at OakTable World UK 2013, an attendee asked me an interesting question that can be summarized as follows: does ASH show the switch of execution plan that takes place for an adaptive plan?
DB2 Tips n Tricks Part 17 – How to Enable a user for multiple Authorization Ids
(Harishkumar Baburao Pathangay) How to Enable a user for multiple Authorization Ids GRANT setsessionuser Privilege by SECADM
The DB2Night Show #120: Tuning SAP on DB2 LUW with Martin Hubel
(Scott Hayes) 100% of our studio audience learned something! During this episode of The DB2Night Show™, Martin offered many valuable suggestions for tuning SAP in a DB2 LUW environment based on his experiences at several clients.
Big Data and the Changing Role of DBAs
(Troy Coleman) In our industry it seems people are being asked to do more with less, while our employers focus on the present and near-term. Businesses aren’t planning for the long-term when it comes to making employees productive and ensuring that the data being used to make critical business decis
JQuery Trigger Event on Show/Hide of Element
(Viral Patel) JQuery provides powerful API to manage triggering of events. It provides a way to trigger the event handlers bound to an element without any user interaction via the .trigger() method.
Moving tablespaces
(Josh Berkus) PostgreSQL has a feature called “tablespaces” which allows you to put separate data directories on different mount points. There’s a variety of uses for this, including: storing data somewhere different from $PGDATA, putting your hot tables on SSD, or expanding the amount of storage s
Recursive Querying in SQL Server
(Viswanathan Neelakantan) In this post we will discuss about the use of recursive querying in SQL Server.