There isn't a lot on the Internet. It's one of the things we are working on at Red Gate, trying to get more information out there on how to do...

John Mitchell-245523 (1/9/2015)

---

If you use third-party backup software (I'm thinking of LiteSpeed, but I wouldn't be surprised if other products are similar) and you need to restore to a server...

Divine Flame (1/9/2015)

---

I only do that in situations where I need to backup the database urgently & no single drive attached to the server have enough space to store the...

Read this first: http://technet.microsoft.com/en-us/library/aa902643%28v=sql.80%29.aspx

There are restrictions for your base tables. Essentially you build the view WITH SCHEMABINDING and add an index. An example about 2/3 of the way down...

I've done this in a few ways with one database server. However, it's always a custom solution, depending on the changes being made.

For everything, we need a

For procs/functions/views, we...

Do you mean the permissions for a role added to another role?

There are scripts to get the role permissions, like this one: http://www.sqlservercentral.com/scripts/SQL+Server+7/61878/

Then you can do a search/replace to change...

Hugo Kornelis (1/9/2015)

---

Good question.

What I missed in the explanation is that the filestream filegroup does have a physical path, but this is to a directory, not a file. And directories...

deprecated doesn't mean gone. If it's still in there, I'd use it. A few things in SQL Server have been deprecated, but lived for quite a few versions.

Wayne West (1/8/2015)

---

I've never been a fan of clouds, too many news stories like this one talking about outages: botched upgrades, misconfigurations, etc. At least this time Verizon is...

lshanahan (1/8/2015)

---

First: Ouch.

Second: I'm trying to wrap my head around what kind of maintenance could possibly require a 48-hour downtime, and even then, there's no high availability architecture in...

Does the query posted above by mauriciorpp not help?

What is the servername of the disk?

It's probably not that site posting SPAM, but someone with an affiliate code, or perhaps just a vandal.

Red Gate's SQL Test isn't based on this. It provides a GUI view of the tSQLt...

Thanks

SQLRNNR (1/7/2015)

---

Stefan Krzywicki (1/7/2015)

---

Wow, that's a complete disaster. I wouldn't just be "downloading data to make sure I had access during the...