Tag Archives: administration

Dropping Indexes

While working on some demos recently, I needed to drop an index for a test. I executed this generic statement for an index I’d just created. 1: DROP INDEX ix_IndexName Needless to say I was surprised when I got this … Continue reading

Posted in Blog | Tagged , , , | 3 Comments

Attaching an MDF with no Log (AdventureWorks)

Attaching an MDF file without an LDF file can be a little tricky. I had to go through this recently when I downloaded the AdventureWorks2008R2 database, which was just an MDF file. I know I’ve done this before, but I … Continue reading

Posted in Blog | Tagged , , | 1 Comment

The Dark Side

Recently I was invited to speak at the Rocky Mountain Oracle Training Days. It was part of some cross platform talks that have happened in Denver, with some Oracle professionals coming to our last SQL Saturday in Denver. I was … Continue reading

Posted in Editorial | Tagged , | Comments Off on The Dark Side

Database Maintenance Essentials – Oracle Training Days

Presented at Oracle Training Days, 2013 Abstract: SQL Server requires a minimal level of maintenance to ensure that the platform functions at an optimum level without any unnecessary outages or problems. This talk will look at the basics of the … Continue reading

Posted in Presentations | Tagged , , | Comments Off on Database Maintenance Essentials – Oracle Training Days