External Article

SQL Server Security Audit Report

If your company needs to go through a SOX (Sarbanes–Oxley) audit or any security audit, the DBA has to provide security information to them. If you have purchased third party tools to provide this information that is great. If you don't have third party tools and need to go through many servers to provide this information it can be a hassle and very time consuming. So I put together a script to generate a report that I could just review. The script generates a report of all elevated level accounts and any possible security holes.

SQLServerCentral Editorial

Easy Licenses

Software licensing can be complex and confusing. Even in Windows and SQL Server, where hard limits are not enforced, people have problems determining how they should license software. Steve Jones talks about what vendors could do to help us.

Technical Article

Easy Licenses

Software licensing can be complex and confusing. Even in Windows and SQL Server, where hard limits are not enforced, people have problems determining how they should license software. Steve Jones talks about what vendors could do to help us.

Technical Article

Easy Licenses

Software licensing can be complex and confusing. Even in Windows and SQL Server, where hard limits are not enforced, people have problems determining how they should license software. Steve Jones talks about what vendors could do to help us.

SQLServerCentral Editorial

Speed Phreaks

A guest editorial from Phil Factor looks at the Speed Phreak competition that has been taking place recently and is quite popular. Read about the inspiration for the competition and why you might want to participate.

Blogs

Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To

By

An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...

SQL Server Security Hardening Guide Using the DoD STIG Checklist

By

Security on your SQL Server is important. That doesn’t need any explaining. But where...

EightKB 2026: Registration is Open!

By

It’s that time of year again! EightKB is back on August 20th at 13:00...

Read the latest Blogs

Forums

Are You Working More Hours?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Are You Working More Hours?

Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time

By Massimo Preitano

Comments posted to this topic are about the item Stairway to Reliable Database Deployments...

A Limited Startup

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Limited Startup

Visit the forum

Question of the Day

A Limited Startup

I add this parameter to SQL Server 2025 in the Configuration Manager:

-mDynamics
What does this do?

See possible answers