Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Starting to Program Expand / Collapse
Author
Message
Posted Thursday, July 5, 2012 10:22 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 7:12 AM
Points: 31,284, Visits: 15,746
Comments posted to this topic are about the item Starting to Program






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1325832
Posted Thursday, July 5, 2012 11:30 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 17, 2013 8:58 PM
Points: 28, Visits: 114
My usual starting point for Powershell is with "The Scripting Guy" at http://technet.microsoft.com/en-us/scriptcenter/dd901334.aspx
If he does not provide what I am looking for I then do a Google and/or Bing search.
Post #1325845
Posted Friday, July 6, 2012 2:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:19 AM
Points: 153, Visits: 238
When I needed to learn XPath and XQuery I went to W3Schools (www.w3schools.com), the tutorial was straight forward and has a good reference section.

I started off as a VB6/VBA programmer years ago with the Microsoft Press book Visual Basic Step-By-Step and added SQL to this later.

CodeAcademy (http://www.codecademy.com) has a basic introduction to Java.

However most of the time I learn best from books (not e-books) and have found the O'Reilly books some of the best references with their "In A Nutshell" range. I also have a large collection of Microsoft Press books for topics such as ADO.NET, Powershell and C#.
Post #1325901
Posted Friday, July 6, 2012 5:07 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 1:09 AM
Points: 570, Visits: 1,237
VB should be the start as SSIS uses it and particularly VB.NET. I'd recommend a course first but my favourite website for getting to grips with vb.net web apps was 4guysfromrolla.com
Post #1325989
Posted Friday, July 6, 2012 5:54 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 9:04 AM
Points: 889, Visits: 2,456
The same advice holds true for a DBA learning to program as anyone else learning to program; determine your goals.

For any DBA, I'd say learning SQL would be the most important - not just memorizing Microsoft additions, but really working with the language at a detailed level. You'll note that the advanced scripts we see use a variety of concepts to achieve their aims, some of which are little Microsoft based tricks, and some of which are very sound, generalizable algorithms and techniques. SQL Parameters are essentially no different than variables in other languages, passing arguments is similar - make use of OUTPUT parameters in stored procedures, and that'll be a sound base for other procedural languages.

If you're not serious, then play around with whatever you like - I'd recommend, in general, a scripting language.
A simple set would be SQL, batch files or Powershell, and x.NET or Python or another modern easy to write language.

If you are serious, pick about three disparate languages... and learn your algorithms and underlying constructs. Learn about sorting algorithms, from bubble and selection sorts to hash and quick sorts. Learn about pointers and trees and linked lists and hash tables and other data structures. Learn about network coding - at a minimum, TCP and UDP. Learn about disk access, buffered and unbuffered, sequential and random. Learn about CPU instruction sets. Learn about stack based vs. register based coding. Learn about word alignment. Learn about data types. Learn about parallel programming. Learn about memory management.

A very serious set would be, say, SQL, C, and some CPU's assembly language - after learning these three, anything other procedural language is just syntax.
(1)C++ can be learned as an adjunct for object oriented programming, but for the very serious, learn C first; object orientation is an abstraction layer for the programmer that doesn't survive at the instructions the CPU executes.

A moderate set would be, say, SQL, x.NET or Python or another modern easy to write language, and either C or an assembly language.
x.NET - all .NET languages are essentially a front end to a very large library of functions and procedures, with minor syntactical differences. VB.net is case insensitive, C#.net is case sensititive.
Post #1326017
Posted Friday, July 6, 2012 6:57 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 23, 2014 2:48 PM
Points: 1,754, Visits: 4,966
I've actually started tinkering around lately with, Inform, a natural language programming tool for writing interactive fiction (remember Zork?). There are tons of tutorials and examples out there, and most of the stories are published free along with the source code. This would make an excellent entry point for school kids who are interested in programming computers. Also, for those of us who program professionally, it's nice to cleanse the pallet at the end of the day and program something that doesn't involve number crunching and deadlines.

Inform website.
http://inform7.com/learn/
A website hosting an Inform interperter, IDE, place for writers to post their stories.
http://playfic.com/
Post #1326056
Posted Friday, July 6, 2012 7:24 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:23 PM
Points: 737, Visits: 5,457
I've done some Powershell, although mostly I've found scripts to accomplish what I need in general, then fine-tune them. An excellent resource for picking up on Powershell is the Sapien Press book: TFM - Windows Powershell 2.0

Also, as Frank W stated, the Microsoft Scripting Guys are also a big help.

Jason
Post #1326076
Posted Friday, July 6, 2012 7:28 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:32 AM
Points: 1,625, Visits: 5,702
I was a programmer long before I had anything to do with SQL. I started coding in BASIC on a ZX Spectrum 30-odd years ago. I've done Pascal, C, C++, C#, and assembly in my time, and yet the language I find the most frustratingly difficult to figure out is, you guessed it, SQL. The mindset you need to be in to do things in a set-based fashion as opposed to a procedural fashion is utterly different, and I suspect it's actually easier to come at this from the SQL side to the procedural side than it is to do it the other way round!

As for learning procedural languages, I actually think a BASIC variant is a pretty good place to start. The syntax is certainly more akin to SQL than, say, C is (using <> for "not equals" and Boolean operators spelt out as their English names, for instance), and modern BASICs are considerably more structured than the famed spaghetti code generators of yore. You can also use VB.NET to write your CLR routines once you're done!
Post #1326080
Posted Friday, July 6, 2012 7:44 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:04 AM
Points: 699, Visits: 1,754
As a programmer, three skills I suggest are: version control, project management and documentation.

As for a .NET language to use with SQL Server and it's features, I hate the fact that VB is supported more than C#.
Post #1326093
Posted Friday, July 6, 2012 8:45 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:00 AM
Points: 542, Visits: 2,136
Steve,
I got a real bang seeing that photo on the right hand side of your editorial. Not many people can say they actually ever used a card punch machine. I can say that I used it and enjoyed it. and was really good at it.. and it brings back some good feelings of the past - like BASIC, FORTRAN, ASSEMBLER and yes COBOL.
Post #1326138
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse