Announcement of the Spanish translation of 'SQL Performance Explained' with updates for latest database releases and a refreshed SQL indexing quiz.
Summary of major database trends in Fall 2017, including SQL's resurgence, cloud pricing wars, IBM's renaming controversy, and new releases.
A practical guide outlining essential tools, skills, and practice methods for beginners to start a career in data science.
Explores the various uses of the DISTINCT keyword in PostgreSQL, including DISTINCT ON, with practical SQL examples.
Explores Oracle 12.2's new Property Graph feature for graph analysis within the database, using a practical setup guide.
A tutorial on using Apache Drill to query and analyze JSON files with SQL, using blog analytics as a practical example.
An overview of Postgres Foreign Data Wrappers (FDWs), explaining how to connect and query external data sources directly from PostgreSQL.
A technical guide on configuring Apache Drill's ODBC driver to connect with Oracle Business Intelligence Enterprise Edition (OBIEE) 12c on a Linux environment.
A technical guide on using Google BigQuery to analyze GitHub pull request data, including SQL queries for repository statistics.
Tips and best practices for writing clean, readable, and maintainable SQL code, including formatting, CTEs, and commenting.
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.
