Login or Sign Up to become a member!

EXPERTS, INFORMATION, IDEAS & KNOWLEDGE

Social bookmarker Add this

Your profile

Search

July 2009
Mon Tue Wed Thu Fri Sat Sun
 << <   > >>
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    

XML Feeds

Authors

« Todo List 2009My TODO list 2009 »

2009 To-do list

by riverguy


Permalink 05 Jan 2009 08:55 , Categories: Ethics & IT

Every year it seems to become more difficult to remain current on new technology. The following is definitely a bit ambitious, but if I accomplish fifty percent, I will be more than satisfied.

.Net
I’ve gone through various phases of my career where my responsibilities have switched from SQL Server centric to Visual Basic centric and back again as far as development is concerned. Although I’m now concentrating more on SQL Server/data modeling/ETL in my current role, I still need to stay current should the need arise. That being said, my .Net goals are the following:

LINQ & WPF.
I’m still “old school” when it comes to .Net development. I know there are several scenarios where LINQ would make my development more agile and allow me to get tasks accomplished more quickly. WPF would be nice to learn as well, but in the corporate world, desktop applications are fading a bit and fancy screens aren’t at the top of the list. So WPF would be a “nice to have.”

SQL Server
Top of the list here would be becoming familiar with SQL Server 2008. I had an advantage when 2005 was released—I lead a small department embarking on a new data warehousing project so it was fairly easy to select the latest and greatest technology. At the present, it’s not as straightforward to move to a new platform. However as far as development is concerned, the following look like interesting additions to SQL 2008:
• Table valued parameters
• Built-in Change Data Capture
• T-SQL Merge statement
• Improvements to Reporting Services (definitely needed)

I also need to start using common table expressions more often—often enough that they become second nature and I don’t have to reference MSDN for any syntax hints even on brain-dead days.

Other

There are several other areas wherein improvements have been made to the underlying technology but I’ve become rusty and fallen behind on due to infrequent usage the past couple of years. I’d like to get back up to speed on the following:

• Crystal Reports
• C#
• DB2/400

…And Most Importantly
Much of my free time in 2009 should be taken up by home improvement projects. I could create a two page list just on this, but it wouldn’t be that interesting.

3 comments »Send a trackback » 317 views

Trackback address for this post

Trackback URL (right click and copy shortcut/link location)

3 comments

Comment from: SQLDenis [Member] Email
*****
CTE I also need to lookup

The one thing I lookup the most is the CREATE FUNCTION syntax, I always mess it up
05/01/09 @ 11:09
Comment from: AlexCuse [Member] Email
>>WPF would be nice to learn as well, but in the corporate world, desktop applications are fading a bit and fancy screens aren’t at the top of the list. So WPF would be a “nice to have.”

If you find yourself working with web applications more, you could check out Silverlight instead. There are some limitations in the actual coding (for example no system.data namespace) but the markup language used to create the UI is more or less identical. And a joy to use, I might add!
05/01/09 @ 13:47
Comment from: dewitte [Member] Email
That's pretty ambitious - good luck! I'm in about the same position right now - .net, but now in SQL and I need to get up to speed again.
07/01/09 @ 08:50

Leave a comment


Your email address will not be revealed on this site.

Your URL will be displayed.
PoorExcellent
(Line breaks become <br />)
(Name, email & website)
(Allow users to contact you through a message form (your email will not be revealed.)