Documenting a legacy database is what I call "database cartography". Sometimes it's just built in a piecemeal fashion over time based on exploration and local folklore passed down from gray...

Database modeling tools can be expensive, complicated, and despite all their bells and whistles, are ultimately rigid. There have been situations where I have questioned why a database was designed...

So, it's one thing to talk about data privacy in terms of how it impacts the lives regular folks in "flyover country". Ask any politician and they'll acknowledge it's an...

I recently got added to the company's PluralSight subscription and have found the content and presentation to be quite good. It helps when your employer is forthcoming about their future plans...

If user Smith Rice can query and update tables at will, then they are totally awesome. Best thing to do in this situation is hunker down and hope they don't...

Query Store is to query performance metrics what Service Broker is to message queuing; it's just a standardized, optimized, and extensible way of doing something that many of us have...

I enabled Query Store on a 3 TB sized database that is bulk loaded nightly. During the day it receives a fairly high volume of queries (ie: 100 per second)...

If the job basically involves assisting end users with data entry and querying using the front office application GUI (not back office ETL programming or data analysis) then I'd call...

An administrative assistant who specializes in performing basic data querying tasks for an executive would probably be soon displaced by {Alexa, Cortana, Echo, Watson}. It still sounds like a job...

It's entirely possible the DBA can't help much when it comes to understanding the logical model of the database, especially if it's part of a 3rd party vendor application, because...

...Perhaps we need data scribes in more industries. Not a single employee dedicated to one person, but a specialist in the gathering and cleaning of data, preparing it in...