z***y
发帖数: 7151 | 1 欢迎大家补充。
T-SQL
● Tools for the DBA
● Development
○ SPs
○ Triggers
○ Functions
○ CTEs
○ Temporary objects
Installations and patching
● Standalone
● Cluster
SQL Server Upgrades
● Standalone
● Cluster
Configuration Best Practices
● Database files placement
● Tempdb configuration
● Lock PAGES in memory
● Memory configurations
Performance tuning high level (how to)
● Indexes
● Execution plans
● DMVs
● Performance Counters
● Database design
● Parallelism
● Compilation/
● recompilations
Security
● Logins
● Users
● Schemas
● Roles
Backup & Recovery
Maintenance plans
● Index defrag
● Integrity checks
● Update stats
● Errorlog recycling
● Purge history from msdb
High Availability/ Disaster Recovery (planning and recommendations)
● Clustering
● Log Shipping
● Database Mirroring
● Database Snapshots
● Replication
● P2P Replication
Very large databases (> 1TB)
● Backup strategy
● Maintenance
● Table Partitioning
● DR
SSRS
SSIS
SSAS | s**********o
发帖数: 14359 | | B*****g
发帖数: 34098 | 3 你赶紧给转到CINASSUG
【在 s**********o 的大作中提到】
: very large好像在4TB以上了吧
| s**********o
发帖数: 14359 | 4 有人转了
【在 B*****g 的大作中提到】
: 你赶紧给转到CINASSUG
| e****7
发帖数: 4387 | 5 不错
随便加几个中用不中用的
transaction log，recovery mode, compatibility level, Service broker,
migration strategy
tools 里
redgate据说不错，
vs 也有些不错的utility, 例如schema compare。db project 还行。 |
|
