Category Archives: Presentations

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

Database Maintenance Essentials

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

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

Getting Control of Your Instances with Policy Based Management

Managing lots of database or instances in an efficient manner requires a DBA to find automated ways to ensure their databases are configured correctly. In SQL Server 2008, Policy Based Management (PBM) was introduced to help DBAs implement a framework … Continue reading

Posted in Presentations | Tagged , | Comments Off on Getting Control of Your Instances with Policy Based Management