DBMSguy.com

One of the things I find very powerful in my day to day work as a DBA, is the use of inline shell/awk scripts.  I use this technique when I need to do the same thing to many objects.  I often use it when I want something quick and dirty or create a base script [...]

I’ve always been a little frustrated with db2 when running scripts and command lines with fact that when a command would run like insert, update or delete, you never knew how many rows you affected.  Some GUI products will tell you, but with command line it would just come back as being successful (or not) and it [...]

There are a lot of things you can do with db2 batch scripts that can make your life easy.  In this set of posts I will talk about just a few things that might make your life easier.

A long time XP user, I was very nervous about getting a new system with windows 7.  Would anything work?  Would it be slower?  All kinds of things ran through my head.  I read all the reviews and for the most part, it seemed like a sucessful release, but then?……..

This is the last post about HADR, I think I covered most of the basics of HADR finishing off with how it switches primary and standby.  What I have gone over is the basics of HADR.  There are many other topics within HADR.  One important thing to remember is to NEVER do unlogged operations (careful [...]

Okay, so here we go …. setting up an hadr environment….  HADR in it’s lowest form is very straight forward to set up.  Here are the steps to start HADR

HADR is a very easy and effective way to maintain a DR and/or standby for any given database.  You can implement it very quickly and simply and it works well.  In essence it is basically log shipping, but done in real time and elegantly.  It is not replication, so the standby database is not really [...]

Excel is a wonderful tool that can be used to write sql using substitution from cells to cusomize and update or insert.  One problem has always been dates… they never come out right

To find text in a directory of files, use the following Windows command (it’s faster than Windows Search): This will search all files in the current directory for the text you are looking for: findstr /c:”I want to find this text” *.* If you want to also search sub-directories use the /s option: findstr /s [...]

Hi folks, I was cruising around the www and found a couple of interesting sites that I thought I would pass on …