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

The trade-offs associated with low-code solutions

By

Low-code solutions often accelerate development and make tasks accessible to people who can’t or...

Monday Monitor Tips: Looking Back in Time

By

Often we find out about a problem reported by a customer after the incident...

Can You Tell Why a Plan Didn’t Go Parallel?

By

Let’s face it, most of the time, you probably don’t want your SQL Server...

Read the latest Blogs

Forums

Is there a way to determine an Azure Data Factory Trigger's "next run time"?

By Orlando Colamatteo

Many job schedulers (e.g., SQL Agent, Airflow, Azure Logic Apps) can report when a...

The Table Backup

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Table Backup

Dynamic T-SQL Script Parameterization Using Python

By omu

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

Visit the forum

Question of the Day

The Table Backup

I run this code in SQL Server 2022. What happens? 

BACKUP TABLE beercount TO DISK = 'beercount.bak'
 

See possible answers

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy