Daily Series: SQL Server DBA tips

In questa serie di posts Ted Krueger riporta i principali “tips” per chi amministra SQL Server.

SQL Server DBA Tip 1 – Server Configuration – MAX Memory
SQL Server DBA Tip 2 – Server Configuration – Data/Log Files
SQL Server DBA Tip 3 – Server Configuration – Model Database
SQL Server DBA Tip 4 – Server Considerations – 32 bit / 64 bit
SQL Server DBA Tip 5 – Server Considerations – Installing Features (SSIS, SSRS, Engine, SSAS)
SQL Server DBA Tip 6 – Server Security – Windows Authentication / SQL Authentication
SQL Server DBA Tip 7 – Server Security and grouping – Schema Control
SQL Server DBA Tip 8 – Server Monitoring – Baseline
SQL Server DBA Tip 9 – SQL Server Monitoring – Default Trace
SQL Server DBA Tip 10 – SQL Server Reporting – Offload the reporting factor
SQL Server DBA Tip 11 – SQL Server Configuration – MIN Memory
SQL Server DBA Tip 12 – SQL Server Tuning – Missing Index DMV
SQL Server DBA Tip 13 – SQL Server built in DR/HA Solutions
SQL Server DBA Tip 14 – SQL Server General – Updating Production Data
SQL Server DBA Tip 15 – SQL Server Agent – Job ownership
SQL Server DBA Tip 16 – Working with Files and Folders