Gethyn is correct. There is advice from various sources, including SQL CAT, that you restore each backup, each day, to a test machine to ensure it will work. I think...

TDE protects from physical access to the files if SQL is down. If you detach/attach files, they are safe.

You can't run TDE on laptops practically. It's in Enterprise Edition only...

As mentioned, it's hard to say. I've had lots of SQL 2000 servers that ran on dedicated machines with 2GB or 4GB of RAM. SQLServerCentral served thousands of clients from...

http://www.sqlservercentral.com/Forums/TopicSubscriptions1.aspx

Click control panel to the upper left, then scroll down to find forum, and topic, subscriptions. There's also a contact us link on the menu to the left.

I like the idea of the cloud, but as a private, secured set of services inside my walls. Deploying to a cloud, without having to worry about a particular server,...

Her is the link for the book from MS that can help: http://blogs.msdn.com/b/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx

Please don't upload books from someone else, like MS.

Agree

Agree

Agree

Now if I had someone to make a few changes and test them. This is a relatively low priority item, but I do agree that these are some changes that...

If you just want to get notified if SQL is down, not Windows, Go to the control panel, look for services, look for the SQL Server. Look at the options...

Jeff Moden (6/30/2010)

Actually, it's not. It's only easier to comment out the last line with...

I've typically used a domain account, no rights (except Everyone or what the service specifically needs on the network). I don't think there's a fundamental reason to do this over...

You don't need a dedicated machine, but you need one up and running all the time. SQL is a service, like Exchange. Responds to network requests, sends data back and...

Please do not request, not ask for materials that are under NDA. To study for an exam, use public materials or books, but do not ask someone to get you...

My point is yours, it ought to be agreed to. Announce it's coming. Bringing them in when everyone has eaten, or not bringing them when you have been for weeks,...

The service has a series of options, depending on your OS, to run a command. You can use that.

Thanks for the update. Had me worried for a minute.

The only flash thing should be the ad at the top. Blocking it shouldn't affect the site.