Calendar of Posts

May 2012
M T W T F S S
« Jan    
 123456
78910111213
14151617181920
21222324252627
28293031  

Contributors

Paul Mayhew dbmsguy.com

Ivan Beg
A $25 loan can change a life forever

Windows 7 — First Impressions

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?……..

[...]

DB2 HADR for dummies – Part 3

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 [...]

DB2 HADR for dummies – Part 2

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

[...]

DB2 HADR for dummies – Part 1

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 [...]

using excel to write sql

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

[...]

find files using windows cmd

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 [...]