Updating and deleting documents, creating queries, and managing query results in Microsoft's new NoSQL database-as-a-service.
The post Working with Azure DocumentDB: SQL & NoSQL Together appeared first on SQLServerCentral.

Learn about working with time series data using T-SQL code and how to add additional data to the data set for more in-depth data mining.
The post Time Series Data Mining Example with T-SQL when Adding New Data appeared first on SQLServerCentral.

Learn how you can design a table that will only have one row. Always.
The post Ensuring a Single Row Table appeared first on SQLServerCentral.

November approaches again. For Europeans, that is a month like any other, for Americans, November means: Black Friday, with huge discounts!
The post Black Friday returns to SQLServerFast appeared first on SQLServerCentral.

Learn how to unpivot data or sets of data with SQL Server queries using CROSS APPLY.
The post Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY appeared first on SQLServerCentral.

Introduction In the previous article, we learned how to install a SQL Server instance with basic parameters like InstanceName, Features, SourcePath, SQLSysAdminAccounts, etc using Powershell DSC. In this article, we'll discover how to enhance our SQL Server installation with additional configurations. We'll cover things like setting up service account credentials, custom installation directories, configuring TempDB […]
The post Advanced SQL Server installation using Powershell DSC appeared first on SQLServerCentral.

When people start learning a new field, for example T-SQL, it’s tempting to spend very little time trying to understand the fundamentals of the field so that you can quickly get to the advanced parts.
The post T-SQL Fundamentals: Controlling Duplicates appeared first on SQLServerCentral.

Coding for the new NoSQL JSON database service that supports SQL queries.
The post Azure DocumentDB: Working with Microsoft's NoSQL Database in the Cloud appeared first on SQLServerCentral.