Wednesday, November 30, 2011

This is how you deal with being cut off in traffic

Could someone fix my defective keyboard?

To be honest, I'm not sure I could create a DTS package if your life depended on it.

I would never put my life on the line for something so trivial...

But seriously, do you know how long it has been since since I last actively developed with DTS. Here's a clue: DTS was replaced by SSIS in SQL Server 2005... The SQL Server 2012 RC0 has been released... You can do the math for yourself. DTS was a powerful tool in its day, but technology has advanced so much that trying to downgrade is a pointless struggle. Even spell-check thinks that it is a invalid term; it suggested STD instead.

It's time to move on.

Adapt or die.

Monday, November 28, 2011

You can write a SELECT statement? So what? So can I.

SELECT userid, COUNT(clueid)
FROM userclues
GROUP BY userid
HAVING COUNT(clueid)> 0

See what I did there?

Unfortunately, SQL is a relatively easy language to learn. It only has four keywords, right? <wink>. But the problem with any language is not in its correct usage; it's in what happens when someone misuses it.
Say, what does this DROP DATABASE MONEY thingy do? Drop money into my bank account? That would be awesome.
 You, sir, need to back away from the keyboard.

What is the significance of varchar255?

Varchar(255) is what happens in your database when you let someone who doesn't know what they are doing touch it.  For example, you let a business user import an .xls spreadsheet as a table "for reporting purposes". Most likely it is named [Sheet1$].

But now you're asking:
Why does that import functionality exist then?
Listen carefully. It's only for the use of trained professionals who understand field mapping and datatypes. This is not you.