There are several obvious problems with poor SQL Coding habits. It can make code difficult to maintain, or can confuse your team colleagues. It can make refactoring a chore or make testing difficult. The most serious problem is poor performance. You can write SQL that looks beautiful but performs sluggishly, or interferes with other threads. A busy database developer adopts good habits so as to avoid staring at execution plans. Rob Sheldon gives some examples.

Rewrite Your Code Tomorrow

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones notes that we often solve problems better the second time around.

Understanding Azure Data Factory – A Cloud Based Integration Service

by Additional Articles

Database Journal

Azure Data Factory

Azure Data Factory is a cloud based data integration service. This helps you to define, schedule and manage data pipelines to transfer and transform the data from disparate on premise and cloud data sources. Read on to learn more.

Azure DWH part 17: ADF:Import Data from SQL Server on-premises to ASDW

by Daniel Calbimonte

SQLServerCentral.com

Azure

In this article we will learn to use Data Factory to import table from SQL Server to Azure SQL Data Warehouse.

No More Service Packs

by Steve Jones

SQLServerCentral.com

Editorial

There won't be any more service packs for SQL Server after version 2016.

Data in Motion and Data at Rest

by Additional Articles

SimpleTalk

StreamInsight

Microsoft (StreamInsight), and Azure Stream Analytics represent a very different model for processing data. They are concerned with processing complex event streams of data (CEPs) from such things as sensors to deduce significant patterns and apply filters. Joe Celko discusses the background to an intriguing technology of complex event processing to establish the difference between data at rest, and data on the move.

Get-DbaPowerShell

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones talks PowerShell and how it is a skill that you might find useful.

The Worms-eye View

by Phil Factor

SQLServerCentral.com

Editorial

Even the most elaborate team-based development methodology won't compensate for the blinkered attitudes and tribal cultures that come from over-specialization in IT.

Should DBAs learn Linux?

by Additional Articles

Brent Ozar Blog

SQL Server on Linux

Brent Ozar looks at the similarities between SQL Server on Linux and SQL Server on Windows Core from back in 2012, and asks whether DBAs should bother learning it.

SQL Prompt Tip: how to control when the suggestion box pops up

by Additional Articles

Redgate

RedGate

By default, SQL Prompt shows code auto-completion suggestions automatically, and continuously. 90% of the time this is exactly what you want, but there are other times where you just need a bit of space - Phil Factor shows how.

The Basics of Good T-SQL Coding Style – Part 4: Performance

Rewrite Your Code Tomorrow

Understanding Azure Data Factory – A Cloud Based Integration Service

Azure DWH part 17: ADF:Import Data from SQL Server on-premises to ASDW

No More Service Packs

Data in Motion and Data at Rest

Get-DbaPowerShell

The Worms-eye View

Should DBAs learn Linux?

SQL Prompt Tip: how to control when the suggestion box pops up

Blogs

Redgate and Rome

Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database

PowerShell Newbie – Variables

Forums

SSRS Is Dead. Here Are Your Real Options

The Distance Metric

The New Wave of Security Threats

Question of the Day

The Distance Metric