Network World

Building SQL reports with Eclipse BIRT

With BIRT you define a SQL query that pulls your data, then you use a drag-and-drop report creation interface to lay out the data fields for your report. The report is generated in HTML, which you can ...
InfoWorld

Building a hybrid SQL Server infrastructure

Pairing your on-prem SQL Server with a cloud-based instance for high availability has its challenges, but they can be overcome. Here’s how. The geographic distribution of cloud data centers makes it ...
InfoWorld

Building a multi-zone and multi-region SQL Server Failover Cluster Instance in Azure

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.
Business Wire

Upsolver SQLake Makes Building a Pipeline for Data in Motion as Easy as Writing a SQL Query

SAN FRANCISCO--(BUSINESS WIRE)--Upsolver, the company dedicated to making data in motion accessible to every data practitioner, today announced the general availability of SQLake. The new service ...
Ars Technica

T-SQL: Building a string from all columns meeting a certain condition

DECLARE @string VARCHAR(MAX) = ''; SELECT @string = CASE WHEN MeaslesDue < '5/16/2013' THEN @string + MeaslesDue END CASE WHEN MumpsDue < '5/16/2013' THEN @string + MumpsDue END CASE WHEN RubellaDue < ...