How to move a log shipping database to a new monitor server without removing and rebuilding the log shipping setup.

Bad Cardinality Estimates from SSMS Plans – Redux

by Additional Articles

SQLPerformance.com

Cardinality Estimates

Aaron Bertrand shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.

New MySQL Engine Supports T-SQL

by Press Release

SQLServerCentral.com

MySQL

MySQL has a new query processor that will run your T-SQL code.

SnowCrash for SQL Server

by Steve Jones

SQLServerCentral.com

Editorial

A new idea for managing your future SQL Servers.

The Database Transaction Unit (DTU) Decoded

by Steve Jones

SQLServerCentral.com

Editorial

In an Azure SQL Database, you pay for a certain number of DTUs, but what are these? Steve Jones explains.

If SQL Server Runs on Linux, What's Left for April Fools Day

by Andy Warren

SQLServerCentral.com

humor

It’s still a bit hard to believe that SQL Server will soon run on Linux. If you think back to the early days of SQL 7, 2000, even 2005, who would have bet any money on it ever happening?

Relational Algebra and its implications for NoSQL databases

by Additional Articles

SimpleTalk

Relational Algebra

With the rise of NoSQL databases that are exploiting aspects of SQL for querying, and are embracing full transactionality, is there a danger of the data-document model's hierarchical nature causing a fundamental conflict with relational theory? We asked our relational expert, Hugh Bin-Haad to expound a difficult area for database theorists.

Examining SQL Server 2016

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones wonders if any of you are looking at the next version of our platform, SQL Server 2016.

Creating a Date Dimension in a Tabular Model

by Additional Articles

SimpleTalk

Tabular Model

As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either runs in-memory or in DirectQuery mode. The in-memory analytics engine allows the users of Excel or Power View to base reports on tabular model objects. Having shown how to handle date-based information using the Multi-dimensional model, Dennes now turns his attention on the in-memory tabular model.