SQL Server Interoperability
New & Notable
Free Resource: Hive vs. Spark vs. Presto
While SQL is the common langue of many data queries, not all engines that use SQL are the same—and their effectiveness changes based on your particular use case. So what engine is best for your business to build around? Compare Hive, Spark, and Presto to see which is best for you.
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.
SQL Server Interoperability Get Started
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
Evaluate SQL Server Interoperability Vendors & Products
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
Manage SQL Server Interoperability
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
Problem Solve SQL Server Interoperability Issues
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