Additional Articles

Redgate Streamed: Embracing technology trends for database success

by Additional Articles

Redgate

Conferences, Classes, Events, and Webinars

Innovating in the database is crucial for success, and we’re seeing new trends impact the database, like cloud migration, SRE, and the growing need for big data and tools to support growing estates. On 23 June, Redgate Streamed brings you organizations who have implemented these database technology trends, including speakers from Google, Microsoft, and AWS, who will share their success stories and tips for embracing technology changes.

2021-06-07

The changing landscape of continuous database integration

by Additional Articles

Redgate

Vendors/3rd-party Products

Considering introducing continuous database integration? Learn the principles in this ThoughtWorks webinar hosted by Pramod Sadalage, expert in this discipline and author of several books about database refactoring and development.

2021-06-04

Using Delta Schema Evolution in Azure Databricks

by Additional Articles

MSSQLTips.com

Azure

In this article we explore schema evolution capabilities and limitations in Databricks with regular parquet format and explore schema evolution features and capabilities through delta format with inserts, appends, and overwrites.

2021-06-04

CTE in SQL Server Examples

by Additional Articles

MSSQLTips.com

In this article we cover what a Common Table Expression CTE is and how to write a CTE for doing selects, inserts, deletes, updates and more.

2021-06-02

The future of Database DevOps

by Additional Articles

Redgate

Vendors/3rd-party Products

Director at ThoughtWorks Pramod Sadalage explores trends such as rapid digital transformation and an ever-changing tech landscape, that'll change the way we work with databases and DevOps in the next 20 years.

2021-06-02

Managing Database Documentation during Flyway-based Development

by Additional Articles

Redgate

Vendors/3rd-party Products

How to create and maintain a 'data dictionary' for your databases, in JSON format, which you can then use to add and update the table descriptions, whenever you build a new version using Flyway.

2021-05-31

Oracle Sequences: RAC

by Additional Articles

SimpleTalk

Oracle

Using sequences when scaling up with Oracle RAC presents more issues with contention. In this article, Jonathan Lewis explains how to avoid the problems.

2021-05-31

Constraints and declarative referential integrity

by Additional Articles

SimpleTalk

Design and Theory

Database systems have powerful features built right in that can ensure the integrity of data. In this article, Joe Celko discusses keys and constraints.

2021-05-28

Introducing the PASS Data Community SUMMIT

by Additional Articles

Redgate

Conferences, Classes, Events, and Webinars

Join the world’s largest gathering of data professionals at this year’s free online PASS Data Community SUMMIT. Connect and network with 1000s of your peers and learn from some of the brightest minds in the data industry. This year’s must-attend online event is completely free, so sign up now to be notified when registration opens.

2021-05-28