Tuesday, July 27, 2010

SQL Go and Batches

The other day someone asked me how the GO command should be used with MS SQL Server. I must admit that it was one of those things that I just used without fully understanding what it is. So I researched it and found directly from the source (msdn page about GO and msdn page about Batches) a good technical explanation. In summary, the GO command is not a SQL command at all, instead it is a command used by our most common SQL tools (sqlcmd and osql utilities and SQL Server Management Studio Code editor) to signal the end of a batch. So what is a batch and how is it different then a transaction. The short answer is a batch is the group of commands sent all at once to the server from the client. A transaction consists of one or more batches.

Fiction Blog

On the way to work this morning I had this idea for a fictional set of blogs. Or more specifically, what would happen if a blog site was setup to host one or more interrelated "blogs" by/about fictional people and then the community was asked to create the entries. Basically, each entry would me a mini story painting part of the larger picture of the fictional owner. Multiple blogs could support other characters, maybe those that the first one meets or interacts with. I wonder what would the story look like in the end?

Local Events

I never realized that the Bellingham Herald had an events calendar.  Here is the list of Kid friendly events for Bellingham.  This inspired me to check the Skagit Valley Herald.  They have an events page for Skagit County.  The Bellingham one is a bit better as at least I am able to filter on kid friendly.  I really wish I could add them to my google calendar easily.  Need to work on that.  I kinda started my own calendar that I maintain and my family uses.