SQL Server Interoperability

SQL Server Interoperability News

March 12, 2012 12 Mar'12
Don’t sweat migration from Oracle, Sybase to SQL Azure

Are you considering moving your database to Azure? Concerned about complexity? Read this tip from expert Denny Cherry. Migrating to SQL Azure might be the easiest move ever.
November 11, 2010 11 Nov'10
Microsoft gives tour of new release of SQL Server

Microsoft gave PASS Summit 2010 attendees a walk-through of its Denali SQL Server release, demoing its AlwaysOn, FileTable and expanded SQL Server Integration Services features.

Bring yourself up to speed with our introductory content

MySQL

MySQL is a relational database management system (RDBMS) based on SQL (Structured Query Language). Continue Reading
Microsoft SQL Operations Studio eases SQL Server admin tasks

SQL Operations Studio simplifies routine administration of SQL Server and Azure SQL databases, making database development and management easier for users who aren't full-time DBAs. Continue Reading
CORBA (Common Object Request Broker Architecture)

Common Object Request Broker Architecture (CORBA) is an architecture and specification for creating, distributing, and managing distributed program objects in a network. Continue Reading

Weigh the pros and cons of technologies, products and projects you are considering.

SQL Server 2014 features enable hybrid cloud scenarios

Microsoft continues to improve integration between on-premises data centers with Microsoft Azure. An expert looks at SQL Server 2014 features that enable hybrid cloud scenarios. Continue Reading

Learn to apply best practices and optimize your operations.

How SQL Server containers in Docker can ease database deployment

Docker containers can make the SQL Server deployment process more efficient and flexible. Here's what they are and how to get started on creating containers for SQL Server databases. Continue Reading
How to provision a SQL Server virtual machine on Azure

Basit Farooq provides two different methods for provisioning a SQL Server virtual machine on Windows Azure. He also explains the benefits of the Windows Azure virtual machine and how to migrate from on-premises to Windows Azure. Continue Reading

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

ODBC drivers replacing OLE DB? Say what?

After years of telling SQL Server users to avoid ODBC in favor of OLE DB, Microsoft has suddenly reversed its position and advised going back to ODBC. Why? And what should you do about it? Continue Reading
SSIS package to filter false records

I have a table, let's call it AlarmTriggers and it has a Boolean field pulled into it. When my software writes to it the table doesn't set the field to true. It's kept false. I want to use an SSIS package that filters all false records in the table ... Continue Reading
Performing incremental loads and extracting data

SQL Server Security Expert Joe Toscano shares source data tables designed to easily perform an incremental load / extract. Continue Reading