I guess there is still a bit of a bitter taste.
It's one thing, to require installing SSIS, when you need the service, to back up your package execution.
And...

It would be nice to extend same function to proper zip / unzip archival. Wikipedia has published zip archive format specifications. Here is the link.

http://en.wikipedia.org/wiki/ZIP_(file_format)

I did...

Would you mind posting entire set of performance counters, any trace and / or SQL Server log records.

Had similar issue with SQL Server running with encrypted connection.

Resolved by securing certificate includes localhost as one of the common name entries under the certificate "subject".

Did you try to lookup Broker to Web Service Bridge on codeplex? Thought it was one of the coolest features to integrate as add - on or just built as...

* To cover bases we need to add to this article performance data for compression + encryption. It needs to be more generic in terms of CPU I/O cycles to...

When host machine attached to existing domain you don't really need third machine running domain controller.

Loopback adapter provides sufficient utility to configure public network for cluster and expose Virtual Instance...

see if you can achieve it using DDL trigger by checking application name trying to execute alter table.

if the database is in fully logged mode you can query database log using dbcc log command.

the constraint assumption was confirmed. Workaround is to place ActiveX script between parallel task and the point where parallel paths join back to "main" thread. From this script one could...

Hi, I tried yesterday similar approach by dropping on the DTS design surface

a. SQL Server connection

b. Two Execute SQL tasks

c. ActiveX script task with

I....

I like the idea and am thinking on using it in tasks other then index maintenance.

One thing I would like to abstract away is parallelizing specific task, in this case...

Hi,

does anyone has a clue if it is legal for a paid campaign activist to make an unsolicited call to home, request identification, and then specifically question personal voting choices.

I...

not nesessarilly, it uses xp_userlock internally, and with @LockOwner set to 'Session' it will only honor current connection. Just...