Will Assaf


Blog Post

Moving Into Consulting 101

Introduction to this blog series

After being laid off by a Great Recession-era mortgage company in 2007, I entered into consulting. I made that switch from in-house DBA to consulting...

2021-03-30 (first published: )

1,381 reads

Blog Post

Confounding Variables from Historical Bias

Note: co-authored with Christine Assaf, originally published in the now-defunct PASS Blog.
Historical data analysis that is naïve to past discrimination is doomed to parrot bias. How do we combat bias in our...

2020-09-23

9 reads

Blogs

Excel to SQL: Ditch the Spreadsheet Headaches

By

If you're a data analyst drowning in Excel, you know the pain. Endless filtering,...

Securing Kubernetes With External Secrets Operator on AWS

By

Here’s a way to centralize management, rotate secrets conveniently without downtime, automate synchronization and...

Save Azure PostgreSQL Backup to Storage

By

This may or may not be helpful in the long term, but since I’m...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Pitfalls to avoid while feeding events into CrowdStrike

By Pablo Echeverria

Comments posted to this topic are about the item Pitfalls to avoid while feeding...

Column Adds and Drops

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Column Adds and Drops

Visit the forum

Question of the Day

Column Adds and Drops

I run this batch on SQL Server 2022. What happens?

ALTER TABLE dbo.Accounts
 ADD AccountAccessType INT
GO
ALTER TABLE dbo.Accounts
 DROP AccountAccessType
GO

See possible answers