Install and configure
Plan installation
Evaluate installation requirements;
design the installation of SQL Server and its components (drives, service accounts, etc.);
plan scale-up vs. scale-out basics;
plan for capacity, including if/when to shrink, grow, autogrow, and monitor growth;
manage the technologies that influence SQL architecture (for example, service broker, full text, scale out, etc.);
design the storage for new databases (drives, filegroups, partitioning);
design database infrastructure;
configure a SQL Server standby database for reporting purposes;
Windows-level security and service level security;
Core mode installation;
benchmark a server before using it in a production environment (SQLIO, Tests on SQL Instance);
choose the right hardware
Install SQL Server and related services
Test connectivity; enable and disable features;
install SQL Server database engine and SSIS (not SSRS and SSAS);
configure an OS disk
Implement a migration strategy
Restore vs detach/attach;
migrate security;
migrate from a previous version;
migrate to new hardware;
migrate systems and data from other sources
Configure additional SQL Server components
Set up and configure all SQL Server components
(Engine, AS, RS and SharePoint integration) in a complex and highly secure environment;
configure full-text indexing;
SSIS security;
filestream;
filetable
Manage SQL Server Agent
Create, maintain, and monitor jobs;
administer jobs and alerts;
automate (setup, maintenance, monitoring) across multiple databases and multiple instances;
send to "Manage SQL Server Agent jobs"
|