Library SQL Server Resources

Library

Practical, real-world guidance for working with — and optimizing — SQL Server: in-depth KB articles, quick tips, and (soon) longer articles and documentation for my open-source tools.

Latest

Recently added.

library kb Featured
Type
KB
Released

Enabling SQL Server Trace-Flags without a Service Restart

Enable SQL Server trace flags without an immediate restart: add -T startup parameters in Configuration Manager so they persist, then run DBCC TRACEON(xxxx, -1) to apply them globally right now.

  • Overview + Trace-Flags Warning
  • Enabling Trace-Flags - via Startup Parameters
  • Enabling Trace-Flags via DBCC TRACEON()
  • Enabling Trace-Flags without a Restart

Topics

Browse by topic.

Disaster Recovery 1

Backups, restores, and recovering when things go wrong.

Encryption 2

TLS, certificates, best-practices, and drivers.

Code Optimization 1

Optimizing SQL code for better security and cost.

Capacity Planning 1

Migrations 1

T-SQL 3

Documentation for my open-source projects is moving here soon — meanwhile, see them on GitHub

Consulting

Initial consultations are always free.

Bring your toughest SQL Server problem — performance, backups and restore-testing, auditing, encryption — and get an independent, experienced second set of eyes.

Book a free consultation