SQLServerCentral Editorial

You Should Know

Are there things you should know? It seems that we quite often find that others in our profession don't understand the simple things we assume they do. Steve Jones talks about one item in particular: staging servers.

External Article

Re-generating SQL Server Logins

SQL Server stores all login information on security catalog system tables. By querying the system tables, SQL statements can be re-generated to recover logins, including password, default schema/database, server/database role assignments, and object level permissions. A comprehensive permission report can also be produced by combining information from the system metadata.

Blogs

Flyway Tips: AI Generating Migration Script Names

By

AI is a big deal in 2026, and at Redgate, we’re experimenting with how...

The Book of Redgate: Get the right stuff done

By

Another of our values: The facing page has this quote: “We admire people who...

Runing tSQLt Tests with Claude

By

Running tSQLt unit tests is great from Visual Studio but my development workflow...

Read the latest Blogs

Forums

SQL Server 2025 Standard Developer Edition

By Johan Bijnens

Comments posted to this topic are about the item SQL Server 2025 Standard Developer...

URL Safe or Not?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item URL Safe or Not?

No Defaults Passwords Ever

By Steve Jones - SSC Editor

Comments posted to this topic are about the item No Defaults Passwords Ever

Visit the forum

Question of the Day

URL Safe or Not?

If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?

See possible answers