SQLOS provides user-level operating system services (hence the name “SQLOS”) to the rest of the server. Components in the SQL Server Engine make use of the services provided by SQLOS to schedule individual or multiple tasks, allocate memory, and so forth. In the past, scalability was the major issue in SQL Server because it supported […]
MS SQL
Microsoft SQL Server – How to verify connection information using SQLCMD
quesstion: How to Verify Connection Information to Microsoft SQL Server using SQLCMD? When you are trying to connect a MS SQL server, if the incorrect information is specified, the following error can occur during database creation or migration: Database Server Error: Named Pipes Provider: Could not open a connection to SQL Server [1231]. A simple […]
How to Change the Port Used by an MS SQL Server
Question: How to determine or configure the port used by a Microsoft SQL Server database instance? How to make the port number of a Microsoft SQL Server database instance static versus dynamic? Verify the TCP/IP Port Used by a MS SQL Server Instance 1. From the Microsoft SQL Server database server, launch the SQL Server […]