David.Poole (6/11/2008)

---

... I've been looking at spatial geography and trying to understand the new indexes which are really odd. I'm not sure why the new geography and geometry types...

Charles Kincaid (5/21/2008)

---

...(1) In your database create a nonsense, but unique, filename for each "target".

(2) Use that to include in a well crafted HTML email that references an external graphic....

Jim Russell (5/21/2008)

---

I was disappointed when, per the MS Connect site, that the horrible flaw in the SSIS FTP task was not fixed. (The flaw is that the source/destination directory...

There are also the free SQL boot camp weekends occasionally done in Florida and California (and sprouting up in other places), again your boss would be out transport, meals, and...

Grant's got it right. If the company doesn't have a good training plan, you can pretty much forget it. And it used to be that you could write-off...

There's a good article on Technet on implementing row-level security, actually it's on building a classified database, but it does include row-level security, which doesn't look too difficult to implement.

http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx

It's kind of funny. My best friend (she was best man at my wedding, my wife and I just celebrated our third anniversary Wednesday) frequently told me that no...

James Raddock (6/3/2008)

---

... Some people I've worked with think it's best to declare your variables at the top of the proc with your temp tables, but that's more of a...

Your best bet for getting the files into a specific directory is to either move them through a CMD file (which is how I invoke PSFTP), or to download them...

I don't have an answer for you, but I might have a clue to suggest. I'm trying to set up an SFTP download in a scheduled job and I'm...

Ah, I hadn't noticed the PERSISTED, it was off into the scrolled section. It's kind of funny, I'd never had a problem with non-deterministic indexing until I started developing...

I don't have time to test what you did, but it looks like it might be viable. Try two dates: 5/2/08 and 2/5/08, it's a good test if people...

It was pretty simple, at least on the surface. The case study was a drug study where you have a group of subjects with a condition and you're testing...

Answered my own question!

There's a box that lets you skip X number of rows. When I told it to skip the first row, then it allowed me to define...

But if we're packaging ourselves to be more sellable, do we have to put an expiry date on ourselves? And if we don't expire on that date, is it...