Understanding Views in SQL

• by Additional Articles

• Database Journal

• Views

Learn about the concept of views in SQL, and how they work. Read on to see clear examples of how to implement views.

A Virtual Trip Down Under

• by Steve Jones

• SQLServerCentral

• Public Speaking

Steve returns from vacation and gets ready for a virtual trip to Australia.

Creating a Serverless Database in Azure

• by Emmitt Albright

• SQLServerCentral

• Azure SQL database

Learn how you can create a database in the serverless tier in Azure.

How to Create an Ubuntu PowerShell Development Environment – Part 3

• by Additional Articles

• SimpleTalk

• SQL Server on Linux

Running SQL Server in a container may seem daunting at first, but it’s easy once you understand the handful of commands needed. In this article, Robert Cain demonstrates how to run SQL Server in a Docker container on Ubuntu.

The Appliance of Science

• by Phil Factor

• SQLServerCentral

Phil Factor challenges 'the Agile orthodoxy'.

Annoyances

• by Steve Jones

• SQLServerCentral.com

• Editorial

Working with others can be a challenge. This Friday's poll asks for those little annoyances in the workplace and how to deal with them.

Getting started with SQL 2019 big data cluster in Azure

• by Blesson John

• SQLServerCentral.com

• Big Data Cluster

Installing and connecting to SQL 2019 big data cluster

Cloud adoption rates see increase in 2020

• by Additional Articles

• Redgate

• SQL Monitoring

Usage of Microsoft Azure is up by 15 percentage points compared to 2019 and it remains the most-used cloud platform. This is possibly as a result of increased remote working and the need to no longer rely on physical machines. For more insights into 2020 trends and challenges, download the State of Database Monitoring report here.

Using SQL Server Profiler to Capture Stored Procedures Executions

• by Additional Articles

• MSSQLTips.com

• Stored Procedures

In this article we look at how to capture stored procedure executions using Profiler to help with troubleshooting issues that are occurring from your application making procedure calls.

Falling Over our Assumptions

• by Phil Factor

• SQLServerCentral.com

• Editorial

There's a saying about what it says about a person to assume something. However it's something we all do every day. Phil Factor brings us a guest editorial about assumptions in SQL code.