Additional Articles

SQL Server R Services: Working with Multiple Data Sets

by Additional Articles

SimpleTalk

SQL Server R Services

Although it is easy to use SQL Server R Services to create R scripts that incorporate SQL Server data by passing in a T-SQL query as an argument when calling the sp_execute_external_script stored procedure, you are limited to that one query, unless you pass additional data directly between R and SQL Server via CSV files. It is simple to do, and opens up many additional opportunities for data analysis. Robert Sheldon explains how.

2017-12-07

3,542 reads

Correlation Analysis using Correlation Plot in Power BI Desktop

by Additional Articles

MSSQLTips.com

Power BI

Power BI provides correlation plot visualization in the Power BI Visuals Gallery to create Correlation Plots for correlation analysis. In this post, Siddharth Mehta shows how to create a correlation plot in Power BI Desktop using a sample dataset of car performance.

2017-12-06

2,780 reads

Book Review: Database Reliability Engineering by Campbell & Majors

by Additional Articles

Brent Ozar Blog

Book Reviews

Brent Ozar explains why DBAs should read this book about the future of database administration at scale.

2017-12-05

3,193 reads

Importing JSON Data from Web Services and Applications into SQL Server

by Additional Articles

SimpleTalk

JSON

To support many applications, it makes sense for the database to work with JSON data, because it is the built-in way for a JavaScript or TypeScript application to represent object data. It can mean less network traffic, looser coupling, and less need for the application developer to require full access to the base tables of the database. However, it means that the database must do plenty of checks first before importing. Phil Factor explains how it can be easily done.

2017-12-04

4,513 reads

Even More SQL Server Features that Time Forgot

by Additional Articles

SimpleTalk

SQL Server

SQL Server works well, and Microsoft does everything it can to keep it relevant and competitive: As with everything in real life, it doesn't don't always get it completely right, and Rob Sheldon continues his quest through the jungle of past features to rediscover and explore the ones that time forgot. Here, he comes across Lightweight Pooling, XML Indexes, Stretch Databases, SQL Variants, Transaction Savepoints and In-Memory OLTP.

2017-12-01

5,018 reads

Free Database Unit-Testing Framework for SQL Server

by Additional Articles

MSSQLTips.com

Unit Testing

Learn how to implement an advanced and cost-effective database unit-testing framework with tSQLt in SQL Server Management Studio.

2017-11-30

4,320 reads

Simple SQL: Handling Location Datatypes

by Additional Articles

SimpleTalk

T-SQL

How do you record locations in SQL? Most relational database systems support spatial and geographical data, generally using the round-earth system based on the SQL specification of the Open Geospatial Consortium (OGC). However, this is not the only approach, as Joe Celko explains.

2017-11-29

2,871 reads