Windows 2016数据中心版:部署SQL Server 2019开发版与配置教程

版权申诉
9 下载量 78 浏览量 更新于2024-09-11 收藏 1.28MB PDF 举报
本文档详细介绍了如何在Windows 2016数据中心版服务器上安装和配置SQL Server 2019数据库。首先,对于学习用途,作者建议使用阿里云的学生服务器,因为该环境与个人电脑的安装过程相似。安装步骤如下: 1. **下载安装程序**: - 从微软官网或作者提供的天翼网盘(访问码sji5)下载SQL Server 2019的安装文件,推荐选择SQL2019-SSEI-Dev开发版,因为它是免费的。 2. **安装过程**: - 运行安装文件,选择“自定义”安装方式,按照向导指示,选择“Developer”版本。 - 勾选数据库引擎,根据实际需求选择其他组件。 - 自定义服务器名或接受默认,选择“混合模式”,并设置管理员密码。 3. **配置服务**: - 在安装完成后,打开SQL Server配置管理器,找到新创建的实例,启用TCP/IP协议,并将默认端口(如1433)修改为所需的值,例如1433。 4. **防火墙设置**: - 对于阿里云服务器,需要进入控制台,调整防火墙规则,确保1433端口对外暴露。如果是轻量应用服务器,可能需要添加安全组;如果是ECS,需操作安全组设置。 5. **客户端工具**: - 下载并安装SQL Server Management Studio (SSMS),可以从微软官网获取,也可以通过作者提供的天翼云盘(访问码7uz2)下载。 6. **连接数据库**: - 使用客户端,通过服务器IP地址、1433端口、登录名(sa)、以及之前设置的密码来连接到数据库服务器。 总结来说,本文提供了一套完整的Windows 2016数据中心版服务器上安装和配置SQL Server 2019数据库的步骤,包括下载、安装、配置网络服务、防火墙设置和客户端连接,适用于学习和个人开发环境。通过遵循这些步骤,用户可以顺利搭建并管理自己的SQL Server数据库。
2017-03-26 上传
SQL Server 2016 Developer's Guide by Dejan Sarka English | 22 Mar. 2017 | ASIN: B01MS5L01Q | 616 Pages | AZW3 | 16.98 MB Get the most out of the rich development capabilities of SQL Server 2016 to build efficient database applications for your organization About This Book Utilize the new enhancements in Transact-SQL and security features in SQL Server 2016 to build efficient database applications Work with temporal tables to get information about data stored in the table at any point in time A detailed guide to SQL Server 2016, introducing you to multiple new features and enhancements to improve your overall development experience Who This Book Is For This book is for database developers and solution architects who plan to use the new SQL Server 2016 features for developing efficient database applications. It is also ideal for experienced SQL Server developers who want to switch to SQL Server 2016 for its rich development capabilities. Some understanding of the basic database concepts and Transact-SQL language is assumed. What You Will Learn Explore the new development features introduced in SQL Server 2016 Identify opportunities for In-Memory OLTP technology, significantly enhanced in SQL Server 2016 Use columnstore indexes to get significant storage and performance improvements Extend database design solutions using temporal tables Exchange JSON data between applications and SQL Server in a more efficient way Migrate historical data transparently and securely to Microsoft Azure by using Stretch Database Use the new security features to encrypt or to have more granular control over access to rows in a table Simplify performance troubleshooting with Query Store Discover the potential of R's integration with SQL Server In Detail Microsoft SQL Server 2016 is considered the biggest leap in the data platform history of the Microsoft, in the ongoing era of Big Data and data science. Compared to its predecessors, SQL Server 2016 offers developers a unique opportuni