Understanding SQL Server Instances
Being raised within SQL Server 6.5 & 7.0, SQL Server instances were not available in those versions. I never fully understood the advantage of having multiple instances on the same server so I never embraced it. I always had a single, default instance per physical server. Once I got involved with virtualization a few years ago, having multiple instances of an OS running on a single physical server finally got me thinking about multiple instances of SQL Server. ...