Features

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL queries that incorporate OUTER JOINs. Continue Reading
5 trends for SQL Server environments as SQL Server 2019 looms

SQL Server is undergoing new changes, as Microsoft prepares to release the 2019 version of the database software. Other changes are also on tap for SQL Server users. Continue Reading
The most useful new features in Microsoft SQL Server 2019

SQL Server 2019 includes welcome new features, particularly updates to its indexing and high availability capabilities and added SQL Server on Linux functionality. Continue Reading
How Azure SQL DW Gen2 boosts cloud data warehouse's performance

The Gen2 version of Azure SQL Data Warehouse gives Microsoft's cloud data warehouse a shot in the arm on performance, making it more competitive with rival technologies. Continue Reading
Common Data Service for Analytics eases Power BI integration

Integrating data into Power BI for analysis can be a challenge, but Microsoft's Common Data Service for Analytics technology is designed to simplify the process for users. Continue Reading

Power BI Report Server adds new Power BI reporting options

Updates to Power BI Report Server expand the on-premises platform's reporting functionality and increase the number of data sources users can connect to when building Power BI reports. Continue Reading
What the Microsoft GDPR compliance toolkit offers for SQL Server

The set of GDPR compliance tools that Microsoft offers for SQL Server is designed to make it easier for users of the database software to adhere to the EU's new data rules. Continue Reading
How SQL Server containers in Docker can ease database deployment

Docker containers can make the SQL Server deployment process more efficient and flexible. Here's what they are and how to get started on creating containers for SQL Server databases. Continue Reading
Notre Dame seeks SQL Server performance baseline for run to cloud

Establishing SQL Server performance baselines is a crucial first step for cloud migrations, says a University of Notre Dame DBA, who is using database monitoring software to do so. Continue Reading
SQL Server on Linux signals Microsoft's changing development landscape

Expert Joey D'Antoni explains what SQL Server on Linux and the addition of some Enterprise Edition features to the database's Standard Edition say about the changing face of Microsoft. Continue Reading
SQL Server for Linux shows Microsoft changing with the times

SQL Server on Linux didn't come out of nowhere. The database's roots are in Unix, and Microsoft has been making a concerted effort to be less Windows-centric overall. Continue Reading

Database trends to watch after SQL Server 2005 end of life

Two database industry experts discuss infrastructure and analytics trends to consider for database upgrades following the end of SQL Server 2005 extended support. Continue Reading
Why SQL Server 2005 end of life is good news for DBAs

Two database experts explain how to take advantage of the opportunity created by SQL Server 2005 end of life and how to build a better database. Continue Reading
What's new in 2016's SQL Server AlwaysOn Availability Groups

Microsoft has added Distributed Transaction Coordinator support, optimized log transport and other features to AlwaysOn Availability Groups in SQL Server 2016. Continue Reading
DH2i containerization software gets Westminster, Colo., to clustering

When Microsoft's licensing policy began costing too much, the City of Westminster used DH2i's containerization software to cluster its over 30 servers, standardize them and save money. Continue Reading