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 ...

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 ...

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 ...

Brien M. Posey is a freelance technical writer who has contributed to dozens of books and is a six-time Microsoft MVP award winner. SQL Server 2005 reaches its end-of-life milestone on April 12, the ...