Announcing a full-day SQL workshop on optimizing data warehouses using Columnstore Indexes, from basics to advanced tuning, at SQLSaturday Madrid 2018.
A personal reflection on the author's 5-year journey writing a blog series about SQL Server Columnstore Indexes, from initial posts to becoming an expert.
Argues against using Oracle's automatic optimizer statistics collection in data warehouses, advocating for manual stats management as part of ETL processes.
A technical deep-dive into making Partition Change Tracking (PCT) refresh with partition truncation work correctly for Materialized Views in Oracle 11g.
Explains Oracle 11g's incremental global statistics for partitioned data warehouses, covering benefits and a major storage overhead issue.
Analysis of a now-removed blog post containing performance results from an Oracle Exadata V2 proof-of-concept test.
![ORA-12537 / ORA-12518 [Informatica DAC error CMN_1022]](https://alldevblogs.blob.core.windows.net/thumbs/article-ca653caba3fd-full-fd775a3b.webp)
Troubleshooting ORA-12537 and ORA-12518 errors in an Informatica DAC environment, focusing on database connectivity issues.
