InfoQ Homepage SQL Content on InfoQ
-
/articles/oracle-to-mysql-aws-database-migration-service/en/smallimage/logo-1662492103321.jpg)
How to Migrate an Oracle Database to MySQL Using AWS Database Migration Service
Data migration efforts are typically taken up for database consolidation, cost considerations, or migrating on-prem databases to a cloud platform. In this article, author Deepak Vohra discusses the details of migrating a local database to MySQL database on the cloud, using AWS Database Migration Service.
-
/articles/steampipe-api-sql/en/smallimage/logo-1656952403557.jpg)
API Friction Complicates Hunting for Cloud Vulnerabilities. SQL Makes it Simple
APIs can tell you everything about your cloud infrastructure, but they're hard to use and work in different ways. What if you could write simple SQL queries that call APIs for you and put results into a database? Steampipe, an open-source project that maps APIs to Postgres foreign tables, makes that dream come true. It's hard enough to reason over data. Acquiring it should be easy, and now it is.
-
/articles/azure-synapse-analytics-service/en/smallimage/evolution-of-azure-synapse-small-1622106447915.jpg)
Evolution of Azure Synapse: Apache Spark 3.0, GPU Acceleration, Delta Lake, Dataverse Support
At Microsoft Build 2021, Azure Synapse has announced significant improvements for its Apache Spark pool, its performance, and data querying and integration capabilities. This article outlines the improvements and provides the context.
-
/articles/book-review-bug-hunting/en/smallimage/real-world-bug-hunting-qa-1570538890072.jpg)
Q&A on the Book Real-World Bug Hunting
The book Real-World Bug Hunting by Peter Yaworski is a field guide to finding software vulnerabilities. It explains what ethical hacking is, explores common vulnerability types, explains how to find them, and provides suggestions for reporting bugs while getting paid for doing so.
-
/articles/typescript-mysql/en/smallimage/typescript-mysql-s-1556297412283.jpeg)
Using TypeScript with the MySQL Database
TypeScript has emerged as a powerful environment for authoring web applications, providing significant improvements over standard JavaScript while remaining consistent with the language. In this article we'll explore in depth the details necessary to use TypeScript with Node.js, MySQL, and TypeORM to create a powerful solution for managing database access with server-side TypeScript.
-
/articles/DevOps-Databases/en/smallimage/DevOps-Databases-s-1541670287515.jpeg)
How to Source Control Your Databases for DevOps
A robust DevOps environment requires having continuous integration for every component of the system. But far too often, the database is omitted from the equation. In this article, we discuss the unique aspects of databases, both relational and NoSQL, in a successful continuous integration environment.
-
/articles/monitoring-SRE-golden-signals/en/smallimage/logo-8-1524683952703.jpeg)
Monitoring SRE's Golden Signals
Golden signals are increasingly popular these days due to the rise of SRE. This article outlines what golden signals are, and how to monitor and use them in the context of various common services.
-
/articles/sql-server-containers/en/smallimage/stanton-logo.jpg)
Introduction to SQL Server Containers
Containers are just around the corner for the Windows community, and this article takes a closer look at using SQL Server containers. The author discusses the value, use cases, and means for taking advantage of SQL Server containers today.
-
/articles/SQL-Server-ColumnStore/en/smallimage/big-data-logo.jpg)
Big Data Solutions with MS SQL ColumnStore Index
Columnar data storage can offer significant performance improvements over the way database tables are traditionally stored, but they aren’t always faster. Aleksandr Shavlyuga explores the power, and limitations of SQL Server’s ColumnStore Indexes.
-
/articles/SSDT-Intro/en/smallimage/logo2.jpg)
SQL Server Source Control and Deployment with Visual Studio
The holy grail of database development is the ability to treat database objects (tables, views, stored procedures, etc.) as if they were just like any other form of source code. While SQL Server Data Tools doesn’t quite that level, it gets very close.
-
/articles/map-sql-nosql/en/smallimage/image_sql-nosql-arrow.jpg)
How to Effectively Map SQL Data to a NoSQL Store
Sytze Harkema explains how to save and retrieve relational SQL data into a NoSQL key-value store as implemented by FoundationDB, an open source, scalable, fault tolerant and ACID database.
-
/articles/Red-Gate-SQL-Source-Control/en/smallimage/logo2.jpg)
Introduction to Red Gate’s SQL Source Control
It’s unthinkable for modern application developers to work without source control. The benefits it brings to software development are so well and so long understood that even lone hobbyist developers will tend to employ a source control system. Yet somehow, databases are often left out. David Atkinson shows how this doesn’t have to be the case with Red Gate’s SQL Source Control.