Crosstab queries using PIVOT in SQL Server

• MSSQLTips.com

• Crosstab

In this tip we look at how to construct a SQL Server PIVOT query with an example and explanation.

Additional Articles

2019-04-04

How to Monitor IDENTITY columns to prevent unplanned downtime

• Redgate

• IDENTITY

If a table runs out of IDENTITY values then it, and any dependent services and applications, will be "read-only" until the problem is fixed. Steve Jones explains how to set up a custom monitor to detect and prevent such problems.

Additional Articles

2019-04-04

Automating Builds from Source Control for the WideWorldImporters Database

• Redgate

• Automate

Kendra Little shows how to get the WideWorldImporters database into version control, using SQL Source Control, and then set up an automated database build process, using Azure DevOps with SQL Change Automation.

Additional Articles

2019-04-17 (first published: 2019-04-03)

Enforce SSL for connecting to AWS RDS Instance of SQL Server

• MSSQLTips.com

• SSL

Learn how to force all SQL Server connections to an AWS RDS instance to use SSL encrypted connections.

Additional Articles

2019-04-02

Converting a History Table into a System-Versioned Temporal Table

• SimpleTalk

• SQL Server 2016

Temporal tables were introduced with SQL Server 2016. To take advantage of this feature, you might start fresh with a brand new table. It is possible, however, to convert an existing table with accumulated history to the new functionality. In this article, Mala Mahadevan explains how to create temporal tables for both scenarios.

Additional Articles

2019-04-01

Are nulls stored in a nonclustered index?

• Brent Ozar Unlimited Blog

• Indexing

When you index a nullable field, are the rows with nulls stored in the index? It’s easy enough to find out by creating a table with a nullable field, and then creating an index on it.

Additional Articles

2019-03-29

Breaking the 4th Wall with Unity

• SimpleTalk

• .Net

Even when creating games, your code has access to environment variables and document files. In this article, Lance Talbert shows how to access files to convince the player that maybe the game knows more than it should.

Additional Articles

2019-03-28

Create Azure Data Lake Linked Service Using Azure Data Factory

• MSSQLTips.com

• Azure

In this article we walk through a step-by-step example on how to create an Azure Data Lake Linked Service in Azure Data Factory v2.

Additional Articles

2019-03-27

Creating CRUD Stored Procedures in SQL

• Database Journal

• Stored Procedures

Back to the basics: learn how to Create, Read, Update and Delete operations are pivotal for any database application. Plus, you’ll see how to use Stored Procedures to manipulate data on the database side instead of on the application side.

Additional Articles

2019-03-26

Introduction to SQL for Cosmos DB

• SimpleTalk

• SQL

This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer. More specifically it will show you how to leverage your Structured Query Language skills to exploit the core possibilities of Cosmos DB as a NoSQL document database.

Additional Articles

2019-03-25

219 reads