(Frits Hoogland) Recently I am involved in a project which requires a lot of data to be extracted from Oracle. The size of the data was so huge that the filesystems filled up. Compressing the output (using tar j (bzip2) or z (gzip)) is an obvious solution, but this can only be done after the files a
Author: SSWUG Research
A healthy way to do an Oracle database health-check
(Carlos Sierra) Q: How do I do an Oracle database health-check?
Next DB2 Tech Talk: Use DB2 on the Cloud
(Cindy Russell) Need to get started using DB2 quickly and at a low cost? DB2 on the cloud is an ideal way to get up and running quickly.
Find the Statements Using an Index Without Event Monitors
(Ember Crooks) This post is specific to DB2 9.7. In DB2 10.1 and above, Usage Lists would be a better way to handle this.
XML Creation with DOM in Java
(Vic Hargrave) Awhile back I wrote a blog about parsing XML documents with the DOM facilities provided by Java. As it turns out you can use the same API to programmatically create an XML document.
SSWUGtv: John Treadway from Cloud Technology Partners is on the show to talk about releasing PaaSLane static code analysis solution!
Video Programming for IT Professionals
Determining Permission Issues for a SQL Server Object
(K. Brian Kelley) I have a security problem. Users have the ability to access the tables in a database with one exception. No matter what permission I grant or what role I give within the database, users are still denied access. I’ve even made users a member of the db_owner role, but to no avail. Th
Designing one to many relations – MongoDB vs MySQL
(Stephane Combaudon) We already discussed one to one relations in MongoDB, and the main conclusion was that you should design your collections according to the most frequent access pattern. With one to many relations, this is still valid, but other factors may come into play.
SQL Commands : Part 1
(Nipun Tomar) While using SQL there are some queries we can use on a frequent basis, since these queries play a vital role in storing the data into the database. But, before explaining these queries, let us first understand what "SQL" is.
SharePoint: Employee Directory and a Team Site
(Ellen van Aken) If you saw an employee profile from her location, you could trust it would be 100% accurate. Being that dedicated also took her a lot of time. So she asked me if there was a solution to her chasing everyone for the correct information.