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 ...

If you want to learn how to use Transact-SQL (T-SQL) F1 Help, please view the Transact-SQL F1 Help section. If you want to learn about tasks that you can do with the editor, please visit the Editor ...

Poke around the infrastructure of any startup website or mobile app these days, and you're bound to find something other than a relational database doing much of the heavy lifting. Take, for example, ...

A program that accepts SQL commands and accesses the database to obtain the requested data. Users' requests in a query language or database language must be translated into an SQL request before the ...

Security is a longstanding priority for Microsoft across its products and offerings. In fact, SQL Server has pro­duced the fewest security vulnerabilities of all the major database platforms for many ...

In previous columns, we’ve noted that the SQL language is in the ascendant. New SQL native databases such as CockroachDB and Yugabyte are showing robust adoption, while non-relational (NoSQL) ...

SQL Server database corruption is troublesome for DBAs, particularly if the situation arrives suddenly and there is no backup. This situation can lead to prolonged downtime and permanent data loss in ...