A developer shares 10 essential PostgreSQL features and tips for 2016, including CTEs, performance tuning, and configuration.
A detailed overview of key new features in PostgreSQL 9.5, including Upsert, grouping sets, and pg_rewind.
Explores how MongoDB's BI Connector pushes SQL WHERE clauses and projections down to the database as an aggregation pipeline for efficient querying.
A tutorial on using ODBC and SQL to query MongoDB data from a Linux command line, using the MongoDB BI Connector.
Guide on using MongoDB's BI Connector to access MongoDB data via SQL/ODBC from Windows tools like Excel, with a practical example using UK MOT test data.
A tutorial on using R's dbWriteTable function to efficiently write a data frame to a temporary SQL table for database queries.
Explains how to use SQL window functions and percentiles in Postgres for more meaningful data analysis than simple averages.
A first look at the new UPSERT feature in PostgreSQL 9.5, explaining its syntax and practical use cases for developers.
Explains how to instrument OBIEE database connections for detailed performance monitoring and diagnostics.
![Sessionizing Log Data Using dplyr [Follow-up]](https://alldevblogs.blob.core.windows.net/thumbs/article-29f99ec93e7c-full-62a10501.webp)
A technical tutorial on sessionizing log data using the dplyr package in R, comparing it to a previous SQL-based approach.
A technical guide on using SQL window functions to group discrete time-series events into user sessions for data analysis.
Tips for improving Drupal performance by optimizing database indexes and SQL queries, inspired by Doom's difficulty levels.
Discusses the importance of naming conventions and coding style for readability and productivity, with examples from SQL and C++.
A data engineer shares five practical lessons and performance tips for working with Apache Hive, focusing on common pitfalls and optimizations.
A historical account of Oracle's poor performance in a 1983 database benchmark and their alleged attempt to have the professor behind it fired.
A technical guide on using SQL window functions, specifically LAG, to calculate month-over-month revenue growth percentages for SaaS or recurring billing analysis.
Explains how to use PostgreSQL's CTEs (WITH clauses) to write more readable, composable, and maintainable SQL queries.
A guide to using SQL queries and a simple Ruby script to send personalized, data-driven emails to users, avoiding complex marketing tools.
A tutorial on using Apache Hive to create tables and views from data loaded into a Hadoop cluster, continuing a multi-part series.
Explains how to use PostgreSQL's COMMENT feature to document tables, columns, and SQL for better data understanding and maintenance.
