bj_fentress (1/17/2013)

---

Hey Steve,

Great post on security! I do use password safe here at work religiously, but I was curious if there was something out there that does the same thing...

The XML part is definitely challenging for beginners. It's the same with Extended Events and a number of other systems introduced in R2/2012. I don't think it's that hard, but...

If you have the files in a CSV, then you can put a column at the right and use a formula for =LEN(A1) or whatever the column in.

To import into...

It's hard to understand if you are quoting something or stating something.

Full backups do not affect or break the log chain. The full backup can include part of the log,...

This kind of works, but I'm wondering if you've calculated something in this view already.

SELECT cid, COUNT(DISTINCT ccid)

FROM dbo.MyTable

GROUP BY cid

How are you getting the counts? are you basing this on the CCID column for a CID?

It's better if you can give DDL like this:

CREATE TABLE mytable

( CId int

, CCId...

You'd have to ask ArcServe. The SQL side should be fine. It doesn't matter where or how the backups are taken, as long as they are transactionally consistent with through...

Have you tried stopping and restarting the replication agent?

Can you connect from SSMS on one server to the other? Or with a Linked Server/OpenRowset just to verify there's no network...

You can use staging tables, or partitioning, if your edition supports it. Partitioning sounds like what you are thinking of.

When you looked through the data, do you mean in SSMS? Or did you query something like LEN()?

Never been to a GenCon or Comicon. Would like to give it a try if one comes close.

Yes, always looking for them.

Miles Neale (1/15/2013)

---

Steve, I have to admit that today's editorial is one of the most hard-nosed, direct, hard hearted, and excellent ones you put together and I could not...

aykut canturk (1/15/2013)

---

okay, not related with this topic but if I use ms azure for hosting instead of renting my own physical one, would I guarantee that my sql data...

majorbloodnock (1/15/2013)

---

GSquared (1/15/2013)

---

The problem with the part I added emphasis to, is that quite often a company needs to hire a DBA because they don't have anyone who knows anything...