My $0.02:

Since 1996 Unicode has not been a 16-bit encoding Unicode.org.

There are 3 encoding schemes for unicode UTF-8, UTF-16 and UTF-32 but all of these encoding schemes can use...

"karo yaa na karo, koshish jaisa kuch nahi hai"

"Do, or do not. There is no try."

Nice, a quote from a Yogi and a quote from a Yoda.

Great article. Thanks for...

David B (5/24/2009)

---

and apparently is considered insecure (MSDN Link) along with the other MD hashes. SHA is apparently the way to go instead.

Of course I don't really play in that...

Phil Melling (5/8/2009)

---

Security considerations. Time after time I get databases come to me with instructions on how to deliver the various database objects, but no consideration on how users...

My biggest annoyance is the colour printer sitting outside my office. I can live with the fact that it sounds like a 747 taking off when it warms up, but...

My biggest productivity improver is VPN.

I don't use it often, but being able to schedule production roll outs and patches at 10:30 pm on Friday night without driving in to...

I can understand (and even agree with) where this CEO may be coming from.

He's not requiring his personal review of every travel request, just the "emergency" ones. I suggest that...

In order to run SSIS packages you need to be a member of db_dtsoperator, db_dtsltduser, or db_dtsadmin. See http://msdn.microsoft.com/en-us/library/ms141053(SQL.90).aspx

Rather than granting the user this kind of permissions (probably...

I think all of my wish list has already been covered but I'll reiterate it since it's small.

Working in education an age function would be really nice and so would...

>>Is there any way to tell SSIS to ignore text qualifiers which are not followed by column delimiters...

I've banged my head on the keyboard for this quite a lot....

Steve,

Could this be the explanation for why the are so hesitant to give us SP3 for SQL 2k5?

Maybe they really don't have the resources to do it once it's no...

Hi Tony

That'll work but I've always preferred:

WITH T AS (

SELECT *

, ROW_NUMBER() OVER (PARTITION BY [Name] ORDER BY [ID] DESC) AS RowNum

FROM [Table]

)

SELECT * FROM T WHERE RowNum = 1

It...

-- I have to agree with some of the previous posts about the wording of the question.

-- When you talk about amalgamating tables I think of a UNION not a...