by XTIVIA | May 3, 2012 | Blog, Databases
This is a short video on how you can use an open source tool called Pentaho Data Integration to migrate data between tables in DB2 and SQL Server. This video is on youtube and walks through downloading the open source code, setting up database connectivity,...
by Tony Salerno | Apr 26, 2012 | Blog, Databases
Insurance: what you need is generally a balance between type, amount, cost, and where you can find it. Everyone of course has different advice on what is optimal. Best bet is to always get that which will keep you safe, you can afford, and from someone you...
by XTIVIA | Apr 9, 2012 | Blog, Databases
Well, I’m in the final 4 and I made my last presentation on the DB2Night Show’s “DB2’s Got Talent Contest 2012” last week. I wanted to make it a fun and ‘edutaining’ presentation so I chose to do a parody of the American...
by XTIVIA | Mar 29, 2012 | Blog, Databases
Hello everyone, Today is the last chance to vote me into the top 3 of this DB2 presentation contest. If you could take 10 seconds and go to this link and vote, I’d really appreciate it. It has to happen today!! You don’t need to...
by XTIVIA | Mar 22, 2012 | Blog, Databases
As a DBMS SQL Server is a powerful, cost-effective, and simple-to-use DBMS able to service the needs of most small-to-medium size businesses right out-of-the-box without professional management by a DBA. In fact, a recent survey reported that 45% of IT personnel...
by XTIVIA | Mar 16, 2012 | Blog, Databases
I gave my third presentation today for the finals of the DB2’s Got Talent contest given by the good folks at the DB2Night Show. I found out that I’ve made it to the final round! Thanks to everyone that voted for me! (I’ll have to...
by XTIVIA | Mar 6, 2012 | Blog, Databases
A colleague wanted to work an old Henny Youngman joke into a performance analysis. He wound up not using it, so I will: Man goes to the doctor. He swings his arm and says, “Doc, it hurts when I do this.” Doc says, “Don’t do that!” I came...
by XTIVIA | Mar 5, 2012 | Blog, Databases
Hello again, I presented on DB2 Table Reorg on Friday, March 2 for the DB2Night show’s 4th annual DB2’s Got Talent contest. I’m one of 10 finalists from around the world and Friday was the first of 3 rounds to choose a winner. The...
by XTIVIA | Feb 16, 2012 | Blog, Databases
Importing data in DB2 HADR takes some extra considerations. For one, non-logged activity is not replicated to the Standby database. So if you use the LOAD command to import data into a table on the Primary database, the same table on the Standby database...
by XTIVIA | Feb 14, 2012 | Blog, Databases
Problem: You’re an admin in SQL Server Reporting Services (SSRS). You want to see everybody’s subscriptions on all reports. Yet you can only see your own. Solution: You can do this easily. You just can’t do it in Report Manager. But remember that...
