Ars Technica

Settle an argument: SQL update with left join + isnull() vs inner join

I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because inner was missing some records somehow in the left table - tableB in ...
TechRepublic

SQL JOINs make it easy to find and fix missing data

Many people are confused by various JOIN operations supported by SQL. Learn to master the SQL command line with this crash course in JOIN syntax. In response to previous SQL lessons, TechRepublic ...
Ars Technica

Left 4 Dead 1 -- Late 2 D Par-T (or something) Join my server!

I set up a server for Left 4 Dead, and I'm wondering if any other Arsians missed this one the first time around but picked it up on the Steam sale.<BR><BR>The server's named [Ars] L4D (password: gesc) ...
Redmond Magazine

Restoring a Database to an Older Version of SQL Server

SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...
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.