Going out of my comfort zone...development

OK...so I have an ambition to sometime in the next 2 or 3 years to attempt the MCM (Microsoft Certified Master), as long as my company is willing to pay for it of course.

Anyway I have the administrative stuff down, with the exception of those handfull of features I have not worked with before. Which a DBA cannot work with everything, there are going to be some holes to fill. I plan on sitting the 70-450 exam sometime in May 2011. If I pass that then I will have the DBA track meet for SQL Server 2008. The other pre-requisite for MCM is obtaining the MCITP DEV certification for SQL 2008.

Here in lines my problem on the dev certifications: I'm not a developer. I know how to read T-SQL and can write some basic things. I'm not going to bang out any advanced code by heart or anything. It would be safe to say I have a basic understanding of coding and T-SQL. What books/tutorials/suggestions can be given to broaden my horizons in the dev area of SQL Server?

What I have so far is Itzik Ben-Gan's book on T-SQL Fundamentals for SQL 2008 and a teach yourself book on C#. I want to learn C# since I see it most commonly referenced in things with SQL Server (this may have changed). I don't want to become a developer necessarily but would like to learn more of it, obviously to pass the test, but also just cause I'm interested in learning it to some degree.
more ▼

asked Apr 20, 2011 at 12:06 PM in Default

Shawn_Melton gravatar image

5.4k 20 21 29

I'm pretty sure the 'dev' part is for sql dev not c# dev - you shouldn't need it to get MCITP SQL Dev
Apr 20, 2011 at 12:21 PM Kev Riley ♦♦
Doesn't CLR integration involve using a coding language other than T-SQL?
Apr 20, 2011 at 12:37 PM Shawn_Melton
ah fair point - I never think of CLR !!!
Apr 20, 2011 at 01:00 PM Kev Riley ♦♦
I by no means want to become an expert in C#, but do want to get familar with it incase a question(s) gets thrown into the test.
Apr 20, 2011 at 01:02 PM Shawn_Melton
If you do want an overview to CLR - then I did a session on it at SQL Bits 7 which covers a lot of how to implement code for CLR objects. It's a whistle-stop tour - and try to ignore the ugly guy at the front.
Apr 21, 2011 at 12:12 AM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
In SSIS 2008 they added C# as a script language for a Script task (it was VB only in 2005), and in SSRS, I think, it's still VB only as a language for inner code. However, for SQL server 2008 development certification you don't need either C# or VB. On the Miscrosoft learning portal there is a list of skills measured in this exam ( http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-451&locale=en-us#tab2). The only "alien" language there is XML :)
more ▼

answered Apr 20, 2011 at 02:01 PM

Tatyana gravatar image

413 15 15 18

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 20, 2011 at 12:06 PM

Seen: 1191 times

Last Updated: Apr 20, 2011 at 12:16 PM