(David Beulke) Companies are realizing that “reduce, reuse, recycle” isn’t just a strategy to save our environment, it’s also a sensible strategy for business. IBM recently consolidated almost 4,000 servers in one of its data centers onto just 30 System z mainframes running Linux — a move it expects
Other News
Working with Time Spans and Durations in SQL Server
(Jeff Smith) What is the best way to return the “duration” of an event in SQL, given the start and end datetime values? How can we add up these durations to return grand totals? What data types should be used to return this data to our clients? How do we handle overflows, such as when hours go over
Databases Vs. Business, BLOBS and More
Latest Show Posted Watch: SQLonCall: How to Hire a DBA – Part 3/3 – The Interview. Questions to ask, answers to look for, interpreting the responses, making the decision. Also available: Watch: SelectViews – Replication, Part-Time DBAs, 60-Second Tip of the Day Watch: SQLonCall: How to Hire a DBA – How to review resumes, what to look for, what to […]
The SQL Server BLOB Debate
New SQL Show Posted Watch: SQLonCall: How to Hire a DBA – Part 3/3 – The Interview. Questions to ask, answers to look for, interpreting the responses, making the decision. Also available: Watch: SelectViews – Replication, Part-Time DBAs, 60-Second Tip of the Day Watch: SQLonCall: How to Hire a DBA – How to review resumes, what to look for, what […]
Remote Data Piping into DB2 for z/OS
(Ben Budiman, Joe Kidd and Johannes Schuetzner) With multi-tiered applications, there are often topologies with DB2 for z/OS as database backend and the application logic running on another platform like AIX, Linux or Windows. Using the DRDA protocol, the application remotely accesses DB2. An exampl
Permission Set XML for a Custom Trust Level
(Don Kiely) I’ve written a lot in this Secure ASP.NET column about partial trust ASP.NET applications. Simply put, if you deploy a Web application using the default Full Trust, you deserve whatever abuses hackers rain down on your site. You’ve bypassed one of the most powerful techniques Microsoft h
Binary XML, Efficient XML
(Anthony Coates) I have written before about the need for a standard binary compression technique for XML. It’s an issue that divides the XML community somewhat. Some very well known names in the XML world, people I get along with very well socially, are strongly and publicly against the use of bina
Using the DAO (Data Access Object) J2EE Design pattern with ADF
(Pas Apicella) I have always been a big fan of ADF BC , after all it’s a lot less coding but I still do write DAO (Data Access Objects) applications and using ADF it doesn’t take look to get those DAO method which return database data results onto my page. I find the ADF JSF experience just a little
Compatibility Combinations of DB2 QMF V8 and DB2 for z/OS
With the general availability of DB2 QMF V8.1 and DB2 for z/OS V8.1, questions have been asked about the compatibility of DB2 QMF with different DB2 versions. For example: does DB2 QMF V7 tolerate DB2 V8? Does DB2 QMF V8 tolerate DB2 V7?
Data Sources as Web Services
(Kyle Gabhart) WSO2 (WS OH 2) is growing in popularity and the team continues to produce quality products. The WSO2 (a.k.a. Web Services Oxygen Tank) team that has pulled together a platform around Apache SOA projects, producing an application server, ESB, Web 2.0 mashup engine, and more. Most recen