Each application may or may not support connection pooling and this is separate from other applications even if the application target the same server and database.  Everything in the connection...

Many places that sell SQL Server include 5 or 10 CALS but that should be clear from the invoice.  If you bought 5 CALS it would say so.  If they...

I used to work with DB2 years (and years :wow ago and at that time DB2 internally handled LEFT JOINS more efficiently than RIGHT JOINS. ...

Its not yet the 27 and yet the contest is over!  This is the messsage I get when emailing the contest.

Hi. This is the qmail-send program at lance.cordhosting.com.

I'm afraid...

If the contest is still on why does the email address no longer work?

Hi. This is the qmail-send program at lance.cordhosting.com.

I'm afraid I wasn't able to deliver your message...

From Microsoft "By default, the trunc. log on chkpt (ie Simple in SQL 2000)database option is set for the SQL Server msdb system database. This helps ensure that the transaction...

Thanks this helps.  Most of the DW books and articles concentrate on the mechanics of AS and not on the overall approach

Do you have mixed security?  Can you log on with sa or change the sa password?

Check if you are running SP3A.  Also go to http://www.microsoft.com/sql/downloads/securitytools.asp and check for the slammer...

Access superior in some way to anything! Really?  I didn't even know that Access had anything that could be called security.

Unless that password...

I agree encryption is not 100% but I doubt you can break encoding by SQL Shield.  Having said that, putting business logic into a DLL makes sense, SQL procs should contain...

If this system will be run on your clients servers then they will have access to the server and all the tools.  Create the procs WITH ENCRYPTION as in

(see...

With respect to how to handle database changes, some method of cache refresh has obviously got to be designed.  What this is might depend on the volatility of the data.  I...

Thanks guys!!!  Jonathan your suggestion worked.

There are quite a lot a auditing applications available- OmniAudit, ApexSQL Audit, SQL Smart Audit, SQLAUDIT, DBAudit.  They all differ in cost, where the audit data is stored (same database,...

They aren't exactly pulling you leg, just not telling the whole story.  Oracle stored procs do not return recordsets by default like SQL Server stored procs, but they can be...