Learn how to use the PIVOT operator in SQL in a step-by-step manner.

Pulling the Plug

by Steve Jones

SQLServerCentral.com

Editorial

Steve talks about when you might stop investing in old technology and replace it.

Efficient Solutions to Gaps and Islands Challenges

by Additional Articles

SimpleTalk

T-SQL

Window functions are useful for solving many SQL queries. In this article, Ed Pollack demonstrates how they can be used to analyse baseball winning streaks.

Updates to the Deployment Suite for Oracle

by Additional Articles

Redgate

Oracle

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 […]