The May 2009 TechNet Magazine is now available online, and it's the annual security issue. In there is an article I wrote highlighting 10 common security issues (and solutions) you should worry about if you're not a security-savvy DBA. It covers: Physical security Network security Attach surface minimzation Service accounts Restricting use of administrator privileges [...]
Paul S. Randal
In Recovery...
TechNet Magazine: feature article on Common SQL Server Security Issues and Solutions
Posted on: April 3, 2009 7:35 am
SQL Server 2008: Does my database contain Enterprise-only features?
Posted on: August 23, 2008 4:06 pm
Moving databases around is pretty common, as is moving databases between servers running different Editions of SQL Server, especially during a disaster recovery situation. You may not know this, but in SQL Server 2005, if you had partitioning anywhere in a database, you could only attach/restore that database using an Enterprise or Developer instance. I [...]
Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials
Posted on: March 12, 2008 5:23 pm
A couple of weeks ago I blogged about the three tracks of the SQL Server 2008 JumpStart course that SQLskills.com taught internally for Microsoft and some MVPs – see here for details. Well, the content is now available to download! Note that this was based on CTP-5 (November 2007 CTP) and there have been *lots* [...]
TechNet Radio interview with Paul and Kimberly on SQL Server 2008 – Part 1
Posted on: March 5, 2008 2:31 am
Wow – almost 10 days without a blog post – that must be a record for me! :-) Never fear – I'll be posting more over the next couple of weeks. Kimberly flew off to India yesterday to teach some Microsoft classes and unfortunately I couldn't join her this time as I'm teaching 3 classes [...]
SQL Server 2008 JumpStart
Posted on: February 15, 2008 12:38 am
Phew – last week Kimberly and I spent 3 days teaching the ins-and-outs of SQL Server 2008 for DBAs/IT-Pros to about 130 Microsoft SQL Server experts and MVPs (like Kalen Delaney, Adam Machanic and Ron Talmage). This was the (95% complete) Beta delivery of a course we’ve been developing for the last six months for Microsoft [...]
Paul and Kimberly interview on RunAs Radio – What’s New in SQL Server 2008?
Posted on: December 12, 2007 6:07 pm
While we were in Barcelona we sat down with Richard Campbell and Greg Hughes from RunAs Radio to record a 1/2 hour interview on SQL Server 2008. We touch on a ton of different features (look at the number of Categories I’ve tagged this with!) and have a bunch of laughs along the way – [...]
