The vast swathes of unstructured data that now reside in the cloud has changed the nature of information technology in many ways. One of the more significant is that it has led to the widespread use ...

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 ...

The end goal of database design is to be able to transform a logical data model into an actual physical database. A logical data model is required before you can even begin to design a physical ...

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 ...

Whenever you use PowerShell, whether it is querying data or making a change to some configuration or existing object, you are working with different types of objects. You may not be aware of it ...