If you break permission inheritance on your SQL backup folder, and if you have a maintenance plan that uses subfolders to backup your databases by name, you could render your Maintenance Cleanup Task inoperable. If you encounter this problem, you probably noticed that the cleanup task appears to run successfully, but in reality it doesn’t…
Read On…
As part of an internal security review, I put together the following best practices guideline to secure SQL servers. This is just an example, and is not meant to be a comprehensive list of SQL server security parameters. DATABASE CREATION AND CHANGES New databases must be requested using a SQL database request form with proper…
Read On…
Change tracking, resource allocation and security auditing are three very important issues for any IT administrator, particularly DBAs (database administrators). One item that can easily be overlooked is at the point of database creation. Why is the database needed? Who is requesting it? Will the database be used for production or testing/development? What are the…
Read On…