We're always looking for articles, but here are a few ones that I'd like to see written up.

Questions About PowerShell Basics That You Were Too Shy To Ask

by Additional Articles

SimpleTalk

PowerShell

Developers who are already familiar with application languages will be baffled by different aspects of PowerShell to the beginner to programming. Laerte recalls his initial struggles with PowerShell and answers those questions he wished he'd found quick answers to.

Azure SQL Database Elastic Database Jobs

by Additional Articles

Database Journal

Azure

In this article, Marcin Policht describes the basic functionality and implementation steps for Azure SQL Database's Elastic Database jobs.

Cloud First

by Steve Jones

SQLServerCentral.com

Editorial

SQL Server 2016 is the first cloud first version of SQL Server being released as the on-premise product.

Data Mining Part 38: Text Mining - The term lookup

by Daniel Calbimonte

SQLServerCentral.com

Integration Services (SSIS)

In this new article, we will show how to use the SSIS term lookup transformation tool.

How to change server level collation for a SQL Server Instance

by Additional Articles

MSSQLTips.com

Server-Level Collation

Manvendra Singh explains step by step how to change the server level collation setting for an existing SQL Server instance.

Specialist or Generalist

by Steve Jones

SQLServerCentral.com

Editorial

The idea of being a generalist of specialist may not need to be a choice.

SQL Server Resource Governor

by Arun Sirpal

SQLServerCentral.com

Resource Governor

Using Resource Governor on a SQL Server that suffers from CPU contention thus allowing us specify limits on the amount of CPU that an incoming request can use.

The Practical Problems of Determining Equality and Equivalence in SQL

by Additional Articles

SimpleTalk

In theory, it is easy to determine whether data is equal to, greater than or lesser than a value. Real-world data types can be surprisingly tricky, even for gauging data equivalence. Because SQL cannot remain aloof from any application's data types, you need to be aware of the ways and pitfalls of individual datatypes and how you can test for equality, equivalence, similarity, identity and all that jazz. Joe Celko discusses.