Transactions and transaction playback, log shipping, are not the same as a backup, a page-by-page copy of the database. The processes of restore are different. The at rest copy of...

Pretty much what Luis said. It's entirely possible to learn about 6 months worth of DBA knowledge and then repeat those 6 months for 10 years. I've interviewed a lot...

I am absolutely anti-certification. However, that said, if you're going for the certification, I would not recommend getting the 2008 cert. Go for the 2014 cert or wait for the...

VPlex I believe copies stuff at the page level? If so, yeah, it's likely to replicate corruption.

Log shipping (or, since we're in the 2014 group, Availability Groups, a much better...

Is recovery full? If so, as much as I dislike this, change it to simple. If you're dumping the logs you can't do a full recovery anyway. Might as well...

You do know that NOLOCK leads to extra or missing rows if you're experiencing scans, right?

You're getting inconsistent behavior because you're not providing the schema. That's the right way to do things. It might mean you need to go back and edit your code, but...

The best way is to restore the database, but there are some other checks you can run. I have an article that lays it all out here[/url].

I'd just go over to Red-gate.com and get a copy of SQL Search[/url]. It's a free tool and will do pretty much any kind of search you need against your...

Not really. Something is up at the TFS level. It should lock the ability of more than one person to check out a given file. It won't affect what you...

Well, it's still going to work on the files locally, but they should be locked from others working on it. You won't be saving directly to the server.

Ah, so using SQL Server Data Tools to do the database? You should still be able to check out exclusive through Visual Studio. It's just how you do the checkout...

What tool are you using to perform the checkouts?

There are the PASS Virtual Chapters. They cover topics other than SQL Server. After that, for non-Data Platform stuff, I'd suggest searching through meetup[/url].

SQL Saturday, already linked, is one great resource to expand your learning. If you're trying to track down a local user group, I recommend searching through the Chapters list at...