(Joshua Tolley) One of our clients, for various historical reasons, runs both MySQL and PostgreSQL to support their website. Information for user login lives in one database, but their customer activity lives in the other.
Author: SSWUG Research
DB2 Tech Bits: Hear impressions of BLU from IBM Champions
(Susan Visser) Rick Swagerman who took over as the DB2 Tech Talks Host from Serge Rielau has just recorded two Tech bits. Tech bits are shorter recordings on topics related to DB2. These two bits are both conversations with IBM Champions to hear their impressions of the latest technology being de
You Can Never Be Too Smart
(David Fitzjarrell) Smart Scans are part of what Kerry Osborne calls the ‘secret sauce’ of Exadata, and he’s right. Smart Scans can definitely improve throughput by using the various optimizations to reduce the amount of data read and the volume of data returned to the database servers.
Spring Object/XML mapping example
(Bharat Sharma) In this tutorial we will look into Spring’s Object/XML mapping support.
Setting up SQL Agent in SQL Server to run ETL Jobs
(biscoop) By Default SQL Agent is Disabled on SQL Server, and if you need to use the SQL Agent then you need to execute the following :-
SQL Server Alerts with Text Messaging from SQL Server Database Mail
(John Grover) I need to get alerts from my SQL Server databases 24/7, but I don’t always carry my laptop to check email and when I do, I may not be near an internet connection. I always have my cell phone with me, though. Can I get my SQL Servers to send me a text message when there is an […]
Visual Studio 2012 New Features of the IDE
(RKT.Ashoka) This post talks about the Visual Studio 2012’s IDE new features.
The MySQL Cluster storage engine
(Stewart Smith) This is one close to my heart. I’ve recently written on other storage engines: Where are they now: MySQL Storage Engines, The MERGE storage engine: not dead, just resting…. or forgotten and The MEMORY storage engine. Today, it’s the turn of MySQL Cluster.
WebSphere Commerce Instance Creation Creates Database as Wrong User
(Ember Crooks) We’ve reported this issue to IBM, but since we’ve run into it several times across more than a year, and in multiple different Fix Packs of Commerce, I thought I’d share it in case someone else runs into it. The main way it manifests initially is like this:
XML value testing with Array
(Zoo Zoo) In a C# program I’m receiving a value from the XML, then I need to test this against an array. If the value is found in the array return true else return false. Here is the code: