SQL Server databases move around as an organisation’s data grows, applications are enhanced or new versions of the database software are released. If not anything else, servers become old and unreliable and databases eventually need to find a new home. Here's what to do when migrating your databases.  Read more...

This tip I will explains a step-by-step method to perform the SQL Server Log Shipping migration.  Read more...

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...

A script to generate a recovery script for setting your sa account back to the password it is using at the time of running this script.  Read more...

This article gives 20 tips how to modify MySQL views to make it compatible with Microsoft SQL Server.   Read more...

I need to move all the objects off the 2005 Reporting Server to the 2008 Reporting Server. Is there an easy way to do this without saving each report file (edit report and save .rdl) then uploading the report to the new server? This would also mean recreating the data sources and subscriptions.  Read more...

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...

Continuing from Part 1 , our Migration Checklist continues: Step 5: Update statistics It is always a good idea to update the statistics of the database that you have just installed or migrated  Read more...

It is a fact of life: SQL Server databases change homes. They move from one instance to another, from one version to the next, from old servers to new ones. They move around as an organisation’s data grows, applications are enhanced or new versions of the database software are released.  Read more...

Script Server Roles in case of migration or documentation  Read more...

We soon learn, in SQL Server, that heaps are a bad thing, without necessarily understanding how or why. Jonathan Lewis is an Oracle expert who doesn't like to take such strictures for granted, especially when they don't apply to Oracle. Jonathan discovers much about how SQL Server places data, and concludes from his experiments that heaps perform badly in SQL Server because you cannot specify a fill factor for them.  Read more...

When reloading or attaching a SQL 2000 database to SQL 2005 or 2008, the database objects are upgraded automatically. Some database options don't change, though. PAGE_VERIFY is one of them.  Read more...

This script can convert the usage of bound default objects in tables to column defaults  Read more...

This script can convert the usage of bound rule objects in tables to column check constraints  Read more...

The final part of the series will examine full text catalogs and indexing, database collation, service broker considerations, encryption and high availability.  Read more...

Part 2 of the database migration series examines setting database options, mapping database users to logins, recovery models, backups, and changing the code associated with configurations.  Read more...

Migrating a database is often a task fraught with complications, this series examines the key issues in a simple checklist.  Read more...

How to move databases from one server to another with limited downtime  Read more...

Microsoft has always been pretty good at one thing, ease on install. One of the things I always says is the greatest thing about SQL Server is any idiot can install it. The other thing I also say is the worst thing about SQL Server is any idiot can install...   Read more...

large Analysis Database migration (hundreds of gigabytes, hundreds of users and thousands of user MDX queries)  Read more...