March 2009 | Archive by Month | SearchSQLServer.com

March 2009

  • Testing a SQL Server environment before an upgrade

    Learn how application and full regression testing can ensure a successful SQL Server upgrade – and save on money and performance headaches.30 Mar 2009

  • SQL Server Consolidation Fast Guide

    This short guide features resources for those looking to learn more about SQL Server consolidation, with details on when (and when not) to consolidate, strategies, best practices and more.25 Mar 2009

  • SQL Server consolidation strategies and best practices

    Several consolidation options are available for managers and DBAs who are looking to cut costs. Learn about some of these strategies and when to use them along with details on the benefits of SQL S...25 Mar 2009

  • Sharing SSAS cube data in SharePoint with PerformancePoint Server 2007

    Microsoft PerformancePoint Server 2007 turns SQL Server Analysis Services cube data into scorecards and dashboard applications that can be read company-wide in Microsoft SharePoint.23 Mar 2009

  • tablespace

    In a database management system (DBMS), a tablespace is a logical group of data files in a database. A typical database contains at least one tablespace, and usually two or more. In a database, a...19 Mar 2009

  • Choosing a SQL Server disaster recovery solution

    Determining your goals is the first step to selecting a disaster recovery technology. Here's how to weigh the pros and cons of the myriad options depending on your business requirements.18 Mar 2009

  • Examining data files when SQL Server tempdb is full

    If your SQL Server tempdb database is full, the data files could be the cause. Find out how to use the SQL Server process ID number, along with T-SQL queries, to find the source of any unexpected g...16 Mar 2009

  • Loading data files with SQL Server's BULK INSERT statement

    The BULK INSERT statement enables the bulk-loading of data files into SQL Server databases. Get instructions on how to use it, along with details on the FIELDTERMINATOR and CHECK_CONSTRAINTS options.11 Mar 2009

  • DBSync for MS FoxPro & MS SQL

    DBSync for MS FoxPro & MS SQL performs MS FoxPro-to-SQL and MS SQL-to-FoxPro database conversion and synchronization.06 Mar 2009

  • DBSync for MS Access & MS SQL

    DBSync for MS Access & MS SQL performs Microsoft Access to SQL Server and SQL Server to Microsoft Access database conversions and synchronization.06 Mar 2009

  • DBConvert for MS SQL & PostgreSQL

    DBConvert for MS SQL & PostgreSQL allows for data conversion from SQL Server to PostgreSQL and from PostgreSQL to SQL Server databases.06 Mar 2009

  • DBConvert for Access & MS SQL

    DBConvert for Access & MS SQL allows for the conversion from Microsoft Access databases to SQL Server and from SQL Server databases to Microsoft Access.06 Mar 2009

  • DBConvert for MS FoxPro and MS SQL

    DBConvert for MS FoxPro and MS SQL converting data from MS FoxPro databases to MS SQL server and from SQL servers to FoxPro databases.06 Mar 2009

  • DBForms from MS Access to ASP.NET+MS SQL

    DBForms from MS Access to ASP.NET + MS SQL converts Microsoft Access databases and tables to MS SQL databases.06 Mar 2009

  • DBSync for MS SQL & MySQL

    DBSync for MS SQL & MySQL performs SQL-to-MySQL and MySQL-to-SQL database conversion and synchronization.06 Mar 2009

  • DBConvert for MS SQL & MySQL

    DBConvert for MS SQL & MySQL allows for the conversion from MySQL databases to SQL Server and from SQL Server databases to MySQL servers.06 Mar 2009

  • PowerSQL

    PowerSQL improves productivity and reduces errors for SQL development for Eclipse application developers.06 Mar 2009

  • Does upgrading to SQL Server 2008 fit your business?

    While SQL Server 2008 offers several new benefits for organizations, the trick is figuring out if those performance and availability advantages are truly worth the upgrade.04 Mar 2009

  • Microsoft SQL Server Integration Services primer

    In this chapter excerpt from "SQL Server 2008 Integration Services Unleashed", learn what's included with SSIS and how developers and database administrators can use these utilities to improve perf...02 Mar 2009

  • A short history of SQL Server Integration Services

    In this chapter excerpt from "SQL Server 2008 Integration Services Unleashed", learn more about how SQL Server Integration Services evolved from Data Transformation Services into a fully functional...02 Mar 2009