Thursday, June 29, 2017

The Sun, a Primer

Here is a primer on our favorite star, the sun. This article is part of my preparations for the total solar eclipse which will cross the continental United Status on August 21. Please follow the link, and enjoy!


-

Sunday, June 11, 2017

The Invisible Hand

A theatre company in the Tampa Bay area just completed its run of a very intriguing play. It's called The Invisible Hand, a 2012 play written by Ayad Akhtar.

In remote Pakistan, Nick Bright, an American and Citibank employee in his 30s, awaits his fate. A successful financial trader, Nick is kidnapped by an Islamic militant group, but with no one negotiating his release, he agrees to an unusual plan. He will earn his own ransom by helping his captors manipulate and master the world commodities and currency markets.

The play's language is salty and the story is adult in nature. But the material is thought provoking. I encourage you to check it out!

Find on:
Learn more:
-

Better Than Biscuits

(This story was shared with the Chancel Choir of my church by our amazing organist. Thanks, Doug!)

One Sunday morning at a small southern church, the new pastor called on one of his older deacons to lead in the opening prayer. The deacon stood up, bowed his head and said, “Lord, I hate buttermilk.”

The pastor opened one eye and wondered where this was going. The deacon continued “Lord, I hate lard.” Now the pastor was totally perplexed. The deacon continued, “Lord, I ain’t to crazy about plain flour. But after you mix ‘em all together and bake ‘em in a hot oven, I just love biscuits.”

“Lord help us to realize when life gets hard, when things come up that we don’t like, whenever we don’t understand what You are doing that we need to wait and see what You are making. After you get through mixing and baking, it’ll probably be something even better than biscuits. Amen."

-

Friday, June 9, 2017

How To Repair A Suspect Database In Microsoft SQL

Here is a Microsoft SQL tip. A fellow team member recently dealt with this issue. The recommended steps come from the support articles of Managed.com.
Symptom:
In Microsoft SQL Server, you have a database that is tagged as "suspect" and you are unable to connect to the database.
Possible Causes: 
  • The database could have become corrupted.
  • There is not enough space available for the SQL Server to recover the database during startup.
  • The database cannot be opened due to inaccessible files or insufficient memory or disk space.
  • The database files are being held by operating system, third party backup software etc.
  • There was an unexpected SQL Server Shutdown, power failure or a hardware failure.
Resolution:

These steps require you to have Microsoft SQL Server Management Studio installed on your computer. Once this is done, proceed as follows.

1. Open Microsoft SQL Server Management Studio and connect to your database. 
2. Click the New Query button.
 
3. Paste the following SQL script into your New Query page replacing [YourDatabase] with the name of your database.
  EXEC sp_resetstatus [YourDatabase];
ALTER DATABASE [YourDatabase] SET EMERGENCY
DBCC checkdb([YourDatabase])
ALTER DATABASE [YourDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ([YourDatabase], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [YourDatabase] SET MULTI_USER

4. Click Execute. Your database should no longer be tagged as "suspect" and you should be able to access it.

To learn more, see these articles:
-