The ways in which we collect and use data aren't always apparent to our customers. Perhaps we should do better.

Handling error converting data type varchar to numeric in SQL Server

by Additional Articles

MSSQLTips.com

varchar

Error converting data type varchar to numeric may occur when trying to import data that looks like numbers, but doesn't act like a number. Read how to solve this issue.

Protecting Our Stream of Data

by Steve Jones

SQLServerCentral.com

Editorial

We can't protect against all hacks, but can we prove they weren't our fault?

SQL Server 2008 Migration to SQL Server 2017 Linux Containers using Database Cloning

by Paul Stanton

SQLServerCentral.com

Containers

Learn how you can get a SQL Server 2017 container working with Docker and Windocks.

Azure SQL Database Business Continuity Enhancements

by Additional Articles

SQLServerCentral

Azure SQL database

Marcin Policht provides an overview of a number of new features that facilitate Azure SQL Database business continuity.

'Comedy Limited' with SQL Server

by Phil Factor

SQLServerCentral.com

Editorial

Phil Factor is not amused by SQL Server's handling of the comma-separated value (CSV) file format.

The Crimes of Chicago: Working with Data in MongoDB

by Additional Articles

SimpleTalk

MongoDB

NoSQL databases like MongoDB are gaining popularity, but using the right tools for the job at hand is most important. In this article, Phil Factor demonstrates how to work with a MongoDB database and how to use PowerShell with MongoDB so that the process can be automated.