Access and Nonproduction Data Practices

Operational access, production-data handling, and safe nonproduction practices.

22 associated posts19 primary posts

Production DBA

Dev, Test and Production SQL Server Environments

In a perfect world, my test/QA servers get restored nightly from production. Let's say every night at 9pm, the production full backups kick off, and they're finished by 10pm. At 11pm, the QA box kicks off a restore job that grabs the latest full backups off the file share and restores them. The production backups are written to a file share, never local storage, so there's no additional overhead on the production box for this restore process.

Read more about Dev, Test and Production SQL Server Environments 91 comments — Join the discussion

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