Find MSSQL Tables That Have Data
You may find yourself looking at an unfamiliar MS SQL database with potentially hundreds/thousands of tables that may or may not have good naming conventions. This query below will help you find the tables that have data in them to speed up your analysis.
SELECT distinct
so.[name] as [table name],si.rowcnt
FROM sysindexes si
INNER JOIN sysobjects so ON si.id = so.id
WHERE so.type = ‘U’ — Only User Tables
AND rowcnt > 0
ORDER BY si.rowcnt DESC
Bibleshark: Cross-Translation Keyword Search
I have a quick shameless plug. We have been working quite a while on our cross-translation keyword search over at Bibleshark.com. We are happy with what we are delivering on a first phase release. We are investigating some new technologies etc. to increase the speed and accuracy of the search over time. I still believe it to be the one of the best if not the best bible search on the net and there will be more to come.
A great quote my Dad made me aware of
“We the willing, led by the unknowing, are doing the impossible for the ungrateful. We have done so much, with so little, for so long, we are now qualified to do anything, with nothing.”
This is just to good.
WATCHMEN: Awesome Graphic Novel
WATCHMEN Book Cover
I just got back from a relaxing vacation and part of that relaxation time was spent reading WATCHMEN. I went to a movie about a month ago and saw a preview for the WATCHMEN movie that is out in theaters now and that it was based on the graphic novel. I haven’t ever read a graphic novel and immediately thought that this one would be a good one to read. I picked up a copy the day before we left for vacation and I completed it today. The book is awesome and I would highly recommend reading it if your looking for a great piece of fiction. This book is outstanding from a literary and artistic viewpoint. This novel really paints a picture of evil and how it decays the world. Though this book really didn’t strive for a hidden Christian message of any kind, I found the following quote from the text fitting:
“I guess I’ve just reached a point where I’ve started to wonder whether all the grandstanding and fighting individual evils does much good for the world as a whole. Those evils are just symptoms of an overall sickness of the human spirit, and I don’t believe you can cure a disease by suppressing its symptoms.” Adrian Veidt (Ozymandias)
Go out and grab a copy if your looking for an entertaining read. I plan to read more graphic novels and I am looking forward to selecting the next one to read.
leave a comment