Roland Alexander was an application developer for the first half of his 20+ year career in IT – then he came over to the Dark Side of SQL Server development, and is now diving headfirst into the deep end of the DBA pool. This blog is about his observations, discoveries, trials, and tribulations, and he hopes you enjoy reading it, learn a thing or two, and (hopefully) teach him a thing or two while you’re at it.

All authors

All authors

Blogs

Can You See Table Valued Parameters in Extended Events?

By

I live for questions and this was an interesting one. Can you see Table...

Can an AI Help Me Find a Job?

By

I’m not looking for a job, but I ran across an article about using...

EightKB 2025

By

EightKB is back! The biggest online SQL Server internals conference is back in 2025…it’s...

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