Use this script to create an SSRS report that will display all database(s) restored on one server. Alternatively, you may create a database and run an SSIS package that loads every day’s results into a location where you can run reports against that data. This is often called a “Meta data repository”. Read the rest

Read more…

Source Article: http://www.dbafarm.com/ PowerShell Copy Backup to network share Seems simple, but it’s not. I tried the following scenarios: 1. Local copy 2. Copy to share 3. Copy to share on different domain 4. Copy to admin share *Note : this script can also Mirror the source and destination– just like the /Mir robocopy switch,

Read more…

A time dimension is something you should not have to create on a nightly or incremental basis during execution of the existing data warehouse ETL.  Instead, here is some SQL to generate a time dimension for you.  Modify it as needed to suit your needs. /* Author/Co-author:Lawrence Patrick Email: [email protected] Object: SQL code; none Description:

Read more…