SQL Server Administration and Maintenance

SQT08 The Creepy DBA, How to Stalk Your Users


11:00am - 12:15pm

Level: Intermediate

Jason Strate

Database Architect

Pragmatic Works

Do you know when your users are using the production login accounts from their workstations? Are you aware of changes being made to the development servers that may impact future deployments? Has the new Junior DBA start giving out access like candy? As DBAs, we are responsible for knowing and acting on all of this and much more. Fortunately, SQL Server provides a number of features that you can use to monitor and track user activity. In this session, we'll look at these features and demonstrate how you can use them to the extent that your users find you creepy!

You will learn:

  • Define the responsibilities required of DBAs
  • Discuss methods to monitor activity on SQL Servers
  • Demonstrate tools available to "stalk" your users