We could. I'd actually like it if we had a good piece of software to help checks, and have someone independent, like PASS, host it. We could cut/paste a quick...

Third vote here. network copies can tolerate delays, and will retry if packets are lost (which happens all the time). The SQL backup throws pages out as fast as it...

I do think things will mature, and we'll get data in the cloud. Even financial data, but it will not be the mainstream, IMHO. Just like the web, we'll get...

I don't think it's cultural. I think it's more Roy's #2 reason. There are people looking to get ahead, and when it's a large number of people, there are a...

I completely agree. However when they become more like 40% or more the cost, which I've seen, then...

For the humor ones, not necessarily related to SQL, I kind of expect that you'd guess for fun or Google the answer.

Glad you enjoyed it. Sounded like a great event from the tweets.

Thanks for the comment, but I think you're taking the wrong approach here. All the good that you have done gets...

chandrashekarthota (4/26/2010)

---

As a site administrator I request you to kindly ignore my Core member comments. I am

closing down my site for few weeks just because of plagiarism and I have

learned...

I agree with that post above that most people don't know how to run or manage a meeting, or often just don't want to spend the time prepping for a...

XEN or VMWare will let you run it (Windows + SQL Server) on a Linux host.

Data + objects? No. You could script out objects, and then you'd need to export the data. SSIS could easily build a package here. What I'd do is build...

Something like this:

CREATE TRIGGER emptrigger ON emp for INSERT

AS

BEGIN

IF NOT exists( SELECT e.empid

FROM emp e

INNER JOIN INSERTED i

ON...

You can't set a constraint between a table and a view, but you could set a trigger that would check to see if the inserted data was in the view.

Perry is correct, but you should be OK in terms of your app with the compat mode. I haven't heard of issues, but I haven't seen many people running in...