A DBA should be working to automate their tasks, and find time to do things that are really important. Like keeping their coffee cup topped off 🙂

Premature Optimisation

by Gail Shaw

SQLServerCentral.com

Performance Tuning

Learning how to tune a system is a bit of science and a bit of an art. Gail Shaw gives some guidelines on when you might want to tune and how to go about it so as not to unnecessarily undertake the effort.

Watson Freemium

by Steve Jones

SQLServerCentral.com

Editorial

IBM has released a free version of its Watson service to help people perform analytics on their data.

Prevent Confidential Data at the Application Layer from getting into SQL Server

by Additional Articles

MSSQLTips.com

Security

In this tip Tim Smith looks at different approaches to stop confidential data from getting into the database.

Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

by Jeff Moden

SQLServerCentral.com

Hierarchy

SQL Server MVP Jeff Moden shows us a new very high performance method to convert an "Adjacency List" to “Nested Sets” on a million node hierarchy in less than a minute and 100,000 nodes in just seconds. Not surprisingly, the "steroids" come in a bottle labeled "Tally Table".

No Compelling Reason

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones wants to know if you have compelling reasons to upgrade or not upgrade this week.

A TDD Journey: 3- Mocks vs. Stubs; Test Frameworks; Assertions; ReSharper Accelerators

by Additional Articles

SimpleTalk

Test Driven Development (TDD)

Test-Driven Development (TDD) involves the repetition of a very short development cycle that begins with an initially-failing test that defines the required functionality, and ends with producing the minimum amount of code to pass that test, and finally refactoring the new code. Michael Sorens continues his introduction to TDD by implementing the first tests and introducing the topics of Test doubles; Test Runners, Constraints and Assertions.