Age calculation based on the right method used in real life.

Who Changed My Database Schema?

by Additional Articles

Database Journal

Schema

Have you ever wanted to know who made a schema change to your database? If so, that information is tracked in the default trace - Greg Larsen shows how to view it.

Azure Data Warehouse 7: Create reports in Azure SQL DWH using SSRSS

by Daniel Calbimonte

SQLServerCentral.com

Azure

In this article, we will show how to create reports in ASDW using SSRS

I'm "working from home"

by Phil Factor

SQLServerCentral.com

Editorial

Phil Factor argues that The serious problems with working from home come not from poor productivity, but when office-based team members seem to prefer to ignore the fact that the remote workers exist.

Is Big Data good for Data Professionals?

by Steve Jones

SQLServerCentral.com

Editorial

Is Big Data good for us? Steve Jones thinks it is.

Using AT TIME ZONE to fix an old report

by Additional Articles

SQLPerformance.com

AT TIME ZONE

Rob Farley contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.

The Mysterious Case of the Missing Default Value

by Raul Gonzalez @SQLDoubleG

SQLServerCentral.com

SQL Server internal storage

Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.

Encrypting SQL Server: Transparent Data Encryption (TDE)

by Additional Articles

SimpleTalk

Transparent Data Encryption (TDE)

Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the original encryption certificate and master key, the data cannot be read when the drive is accessed or the physical media is stolen. The data in unencrypted data files can be read by restoring the files to another server. TDE requires planning but can be implemented without changing the database. Robert Sheldon explains how to implement TDE.