You always restore in this order:

- full backup

- latest diff backup only

- log backups SINCE the last diff

An update: I found this site today, and apparently Microsoft is really going to push this forward: Microsoft Private Cloud

If you are auditing connections, this ought to be in the Windows security log. Otherwise, I don't think so.

You should make sure that you are using a specific proxy account for the linked server. It might be set to use the SQL Server service account by default, and...

I'm looking to write something up on that. Once I get some screenshots and we schedule the maintenance, we'll change that. Part of what we are showing is that we...

Grant Fritchey (12/9/2010)

---

Jack Corbett (12/8/2010)

---

Hey guys, I don't see any threadizens on the list of submissions to SQLRally yet! What's taking y'all so long. There isn't any of...

Rod,

That makes sense.

If you have something like Red Gate's Data Compare (my employer), this is very easy to do with a backup. No need to restore.

AndrewJacksonZA (12/9/2010)

---

From a pure hardware point of view, NOT taking into consideration optimising the software like mu_rauer said, investigate RAIDing some...

To me, the cloud commercials highlight the issues of sharing and not being overly dependent on a piece of hardware that can fail. It's a good thing for consumers, many...

In SQL Server, if you don't provide this, you have a default database you are assigned to. Not sure how it works in DB2. In Excel, it can be the...

We send mail through a .NET application, which sends them individually. There is a limited customization for each one, and so the database needs to be read to send them....

Using varchar(max), or nvarchar, will not waste space. It will use what space you require.

I signed up, but was out and about. If I get the recording link, I'll post it here.

AFAIK, they are. There are sometimes different patches for that edition, but it is the same build.

did you read Gilamonster's last note? The pages are not necessarily "corrupt" as in bad sectors on disk. SQL Server is not finding on those pages what it expects, so...