(Willie Favero) I guess it’s about time that I’m finally getting back to answering those 3 questions I posed back in my July 20th blog post titled “A few thoughts on using DB2’s dynamic statement cache”.
Other News
mydumper & myloader : fast backup and restore
(Rene Cannao) At PalominoDB we do not normally use mysqldump for regular backups, but only in some circumstances (for example MySQL upgrade).
Multiple Custom DataAnnotations on Same Filed With jQuery Validation
(skumar.mastermind) In this article, I will describe implementing custom DataAnnotation validation for ASP.NET MVC3 applications with support for AllowMultiple = true on both server side and client side.
IBM Cognos Proven Practices: Securing the Lifecycle Manager Web URI
(Greg McDonald, Amrita Sasane, Niraj Modi, Amit Nagar, and Mrunal Lohar) Lifecycle Manager is a standalone application, that once installed and configured, runs it’s own instance of a Tomcat application server. Lifecycle Manager’s UI is web based and therefore can be accessed without requiring acces
Restoring a SQL Server database that uses Change Data Capture
(Jugal Shah) When restoring a database that uses Change Data Capture (CDC), restoring a backup works differently depending on where the database is restored. In this tip we take a look at different scenarios when restoring a database when CDC is enabled.
Your Future as a DBA? Secure.
Your Future as a DBA? Secure. Bright even. But perhaps not for the reasons you anticipate! I’ve been talking with more and more DBAs about the fact that the architecture and performance side of things is becoming increasingly important. Perhaps surprisingly, it’s not because of current applications support, but rather design of applications to support mobile devices and cloud-based solutions. […]
Covering Index
Covering Index Today I decided to talk about covering indexes. I was pleased to find there has been a lot of recent activity on covering indexes posted here at www.sswug.org. Simply go to our site and type “Covering Index” in the search box. You’ll find many posts. For our Accidental DBA friends, or those new to relational databases, a Covering […]
Version Control and Version Differentiation
$$SWYNK$$ Version Control and Version Differentiation I stated last week that a key reason I don’t care for a number of software development tools is that they do not lend themselves to the ability to integrate with existing version control products allowing you to see in a human readable form the modifications from one version to the next. Most diff […]
At Times, I Fear the Cloud
At Times, I Fear the Cloud I’m not an alarmist by nature. So I bring up the following not as a "pile-on" but rather as a "you should know about this…" Did you hear about the power outages from Amazon and Microsoft’s European cloud services? Sigh. It’s real, and it shouldn’t have happened in my humble opinion. It’s not that […]
The Tipping Point – DISTINCT Causes Timeouts
(Ajarn Mark Caldwell) Everything worked fine for the last six years…and then today we hit the tipping point. I lost many hours today due to the misuse of DISTINCT which was the root cause of timeout errors in our web application.