当你有一个新的服务器需要部署的时候,如果没有部署过的经验很可能会走很多误区,并且给以后的维护工作加大难度,我在这就把我部
当你有一个新的服务器需要部署的时候,如果没有部署过的经验很可能会走很多误区,并且给以后的维护工作加大难度,我在这就把我部署服务器的一些经验跟大家分享一下。
1、登陆服务器以后先将物理盘按照64k为分配单元格式化一下。
因为sqlserver的数据是按页存储的,一个页是8k,8个页正好是一个区也就是64k,这个大家都懂的(我承认我没有测试过实际的效果这么做到底有没有用)。
2、修改服务器名。
最好将机器名修改成一看机器名就知道是哪个业务,在哪个机房,哪台机器。尽量不要用默认的,这个对以后用ssms查询或者各种服务器之间交互很有好处的。
修改机器名我记得是要重启的(这个好久没弄了,记不清了- -),当你已经装了sqlserver服务再去修改机器名,数据库默认使用的还是以前的机器名,还得执行命令修改,,所以最好还是在刚接手服务器时候改好,省的给以后找麻烦。
3、修改服务器密码。
最好同时开2个远程窗口A和B,使用A窗口修改密码然后点保存关闭连接以后,再新打开一个远程桌面输入新改好的账号密码试试对不对。(保留B窗口是因为如果你A窗口修改密码不对这时候你还有机会通过B窗口重新修改 )。
4、注意看下控制面板里边的os的默认的语言是什么。
这个会影响到你安装sqlserver的默认排序规则的。
5、ipconfig一下看下是否给你分配了你想要的内外网ip,ip有没有配错。
6、如果你不想用sqlserver的默认端口,记得提前在防火墙里给对应的端口加上规则。
-------------------------------------------------------------------------------
以上就是我部署服务器的一些经验了,水平不高,技术有限,写出来就是跟大家分享一下,如果有错误和需要补充的地方欢迎指出。
本文永久更新链接地址:

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

Article discusses strategies for handling large datasets in MySQL, including partitioning, sharding, indexing, and query optimization.

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]

The article discusses dropping tables in MySQL using the DROP TABLE statement, emphasizing precautions and risks. It highlights that the action is irreversible without backups, detailing recovery methods and potential production environment hazards.

The article discusses creating indexes on JSON columns in various databases like PostgreSQL, MySQL, and MongoDB to enhance query performance. It explains the syntax and benefits of indexing specific JSON paths, and lists supported database systems.

Article discusses using foreign keys to represent relationships in databases, focusing on best practices, data integrity, and common pitfalls to avoid.

Article discusses securing MySQL against SQL injection and brute-force attacks using prepared statements, input validation, and strong password policies.(159 characters)


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

Atom editor mac version download
The most popular open source editor

Dreamweaver Mac version
Visual web development tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 English version
Recommended: Win version, supports code prompts!
