DB2 Express-C 9.7.4 is now available for download. It is a full refresh of the free edition of the DB2 database server.
Other News
SQL Server Query Hash Statistics
(Kevin Kline) Advanced troubleshooting can be very difficult in SQL Server, particularly when you’re trying to dig into performance issues coming from queries. Typically, the only reliable method is to capture traces of SQL Server activity and then perform laborious and slow analysis of the trace fi
Using MySQL 5.6 to find queries creating disk temporary tables
(Alexander Rubin) In my previous post, I’ve showed how to use Dtrace to find queries creating disk temporary tables (only available for OS with dtrace: solaris, freebsd, etc).
SQL Anti logic!!!
(Sameer Kumar) Well I am just breaking my sequence of RUNSTATS and REORG for a while (I promise my next blog will be having that)…
Microsoft Query lists user objects and system views in the query wizard
When you use an ODBC data source (DSN) to access Microsoft SQL Server database from Microsoft Excel, you will notice that the Available Tables and Columns section in Query Wizard – Choose Columns page, by default, displays the following objects:
Combining IBM DB2 pureScale with Q Replication for scalability and business continuity
(Anand Krishniyer, Jerome Colaco, Serge Bourbonnais and Aslam Nomani) Extend the DB2 pureScale Feature with Q Replication to get scaling, reliability, and transparency, along with the protection and continuous availability of off-site replication. This article discusses the considerations for this s
Custom LINQ Operators, Deferred Execution and Exceptions
The Language-Integrated Query (LINQ) standard query operators that return enumerable sequences use deferred execution but validate any source sequences immediately. Custom LINQ operators should exhibit the same behaviour.
Extending EventEmitter In Order To Create A Response Proxy In Node.js
(Ben Nadel) I’ve been doing a lot of experimenting with Node.js lately and one thing that I thought might be useful would be some additional hooks into the various parts of the HTTP response lifecycle.
Calling a Web Service from the Client Side Using the AJAX Extension Toolkit [Script Manager]
(Pareen Vatani) A proxy class is a script that is automatically generated by the server and downloaded to the browser at page-load time. The proxy class provides a client object that represents the exposed methods of a Web Service. The calls are made asynchronously, through the XMLHTTP object.
Remote Databases – TIPS from the Trenches
Remote Databases – Tips from the Trenches Today I’ll continue the topic regarding accessing data from remote databases. For clarification, in this case we are talking about a Microsoft SQL Server database accessing data from a different SQL Server Database, maybe even mounted on a different Instance of SQL Server. This does not include querying data in other data repositories […]