(Michael Sansoterra) In the first tip, I showed various ways to test DB2 functions, procedure results, and triggers for logic accuracy and security. However, the tip never covered how these tests, once written, are to be processed. In particular, questions such as these need further discussion:
Other News
Return an Interface from Your Methods for Maximum Flexibility
(Peter Vogel) If I’m writing a method that returns a collection, I can, of course, declare my method’s return type using a class name, like this:
Problems with Scaling Out
How do we get the performance we have come to expect from Google? Data and Workload are distributed across a large fabric of small computers. The sum of the whole results in performance greater than that of a super computer. Google has proven the architecture of Scaling Out with dramatic performance at an amazingly low cost. More and more systems […]
SSWUGtv: Today, Steve gives great advice on choosing your best weapons: hosting selection (cloud, on-premise, hybrid) – SQL Server.
Video Programming for IT Professionals
Introducing the Node.js-to-AngularJS Stack
(Brad Dayley) The first section discusses various aspects of the general website/web application development framework, from users to backend services. The purpose of first covering the web development framework components is to help you more easily understand how the components of the Node.js-to-An
Quick reference guide for .NET regular expressions
(Cheryl Simmons) I don’t know about you, but I use regular expressions just enough to be dangerous.
Testing MySQL FULLTEXT Indexes in InnoDB Using Pt-upgrade
(Ike Walker) As I prepare to convert some MySQL tables with FULLTEXT indexes from MyISAM to InnoDB I want to verify that running a standard production query set against the tables will return the same results with InnoDB that it did with MyISAM.
Quick Tip: Simple Errors on Database Connection
(Ember Crooks) There are a couple of errors that you can get on database connection that simply mean you typed something wrong, but I figure there are people who will search on these errors, so I thought I would share.
Returning BLOB file size
(Scott Wesley) Occasionally I’ll want some form of report noting file sizes of blobs in a database.
12c Index Like Table Statistics Collection (Wearing The Inside Out)
(Richard Foote) This change introduced in 12c has caught me out on a number of occasions.