Tag Archives: sql server

Recovering a Database

Posted on July 6, 2011 by way0utwest

So you’re restored a database, restored a few logs, all with NORECOVERY as expected and realize there are no more logs. You see this in Management Studio and wonder what do to: I’ve run a bunch of code, restoring lots … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Recovering a Database

The Top Ten Skills You Need

Posted on July 1, 2011 by way0utwest

One of the things I’ve found is that so many people struggle to get started with SQL Server. There are regular questions about how to learn to work with SQL Server, so I built this quick talk that should help … Continue reading →

Posted in Blog | Tagged , , , | 5 Comments

The difference between REVOKE and DENY

Posted on June 30, 2011 by way0utwest

There was confusion recently with a poster that was moving permissions around and asked why I said they should revoke permissions and not deny them. I decided this was worth a post to explain. If I GRANT SELECT (or UPDATE/INSERT/DELETE) … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on The difference between REVOKE and DENY

New Connect Item – TDE

Posted on June 29, 2011 by way0utwest

Does the certificate matter for TDE? Apparently not as I found a number of people discussing the fact that the expiration date for certificates is not checked for TDE restores. So if your certificate expires, you can still restore the … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on New Connect Item – TDE