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 2016 and Azure SQL Database both give you tables that automatically keep track of the history of your data. Here's how to retrieve that historical data. In an earlier column, I showed how ...

If you look at the challenges facing those charged with building platforms to power data-driven companies, we’ve made a lot of progress but vexing questions remain. One of the most important is how to ...