On both Windows and Linux, the chore of setting up a development workstation can take several days, and there always seem to be a few configuration settings that get missed. You can reduce the time and tedium dramatically by automating the process by using Vagrant to set up the operating system, followed by your choice of provisioning, configuration management and orchestration applications such as Puppet, Chef, Ansible, Salt, Docker, Chocolatey and Boxstarter. Vishwas shows how to make it easy to do with Vagrant, Chocolatey and Boxstarter.

Join Two CSV Files with a Common Column

by Daniel Calbimonte

SQLServerCentral.com

JOIN

In this example we will join two CSV files with a common column using SQL Server.

The Inside Job

by Phil Factor

SQLServerCentral.com

Editorial

Grumpy DBA or necessary corporate oversight?

The Purpose of a Database

by Steve Jones

SQLServerCentral.com

Editorial

Why do we have databases? Steve Jones has a few thoughts.

Getting Started with R Services in SQL Server 2016 – Part 2

by Additional Articles

Database Journal

R Services

SQL Server 2016 brings native support for doing advanced analytics, using R Services, in the database itself. Arshad Ali takes a look at a detailed conceptual execution flow, executing R scripts from SQL Server Management Studio and other R client tools.

Need to run multiple scripts against multiple servers?

by Additional Articles

SQLServerCentral

RedGate

Let Chris Yates give you a quick overview of Redgate's SQL Multi Script to learn more about a quick and easy way to solve the problem.

Data Mining Introduction

by Daniel Calbimonte

SQLServerCentral.com

Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.

Data Mining Introduction

by Daniel Calbimonte

SQLServerCentral.com

Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.

Legacy Limits

by Steve Jones

SQLServerCentral.com

Editorial

Sometimes the hardware or software we use prevents upgrades, which isn't necessarily good for any of us.

Development Delusions: That it is Enough to Build a Better Mousetrap

by Additional Articles

SimpleTalk

Development

You've written a superb, clever, application that you are trying to encourage your colleagues to use. They're not interested. Why? You've neglected the documentation. Surely, the saying goes 'Build a better mousetrap and the world will beat a path to your door'? Nope, not without comprehensive and complete documentation and marketing, it won't. Documentation is the secret of ensuring that good software will succeed.

Automating the Setup of the Local Developer Machine

Join Two CSV Files with a Common Column

The Inside Job

The Purpose of a Database

Getting Started with R Services in SQL Server 2016 – Part 2

Need to run multiple scripts against multiple servers?

Data Mining Introduction

Data Mining Introduction

Legacy Limits

Development Delusions: That it is Enough to Build a Better Mousetrap

Blogs

T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?

Optimizing Redshift Performance by Configuring WLM Queues

PowerShell Strikes Back: Return of the Loop

Forums

Dealing with huge heap tables

Merge Replication failing with Error converting data type nvarchar to numeric

Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit

Question of the Day

Distance Metric Algorithms