All the questions on the site have suddenly become well researched an insightful explorations of the deeper meaning of data, databases, disaster recovery...

RBarryYoung (3/5/2014)

---

Grant Fritchey (3/5/2014)

---

Sure you can. The connection string is a little funky. This is my "server name" for connecting to one of my databases vx6jxrb86b.database.windows.net, well almost. I modified...

yuvipoy (3/5/2014)

---

Grant Fritchey (3/5/2014)

---

Cascade delete is pretty dangerous. I don't know of many people that use it. It tends to create very large transactions that lead to lots and lots...

You already seem to have a decent list. But, to provide a means for validation, Jason Strate maintains a monthly checklist that he updates regularly. You can see the latest...

It depends on how you're marking the event. Use a severity of "INFORMATIONAL" or "WARNING" instead of "ERROR"

Cascade delete is pretty dangerous. I don't know of many people that use it. It tends to create very large transactions that lead to lots and lots of blocking. You're...

Sure you can. The connection string is a little funky. This is my "server name" for connecting to one of my databases vx6jxrb86b.database.windows.net, well almost. I modified that a little....

How about, instead of GeneralInformation, we think of those things as what they are, People. You can then create a People or Person table and there you can locate the...

I have never had to do this before, so I could be very wrong, but, based on my understanding of replication, you're going to have to rebuild the entire thing....

Yep, it includes all the changes made within a database, both structure and data, so no worries.

You need to check all the hardware and configurations. If you've never done that, I strongly recommend getting an expert in the door. Hardware configs, especially I/O, can be extremely...

Assuming it's getting backed up on a regular basis, I'd just access it's backup to do the restore. You can restore from a file share using "\\myfileshare\myfilename.bak" just fine.

dbalmf (3/4/2014)

---

Hi,

I'm assuming your laptop is part of the same domain as the SQL Server. Create a shared folder on your laptop, You will need to give the user which...

If it has to be near real time, replication or an availability group (2012 and greater) are your only real options.

By the way, this is a 2014 forum. If people...

Ha! It gives everyone headaches. But you can search out scripts online to pull the information out. It just...