(Bobby Curtis) Recently on I was strolling the OTN message boards and came across a question about identifying the version of Oracle GoldenGate using OPatch. This was the second time I came across this question; with that I decided to take a look and see if Oracle GoldenGate information could be re
Other News
How To Change The Priority Of Oracle Background Processes
(Craig Shallahamer) Before you get in a huff, it can be done! You can change an Oracle Database background process
Disconnect Users from Database
(Derik Hammer) There are some operations that we execute in SQL Server which need exclusive access to the database. For everyone who has ever attempted this, I’m sure they’ve seen an error like this at least once.
Tip: Concatenate rows with XML, or COALESCE
(Jen McCown) I still reference my Forgotten T-SQL Cheat Sheet, especially for the XML trick that turns a set of rows into a list. The T-SQL Cheat Sheet example uses a parent-child table combination, but what if we want to get the same effect from a single table?
How to create a SSRS DR/Copy Report Server Database across different servers
(Vinoth Nm) Imagine you have installed and initialized SSRS in your Primary and DR Environment and To Mirror the DR environment to the Primary SSRS follow the below steps,
The DB2Night Show z52: DB2 Thread Reuse and RELEASE(DEALLOCATE)
(Martin) 98% of our studio audience learned something! John did a deep dive into thread reuse, and when to use it to maximum advantage.
Oracle In-Memory Database: The Bloom Filter Example Re-visited
(David Fitzjarrell) Oracle 12c (version 12.1.0.2) offers the option of using in-memory processing to speed things along. Called the In-memory option, it’s installed when you install the 12.1.0.2 software.
How To Identify Which ListBox Item the Mouse Is Over
(Ged Mead) This came up as a forum question on VBCity recently. The OP wanted to know why the ListBox and similar items doesn’t have a Mouse Over event that could be used to identify which list item the mouse cursor was currently over.
How to deal with MySQL deadlocks
(Peiran Song) A deadlock in MySQL happens when two or more transactions mutually hold and request for locks, creating a cycle of dependencies. In a transaction system, deadlocks are a fact of life and not completely avoidable. InnoDB automatically detects transaction deadlocks, rollbacks a transacti
Getting Started with IBM InfoSphere Optim Workload Replay for DB2
(Whei-Jen Chen, Nisanti Mohanraj, Hassi Norlen, Leif Pedersen, Patrick Titzler, Tom Toomire and John Vonau) This IBM Redbooks publication will help you install, configure, and use IBM InfoSphere Optim Workload Replay (InfoSphere Workload Replay), a web based tool that lets you capture real productio