Tag Archives: sql server

Database Maintenance Essentials

Posted on November 4, 2012 by way0utwest

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 maintenance operations that should be performed … Continue reading →

Posted in Presentations | Tagged , , | 1 Comment

Searching Binary Data in SQL Server

Posted on November 1, 2012 by way0utwest

More and more data collected in organizations is in an encoded format, essentially a binary classification of data. These can be images, audio files, video, or even common formats like Word and Excel files. This data contains lots of important … Continue reading →

Posted in Presentations | Tagged , , | Comments Off on Searching Binary Data in SQL Server

DBA Support

Posted on October 26, 2012 by way0utwest

There was a time when I managed two production databases on SQL Server. Two. I had a development version of one database where we paused development for testing, and only two production databases to manage. Since I had to also … Continue reading →

Posted in Editorial | Tagged , | 1 Comment

Two Steps Ahead

Posted on October 25, 2012 by way0utwest

  Exceptional DBAs do more than respond to events and issues in their environments. In many cases, I think they even go beyond using metrics that detect problematic activity on their systems before users notify them. I think the best DBAs … Continue reading →

Posted in Uncategorized | Tagged , | Comments Off on Two Steps Ahead