There is something of a perfect storm brewing in the world of data today. The world is becoming more automated, more connected, more wireless, and more complex. The next wave of database administration is intelligent automation. I refer to this as implementing software scrubbing bubbles that “work hard, so you don’t have to.” (Remember that commercial!)As more of the tasks required of DBAs become more automated, the DBA will be freed to expand into other areas. So one front on this storm is the autonomic computing initiatives that automate DBA...
Tuesday, 30 September 2008
Tuesday, 23 September 2008
Who Did What to Which Data When... and How?
Posted on 08:57 by Unknown
As the list of government regulations impacting IT grows organizations must adapt to understand and comply with new rules. This increasing compliance pressure is particularly intense on data stored in corporate databases. As such, organization need to be ever more vigilant in the techniques used to protect their data, and monitor access.Database auditing, sometimes called data access auditing, is one technique growing in popularity as a response to the demands of regulatory compliance. At a high level, database auditing is basically a facility...
Monday, 22 September 2008
What Every Good CIO Needs to Know About Mainframe Database Auditing
Posted on 13:22 by Unknown
Mainframe Executive magazine just published my article on mainframe database auditing. Click here to read all about it: What Every Good CIO Needs to Know About Mainframe Database Auditi...
Friday, 5 September 2008
The Most Important Thing is Recoverability
Posted on 13:18 by Unknown
I know that many readers will question the title of this blog posting. But it is true. Oh, many DBAs think that managing performance is the most important thing they do, but they are confusing frequency with importance. Yes, many are managing performance more often than building backup plans – and they better be managing performance more frequently than they are actually recovering their databases or their company has big problems!Anyway, why do I place recoverability at the very top of the DBA task list? Well, if you cannot recover your databases...
Thursday, 4 September 2008
Database Performance and Row Size
Posted on 14:07 by Unknown
Recently I was reading through some posts in a database-related newsgroup or mailing list (actually, right now I can't remember which one it was). The conversation I was reading was in response to a question like "Does the number of columns or size of the row matter in terms of performance?"Actually, the question asked what kind of a performance impact might be expected if a query was issued against two similar tables. The first table had (say) 20 columns, and the second table had the same 20 columns, as well as 35 additional columns.Well, most...
Wednesday, 3 September 2008
When Not to Index
Posted on 13:39 by Unknown
Answering a question I got via e-mail on indexing... Every now and then I take the opportunity to blog about a question I get through e-mail. This time the question was:When does it make more sense not to build an index for a DB2 table? I'll attempt to answer this question for any SQL DBMS, not just for DB2: First of all, this is a very open-ended question, so I will give a high-level answer. Let's start by saying that most of the time you will want to build at least one - and probably multiple - indexes on each database table that you create....
Subscribe to:
Posts (Atom)
