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
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,
To initialize a secondary database in a log shipping configuration use the code below. This will leave the database in a read_only state waiting for future logs from the primary database. Modify the areas in bold to fit your needs. USE MASTER GO RESTORE DATABASE [db_name] FROM DISK = N’D:LogShipping_tempdb_name_xxxxx.bak’ WITH FILE = 1, STANDBY
@SQLMarksmen, Here is a piece of code I use to check for SQL injection. You can plug this into a generic function or place it in the body of your procedure usually near the top of the procedure. I usually check all CHAR, NCHAR, VARCHAR & NVARCHAR parameters. Remember that in some cases you may
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:
