Redgate has added new capabilities to the Deployment Suite for Oracle, so it now supports automated migrations-based and state-based Oracle deployments on both Linux and Windows. They've introduced Redgate Change Control, a new capability for understanding development changes, generating migration scripts for version control, and getting precise control over the migration path during automated deployments. Our Schema Compare and Data Compare for Oracle command line tools have been extended to Linux as well as Windows, and we’ve added static code analysis that encourages teams to follow good coding practices on Windows or Linux.

Staying Safe when Traveling

by Grant Fritchey

SQLServerCentral

Professional Development

Today, Grant talks about keeping your laptop and phone safe while traveling.

Custom Deployments from Source Control using SQL Compare Command line

by Additional Articles

Redgate

Giorgi Abashidze explains how his team use a 2-phase deployment process with SQL Compare Command line, and some SQL Synonyms, to automate custom deployments for each of their customers, while only needing to maintain one branch per release in source control.

Load Time Series Data with SQL Server

by Additional Articles

MSSQLTips.com

MS Azure

In this article we look at how to load time series data into SQL Server both for an initial load as well as adding new data.

Calculate Moving Averages using T-SQL in SQL Server

by Archana

SQLServerCentral

Introduction In Financial Data, analyzing the Moving Average (MA) is a very common practice. The direction of the moving average conveys important information about prices, whether that average is simple or exponential. A rising moving average shows that prices are generally increasing. A falling moving average indicates that prices, on average, are falling. This article […]

How to Get Started with Version Control for Databases

by Kendra Little

SQLServerCentral

DevOps and Continuous Delivery (CI/CD)

Today, Kendra talks about why version control for databases is important and how to get started.

Building SQL Server Indexes in Ascending vs Descending Order

by Additional Articles

MSSQLTips.com

Indexes

In this tip we look at the impact of building SQL Server indexes in ascending versus descending order and the impact.

Static data in SQL Change Automation SSMS plugin

by Additional Articles

Redgate

SQL Change Automation

Kendra Little sat down with the SQL Change Automation Dev Team to get some insight into how they build the product with the customers in mind. SQL Change Automation 4.1 included adding support for the tracking of static data tables to the SSMS extension. This was a direct result of the communication and work the team have carried out with their customer base. Read Kendra’s blog to find out more about the release and the work that goes into delivering these updates.

Analysis Services : OLEDB Error while processing in SSAS

by aveek22

SQLServerCentral

Problem This is one of the errors that I frequently encounter while deploying or processing SSAS OLAP cubes on the client's computers or on a remote server. Recently, one of my team members also faced the same issue and so I thought to write a resolution for the issue. The error is something like this: […]

Rock and Roll

by Grant Fritchey

SQLServerCentral

Compliance

Today, Grant Fritchey talks about discussing compliance with management.

Updates to the Deployment Suite for Oracle

Staying Safe when Traveling

Custom Deployments from Source Control using SQL Compare Command line

Load Time Series Data with SQL Server

Calculate Moving Averages using T-SQL in SQL Server

How to Get Started with Version Control for Databases

Building SQL Server Indexes in Ascending vs Descending Order

Static data in SQL Change Automation SSMS plugin

Analysis Services : OLEDB Error while processing in SSAS

Rock and Roll

Blogs

Rolling Back a Broken Release

A bespoke reporting solution doesn’t have to cost the earth

Presenting with Visual Studio Code

Forums

Lots of FKs

Real-time On-prem SQL Server Data in Excel – Over the Internet

Can You Let Go of Determinism

Question of the Day

Lots of FKs