First off, never try to bluff your way through an interview.

Next, do apply even if your skills don't align perfectly with what the posting lists. They never will, and...

LIKE comparisons are based on collation, not ascii value. As noted in this thread, SQL_Latin1_General_CP1_CI_AS is Dictionary sort, which places both '\' and '/' between '.' and '9', along...

Kerry,

There are some known issues regarding SP2 and maintenance plans. There were covered here last year.

There are also security flaws in SP2 which need to be patched.

If you are...

Microsoft has provided a complete set of Database Mail Configuration Stored Procedures

If the configuration stored procedures don't meet your needs, you can take a peek inside the stored procedures and...

That's an interesting "feature".

This may be a longshot, but which version of Outlook are you using at work?

The MS Office web site has a Unicode information page that states

"Earlier versions...

Are you using nvarchar as you store the value before using it in sp_send_dbmail (or including "N" prior to the name if hard-coding it: N'Zamestnanecký')?

Here is a quick sample that...

Jeff Moden attached one at http://www.sqlservercentral.com/Forums/FindPost463007.aspx

Paulo G., that was a great catch!

BETWEEN didn't even cross my mind when looking at this originally. I was looking more at the generalities of which techniques...

A slimmed down version of Windows would be nice, especially on the server side. Rather than a modern bloatware linux distro, I'd say this sounds more like a "Server...

Hi K. Matsumura

Thanks for taking the time to play with the queries, that's the best way to know what will work best in your environment.

These tests were conducted using SQL Server 2000...

Found some implementation details:

"If you want to run a package from a 64-bit SQL Server Agent job in 32-bit mode, select a job step type of Operating system, and enter...

When you run it as a package, is that from BI Studio on your workstation (32bit)?

It's not as straightforward as just creating a job to get it to work on...

Great discussion.

I like the password generators.  The easier you can make it to get a long/strong password, the more likely people are to use them.

Vendor applications that require elevated privileges...

Do you really think the size of IBM will help push this?  Microsoft started passport more than 5 years ago [1] and, despite its size (it's apparently the only software company...

Hi ellen feller,

I'll be honest and say I don't know definitively which database the user will connect to.

A quick way for you to check is to create a test user...