In my years as an Oracle and SQL Server DBA and the many technical environments I’ve worked in, there’s almost always one database in each place that is a hybrid of OLTP and OLAP. A highly transactional database that also has reporting requirements, but no separate reporting database. This type of database is pretty much a guaranteed challenge for any DBA. On one hand, [...]