SQLServerCentral Article

Searching Syscomments Accurately

As a SQL Server DBA you should know that your code is stored in syscomments by default. While most DBAs use version control systems, there are times you might want to look through the code on the server for comparison purposes. Robert Cary brings us an article on how you can do this in 2000 and 2005.

Blogs

Local LLM Models at SQL Saturday Boston 2025

By

I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...

3 things you must do to start data quality management right

By

As a data & AI strategist who’s seen countless projects succeed and fail, I...

Set Theory vs. Batch Mode in SQL Server

By

Set Theory vs. Batch Mode in SQL Server Not long ago,...

Read the latest Blogs

Forums

SSC Website Deployment 24 Sept 2025

By Steve Jones - SSC Editor

We are planning on a fairly big code deployment to set the stage for...

Timeout when expanding the table

By LearningDBA

Experts, I am hoping to get some help and feedback. I have a server...

Single User SQL Server on Linux

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Single User SQL Server on...

Visit the forum

Question of the Day

Single User SQL Server on Linux

How can I start SQL Server on Linux in single-user mode to restore the master database?

See possible answers