Weekly Link Post 121

Posted by Rhonda

Application Development/Design

SQL Server, Compliance and PowerShell

Code that Writes Code – Buck Woody gives us a great post on setting up test environments.
When to use SET vs SELECT when assigning values to variables – “SET and SELECT may be used to assign values to variables through T-SQL. Both fulfill the task, but in some scenarios unexpected results may be produced.”
Comma Separated Values (CSV) from Table Column – Pinal Dave provides a script for dealing with Comma Separated Values.
How to Get Table Sizes in SQL Server – Keith Elder shares a great tip.
Pivoting the Dynamic Way – A great article from the November 2009 SQL Server Magazine.

Community/Technology Events & Training

Houston Area User Group Meetings – This is my monthly listing of Houston area user group meetings.

Internet, Software and General Technology

Blogging and Social Networking

Goodbye Twitter/FaceBook Integration, Hello Readability – Joe Webb shares his adventures in Social Media status updates.
SQL Server Presenters on Twitter – Jeremiah Peschka provides a great list of Twitter accounts to consider following.

Self-Improvement, Productivity and Career

What Are You Putting Off? How to Get On With It in 3 Steps – “The problem is, the more we put something off, the harder it is to get going on it. ”
Seven Secrets of Good Presentations – Great pointers for presentations.

Health, Fitness and Recipes

Why Exercise Makes You Less Anxious – “…both in popular imagination and in scientific circles, it has been a given that exercise enhances mood.”

Sports, Entertainment and Everything Else

Smoke trail left by brilliant meteor – This is 8 levels of awesome!
Saturn’s Flickering Lights Caught on Video – As on Earth, electrical fields above Saturn interact with atmospheric chemicals to produce shimmering lights above the polar regions.
Telescope Buying Guide – A series of articles with great advice on buying a telescope.
Sunday Conversation: The case for Pluto – Great post on the “planet” Pluto.
Dilberts I Found Funny: 11-24 | 11-25 | 11-26
Movie Trailers: The Lovely Bones Royal Premiere Featurette