Ramblings of a DBA

Tara Kizer
posts - 166, comments - 837, trackbacks - 75

My Links



Search this Blog


Post Categories


February 2009 Blog Posts

SQL Server 2008 System Views Map

Microsoft published the ERD for the system views about a month ago, but I'm just now seeing it.  It is available in PDF or XPS format.  You can download them here.

posted @ Friday, February 27, 2009 10:53 AM | Feedback (1) | Filed Under [ SQL Server - General SQL Server - Database Administration ]

How to refresh a SQL Server database automatically

As a DBA, we are often asked to refresh a database, which means to overwrite an existing database using a different database's backup.  If you are rarely asked to do this, you may decide to do it manually.  If you are asked to do this on a regular and perhaps scheduled basis, then you'd want to automate it.  Developers often want to write and debug code against a copy of the production database, so it makes sense to refresh their databases on a daily or weekly basis.  If you were to do the refresh manually, you would probably follow these...

posted @ Wednesday, February 25, 2009 12:32 PM | Feedback (8) | Filed Under [ SQL Server - Database Administration ]

Powered by:
Powered By Subtext Powered By ASP.NET