This time, we will talk about the competition or alternatives to Azure SQL Data Warehouse.

The Opportunistic Hacker

by Steve Jones

SQLServerCentral.com

Editorial

Sometimes the crimes of opportunity might be the worst ones for our data.

Detecting Data Breaches

by Additional Articles

SimpleTalk

Security

Data breaches make the news on an almost daily basis. There is no turning back, however, as we are firmly entrenched in this digital way of life. Brian Kelley discusses some of the reasons data breaches occur and what we can do to prevent them.

Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

by Additional Articles

Microsoft MSDN

Performance

SQL Server 2014 introduces the first major redesign of the SQL Server Query Optimizer cardinality estimation process since version 7.0. The goal for the redesign was to improve accuracy, consistency and supportability of key areas within the cardinality estimation process, ultimately affecting average query execution plan quality and associated workload performance. This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query processor team, covering how to enable and disable the new cardinality estimator behavior, and showing how to troubleshoot plan-quality regressions if and when they occur.

Closer to the Heart

by Steve Jones

SQLServerCentral.com

Editorial

This week Steve Jones wonders where you would work if you had the chance.

Do you use DAX?

by Steve Jones

SQLServerCentral.com

Editorial

This week Steve talks about the Data Analysis Expressions language.

Enable FIPS 140-2 Compliance in SQL Server

by Jason Ash

SQLServerCentral.com

Security

What is FIPS? How do I use it? What is going to break if I do use it?

Power BI Introduction: Working with Power BI Desktop — Part 2

by Additional Articles

SimpleTalk

Power BI

Power BI Desktop is the free tool from Microsoft for developing in Power BI. In this article, Robert Sheldon walks you through importing and manipulating data with the Query Editor in Power BI Desktop.