Skip to content

The T-SQL Paradigm

November 1, 2013

This editorial was originally published on Mar 21, 2009. It is being re-run as Steve is on vacation.

I ran across this post ranting about T-SQL. It’s got going pretty quickly with some less that professional responses. It’s cleaned itself up a bit, but it got me thinking for this Friday.

My first programming was done in BASIC. From there I played with a little assembler before going on to Pascal and C in high school. The came LISP, APL, Fortran, more assembler, C++, and a little ADA in college. My professional career had me programming in Lotus 1-2-3, dBase, FoxPro, C, VB, and finally SQL with minor dabbling in HTML, XML, ASP, and some .NET.

I think I’ve had a decent amount of programming experience in my life. In that time, I’ve found that most programming languages to work fine, and while I’ve enjoyed some more than others, I haven’t thought that any “sucked.” I wouldn’t want to write most modern apps in APL, but I don’t much think there’s any thing wrong with picking VB.NET v Java v C#. So for this Friday’s poll:

Is T-SQL really a strange paradigm?

Or SQL in general? Is it really messed up? Would the structures used by LINQ make more sense to anyone? Hardcore developers seem to like a different structure, but is it because it seems more natural to them? Or is SQL really such a strange beast.

Many people seem to have trouble with SQL. Just read the forums here at SQLServerCentral to see all the issues that come when people try to query the database. But is it just hard to learn or is there a better way to build a query language?

Steve Jones


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available atsqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there.

You can also follow Steve Jones on Twitter:

Overall RSS Feed:  or now on iTunes! 

Today’s podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

I really appreciate and value feedback on the podcasts. Let us know what you like, don’t like, or even send in ideas for the show. If you’d like to comment, post something here. The boss will be sure to read it.

About these ads

From → Editorial

One Comment
  1. I have worked with most of the languages that you mentioned in the article. I have been working a lot with T-SQL and got good at it. Some people like to attack the unknown the same way that in most of sci fi movies the humans attack the UFOs first. We are scared of what we do not know.

    In my opinion, the real problem is that some people like to compare oranges and apples. They are too immersed in what they know and attack others because they think that they are in the same situation (T-SQL cage). My advice to these type of people is to find a good learning tool that work for them. In my case real life examples with explanations helped my understand they why of things. Why we have to think in sets? Why we need transactions? Why we do not use cursors? Etc.

    I do know, there might be a better way to create a query language. But I think that SQL is still evolving and I found it easy to learn.

Comments are closed.

Follow

Get every new post delivered to your Inbox.

Join 4,323 other followers

%d bloggers like this: