This article will show why there is a need for remote access with a Biztalk server that uses log shipping.

Handling Graphs in SQL

by Additional Articles

SimpleTalk

Graphs

Many practical database problems can be tackled more simply and intuitively by graphs or networks, which in this sense are graphs in which attributes can be associated with the nodes and edges. It is a natural way to study relationships within the data. SQL databases aren't the easiest way of doing it, but it makes sense where the scale permits it. Because of the range of graphs and techniques, some Graph theory is unavoidable before you get stuck into the code, and who better to introduce graph databases than Joe Celko?

Hacked

by Steve Jones

SQLServerCentral.com

Editorial

Getting hacked is no fun. Today Steve Jones notes he's been hacked, in more ways than one and wants you to think about this at your workplace.

Performing a Right and Comprehensive Age Calculation

by Sergiy Floka

SQLServerCentral.com

Datetime conversions

Age calculation based on the right method used in real life.

Who Changed My Database Schema?

by Additional Articles

Database Journal

Schema

Have you ever wanted to know who made a schema change to your database? If so, that information is tracked in the default trace - Greg Larsen shows how to view it.

Azure Data Warehouse 7: Create reports in Azure SQL DWH using SSRSS

by Daniel Calbimonte

SQLServerCentral.com

Azure

In this article, we will show how to create reports in ASDW using SSRS

I'm "working from home"

by Phil Factor

SQLServerCentral.com

Editorial

Phil Factor argues that The serious problems with working from home come not from poor productivity, but when office-based team members seem to prefer to ignore the fact that the remote workers exist.