Segments for Protection

• by Steve Jones

• SQLServerCentral

• Security

Computer network security is important, and it's something we ought to be more concerned with as data professionals.

SQL Server Agent for SQL Express on Linux

• by Thom Andrews

• SQLServerCentral

• SQL Server on Linux

This article will show you how to use crontab to schedule tasks that you want to run on a SQL Server on Linux instance when no Agent is configured.

Resolving could not open a connection to SQL Server errors

• by Additional Articles

• MSSQLTips.com

• Connections

Sometimes you may have issues connecting to SQL Server and you may get messages such as could not open a connection to SQL Server. In this tip we look at different things you can check to resolve this issue.

SSMS or SSDT

• by Steve Jones

• SQLServerCentral.com

• Editorial

The question this week deals with tools. Steve Jones is looking to see which tools are preferred by most database developers.

Watching Out for Deferred Name Resolution

• by Tony Davis

• SQLServerCentral

• Deferred Name Resolution
• T-SQL

Deferred Name Resolution can be useful in writing ...

SQL For Cosmos DB – Handling Complex JSON Structures

• by Additional Articles

• SimpleTalk

• NoSQL

The JSON documents that are part of Cosmos DB document collections can be complex with arrays and nesting. In this article, Adam Aspin shows you how to query them with SQL.

Microsoft and Oracle Cloud Partnership

• by Kathi Kellenberger

• SQLServerCentral

• Database Weekly

Many of us checked to make sure it wasn’t April Fools Day a couple of years ago when Microsoft announced that SQL Server 2017 would run on Linux. This means that some shops who want to run SQL Server, but not Windows Server, now can. But it also means that SQL Server professionals need to […]

SQL Server Performance Benchmarking with Patterns

• by Paul Brewer

• SQLServerCentral.com

• Performance

A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.

VMs are not VMs

• by Steve Jones

• SQLServerCentral.com

• Editorial

Today Steve Jones talks about how database VMs are not like other VMs.

Reporting Services Basics: Creating Your First Report

• by Additional Articles

• SimpleTalk

• BI

In this article, Kathi Kellenberger demonstrates how to create a project and report using the SSRS Report Wizard. The wizard is fine for getting started, but you’ll soon learn about its many limitations. She also explains how reports fit in projects and solutions.