This is my last post of year 2012, a year full of learning, writing and community events. Listing every highlight could take several days. Instead, I want to remember a few projects and moments that made the year special.

SQL in Sixty Seconds
The idea behind SQL in Sixty Seconds was simple: share one useful tip in the time we might otherwise spend waiting in a queue or riding an elevator. A short lesson could fit into a busy day.
By the end of 2012, the series had reached 37 episodes. Almost all had passed 1,000 views, and some had been watched tens of thousands of times. I was grateful to see readers and viewers respond so warmly to the format.
You can find the series on the SQL in Sixty Seconds channel. Here are the 37 episodes included in this year-end post:
Episode 1 | Episode 2 | Episode 3 | Episode 4 | Episode 5 | Episode 6 | Episode 7 | Episode 8 | Episode 9 | Episode 10
Episode 11 | Episode 12 | Episode 13 | Episode 14 | Episode 15 | Episode 16 | Episode 17 | Episode 18 | Episode 19 | Episode 20
Episode 21 | Episode 22 | Episode 23 | Episode 24 | Episode 25 | Episode 26 | Episode 27 | Episode 28 | Episode 29 | Episode 30
Episode 31 | Episode 32 | Episode 33 | Episode 34 | Episode 35 | Episode 36 | Episode 37
SQLAuthority Memory Lane
Daily writing had left me with more material than I could remember. Sometimes I would research a topic and find one of my own older posts in the search results. Memory Lane gave me a way to revisit those useful ideas and bring older articles back into view.
The series had reached nine episodes by the end of 2012. Looking through them reminded me how much we had already discussed on the blog.
Current editorial note: The nine Memory Lane pages have since been rewritten as individual SQL Server articles. This recap preserves the series history, but the links below lead to the current articles, not the original episodes.
- Walking Foreign Key Chains to Find a Safe Delete Order
- Recycling the Error Log on a Schedule and Keeping Enough History
- Restoring a TDE Protected Database on Another Server
- Cursor Options That Matter: LOCAL, FAST_FORWARD and STATIC
- STRING_AGG Limits: The 8,000 Byte Error, Ordering and Duplicates
- Removing Repeated Characters From a String With GENERATE_SERIES
- Uneven Parallelism: Spotting Skewed Threads Behind CXPACKET Waits
- Disabling Nonclustered Indexes Before a Large Load, Then Rebuilding
- Regaining sysadmin Access When Nobody Can Log In

Community events in 2012
I attended nearly 30 events during the year. Some were small, others were large. Some took place in the Indian subcontinent and others outside Asia. Each offered a different chance to meet people and share what we were learning.
SQL PASS 2012
SQL PASS was a highlight. I enjoyed the book signing and the release of our new books, along with the chance to spend time with the SQL Server community.

TechEd India 2012
At TechEd India, I enjoyed meeting the local community and sharing some SQL enthusiasm. My family had attended for four years, and we continued that tradition in 2012.

Thank you for reading, watching and joining these conversations throughout 2012. See you next year, which is tomorrow!
A year-end post is not just a list of milestones, it is a chance to thank the people who made them memorable.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
Discover more from SQL Authority with Pinal Dave
Subscribe to get the latest posts sent to your email.


6 Comments. Leave new
Wish you a very new year, and your blog always rocks and inspires people. Hope this new year also brings you more interesting things.
Keep sharing your humungous knowledge.!
Happy new year and have a great 2013! :) I look forward to reading what you have to post in the coming year.
I wish u a Splendid Year Ahead. Thanks a lot For all the great posts that you have been providing for us. I wish u all the success and happiness for u and for your family.
Wish you Happy New Year…. My Best Wishes to you and your family…
Here’s wishing you a very Happy & Prosperous New Year 2013!
Thanks for all your blogs sir!!
Wish you and your family a Very Very Happy New year!!!