Gail Shaw issues a rallying call for the SQL Community to adopt the Scientific Method when investigating and reporting on SQL Server behavior.

PowerShell and Secure Strings

by Additional Articles

SimpleTalk

PowerShell

Greg Moore demonstrates how to work with the Get-Credential PowerShell cmdlet and secure strings when authenticating to an SFTP server.

Resolving Cross Database Dependencies in SQL Change Automation using Local Databases or Clones

by Additional Articles

Redgate

Database Builds

Kathi Kellenberger explains how to avoid build problems, when working with set of inter-dependent databases, by restoring or provisioning copies of all required databases to the development, build, or test instance.

Your chance to speak at PASS Summit

by Kathi Kellenberger

SQLServerCentral

Database Weekly

When I decided to switch careers about 25 years ago, I had no idea how far I would go in tech. I just wanted to leave the profession for which I had trained and become a developer. My goal was to make the switch by the end of 1998. It actually happened in the summer […]

Distributed Computing Principles and SQL-on-Hadoop Systems

by Frank A. Banin

SQLServerCentral.com

Distributed computing

A look at SQL-On-Hadoop systems like PolyBase, Hive, Spark SQL in the context Distributed Computing Principles and new Big Data system design approach like the Lambda Architecture.

Turn Out the Lights

by Andy Warren

SQLServerCentral.com

Editorial

Today we have a guest editorial from Andy Warren that looks at the costs associated with our behavior.

How to Stop a SSIS Package Execution from Code

by Additional Articles

SQLServerCentral

Integration Services (SSIS)

In this tip we look at a way to stop the execution of a SSIS data flow task that is running by executing an outside process to stop the data flow immediately.

Managing Data Masking Rules in Larger Teams using Source Control

by Additional Articles

Redgate

data masking

What if you have several people in the team who are responsible for data security across your databases, and they need to work together to develop and maintain the data masking configurations, which must then be applied consistently as part of an automated provisioning process? How should they do it? The solution turns out to be simple: source control.