Things break and the DBA must be prepared for situations where a failure impacts the availability, integrity, or usability of a database. Reacting to failures and service disruptions is a key ...

There are many ways to describe a database: the role it plays in a distributed architecture, the various internal components that make it work, and the various levels that define specific roles and ...

There is perhaps no area within database administration more time-consuming or fraught with difficulty as the need to accurately shepherd the varied and ongoing vectors of change across an ...

Data is a thorny subject. For a start, we’re not sure how we are supposed to refer to it, that is - data is the plural of datum. Strictly speaking we should talk about data that ‘are’ not ‘is’ ...

Data is one of the most valuable assets for any organization, and the risk of that data being tampered with, stolen or deleted is a fundamental fear. Over the past decade, we've seen an increase in ...

A data dictionary is like a bill of materials for a database; it lists all database components, including reports, tables, field names and field types. Such information helps audit databases for ...

SQL Server database corruption is troublesome for DBAs, particularly if the situation arrives suddenly and there is no backup. This situation can lead to prolonged downtime and permanent data loss in ...