Introduction to Gaps and Islands Analysis

• by Additional Articles

• SimpleTalk

• T-SQL

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

• Azure Data Factory
• ETL (Extract Transform and Load)
• Stairway Series

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

Free eBook: SQL Server Internals: In-Memory OLTP

• by Press Release

• Redgate

• ebook

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.

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 Unlimited 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

• Database Administration
• Indexing
• online

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.