So you are running SQL Server (2005 or 2008) Express (presumably installed as part of an application server install) and you would like to make sure your databases are backing up each night. You go to load the SQL Server Management Studio only to discover it’s not there. So then you head on over to…
Read On…
This post is aimed at home users, but the ideas are sound for business as well. If you’re like me, you’ve reached a point where most of your must-have information and data is in digital form. Whether its photos, music (commercial or self-created), financial records or documents, all my important data is virtual. That is,…
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…