Simple way: Use the import wizard in SSMS to load the data into a temp table.

Then use a query to match up the data. If you temp table is...

Powershell will do this, and give you better error handling. However more development work.

The other thing to think about is using a product like SQLCompare to build your scripts. I...

This says .NET 3.5 (http://msdn.microsoft.com/en-us/library/ms143506%28v=sql.105%29.aspx)

However when you run setup, it will run a pre-check and let you know if you are missing anything. I've never had to enable anything in...

A desktop icon is a shortcut. Easy-peezy for me to add one back.

It's not a one click, and I certainly think not having a "create a shortcut" option from the...

TravisDBA (3/29/2013)

---

Another thing to remember here is that script injection is NOT just restricted to SQL. MSDOS commands can be injected in a string that is passed to an...

Jim,

You can dislike it, but that doesn't mean you're right or wrong. That was my point. There are hundreds of millions of office users. Lots of them like the changes,...

I don't love government intervention, but I do think it's needed in cases. Not here, but I do believe this is bad for baseball: http://espn.go.com/mlb/story/_/id/9109596/alex-rodriguez-make-more-houston-astros-combined-salary

The long, guaranteed contracts without limits,...

jfogel (3/29/2013)

---

I agree that if you are vigilant with security then xp_cmdshell is just fine and I've used it for years. However, over the last year or so I've started...

Jim P. (3/28/2013)

---

I have turned it off in everything MS, and 99.9% of...

peleg (3/29/2013)

---

why to use xp_cmdshell when you have the ability to write assembly it NET, more then that, that can be signed and give a higher level of security?

we are...

Jan Van der Eecken (3/28/2013)

---

And again totally unrelated. Does anyone have an answer to the question I asked here? Steve perhaps? Talking about "Performance Tuning with SQL Server Dynamic Management...

Good answer: http://meta.stackoverflow.com/questions/167452/what-are-the-most-effective-ways-to-guide-new-users/167510#167510

I know we don't keep people away, but treating them with respect, somewhat without regards to how snippy they may appear, is something I would hope we strive...

jasona.work (3/28/2013)

---

Anyone thinking of going to see the popcorn movie that is "GIJoe: Retaliation"?

I'm debating between waiting until tomorrow, or going to see it tonight on my own, then tomorrow...

Some people dress up. I've seen the tophat and tails.

I'll be in jeans and a Hawaiian shirt 🙂

It's just funny to see it in media. I use records in a talk and once in awhile I meet someone that has no idea what they are.

As it is,...