I'm...

cdonlan 18448 (7/2/2012)

---

Convincing the powers-that-be to spend the necessary money can be a real challenge, but if you want something even more challenging try to convince them that with...

Obscurity definitely helps. After all, security isn't a set process. People don't do A, then B, then C. Some do A and B, some B and C, some A and...

Brandie Tarvin (7/2/2012)

---

Chad Crawford (7/2/2012)

---

Help me out - I recognize that security is a concern when hardware is remote,...

Nicholas has stated it as I would. You want to concentrate on the logical reads, since lowering those lowers work. You can't control the physical reads, unless you can load...

The copy piece isn't a part of anything native in SQL Server. Some third party utilities, like SQL Backup Pro from Red Gate, will do this, but you have to...

Slightly jealous of Ray. He lives close enough to Yankee Stadium to get to a game for the day, and he meets Mr. October. I still remember the 3 HRs...

Visible proof

SSPI is a security/kerberos error. Search for it and you should find a few things to check. Often it's something to do with the service account and creating an SPN...

SQLPhil (7/2/2012)

---

Sometimes in order to achieve the big-bucks salaries you have to make sacrifices along the way. I know a couple of people who wanted to break in to...

If you mean can you build a Windows/SQL cluster in a VM, yes. That's what is running the SQLServerCentral servers.

We have two virtual machines running Windows 2008 and SQL Server...

You can add another file, which will help spread the load, but you will continue to add some data to all files.

You can grow the size of the files manually,...

There is no function to do this, but you can write one using the PATINDEX/CHARINDEX functions and SUBSTRING.

The two links posted above work. There are also versions in some mobile stores. I have a port for iOS and for OSX as well.

GSquared (6/28/2012)

---

So long as you can access Dropbox (or...