Both MS SQL and PostgreSQL are popular modern DBMS with powerful capabilities. They also provide high quality administration tools and programming APIs. However, everyone who compares license terms ...

I need to copy a mass amount of tables in SQL Server to the same database (obviously renaming the tables). I need to include constraints, keys, indexes, etc, as well as data. (we need to copy an old ...

Data is stored on a NetApp providing luns that are mounted via fiber channel. So the part of DR I'm providing on my end is a server that I can mount the data from in the event of the primary server ...

With Extended Support for SQL Server 2008 and SQL Server 2008 R2 ending in July 2019, to be followed six months later by the end of Extended Support for Windows Server 2008 and 2008 R2 in January 2020 ...

Have you ever found yourself with the need to copy SQL Server logins from one server to another? It'll come in handy if you're setting up a failover site, building a replacement server, setting up a ...

Are you ready to unlock the power of Microsoft SQL Server 2014? In this blog entry I will examine my 3 favorite new features that show how SQL Server 2014 provides high-performance OLTP, optimization ...