Tag Archives: SQL

Tools for Performance Monitoring and Tuning

Tools for Performance Monitoring and Tuning.

Creating SQL server alias

  1. Run SQL Server configuration manager, in SQL Server Network configuration enable TCP/IP
    sql server configuration manager
  2. Enable TCPIP protocol – just select Yes from the dropdown
    enable tcp ip
  3. Make sure SQLBrowser service is set to Automatic startup and is running
  4. In SQL Native Client create new alias (Alias Name = what you want the “virtual” instance to be named, leave PortNo blank, Protocol = TCP/IP, Server = the existing instance to which the alias points)new_alias

See also: Liam Westly – How to setup a SQL Server alias and when is a connection alias useful for developers?


Scripts, tools and tips, mostly around Microsoft SCCM and EMS

To The Point

Anything about Technology and Business

Brian's Power Windows Blog

Microsoft in the Enterprise. Windows, Hyper-V, Exchange, SQL, and more!

PowerScripting Podcast

Shownotes and links for the PowerScripting Podcast, a podcast to help people learn Windows Powershell

Learn Powershell | Achieve More

What is this Powershell of which you speak?