A Quick Glance at the Year 2011

Here we come to the end of another wonderful year. Year 2011 has been really wonderful and I had varied experiences in terms of Learning, Sharing, Networking, and much more.
From a Technical Standpoint, I have been doing a considerable amount of reading thereby learning new things and improving my skill set in the Microsoft BI space. Exploring the new features of SQL Server Denali was really fun and exciting as more and more feature additions/improvements were made with each CTP release. Currently exploring the SQL Server 2012 RC0 and will continue to explore it in the coming days.
From a Management Standpoint, it has been quite interesting and at times stressful. Though I have been focused more on the technology side of the things right from the beginning of my career, I did a little bit of management work here and there. And, during 2009 I was involved in a considerable amount of management work when I was at the client location and was working as an Onshore Lead in an Onsite-Offshore model. Thereafter, starting from 2010 I was again focused mostly on the technology side of things working as a Technical Lead after I came back to India. During 2011, again I moved into a Techno-Management Role and have been working as a Development Lead for about 6 months now. So far the journey has been pretty good though little stressful at times, as it involves dealing with people, processes, and lot more.

Irrespective of which role we are in, some amount of management experience is essential as we go higher up the ladder and I have gained sufficient understanding of the management aspects based on my last 6 months of journey and I believe it is sufficient for folks at my level of experience in the industry.

I strongly believe that, learning is a continuous process and there is no end to it. We learn something new every day be it technical or non technical. In the coming days, I will focus more on the technology side and try my best to share my learning’s with the community.

Sharing is a very important aspect of learning. Learning is of no use if we do not share our learning with others. Sharing knowledge with others offers great benefits like opportunity to connect with people, learning from their experiences, and also learning new things based on the interactions made as part of sharing and much more.

As part of the sharing exercise, I have delivered few trainings/sessions within the organization on SQL Server, Query Processing, T-SQL, SSAS, & SSRS etc. It was an exciting and a wonderful experience. Will try my best and continue to contribute towards trainings/sessions and anyone interested can contact me through my blog and I will be happy to help you get started 🙂

Blogging is another way to learn and share, and I have been doing quite a bit of blogging though it got slowed down towards the end of the year. I have written quite a few articles on the new features of Denali and have started posting short tips at JustLearned on BeyondRelational.com and have submitted a couple of articles on MSSQLtips.com. I plan to continue to blog and at a more increased pace by publishing articles more frequently and participating more and more on forums etc.

Here is a list of all the tips and articles that I have written during 2011 both on this blog and also on external SQL Server Community Websites.

Publish Date Article Title
28-Dec-2011 Response Time of SSMS in SQL Server 2012 RC0 is Very Slow
24-Dec-2011 Stop Sharing a Folder in Windows 7
13-Dec-2011 SQL Server – 3 part naming Cannot be used when dropping Views,Functions or Procedures. – BeyondRelational.com
09-Dec-2011 Querying SQL Server Agent Job Information – MSSQLTips.com
11-Nov-2011 SQL Server Row Count for all Tables in a Database – MSSQLTips.com
25-Oct-2011 Adding a Not Null Column to a Table in SQL Server
04-Oct-2011 Guidelines on Reading, Writing, and Managing Emails
24-Sep-2011 Coding Standards and Best Practices
14-Sep-2011 Schema name is not mandatory while querying Compatibility Views and mandatory while querying Catalog Views – BeyondRelational.com
04-Sep-2011 Quickest way to SELECT All Columns from a Table – BeyondRelational.com
06-Aug-2011 Intellisense in SSMS 2008 Lists the Objects Even Before Creating them – Pretty Intelligent
16-Jul-2011 SQL Server Code Named “Denali” CTP3 is Available for Download
08-Jul-2011 Internet Explorer – Click the scroll wheel to open a link in a new tab – BeyondRelational.com
27-Jun-2011 Online Tools for Formatting T-SQL Queries – BeyondRelational.com
21-Jun-2011 Shortcut to View the Properties of a File or Folder in Windows – BeyondRelational.com
10-Jun-2011 Combining SELECT INTO and UNION ALL in T-SQL – BeyondRelational.com
10-Jun-2011 Applying Logical Operators in TFS Work Item Queries
07-Jun-2011 Free E-book on Data Quality and Master Data Management
05-Jun-2011 Videos for Learning Microsoft BI
15-May-2011 Always Check-Out the Latest Version of Code from TFS
28-Apr-2011 Resources to Learn More about New Features in SQL Server code-named Denali CTP1
20-Mar-2011 Use of DISTINCT, UNION and UNION ALL in SQL Server
10-Mar-2011 Deploying Multiple Reports to Report Manager in One Go in SSRS
06-Mar-2011 Data Profiling Using T-SQL: Part 1 – Column Null Ratio
26-Feb-2011 Working with CHECKSUM Function in SQL Server
13-Feb-2011 Shortcuts for Starting, Stopping and Restarting SQL Server Service
09-Feb-2011 Formatting Date and Time in SQL Server Reporting Services (SSRS) Reports
25-Jan-2011 Display the Solution Name in Solution Explorer by Default in SQL Server Business Intelligence Development Studio (BIDS)
12-Jan-2011 Improved Description about Transformations in SSIS Toolbox in BIDS in Denali CTP1 – Usability Enhancements in BIDS-SSIS in SQL Server code-named Denali – Part 3
10-Jan-2011 Formatting Shortcuts in SSIS Package Designer in Business Intelligence Development Studio (BIDS)
07-Jan-2011 New & More Organized Toolbox for SSIS in BIDS in Denali CTP1 – Usability Enhancements in BIDS-SSIS in SQL Server code-named Denali – Part 2
05-Jan-2011 Surround With Feature in SSMS in Denali CTP1 – Usability Enhancements in SSMS in SQL Server code-named Denali – Part 3
03-Jan-2011 Insert Snippet Feature in SSMS in Denali CTP1 – Usability Enhancements in SSMS in SQL Server code-named Denali – Part 2
02-Jan-2011 Microsoft SQL Server – The Most Widely Hosted In House Database Servers

All in all, it has been a wonderful year with an increased amount of activity compared to previous year. Looking forward to a new year with lot of learning, fun and excitement!!


About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on December 31, 2011, in About Me. Bookmark the permalink. Leave a comment.

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s