We all have different levels of skills, and it's not always because we don't try. Sometimes it's a question of timing.

Loading Non Duplicated Data Using SSIS

by Rahul Gupta

SQLServerCentral.com

Integration Services (SSIS)

Learn how you can easily load data from a file that isn't duplicated, discarding those rows that are.

SQL Server v.Next : STRING_AGG Performance, Part 2

by Additional Articles

SQLPerformance.com

STRING_AG

Aaron Bertrand starts digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.

Azure SQL Data Warehouse with PowerShell

by Daniel Calbimonte

SQLServerCentral.com

Azure

We will teach how to create a new SQL Azure Data Warehouse using Powershell

The vNext Bleeding Edge

by Steve Jones

SQLServerCentral.com

Editorial

Microsoft has a new early access program for SQL Server.

DevOps and Database Lifecycle Management

by Additional Articles

SimpleTalk

DevOps and Continuous Delivery (CI/CD)

Database Lifecycle Management (DLM) aims to provide a roadmap of what is required, and when, to deliver and maintain effective databases that can respond quickly to business change. How...

The Elusive Conditional WHERE Clause

by John Hick

SQLServerCentral.com

T-SQL

What's this, a conditional WHERE clause that doesn't use dynamic SQL?

Hyper-V and PowerShell: The Basics

by Additional Articles

SimpleTalk

Hyper-V

Because it is important with maintaining Virtual Machine environments to be able to repeat routine tasks completely accurately, Windows PowerShell has grown in importance for the job. Now you can manage the Hyper-V environment via PowerShell without needing to use the Hyper-V Manager console. It opens up many opportunities for automation.