The Gates of Hell located in Kyzylgar, Turkmenistan | Atlas Obscura | Curious and Wondrous Travel Destinations

Excerpt from:
The Gates of Hell located in Kyzylgar, Turkmenistan | Atlas Obscura | Curious and Wondrous Travel Destinations
In the hot, expansive Karakum desert in Turkmenistan, near the 350 person village of Derweze, is a hole 328 feet wide that has been on fire, continuously, for 38 years. Known as the Darvaza Gas Crater or the "Gates of Hells" by locals, the crater can be seen glowing for miles around.
The hole is the outcome not of nature but of an industrial accident. In 1971 a Soviet drilling rig accidentally punched into a massive underground natural gas cavern, causing the ground to collapse and the entire drilling rig to fall in. Having punctured a pocket of gas, poisonous fumes began leaking from the hole at an alarming rate. To head off a potential environmental catastrophe, the Soviets set the hole alight. The crater hasn't stopped burning since.
Though little information is available about the fate of the Soviet drilling rig, presumably it is still down there somewhere, on the other side of the "Gates of Hell."

Largest Hailstones ever to fall in US

Biggest hail ever fell in Vivian South Dakota on 23 July 2010.

A quick way to copy a table row

From http://www.devx.com/tips/Tip/32233

Because I keep looking this up. 

A Quick Way to Copy DataRow
Instead of copying DataRow column by column, the following code copies data in one line from the source to the destination row:

DataTable dtDest = new DataTable();
dtDest = dsActivity.Tables[0].Clone();
foreach(DataRow dr in dsSrc.Tables[0].Rows)
{
DataRow newRow = dtDest .NewRow();
newRow.ItemArray = dr.ItemArray;
dtDest.Rows.Add(newRow);
}

Note: The ImportRow method does the same thing, except that the RowState of source is preserved in the destination, whereas NewRow sets RowState to Added.

Generate Script to drop all foreign key constraints in a database

From http://www.sqlservercentral.com/scripts/Replication/31530/

SET NOCOUNT ON

print 'USE ' + DB_NAME()
print ''

-- Generate Drops for All Foreign Keys in Database
print '-- Drop Foreign Keys'
print ''

select distinct 'ALTER TABLE [dbo].[' + object_name(fkeyid) +
'] DROP CONSTRAINT ' + object_name(constid) +
CHAR(13) + CHAR(10) + 'go'
from sysforeignkeys
go

Employer is closing Hudson, Ohio

Hello All:

  I found yesterday that the office I work is closing.  I have an option to relocation to Wisconsin.
  So I am currently looking a position where my background in SQL Server, MS Access, VB6 and C# could be useful.

  Please pass along any opportunities you think I might be interested in.

Thanks
Gary Kindel