Blog : What’s On Our Mind?

Sharing Our Point of View
By Andy McDermid | On January 13th 2015
Three Ideas for Returning Microsoft SQL Queries Faster
Would you like to make your users happy? Give them the information they need through optimization that allows SQL queries to be returned faster. Here are three quick items to add to your “do” list to generally improve performance by increasing system concurrency. One caveat: these suggestions may not provide uniform results. These tips should be applicable across different types of databases, but your mileage may vary. Before plunging ahead, you may want to make certain your databases are fully backed up…
By Craig Mullins | On December 30th 2014
Lock Contention
I frequently get e-mails with DB2 questions and I plan to start posting answers to some of the more common ones up here. One issue that comes up a lot is dealing with locking issues. Usually it is posed by someone who is experiencing timeouts in an online environment and they want to know how to minimize them. Here is some guidance. When you experience a timeout, it means that another process holds a lock on the data that you are trying to modify. So, it stands…
By Andy McDermid | On December 26th 2014
Location Options for Running SQL Server
If you want to run SQL Server, you’re no longer limited to having it operate from a box in a closet. You have a lot of choices, some of which we cover below. Virtual Machines Virtual machines, which are software abstractions of a hardware server, can be used to run SQL Server. In the InformationWeek 2014 State of Database Technology survey, this was the preferred running environment. In reviewing the survey findings, Don Boxley Jr., a co-founder of the technology start-up DH2i Company, stated:
By Craig Mullins | On December 23rd 2014
No Black Boxes!
I’ve written about this subject before, but I think it is important enough to merit another go-round. First of all, before I go any further, let’s first define what I mean by a “black box.” If I plan to recommend that you prohibit them we better both understand what it is we are talking about proscribing. Simply put, a black box is a database access program that sits in between your application programs and DB2. It is designed so that all application…