Category Archives: SQLServerPedia Syndication

Content automatically syndicated to SQLServerPedia

Book Review – “SQL Server Transaction Log Management” by Tony Davis and Gail Shaw

Posted on May 21, 2013 by

A couple of questions and comments on the Ask.SQLServerCentral.com website have shown some misunderstanding about the use of SQL Server’s Transaction Log files. At about the same time, I was approached by Red Gate as part of their Friends programme … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , , , , , , , | 1 Comment

RESTORE failure – error 3633… ‘DeleteTree’ … ‘fulltext.cpp’

Posted on April 5, 2013 by

Here’s a little bit of the pain that I’m facing today. I was trying a SQL Server RESTORE (using Quest’s Litespeed for SQL Server) of one of our databases, one that has a fulltext index. The restore was consistently failing … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , , | Leave a comment

VirtualBox, Windows Server 2012, BSODs

Posted on March 14, 2013 by

Those of you who are following me on Twitter may have noticed I’ve had a few BSODs (Blue Screens Of Death) during my recent fiddlings with Windows Server 2012 (both Core & GUI versions) under VirtualBox. Kevin Chant (@kevchant) mentioned … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | Leave a comment

Windows Server 2012 Core – Server Configuration, Add/Remove Features, SysPrep

Posted on March 14, 2013 by

Recently, I started building a Windows 2008 R2 / SQL 2008 R2 environment as per Jonathan Kehayias’s (blog|@SQLPoolBoy) series of articles on “Building A Free Test Environment“, I found myself wondering about doing similar in Windows 2012, specifically in Windows … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | Leave a comment

Wrangling Conference Speakers

Posted on March 12, 2013 by

No, not PA systems, but people. As you may recall, I was the speaker liaison for SQL Saturday 194, being hosted by those lovely SQL South West people. Things went pretty smoothly; however, I do have a few observations on … Continue reading →

Posted in SQLServerPedia Syndication | Tagged | Leave a comment

Restoring into a different environment? Security problem? Orphaned Users

Posted on February 22, 2013 by

Oh, man, it’s been a fun ten days or so. Mostly not of my doing, thankfully. However, one thing that was definitely down to me was a minor little hiccup with SQL Server security. Y’see, when you RESTORE a database … Continue reading →

Posted in SQLServerPedia Syndication | Leave a comment

SQL Saturday 194 Exeter Pre-Con – PowerShell 3.0 for SQL Server Administrators and Developers

Posted on February 21, 2013 by

OK, Yes, it’s (yet) another post pimping a SQL Saturday 194 Exeter Pre-Con session. This time, André Kamman (blog|twitter)and his day of PowerShell. I’ve seen André perform at a SQLBits conference, where he gave a session “RoboDBA” about PowerShell, and … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | Leave a comment

SQL Saturday 194 Exeter Pre-Con – T-SQL and Internals

Posted on February 18, 2013 by

OK, Yes, it’s another post pimping a SQL Saturday 194 Exeter Pre-Con session. This time, a quick look at the Two Daves and their session on T-SQL and Internals. Now, I’ve not had the pleasure of attending a full day … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | Leave a comment

SQL Saturday Pre-Con – Mission-Critical Data Platforms on Windows Server 2012

Posted on February 7, 2013 by

OK, my homework for SQL Saturday #194 (Exeter) has slowed somewhat. However, I would like to say a few words about this particular Pre-Con. Christian Bolton & Gavin Payne are just two of the really high-powered consultancy Coeo, a very … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | Leave a comment

Bulk Restores – response to a question on Ask SQLServerCentral

Posted on January 24, 2013 by

Here’s the scenario: You’re rebuilding a DR environment, and have a set of Full, Differential and transaction log backups to restore. How to script this to run with minimal interference? The Approach Assumptions: All your backups are in subdirectories named … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | Leave a comment