InfoQ Homepage SQL Content on InfoQ

Articles

RSS Feed

Newer Older

AI, ML & Data Engineering

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.

Deepak Vohra
on Sep 07, 2022
AI, ML & Data Engineering

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.

Jon Udell
on Jul 06, 2022
Cloud

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.

Lena Hall
on May 29, 2021
Culture & Methods

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.

Ben Linders Peter Yaworski
on Oct 14, 2019
Web Development

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.

Deepak Vohra
on Apr 28, 2019
DevOps

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.

Jonathan Allen
on Nov 12, 2018
DevOps

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.

Steve Mushero
on Apr 27, 2018
Cloud

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.

Paul Stanton
on Sep 08, 2016
AI, ML & Data Engineering

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.

Aleksandr Shavlyuga
on Oct 11, 2015
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.

Jonathan Allen
on Nov 04, 2014
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.

Sytze Harkema
on Oct 23, 2014
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.

David Atkinson
on Oct 01, 2014