What is Oracle 12c Unified Auditing? The short answer is the view UNIFED_AUDIT_TRAIL. This view consolidates all logging and auditing information into a single source.
Other News
Data inconsistencies on MySQL replicas: Beyond pt-table-checksum
(Stephane Combaudon) Percona Toolkit’s pt-table-checksum is a great tool to find data inconsistencies between a MySQL master and its replicas. However it is sometimes not enough to know that there are inconsistencies and let pt-table-sync fix the issue: you may want to know which exact rows are diff
Power Query Now Works With SSAS
(Chris Webb) I normally don’t bother blogging when one of the Power Query monthly updates gets released – the posts on the Power BI blog have all the details and there’s nothing more to add.
Buttons mysteriously resize on VS Tools Dynamics GP Forms — VST template bug?
(Steve Endow) Sometimes strange things happen when you are developing software that can be quite puzzling. A window may behave oddly, data may get updated in an unexpected way, or an application may crash. I tell myself that there is always an explanation, but sometimes these things may seem nearl
Set Operations Prevail
I was recently reminded of differences in performance for different SQL Server persistence techniques. I had a set of data that was generated by my application needing to be merged into an existing relational database consisting of 8 tables. A root table with three dependent tables. Each dependent table had a one or two dependent tables. Level 1-1 Level 2-1 […]
Troubleshooting Table with Failed Load (SQL0668N)
(Ember Crooks) I recently had a client with a table in an inconsistent state. Apparently a load failed, which is common enough, but they then tried to do a reorg, thinking that would solve it, so I first had to identify and force off connections causing a lock chain before solving the root problem.
Stop/Change <meta> Tag Refresh in .NET or Alternative Way to Refresh the Page using JavaScript
(Ankur Rawat) There is no appropriate solution to stop tag refresh attribute or change the time interval of refresh.
Parsing blocks stats blocks parsing
(Bobby Durrett) I had a five-minute conversation with Oracle development Friday that rocked my world. I found out that parsing blocks stats which blocks parsing.
MySQL Query Performance Statistics In The Performance Schema
(Baron Schwartz) We’ve recently added the ability to monitor MySQL query performance statistics from MySQL’s PERFORMANCE_SCHEMA, and there were a number of lessons learned. There are definitely right and wrong ways to do it.
Auto Fix SQL Server Transactional Replication Error 20598 for DELETEs
(Jeffery Yao) From time to time you may see replication error 20598 for DELETEs. This a pain to fix manually and we often do not want to resort to having to redo the snapshot or skip the error. In this tip I show how you can deal with this error.