This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.

Visualizing Data

by Steve Jones

SQLServerCentral.com

Editorial

This week Steve Jones talks about data visualizations, and the opportunities that exist for data professionals.

Why DevOps? Employee Satisfaction

by Steve Jones

SQLServerCentral.com

Editorial

Another reason why a DevOps process is a good idea.

Using Power BI in a Hybrid Environment

by Additional Articles

Microsoft MSDN

Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores. This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources.

Using Trace Flags

by Steve Jones

SQLServerCentral.com

Editorial

Do many of you use trace flags? Steve Jones wonders today.

Windowing Functions: Tell me when that changes

by Michael Morin

SQLServerCentral.com

windows functions

Windowing functions aren't just for analyzing numbers/dates. Using windows functions to analyze when a character field changes is a little know resource

SQL Server Bulk Insert Row Terminator Issues

by Additional Articles

MSSQLTips.com

bulk insert

We often need to import data into SQL Server from a file. Sometimes unwanted end of line characters are part of the source file and these can create issues when importing the data. One of the ways to avoid this issue is to use SQL Server Integration Services (SSIS), but it doesn't always make sense to use SSIS for simple operations. Rahul Mehta explains that he uses BULK INSERT sometimes faces issues with Line Feeds and Carriage Returns. In this post, Rahul shows some examples and explains how to fix the issue.