Required Environment Variables

Writing Output from Powershell

One of the things we often want to do when building a PoSh script is to get some output. I first learned about Write-Host, but I learned over time...

Daily Coping 21 Oct 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

The New Data Warehouse Choice

Steve Jones looks a little more closely at the Azure SQL Data Warehouse, perhaps a viable choice for many of us.

Daily Coping 20 Oct 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

The Log File Structure

TRIM() in T-SQL

The T-SQL language expanded in SQL Server 2017 with the TRIM() function.

Chopping Off Data

An ETL issue with Excel causes issues, because the users didn't realize a limitation.

Daily Coping 19 Oct 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Setting Affinity