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.

Scaling Deployment

by Steve Jones

SQLServerCentral

DevOps and Continuous Delivery (CI/CD)

This week there was an interesting article on DevOps and Ancestry.com's DevOps process. They are a fairly large enterprise, with 70+ teams that need to deploy code on a regular basis. As they've grown, there was some concern over each team learning how to best build their software pipeline. While they shared knowledge with each […]

Hopes for vNext

by Steve Jones

SQLServerCentral

SQL Server

This week Steve is asking for your suggestions for the next version of SQL Server.

The NoSQL Misdirections

by MVDBA (Mike Vessey)

SQLServerCentral

NoSQL / NewSQL

Editorial Note: This is a republish, in memory of Mike who passed away too soon. You can see his memorial at sqlmemorial.org. Recently I have been working with a colleague who is doing a bit of a side projects outside of work. He's trying to expand his skillset using a pet project at home. I encouraged […]

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.

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.

An Introduction To Kusto Query Language (KQL)

by Sucharita Das

SQLServerCentral

Introduction In my last article, An Introduction to Azure Data Explorer, I discussed the process of creating and using Azure Data Explorer. Azure Data Explorer is mainly used for storing and running interactive analytics on Big Data. First, I need to create the ADX cluster. Then, one or more databases should be created inside the […]

Back to Basics, Reaching for the Clouds, and Leveling Up

by Steve Jones

SQLServerCentral

The three themes for speakers at this year's PASS Data Community Summit are: Back to Basics, Reach for the Clouds, and Level Up. The goal here is content that covers a wide variety of areas, with many fewer restrictions from previous years. Perhaps the big thing to note for this year's event is: Free. That's […]

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.

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.

Redgate Streamed: Embracing technology trends for database success

Scaling Deployment

Hopes for vNext

The NoSQL Misdirections

The changing landscape of continuous database integration

Using Delta Schema Evolution in Azure Databricks

An Introduction To Kusto Query Language (KQL)

Back to Basics, Reaching for the Clouds, and Leveling Up

CTE in SQL Server Examples

The future of Database DevOps

Blogs

A New Word: on tenderhooks

Ramblings about data communities and your contributions, no excuses

SQL Server Journey till 2025 (brief)

Forums

Ola Hallengren Index Optimize Maintenance can we have data compression = page

how do i map the "current" object entry in for each to one variable

Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)

Question of the Day

String Similarity I