Brian Knight

Brian Knight, MCSE, MCDBA, is on the Board of Directors for the Professional Association for SQL Server (PASS) and runs the local SQL Server users group in Jacksonville. Brian is a contributing columnist for SQL Magazine and also maintains a weekly column for the database website SQLServerCentral.com. He is the author of Admin911: SQL Server (Osborne/McGraw-Hill Publishing) and co-author of Professional SQL Server DTS (Wrox Press). Brian is a Senior SQL Server Database Consultant at Alltel in Jacksonville and spends most of his time deep in DTS and SQL Server.

All authors

All authors

Blogs

Marketing Analyst: The Data-Driven Superhero Your Company Needs

By

Want to blend your love of marketing with the power of data? Becoming a...

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...

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...

Migrating MDS model individually using MDS UI

By jaango123

Hi All,   Is there a way i can create package for an individual...

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...

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