Table-Valued Functions and User-Defined Types can help you write parameterised U-SQL views in an elegant manner. They also aid code reuse.

Migrating data to Azure SQL Data Warehouse in practice

by Additional Articles

SQLCAT

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

Rangarajan Srirangam from the Azure Customer Advisory Team shares some tips and techniques to help achieve an efficient data migration to Azure SQL Data Warehouse.

Developer Deployment Frustrations

by Steve Jones

SQLServerCentral.com

Editorial

SQL Server should work to make it easy for developers to work with it, and include versions like Express in their applications.

Error Logging Gone Wild

by Andy Warren

SQLServerCentral.com

ERRORS

Many of have applications that log errors to a table. Ever thought about what happens when an application starts to throw a lot of errors? This article looks at the problem and some of the responses you might consider having ready in case it happens to you!

Going Interactive with C#

by Additional Articles

SimpleTalk

.Net

For some time now, C# programmers have gazed enviously at the interactive capabilities of F#, Python and PowerShell. For rapid prototyping work and interactive debugging, dynamic languages are hard to beat. C# Interactive slipped into view quietly, without razzmatazz, in Visual Studio 2015 Update 1. It's good, it's worth knowing about; and Tom Fischer is intent on convincing you of that.

Bingle is my Senior DBA

by Grant Fritchey

SQLServerCentral.com

Editorial

When working with SQL Server, many people don't need the search engine to be their junior DBA, they need it to be their senior DBA.

MDX Calculations Across Multiple Calendars Using Nested SCOPEs

by Paul Burton

SQLServerCentral.com

A solution to the problem of multiple calendar calculations within SSAS Multimdimensional cubes using nested SCOPEs

Azure SQL Database - Azure AD Authentication

by Additional Articles

Database Journal

Azure SQL database

One of the challenges when considering migrating your on-premises SQL Server databases to Azure SQL Database is its lack of support for Active Directory-integrated authentication. With the advent of Azure SQL Database V12, the authentication capabilities have been expanded, allowing for more flexibility that leverages Azure Active Directory. In this article, Marcin Policht provides an overview of this functionality.