Great news for people who want to write portable applications! This reference makes it easy for you to develop applications using SQL that is portable across the DB2 database family, including DB2 for z/OS Version 9, DB2 for iSeries Version 5 Release 4, and DB2 for Linux, UNIX, and Windows Version 9
Other News
What is OBJECT_ID in SQL Server?
(Ben Hall) If you ever looked at the dynamic management views or one of the system catalogs in SQL Server a column called Object ID will be associated, from the looks of it this number doesn’t actually relate to anything – but there is actually a lot more to it than that. Object_ID is a unique id nu
Managing FTP Transfers from an ASP.NET Web Page
(John Peterson) I was recently working on a project in which one of the requirements was that certain query results be sent to a different company via FTP. Granted things would have been much easier if the receiving company had simply set up a web service, but that didn’t seem to be an option. They
Replication Live: Use the Q Replication Dashboard for real-time monitoring
(Dell Burner and Tanya Couch) The Q Replication Dashboard is a part of the IBM® Data Studio Administration Console that helps you monitor and manage the health of Q replication and event publishing. In this tutorial, quickly set up a working replication environment, and use the dashboard to view lat
SQL Server tempdb best practices increase performance
(Denny Cherry) One way to greatly improve your SQL Server’s performance is to properly optimize the tempdb database. To punch up its efficiency, try looking at the physical disk configuration, file configuration, as well as some settings within the database. (R)
Licensing and Auditing in Oracle
(Steve Callan) Frustration. Anger. Despair. Depression. A sense of futility. Words and feelings to describe what it’s like to unravel performance tuning and the conflicting information among MetaLink, documentation, and renowned experts? Well, yes, they can be, but in this case, these words and feel
ASP.NET Tips: Working with large SQL tables
(Tom) There are a number of ways to query for data that is stored in a SQL Database from ASP.NET. Generally the best way is to use stored procedures. They can be compiled to be faster, and they are also much safer as they protect you from SQL injection problems, as discussed here. For an example
Correlated semi-join subqueries and PostgreSQL
(Sergey Petrunia) The work on subquery optimizations goes on, and we’re already curious how the assortment of new 6.0 subquery optimizations compares to what is found in other DBMSes. MySQL’s new strategies are not DBMS theory breakthroughs, similar ideas have been implemented in other DBMSes, but w
SQL Server Index Checklist
Indexing a SQL Server database in some respects is considered both an art and a science. Since this is the case, what are some considerations when designing indexes for a new database or an existing one in production? Are these the same types of steps or not? Do any best practices really exist wh
Does Oracle’s Focus Predict DBA Change?
Don’t Forget the Survey! Give us your feedback here. (Survey is only open to Friday – lots of prizes will be awarded!) Featured Article(s) What is a search engine? Can I build one easily? Yes indeed… If you look at what a search engine does, the solution to how to create a search engine is there. A search engine is […]