DR Types? - surely "Oops" and "Aaaargh!".

Oh, that's two. Better add "Checksum failure"...

[Variation on a theme: there are only 11 types of people in the world - those...

The naming convention does indeed separate aspects of SQL Server in a consistent way, depending on your chosen options. For my PC, MSSQL.1 is the Database service, MSSQL.2 is...

Databases start up when SQL Server restarts, but an individual database that is set to Auto Close will start up if it is not open when someone tries to access...

David Levy (2/19/2010)

---

The whole shadow copying thing scares me because if you have log and data on seperate drives you could introduce corruption like you would see with SAN snapshots....

I found two of my newer servers getting 02:00 backups that I hadn't scheduled, with a brief I/O freeze logged beforehand. This turned out to be caused by HP...

I can offer sympathy if not a solution. I have recently been importing from multiple tables in several Jet databases into SQL Server, and found SSIS very unforgiving if...

I believe AV programs are often designed to target the "last" core available, presumably to keep the remainder available for the work you actually bought the system to do. ...

I am not any sort of senior Windows guy, and I know I said I can't comment on either SQL2K8 or 64-bit, but I do think the remote registry/ability to...

I cannot say anything about SQL Server 2008 or 64/32-bit issues. But the permission required is for the user's Windows account (under which they are running SSMS) to access...

Your example is a backup task: you could generate a different email on Success | Failure of the Back Up Database task using alternative Execute T-SQL Statement tasks that...

For me it is Stored Procedures every time, for most of the optimisation, efficiency, debugging and security reasons already mentioned. I think the IDEs I have used (Delphi...

Not sure of your environment. From my Delphi 7 (Win32) days I've always used ADO/OLEDB. Something in the following might help...

uses ADODb;

// If using SQL...

I assume "turf wars" means territorial conflicts between DBAs and SysOps/engineers,...

I would add my support to the "native SQL Server backup to file" school, partly because this is clear and uncluttered by the need for extra tools, and partly because...

Actually there's also a separate Welsh...