Data storage is something all data professionals need to care about, and today Steve Jones talks about a research project from Microsoft.

Stairway to U-SQL Level 14: Local U-SQL Scalar Functions with C#

by Mike McQuillan

SQLServerCentral.com

Learn how U-SQL leverages C# to support flexible scalar functions in your scripts.

Tempdb size resets after a SQL Server service restart

by Additional Articles

MSSQLTips.com

tempdb

Have you ever checked the size of the SQL Server tempdb after restarting SQL Server to find that it's reset? Simon Liew explains this behaviour.

Validate Integer and Decimal Values in SQL Server

by Additional Articles

MSSQLTips.com

Bhavesh Patel shows how to validate specific use-cases for integer and decimal values in SQL Server.

Comparing and Synchronizing Two Folders with Azure

by Daniel Calbimonte

SQLServerCentral.com

Compare

In this article, we will compare two folders using PowerShell, the command prompt and other tools.

Roll Up All the Versions

by Steve Jones

SQLServerCentral.com

Editorial

Steve talk about the final SQL Server 2012 service pack.

Azure SQL Database - Dynamic Data Masking

by Additional Articles

Database Journal

Azure SQL database

A number of security-related features are built into Azure SQL Database, including Transparent Data Encryption, Row-Level Security, and Azure SQL Database Auditing. Their availability reflects the consistent effort by Microsoft to provide functional parity between Azure SQL Database and SQL Server instances running in Azure virtual machines as well as in your on-premises environment. Another example of this trend is support for Dynamic Data Masking, covered in this article.

SQL Server Temporal Tables: How-To Recipes

by Additional Articles

SimpleTalk

Temporal Tables

Tables that return the value of the data in the table at a particular point of time have been with us since the first relational database, but have always required special queries and constraints, and can be tricky to get right. System-versioned Temporal Tables, new in SQL Server 2016, make such tables behave like any other. How do you create one, or modify an existing table? How can you get an In-Memory Optimized OLTP table to be Temporal? Alex Grinberg shows how.