Technical debt is a real problem in database development, where corners have been cut in the rush to keep to dates. The result may work but the problems are in the details: such things as inconsistent naming of objects, or of defining columns; sloppy use of data types, archaic syntax or obsolete system functions. With databases, technical debt is even harder to pay back. Robert Sheldon explains how and why you can get it right first time instead.

The Case of the Space at the End

by Adam St. Pierre

SQLServerCentral.com

ANSI_PADDING

A gripping expose into the deep, dark world of ANSI_PADDING! What could be more exciting?

The Financial DBA

by Steve Jones

SQLServerCentral.com

Editorial

The future of the DBA might include lots of asset tracking and financial meetings.

Testing DML Statements for In-Memory OLTP

by Additional Articles

SQLPerformance.com

Erin Stellato takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.

Looking Back

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones takes a look back at software during his career.

SQL Server User-Defined Functions

by Additional Articles

SimpleTalk

T-SQL

User-Defined Functions (UDFs) are an essential part of the database developers' armoury. They are extraordinarily versatile, but just because you can even use scalar UDFs in WHERE clauses, computed columns and check constraints doesn't mean that you should. Multi-statement UDFs come at a cost and it is good to understand all the restrictions and potential drawbacks. Phil Factor gives an overview of User-defined functions: their virtues, vices and their syntax.

Resolve Network Binding Order Warning in failover cluster

by Ganapathi varma Chekuri

SQLServerCentral.com

SQL Cluster

In this article, I’m going to show a procedure to resolve an issue that I found while running cluster validation report. you may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue.