Need to know how to use the “Filter” item in the SSMS Object Explorer Details window to show a specific list of tables that contain a specific string of characters? If so, then read on!

CCPA Preparation

by Steve Jones

SQLServerCentral

Data Privacy and Protection

The California Consumer Privacy Act takes effect in a year and there is lots of work to be done. One firm is trying to help companies get ready.

Password-less Authentication for Azure AD Guest Accounts with Azure SQL DB with Access Tokens

by zippy1981

SQLServerCentral

Learn how we can generate tokens that will give access to resources inside Azure without actually adding new users to your domain.

A DBA’s Journey towards Database DevOps

by Additional Articles

Redgate

DevOps and Continuous Delivery (CI/CD)

John Morehouse describes how a quest to help solve his organization's "deployment bottleneck" led them to a place where they could both deliver application and database changes into the wild at a pace to satisfy customer demand, and achieve a better work-life balance for the team, both of which are well worth having.

How to Linux for SQL Server DBAs — Part 4

by Additional Articles

SimpleTalk

SQL Server on Linux

In this article, Kellyn Pot’Vin-Gorman continues teaching SQL Server DBAs how to navigate Linux. She demonstrates usings aliases, setting up environment variables, and examining processes.

Over-thinking Database Build Scripts

by Phil Factor

SQLServerCentral

Database Builds

With SQL Server we tend to build databases, when necessary, from one or more build scripts. If making changes to existing versions of the database, we then script the required changes. Usually, a synchronization tool will create a script that can be tweaked to work; although occasionally it will require something more complicated, as when […]