Due to my background working with other major database platforms such as Oracle, MySQL, and PostgreSQL, I’ve long been an advocate for the SQL Server Migration Assistant (SSMA). This powerful and easy ...

As SQL Server 2008 and 2008 R2 reach the end of support in 2019, you’ll have an opportunity to upgrade to a cloud database service. Follow this step-by-step guide to manage change effectively as you ...

My last couple of months have been filled with a major migration to Microsoft Azure for a client, who has both a very large data warehouse and an online transaction processing (OLTP) Web site. In all, ...

Oracle has announced the general availability of Oracle SQL Developer Release 1.2 that features new capabilities to ease the migration and consolidation of third-party databases onto Oracle Database ...

As an IT professional working for a small to mid-sized organization you are not only in charge of the servers, desktops, firewalls, routers, switches and mobile devices… you’re the chief, cook and ...

Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...

1. Change registry key SqlCluster in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\Setup\ from 1 to 0 2. Disable TCP/IP in Server Network Protocols and enabled Named Pipes from ...

On August 30, Microsoft announced the public preview of the Azure Database Migration Service (DMS) to support online migrations of various databases to Azure. What’s an “online migration”? Online ...

Microsoft offers two paths for running enterprise databases: SQL Server, which you install and manage yourself, and Azure SQL, which Microsoft runs for you as a managed service. Both use the same ...

Percona, a provider of open source database software and services, today announced a partnership with HexaCluster, a PostgreSQL migration and services specialist, to help organizations move off ...