Saturday, April 07, 2012

The first word of Christ ...

If we accept Markan Primacy, then the first words of Christ recorded in the bible are as follows:

“The time has come,” he said. “The kingdom of God has come near. Repent and believe the good news!"

What a truly, truly wonderful thought.

I have an idea.  Let's preach this:  The time has come.  The kingdom of God has come near.  Repent, and believe the good news.  :-D


Tuesday, April 03, 2012

A couple things I learned about databases today

1 - In DB2, the following pseudocode doesn't work:
define cursor
open cursor
while (not end of cursor)
   make table update
   commit;
 end-while
close cursor

The reason?  The "commit;" statement closes your cursor!  you'll have to commit after exiting your loop.

2 - In SQL Server, you can end up with a database that has no owner.  (!)
To correct this, us the sp_changedbowner system stored procedure.
example: sp_changedbowner 'sa'

A more thorough treatment of this topic can be found here.

Crazy ...

The Database is not accessible after creating Always On Availability Group

 Having created a fully functional SQL Server Always On Availability Group, I connect using SSMS. Upon trying to expand the database, I get ...