SQL Server 2016 New Date Objects

SQL Server 2016 introduced three new objects to deal with the greater demand of data; John Miner takes a look at this new functionality.

Byte Me: Development Haze

Stairway to U-SQL Level 10: Table-Valued Functions and UDTs

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

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

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

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#

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

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

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

Azure SQL Database - Azure AD Authentication

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.