Problem solve

SQL Server Interoperability

• Scale out with Windows Azure SQL Database

  Scaling out Azure SQL doesn't have to be a painful process. Microsoft Windows expert Bob Sheldon shows you an easier way with Azure SQL federations.Continue Reading

• 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

• 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.Continue Reading

• 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.Continue Reading

• Microsoft Access 2007 integration with SQL Server

  Microsoft Access 2007 introduces new features to boost integration with SQL Server.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

• 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.Continue Reading

• 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?Continue Reading

• 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.Continue Reading

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

• 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.Continue Reading

• 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.Continue Reading

• 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.Continue Reading

• 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...Continue Reading