Contest

From SQLServerPedia

Jump to: navigation, search

SQLServerPedia's Community Contest 2009

SQLServerPedia is giving away an all-expenses-paid trip to the PASS Summit 2009 to a random community contributor! You can read more about the contest rules here. Each contest entrant is listed on this page along with their entries.

Remember that it takes 4 syndicated blog posts to gain 1 entry into the contest. If you syndicate 1-3 posts, you haven't entered. If you syndicate 8 posts, you've got two entries.

Last Update: Sept 30

Brent updates this page every couple of days. If you've got an entry that hasn't shown up here and it's been more than 2 days, email Brent.Ozar@Quest.com.

Bob Horkay

Blog Entries:

- Sept 12 - The Bob Saturday Night Look
- Sept 10 - HP SIM Manual Discovery
- Sept 2 - Unpatched Vulnerability Discovered in Microsoft SQL Server

Brad Corbin - 1 Entry

- Sept 30 - Monitoring Log File Growth Using Perfmon
Entry 1:
- Sept 30 - Book Review of SQL Tuning by Dan Tow
- Sept 30 - Recovering a Deleted SQL Job
- Sept 30 - The Phantom Query
- Sept 30 - New SQL Server Blog

Brad Shulz - 2 Entries

Blog Entries:

Entry 2:
- Sept 29 - Know Your Data
- Sept 25 - Down for the COUNT(*)
- Sept 23 - A Little Mischief
- Sept 21 - T-SQL Fu: The Story Continues
Entry 1:
- Sept 18 - T-SQL Fu: The Story Continues
- Sept 16 - The Age-Old Select * vs Select 1 Debate
- Sept 11 - Fun with Percentiles, Part 2
- Sept 6 - Fun with Percentiles, Part 1

Colin Stasiuk - 6 Entries

Blog Entries:

Entry 4:
- Sept 28 - The Power of the Dark Side
- Sept 25 - Heard It From A Friend Who
- Sept 23 - Categorizing Your Policies
- Sept 22 - Fail Whale for SSMS
Entry 3:
- Sept 21 - Coauthoring a Book
- Sept 18 - Bring a Friend to EDMPASS
- Sept 18 - Look What I Can Do with PBM
- Sept 17 - Hiding Your Kibbles and Bits
Entry 2:
- Sept 16 - SQL 2008 CMS Security
- Sept 15 - Recording a Webcast
- Sept 14 - The Wiki Witch of the Quest
- Sept 11 - Bingo!
Entry 1:
- Sept 10 - Not the First DBA
- Sept 7 - The Yo-Yo Diet For Your Database
- Sept 2 - When You Want the MAX Row That's Not the MAX Row
- Sept 1 - I'm Not The Only One Who Is Slower In The Mornings

Wiki Articles - New Entries:

Jason Crider - 2 Entries

Blog Entries:

- Sept 26 - Weekly Links
Entry 1:
- Sept 22 - Setting Up Your SQL Server
- Sept 21 - Upgrading Your Plan
- Sept 18 - SQL Server 2005 Upgrade Fact Finding Mission
- Sept 16 - Upgrading from SQL Server 2000 to 2005

Wiki Articles - New Entries:

Sept 21 - [1]

Jason Strate - 1 Entry

Blog Entries:

- Sept 29 - User Group Networking Bingo
- Sept 29 - SSWUG Virtual Conference
- Sept 15 - September PASSMN Meeting Tonight
Entry 1:
- Sept 8 - Check Out PASSMN Meeting Next Week
- Sept 7 - Report Manager in Windows 7
- Sept 5 - PASSMN SQL Summit
- Sept 1 - PASSMN September Meeting

Jen McCown - 17 Entries

Blog Entries:

Entry 9:
- Sept 30 - MidnightDBA Podcasts
- Sept 30 - The Office
- Sept 30 - Free Stuff Friday
- Sept 29 - Inside MS SQL Server 2008 Review
Entry 8:
- Sept 29 - Interesting Tidbit on IsNULL
- Sept 28 - Kick Off Banned Book Week with Beautiful Data
- Sept 28 - Weathering a Code Slump
- Sept 27 - Insert Clever Title About Shortcuts Here
Entry 7:
- Sept 25 - Testify! My Back, You Must Pat It
- Sept 24 - Development Cycle and Second Grade English
- Sept 24 - Free Stuff Friday Eve
- Sept 22 - T-SQL for the Absentminded DBA
Entry 6:
- Sept 22 - Joins and The Problem With Being a Midnight DBA
- Sept 21 - How Do You Keep Track
- Sept 18 - Code Sins - Sardines
- Sept 18 - Free Stuff Friday Again
Entry 5:
- Sept 17 - Good Times at the North Texas User Group
- Sept 17 - Code Sins - The Double Whammy
- Sept 16 - Superhuman Senses and Data
- Sept 15 - $500 Discount Deadline Today
Entry 4:
- Sept 14 - Have I mentioned I'm busy?
- Sept 13 - How Did I Get Involved?
- Sept 11 - Midnight DBA Feels Pretty
- Sept 11 - Free Stuff Friday!
Entry 3:
- Sept 9 - Inscrutably Essential Web Reading
- Sept 9 - SSIS Deploy Packages
- Sept 9 - New Videos
- Sept 8 - Grouping - Level Zero
Entry 2:
- Sept 8 - New Vids: SQL password vulnerability, CASE, grouping, DBAS, and more
- Sept 8 - SSIS Packages: Rename the Package Object as Well?
- Sept 7 - New vids, and new video section!
- Sept 4 - When Do You Become "Something" Part 2
Entry 1:
- Sept 4 - When Do You Become "Something" Part 1
- Sept 3 - Video on Server Side Traces
- Sept 2 - Time Management for IT Folks
- Sept 1 - This Blog Is About Null

Wiki Entries - New Articles:

Sept 21 - Delete_User_Objects_from_a_Database
Sept 16 - How_to_Solve_a_Problem_with_Joins
Sept 14 - Functions_-_@@IDENTITY,_SCOPE_IDENTITY,_IDENT_CURRENT
Sept 11 - Generate_Insert_Statement_for_Table
Sept 10 - Compare_Column_Definitions_Between_Two_Tables
Sept 7 - Joins
Sept 7 - The_Server-side_Trace:_What,_Why,_and_How

Wiki Entries - Enhanced Articles:

Entry 1:
- Sept 15 - Identities_Overview
- Sept 10 - Configuring_Database_Files_for_Optimal_Perfomance

John Pertell - 1 Entry

Blog Entries:

- Sept 28 - Lessons Learned about Report Server Administration
- Sept 24 - What's the Best Practice for Starting SQL Services?
- Sept 18 - SQLSaturday in Iowa
Entry 1:
- Sept 17 - Report Service Error
- Sept 14 - Updates to Previous Posts
- Sept 11 - Documenting Servers
- Sept 9 - No Booting to a VHD For Me

John Sansom

Blog Entries:

- Sept 28 - Top 5 Free SQL Server Tools

John Sterrett - 1 Entry

Blog Entries:

- Sept 30 - Get index fragmentation statistics
Entry 1:
- Sept 29 - Building a Data Warehouse with SQL Server
- Sept 29 - SQLSaturday Update
- Sept 27 - Profiler for Developers
- Sept 24 - Converting a Vertical Table to a Horizontal Table

Jorge Segarra - 3 Entries

Blog Entries:

- Sept 29 - Technical Presentations - Give It A Shot
Entry 3:
- Sept 29 - PASS Virtualization VC Webcast
- Sept 29 - Policy Based Management Walkthrough
- Sept 29 - SQL University - Basic Tools
- Sept 23 - 24 Hours of SQL PASS Recordings
Entry 2:
- Sept 23 - SQL University Orientation
- Sept 21 - Going to be Co-Authoring a Book
- Sept 16 - OPASS User Group Meeting Review
- Sept 15 - PASS Summit 2009: $500 Free?
Entry 1:
- Sept 9 - Upcoming Orlando SSUG and SQL Saturday Talks
- Sept 8 - PASS Summit Hotel/Travel Forum
- Sept 8 - SQL University: A Primer for SQL Server Beginners
- Sept 5 - 24 Hours of SQL PASS - Review

Jose Muller - 1 Entry

Wiki Articles - New Entries:

Using_SQLIOSIM_to_isolate_DB_corruption

Kendal Van Dyke - 1 Entry

Blog Entries:

Entry 1:
- Sept 29 - Off-Hours Work - A Guide for Managers
- Sept 24 - SSMS Prompt Behavior
- Sept 15 - Networking While On Vacation
- Sept 2 - How to Get Table Row Counts Quickly and Painlessly

Lee Anne Pedersen - 1 Entry

Blog Entries:

Entry 1:
- Sept 30 - Thanks for the Community
- Sept 28 - What's Your Access Level?
- Sept 18 - Where in the World is SQL Server 2008?
- Sept 14 - Discovering Aliases and Synonyms

Michael Swart - 1 Entry

Blog Entries:

- Sept 28 - Detecting Loops using Recursive CTEs
Entry 1:
- Sept 25 - CHAR: What Is It Good For?
- Sept 17 - What the Devil?
- Sept 10 - View Blocked Process Reports
- Sept 8 - Finding the Lead Blocker in a Set of Blocked Process Reports

Mike Hillwig - 8 Entries

Blog Entries:

Entry 8:
- Sept 30 - Mike's Rule - Know thy Data
- Sept 30 - Where's Waldo of Red Flags
- Sept 30 - Non-DBA Skills for DBAs
- Sept 29 - Update on Combine
Entry 7:
- Sept 29 - Where does the Business Logic Go?
- Sept 29 - Consolidation Planning
- Sept 28 - Thoughts on Being a DBA
- Sept 28 - A Time for Change Management
Entry 6:
- Sept 25 - Solving Fizzbuzz With T-SQL
- Sept 25 - Toys and Tools
- Sept 25 - Backup Agents: Good, Bad or Ugly?
- Sept 25 - Using Sysdepends the Old Fashioned Way
Entry 5:
- Sept 24 - An Ounce of Prevention
- Sept 24 - Nolock
- Sept 23 - A Bad SAN
- Sept 22 - The Great Breakup
Entry 4:
- Sept 21 - Access Used Properly
- Sept 21 - The Value of a Mentor
- Sept 18 - How I Became a DBA
- Sept 17 - When The Lights Go Out
Entry 3:
- Sept 17 - Only Restoring Where You Want
- Sept 16 - Why is My Tlog Backup Huge at 5am?
- Sept 15 - An Example of Bad Design
- Sept 14 - The Rules
Entry 2:
- Sept 11 - Dear Vendor
- Sept 10 - Crystal Reports Formula
- Sept 10 - Letting SQL Server Do Your Scheduling
- Sept 9 - A World Without Ambiguous Column Names
Entry 1:
- Sept 8 - Backing Up My Primary/Secondary Environments
- Sept 8 - Using sysjobhistory to Find What's Running Longer than Usual
- Sept 8 - An Object by Any Other Name
- Sept 2 - Giving Microsoft Access a Seat at the Table

Mike Walsh

Blog Entries:

Sept 8 - How did I get involved with this SQL Server Thing?
Sept 1 - You Could Be Suffering Right Now

Ron Dameron - 2 Entries

Blog Entries:

Entry 2:
- Sept 29 - PowerShell Quick SQL Server Version Check
- Sept 29 - Linked Server Problem
- Sept 28 - PowerShell Random Password Generator
- Sept 27 - Search for the Error Message
Entry 1:
- Sept 23 - SQL Saturday #21 Orlando
- Sept 17 - Find Null Passwords With PowerShell
- Sept 17 - Count Log-Shipped Databases
- Sept 9 - Discover Dev Databases Set To Full Recovery Model

Sankar Reddy - 7 Entries

Blog Entries:

- Sept 28 - Need to Resend a Reporting Server Subscription?
Entry 3:
- Sept 27 - Monitor Checkpoints with fn_dblog
- Sept 26 - Tracking Password Changes
- Sept 25 - Fact-Checking Ghost Cleanup Part 1
- Sept 23 - The Curse of Implicit Conversions
Entry 2:
- Sept 23 - Database Internal Version
- Sept 17 - How to Identify RS Report Parameters
- Sept 15 - Monitor Checkpoints with Trace Flag 3502
- Sept 10 - Monitoring Checkpoints with Extended Events
Entry 1:
- Sept 9 - Deferred Drop and Truncate Optimization in SQL Server 2005
- Sept 9 - Have You Used sp_helpstats?
- Sept 4 - Are your apps connecting to SQL Server with connection pools?
- Sept 3 - Meta-data for linked servers and collations

Wiki Entries - New Articles:

Sept 30 - Server_Audit_Examples_in_SQL_Server_2008
Sept 26 - Last_clean_DBCC_CHECKDB_date
Sept 26 - Tracking_password_changes

Wiki Entries - Expanded Articles:

Sept 11- Database_Maintenance_-_Dedicated_Administrator_Connection
Sept 8 - Updating Statistics

Steve Novoselac

Blog Entries:

- Sept 28 - Excel 2010 OLAP Writeback

Todd McDermid

Blog Entries:

- Sept 26 - Using CNAMEs for Flexibility

Retrieved from "http://sqlserverpedia.com/wiki/Contest"