SQL Server 2016 Temporal Table Query Plan Behaviour

In this latest T-SQL Tuesday, Rob Farley takes a look at a couple of unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.

Byte Me: Earning in the Grave

Create a SQL Server Reporting Services Report from an Analysis Services Tabular Database

Daniel Calbimonte walks through the steps to creating a SQL Server Reporting Services (SSRS) Report from an Analysis Services Tabular Database.

Changing Replication Passwords

A how-to guide for configuring replication agents after a password change

Moving Fast at Redgate

It's possible to change a software development team and dramatically improve things. Steve Jones highlights an example from Redgate Software.

Strengthening the Foundations of Software Architecture

The term 'Architecture' seems to imply a plan that you can't easily subsequently deviate from. It's true that, if you abandon software architecture, you end up with a big ball of mud, but maybe the art of software is to make change much easier by planning how to implement each feature, tackling dependency issues, splitting functionality into small discrete components and considering how they should interact with each other.

Adding Old Features?

Is Row Level Security a new feature? Or should MS work on improving old ones?

How to Run Scheduled Jobs in Azure SQL Databases

This article will help you to schedule jobs in Azure SQL.

Passwords Under Pressure

Passwords are a problem, especially when we're in a hurry. What should we do?

Introduction to Azure SQL Database Temporal Tables

As announced on June 1, 2016, SQL Server 2016 has reached its general availability. This means that you finally have the option to implement some of its new features in the production environment. While we still have to wait for their full support in Azure SQL Database V12, it is likely that their preview stage will be concluded soon. In this article, we will focus on Temporal tables, which is one example of these new features.