T-SQL window functions simplify solving many complex queries. In this article, Edward Pollack demonstrates how the functions can be used to find gaps and islands in a dataset.

Let's Fix a Password Problem

by Grant Fritchey

SQLServerCentral

Security

Grant discusses the need for password managers to help prevent security issues between different accounts.

Provisioning ADF - Level 2 of the Stairway to Azure Data Factory

by Andy Leonard

SQLServerCentral

In this next level of the Stairway to Azure Data Factory, learn how to build your first ADF environment.

Monitoring your Servers and Databases with New Relic Infrastructure and SQL Monitor

by Additional Articles

Redgate

Monitoring

New Relic Infrastructure is a capable server monitoring tool but adding Integrations provides only 'bare bones' monitoring for SQL Server. Grant Fritchey argues that to "instrument" a complex system such as SQL Server, effectively, you also need a tool that is built specifically for this purpose.

The 2020 Data Professional Salary Survey Results Are In.

by Additional Articles

Brent Ozar Blog

Salary Survey

We asked what you make, and 1,734 of you in 63 countries answered. Altogether, you made $170,753,936 this year. Damn, y’all are bringing home the bacon!

Re-oiling the gears for the data dictionary or catalog

by David Poole

SQLServerCentral

Documentation is never a favorite task for developers. This article describes how you can use database system catalogs to make generating column descriptions less labor-intensive and also jump start a data dictionary or catalog.

Two Important ‘ONLINE’ Column-Level Operations in SQL Server

by Kendra Little

SQLServerCentral

Today Kendra talks about two of the online options used when working with indexes.

Going Serverless with Azure SQL Database

by Additional Articles

SQLServerCentral

Azure SQL database

Microsoft has a new virtual core offering of Azure SQL database called serverless and this offering optimizes the price performance tradeoff and simplifies performance management for databases with intermittent and unpredictable usage.

The Need for a Data Catalog

by Additional Articles

Redgate

data catalogs

In the event of a breach of personal data, any organization must produce proof that they understand what data they hold and where, and how it is being used, and that they have enforced the required standards for access control and security. To make all this possible, it is essential to build a complete model of the data and its lineage, and a data catalog is the first step in this process.