In the lesson 18 and 19 we worked with Data Mining Models.
In this new chapter we will work with more algorithms and show how to test the accuracy of the model.

SQL Server Source Control Basics

by Tony Davis

SQLServerCentral.com

books

Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started.

Troubleshooting SQL Server: A Guide for the Accidental DBA

by Jonathan Kehayias

SQLServerCentral.com

books

Three SQL Server MVPs, and stalwarts of the SQLServerCentral and MSDN community forums, provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".

Set up a Memory Quota for SQL Server Memory Optimized Databases

by Additional Articles

MSSQLTips.com

Memory Quota

You successfully entered into the In-Memory OLTP world by the hand of SQL Server 2014. After a while you notice that the In-Memory objects are using more memory than you estimated. In this tip you will learn how to proceed.

SQL Server Luxembourg: Wait Watchers

by Press Release

SQLServerCentral.com

Events

On November 19, 2014, the SQL Server Luxembourg User Group and Dell Software will be hosting a free event. Richard Douglas will be be presenting a double bill: SQL Server 2014 features everyone can use, and Wait watchers - Gain Performance Increases Fast! This event is free to registered attendees.

Pay It Forward

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones looks at the dilemma of training developers and having them leave, or maybe, just having them stay untrained.

Using Comments to Quickly Test CTEs

by Carl P. Anderson

SQLServerCentral.com

formatting

A quick tip for using a combination of block and line comments to test CTEs

Acceptance Testing with FitNesse: Database Fixtures, Project Overview

by Additional Articles

SimpleTalk

Testing

There aren't many frameworks for writing acceptance tests for databases, including SQL Server. FitNesse is an obvious choice since it is designed with a Wiki-style interface that, once it is configured and set up correctly, makes it very easy for a non-specialist to set up individual tests.