How often do you rename things? It seems to be more common for some than others.

Managing Test Data as a Database CI Component - Part 2

by Additional Articles

SimpleTalk

Continuous Integration (CI)

Tim Hidalgo goes through some practical demos to show you how you can automatically keep your testing environments up to date, and ship more robust databases.

Add Styles to Your Reporting Services Reports

by Adam Aspin

SQLServerCentral.com

Reporting Services provides a robust reporting platform that rivals many other products. New author Adam Aspin stars a series on how you can dress up your reports and maintain good development practices.

Checking Table Metadata with tSQLt

by Steve Jones

SQLServerCentral.com

tSQLt

In this article on tSQLt, learn how you can use the AssertResultSetsHaveSameMetaData method from the framework to enforce your API.

Practical Hekaton

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones is searching for anyone that is using In-Memory OLTP tables in production.

Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server

by Additional Articles

Database Journal

pivot

Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.

Byte Me: Hard Copy

by Bob Lang

SQLServerCentral.com

Byte Me

Stack overflow.

Reusing T-SQL Code

by Additional Articles

SimpleTalk

T-SQL

Alex Kuznetsov, in an article taken from his book 'Defensive Database Programming with SQL Server', shows how DRY principles can be put in practice with constraints, stored procedures, triggers, UDFs and indexes.