True. And, assuming you're only going to run the scripts and then drop the linked server, it's not that big a deal. However, it is a bad practice from a...

Permissions on that proc are set to 'public', so it should work. Can you see it in the master database?

This worked fine when I tested it locally:

declare @sql nvarchar(2000)

set @sql...

I wouldn't add a linked server to production due to the security concerns that could raise.

Otherwise, the cursor option above or maybe an app that uses SQLDMO. DBArtisan will allow...

Honest answer... It depends.

However, if your query is taking 10 minutes, I'd examine exactly what it is that you're doing as far as the basic process goes. Are you moving...

We have an emergency response team that practices recoveries from various issues once a month. Almost all them involves restoring to a point in time. There's nothing worse than have...

One thing not mentioned in the article, if possible, take one more log backup. If not possible, you may lose 9 minutes worth of data.

"Yes, there's the rub. How do you get the users out of the system and lock it down? We do not have a DBA...

Great article. Good advice. Thanks for sharing.

The only thing worse than noticing the issue right after you hit the Enter key is not noticing the issue. We've had a few...

I have to say, I think both articles are right. I see the role of Production DBA seeming to shrink in terms of importance even as it becomes a more clearly defined role...

That's good to know. We were doing it for performance reasons, not because of failures in the code, but if we dodged a bullet, so much the better.

"can we also use a path where the XML file exists."

I'm pretty sure that you can't reference files directly from within TSQL. If you really, really HAD to do...

Nice article.

You might consider adding information about performance management. For example, maintaining the document handle across multiple queries and/or procedure calls is pretty expensive. Generally, if we run into a...

We've been using SQL Data Compare for a couple of years and SQL Compare for just over a year and we've been extremely happy with the tools. Further, we're happy...

By the way, the title of this article is misleading. I expected to see something about natural versus artificial keys, unique constraints, resolving sub-type roll-ups, logical arcs, denormalization by design,...

Naming standards are very good things. Common abbreviations are very good things.

Very good things can, however, be taken to silly extremes. We've got a logical modeling team tasked with, along with...