This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
An open cottage door painted green outside, still red on the inside.

Renaming the Windows Server Under SQL Server: Fixing @@SERVERNAME

September 14, 2013
Pinal Dave
SQL Tips and Tricks
DBA, SQL Server Configuration, SQL Server Installation, Windows

After renaming the Windows server, repair SQL Server’s local name with sp_dropserver and sp_addserver, then verify dependent services.

Read More
A gardener seen from behind adjusting a greenhouse roof vent, with a shade cloth, heater and healthy seedlings.

Windows Settings That Affect SQL Server

May 28, 2008
Pinal Dave
SQL Tips and Tricks
DBA, SQL Memory, SQL Server Configuration, Windows

Windows settings can influence SQL Server CPU speed, file growth, memory stability, and security scanning; learn what to inspect and validate.

Read More
Previous 1 … 3 4 5 6
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com