Maintenance, Roles, Administer, Partial Bkp of a Read-only DB & Naming Standards
Maintenance Plans
Roles
Administer Servers
Partial Bkp of a Read-only DB
Lesson 2: Create and Apply a Naming Standards Policy
Any query will be considered.
T. Amit Vaid S.
2 comments:
Checkpoints
A checkpoint writes the current in-memory modified pages (known as dirty pages)
https://learn.microsoft.com/en-us/sql/relational-databases/logs/database-checkpoints-sql-server?view=sql-server-ver16
Metrics for Performance
https://learn.microsoft.com/en-us/sql/relational-databases/performance/performance-monitoring-and-tuning-tools?view=sql-server-ver16
Standard Edition
https://www.microsoft.com/en-gd/d/sql-server-2022-standard-edition/dg7gmgf0m80j
Default Port 1433
IP address 127.0.0.1 is probably listed. It's called the loopback adapter address.
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/network-related-or-instance-specific-error-occurred-while-establishing-connection
CREATE MASTER KEY
https://learn.microsoft.com/en-us/sql/t-sql/statements/create-master-key-transact-sql?view=sql-server-ver16
Choose Function
https://learn.microsoft.com/en-us/sql/t-sql/functions/logical-functions-choose-transact-sql?view=sql-server-ver16
Imp. Waittype
PWAIT_HADR_CHANGE_NOTIFIER_TERMINATION_SYNC
HADR_LOGCAPTURE_SYNC
VDI_CLIENT_COMPLETECOMMAND
CHANGE_TRACKING_WAITFORCHANGES
Internal Use Only
Post a Comment