Email Alerts
-
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. News | 12 Mar 2012
-
Cloaked in secrecy, Microsoft project aims to wed SQL, NoSQL databases
Microsoft technical fellow David DeWitt is secretly developing a data management system that can do the jobs of both SQL and NoSQL databases. Can he bring the two sides together? News | 01 Mar 2012
-
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. News | 11 Nov 2010
-
PostgreSQL vs. SQL Server: PostgreSQL is right for the Microsoft stack
Is open source database PostgreSQL ready to replace Microsoft's SQL Server in the enterprise? Web application developer and author W. Jason Gilmore tackles the question in this column. Article | 17 May 2006
-
Are single-platform databases in your future?
As databases become more alike and all of them have the capability to pull data from multiple sources, dare to be different! Moving everything to a single platform can make things less complicated. Article | 12 Dec 2005
-
Data integration woes here to stay
At last week's DAMA conference, the experts told DBAs that one way to make data integration problems go away is to play really well with others. Article | 09 Feb 2005
-
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? Tip
-
Five things in SQL Server not in SQL Azure
With the excitement over the cloud, it’s easy to forget that Microsoft’s cloud database, SQL Azure, is not for everyone. Learn the five major differences between SQL Azure and SQL Server. Tip
-
Utilize SSAS for data predictions and classification using Excel
Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007. Tip
-
How to create a SQL Server linked server to DB2
Many SQL Server environments run DB2 servers, too, and often the two servers must be linked. Here's a step-by-step process that shows how to create a SQL Server linked server using Microsoft's DB2 driver. Tip
-
Microsoft Access 2007 integration with SQL Server
Microsoft Access 2007 introduces new features to boost integration with SQL Server. Tip
-
Lessons Learned: Working with Oracle stored procedures, applications and data
Whether you're trying to execute an Oracle stored procedure on SQL Server or move data from one DBMS to another, you'll find troubleshooting advice in this collection of short lessons by Kevin Kline, our resident SQL Server Monitoring/Administration ... Tip
-
Converting a DB2 date to SQL Server
Here's how to enter a DB2 date in the format '0001-01-01' as a date in Microsoft SQL Server. Tip
-
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 a... Ask the Expert
-
Efficiently push and pull data in SQL Server
What is the most efficient way to 'PUSH' data from Sybase to MS SQL Server or 'PULL' data into MS SQL Server from Sybase? Ask the Expert
-
Flat file import not working on 64-bit systems
Is SSIS on 64-bit systems any different from SSIS on 32-bit systems? I am trying to import a flat file in 64-bit systems, and SQL Server is throwing an exception, yet on 32-bit systems it is working fine. Ask the Expert
-
Manipulating users' rights at row level in SQL Server 2005
Integration Services/Development expert Joe Toscano addresses how to manipulate users' rights at row level in SQL Server 2005. Ask the Expert
-
Permissions problem connecting to SQL Server with Excel and VBA
Connecting to SQL Server with Excel and VBA could be a permissions issue and the user should first ensure the login is mapped to a valid database. Ask the Expert
-
Performing incremental loads and extracting data
SQL Server Security Expert Joe Toscano shares source data tables designed to easily perform an incremental load / extract. Ask the Expert
-
Handling metadata processes for SSIS projects
Learn how to capture info for data transformation in this DTS package that appends data to an audit table. Ask the Expert
-
Tools and technique to move SQL Server data to Oracle
Once you have the necessary tools to create a Data Source Name (DSN) which provides the Oracle connectivity details, you can specify Oracle as the destination in your DTS package and start moving. Ask the Expert
-
Connecting a Oracle9i Forms application to SQL Server
There is no easy way to connect an Oracle9i Forms application to a SQL Server database – but Kevin Kline offers some approaches to take if you must make the two work together. Ask the Expert
-
How can I transfer data from a SQL server to a mainframe without using FTP?
How can I transfer data from a SQL server to a mainframe without using FTP? I have an extremely large amount of data to transfer and FTP takes too long. Ask the Expert
-
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. Definition
-
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? Tip
-
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. News
-
Cloaked in secrecy, Microsoft project aims to wed SQL, NoSQL databases
Microsoft technical fellow David DeWitt is secretly developing a data management system that can do the jobs of both SQL and NoSQL databases. Can he bring the two sides together? News
-
Five things in SQL Server not in SQL Azure
With the excitement over the cloud, it’s easy to forget that Microsoft’s cloud database, SQL Azure, is not for everyone. Learn the five major differences between SQL Azure and SQL Server. Tip
-
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. News
-
Utilize SSAS for data predictions and classification using Excel
Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007. Tip
-
How to create a SQL Server linked server to DB2
Many SQL Server environments run DB2 servers, too, and often the two servers must be linked. Here's a step-by-step process that shows how to create a SQL Server linked server using Microsoft's DB2 driver. Tip
-
Microsoft Access 2007 integration with SQL Server
Microsoft Access 2007 introduces new features to boost integration with SQL Server. Tip
-
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 a... Ask the Expert
-
Efficiently push and pull data in SQL Server
What is the most efficient way to 'PUSH' data from Sybase to MS SQL Server or 'PULL' data into MS SQL Server from Sybase? Ask the Expert
- See More: All on SQL Server Interoperability
About SQL Server Interoperability
Many businesses store data across heterogeneous database servers or in various storage systems, formats and locations. Database adminsitrators using Microsoft SQL Server with other platforms often need to resolve these dissimilarties for the data to be used. This topic page provides help overcoming SQL Server interoperability issues, with tips on using SQL Server with other database management systems (DBMS) such as Oracle and MySQL.