SQL Server远程连接设置

SQL Server安装完成后，需进行远程访问配置，以便其他客户端能够连接使用。实现远程访问主要包含三个步骤：首先，在SQL Server Management Studio中启用相关设置；其次，通过SQL Server配置管理器开启TCP/IP协议并配置监听端口；调整操作系统防火墙规则，放行SQL ...
Computer Weekly

Seven secrets of SQL Server Management Studio

SQL Server Management Studio (SSMS) is the principal interface for working with Microsoft SQL Server. However, many subtleties of this powerful tool evade even the most seasoned professionals. Here ...
Visual Studio Magazine

Elevate SQL Development with VS Code

As SQL development increasingly becomes part of full-stack workflows, developers are looking for ways to simplify their tooling without compromising capability. While SQL Server Management Studio ...
InfoQ

SQL Server Source Control and Deployment with Visual Studio

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

Introduction to SQL Server Management Objects with PowerShell

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...