Sometime back one of my friends was asking about upgrading SQL Server 2008 R2 Express to SQL Server 2012 Express. As you may know, the SQL Express edition is free and is often used for smaller database applications and most times there are not full-time
In most environments there may be a need to do an in place version or edition upgrade for an existing SQL Server installation. Microsoft makes this easy using the Edition Upgrade feature and in this tip we walk through the steps on how to do an upgrade t
Peer-to-peer replication can help scale out an application and implement high availability and in this tip we look at an overview of P2P replication.
One of my clients asked me about implementing a High Availability option for his organization. They are using SQL Server 2008, so I told him we should evaluate each of the High Availability options that can be implemented for SQL 2008. I also recommended
Recently I did a migration for SQL Server 2008 from another platform. When I converted the database schema to SQL Server, I faced a problem converting TIMESTAMP to SQL Server. In MySQL/DB2, Timestamp is a datetime field. It is used to track changes to a
One of my clients contacted me about replicating data to non SQL Server databases. My client has a new business partner whose application runs on an Oracle database. Part of the business deal is to replicate data between the two environments. We are alr
One of my client’s requirements is to migrate and consolidate his company departments’ databases to SQL Server 2008. As I know the environment, they are using MySQL , MS-Access and SQL Server with different applications. Now the company has decided to hav