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
A railway track splits in two at a rural junction, an iron points lever pulled toward the narrower branch.

Named Instances and Default Instances

August 12, 2008
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Instance, SQL Server, SQL Server Configuration

Named instances and default instances differ in connection strings, ports, SQL Browser discovery, and the operations each one needs.

Read More
A row of identical terraced houses at night, each front door a different color, one door bright red.

Naming SQL Server Instances So People Understand Them

May 26, 2008
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Best Practices, DBA, SQL Instance, SQL Server

Naming SQL Server Instances well clarifies default and named installs, survives growth, and makes later server renames less painful.

Read More
A shared laundry room with one washing machine and four full laundry baskets waiting in a line in front of it.

Consolidating Small Instances Onto One Server

October 28, 2007
Pinal Dave
SQL Tips and Tricks
DBA, Resource Governor, SQL Instance, SQL Licensing, SQL Server Configuration

Consolidating small instances can reduce hardware sprawl when configuration conflicts, peak workloads, licensing, and migration order are checked.

Read More
A row of moored rowboats in a quiet harbor, with one weathered red dinghy hidden behind the pilings.

Keeping an Inventory of Every SQL Server You Own

July 11, 2007
Pinal Dave
SQL Tips and Tricks
DBA, SQL Documentation, SQL Instance, SQL Server

Build an Inventory of Every SQL Server you own, including hidden instances, owners, versions, recovery details, and a process to keep it current.

Read More
Previous 1 2
  • Books
  • Testimonials
  • Privacy Policy

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