When performance tuning your database server or database server environment.  It is important to look at tempdb growth settings.  When tempdb grows it halts server operations and in some cases this could be very costly.  Use the script provided below to query your database farm and then set the original size to something greater than

Read more…

Microsoft’s Management Data Warehouse Management Data Warehouse Terms are here check them out first as the article will use that terminology. Managed Instance Requirements: SQL Server must be version 10.50 or higher. The SQL Server instance type must be Database Engine. The SQL Server Utility must operate within a single Windows domain, or across domains

Read more…

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…

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

Read more…

Seems silly, but sometimes we forget how to do the simple stuff: How to remove standby/read-only from log shipped database. Considerations: The secondary (warm) server in a log shipping configuration can either be inaccessible or read-only. Answer: When the “source” database in a log shipping configuration fails, some steps are necessary to bring the log

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…