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.

Blogs

Synapse Analytics Spark Example 2 - ROW_NUMBER()

By

The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...

Synapse Analytics Spark Example 1 - Group By

By

I have been playing around with the new Azure Synapse Analytics, and I realised...

Renaming Files by Padding Numbers with PowerShell

By

Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...

Read the latest Blogs

Forums

The media family on device incorrectly formed for read only file group restore

By thostenor

Yes the databases (source and destination) are the same version.  I have checked 3...

The Time Zone Range

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Time Zone Range

Mathematicians and SQL

By Joe Celko

Comments posted to this topic are about the item Mathematicians and SQL

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers