SQL Server Management Studio or SSMS allows you to connect to the SQL server and execute queries. In this tutorial, we will see how you can install and configure SQL Server Management Studio in ...

Learn how to use SQL Server Configuration Manager to configure the Database Engine to listen on a specific fixed port other than the default port, 1433. For more information about the default Windows ...

Find out how to enable or disable a server network protocol. See how to use SQL Server Configuration Manager or PowerShell for this task. remote connections [SQL Server], enabling using Configuration ...

Maintaining and updating the businesses database is crucial to running a successful company. To prevent and diagnose availability, health, and performance issues it is essential to review and manage ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Get ready to scale out SQL Azure databases beyond today's 50GB limit with the Transact-SQL and ADO.NET elastic sharding features, which are coming in the 2011 SQL Azure Federation Community Technology ...

Are you ready to unlock the power of Microsoft SQL Server 2014? In this blog entry I will examine my 3 favorite new features that show how SQL Server 2014 provides high-performance OLTP, optimization ...