BigSam (8/12/2013)

---

You are so correct in there being no downtime. We will pick a time of day to minimize the impact to potential connections.

Sounds like log shipping is the easiest...

you know we can't unsee things, right?...

Jan Van der Eecken (8/10/2013)

---

When I was working for Mercedes in the early 80's we also had a customer who had put over 1 million kilometres on his 1956 190...

chrisn-585491 (8/12/2013)

---

1. community editions may be free and will get you started but once you get beyond a certain point you will want the commercial editions which are definitely NOT...

brdudley (8/12/2013)

---

Set the amnesty date in 2003 and you'd have to fire some Microsoft programmers. I was shocked to see sample code on the architecture and practices site with concatenated...

OCTom (8/12/2013)

---

I may need some educating here. But, is the article Denny Cherry referenced really discussing a SQL injection? It was injecting malicious Javascript to a web page. It seems...

There is no such thing as "no downtime, ever." The sooner your boss understands that, the more rational discussion you can have.

There will always be downtime, but you want...

First, there's no such thing as "best". There are positives and negatives for all methods.

Second, how is the database encrypted. Is it TDE? If it is, then as mentioned first,...

I don't see that.

Is it still there? Or is it gone.

As another note here, I went to a few non-technical people to show them the newsletter and get opinions.

Things were split. About half liked the narrow, fixed width format, about...

Dave62 (8/9/2013)

---

User defined server roles looks interesting. Thanks for the question Steve.

A minor correction is needed on the reference. It points to fixed server-level roles not user defined...

richardm-1037631 (8/9/2013)

---

Steve

My biggest complaint about the new layout comes from featured content section. My Outlook doesn't download pictures (to protect my privacy), so having the image of "Technical Article"...

Jeff Moden (8/8/2013)

---

Right sizing log files and datafiles for the FULL recovery model is a far bigger PITA than TempDB will ever be, IMHO. For example, even if you...

Not sure a...

We have a piece coming next week on CLR procedures and code.