SQL Server Administration and Maintenance

Installation, configuration, automation, health checks, and governance controls.

301 associated posts140 primary posts

DBA 101: The Always-On Workstation

DBAs need an in-office computer to run overnight and weekend performance logs, traces, and long-running queries. For example, let's say you need to run a long series of maintenance queries to rebuild indexes over the weekend. You shouldn't be remote-desktopping into your production servers to run this query: instead, you just need a simple workstation that you can leave logged-in, with the desktop locked, that runs the query.

Read more about DBA 101: The Always-On Workstation 2 comments — Join the discussion