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

The heart of any relational database management system is the system catalog that documents the database objects and system settings being used. The system catalog offers a wealth of information about ...

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

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.

With the upcoming release of SQL Server 2014 (SQL2014), Microsoft is making advancements in the area of mission-critical performance. Microsoft wants to stake out this ground not only as performance ...

Have data sets scattered all over the place? Here's how to pull them into a single, robust catalog with the pointblank R package and a Quarto document. Do you have data sets scattered all over the ...

If your business uses Microsoft's Access database software to manage sensitive data, you'll want to encrypt your database and its tables to prevent them being viewed or manipulated by unauthorized ...

From immutable ledgers in SQL Azure to in-memory cache in Cosmos DB, Microsoft is adding more features to its Azure data platform. If you’re building cloud-native applications you need a reliable, ...

Right now, the City of Chicago is working on documenting all of its data. That’s right: all of Chicago’s public data, across all databases, in all its departments and sister agencies. The project, ...