Tips

  • SQL Server disaster recovery: Recreating historical dat

    Recovering historical data in your SQL Server environment is a painstaking project. Yet, best practices tell us to have a recovery plan in place. Edgewood Solutions' Greg Robidoux shares three opti...

  • SQL Server 2005 Service Pack 2 debugs and adds features

    SQL Server SP2 goes beyond your routine bug fixes. Like SP1, the latest service pack adds features: For one, the new sp_configure flag gets SQL Server 2005 tested by the common criteria organizatio...

  • 32-bit vs. the 64-bit SQL Server performance surge

    The 64-bit platform in SQL Server is setting a new computing standard. Will you make the leap from 32-bit to 64-bit? Contributor Serdar Yegulalp compares the two editions and highlights 64-bit adva...

  • Active/Active clusters in SQL Server

    Multi-instance, or Active/Active SQL Server cluster design is an involved process. To optimize high availability and performance, you must consider a number of components in ensuring both instances...

  • Upgrade to SQL Server 2005 and maintain older database

    Upgrading to SQL Server 2005 may cause you some initial trepidation. You'll want to maintain your databases in old faithful (SQL Server 2000) while your new system proves reliable. Contributor Mich...

  • SQL Server query design: 10 mistakes to avoid

    SQL Server queries should guide you toward successful, trouble-free data retrieval. Edgewood Solutions' Jeremy Kadlec has put together a Top 10 list of query design mistakes to avoid, including tes...

  • Extend SSIS packages with scripting and programming

    SQL Server Integration Services brings new meaning to importing data, compared to DTS. Microsoft also offers two methods of extending SSIS functionality. Contributor Serdar Yegulalp shares how to e...

  • SQL Server change management tools

    Database change management can be an agonizing task for SQL Server developers. Eric Brown, a SQL Server developer and expert, walks you through three useful tools. Learn why using database backup, ...

  • SQL Server backup encryption for improved security

    SQL Server offers many approaches to securing your database backup files, and the contents of those files. You can create backup passwords and/or encrypt stored procedures. Edgewood Solutions' Greg...

  • Logging for security compliance in SQL Server

    Logging for security compliance in SQL Server can be tricky. Recommendations come from all directions: vendors, auditors and lawyers. As a SQL Server administrator, it's your job to determine what'...

  • SSIS programming basics

    SSIS is more than a tool to move data around in SQL Server 2005. It creates a system where the data sets that you import and the packages you create are programmatic objects that can talk to one an...

  • Boost data warehouse performance

    Boost SQL Server data warehouse performance with these tips on improving query performance by expert Jeremy Kadlec.

  • Speed up SQL Server backup and restore time

    Backup and restore are perhaps the most critical tasks you'll run on SQL Server. They should run in minimal time as they both utilize system resources. In fact, restores require exclusive access to...

  • SSIS maintenance plans in SQL Server 2005

    Using SSIS packages for your maintenance plans in SQL Server 2005 allows for greater flexibility to customize tasks and also provides an execution history for less difficult troubleshooting.

  • T-SQL and PL/SQL common languages for database-independ

    Common languages in T-SQL and PL/SQL exist to allow developers to write applications in database-independent environments. Common languages and interfaces such as ANSI and ODBC offer solutions to t...

  • Disaster recovery in SQL Server: What your plan should

    Disaster recovery in SQL Server relies on three components: people, processes and technology. Your failover and failback solutions must minimize SQL Server data loss. Edgewood Solutions' Greg Robid...

  • Segregating data for optimum parallelization

    SQL Server performance and manageability improve with data parallelization. But there's more to parallelization than running multiple processors and queries. Contributor Serdar Yegulalp details how...

  • Surface Area Configuration and other security tools in

    SQL Server 2005 has improved security compared to that of its predecessor. By using the Surface Area Configuration (SAC) tool you can reduce your SQL Server surface area and limit gateways for atta...

  • Recover lost SQL Server data

    Data recovery success in SQL Server depends on your failover method in place. Failover options range from a simple backup and restore process to the highly sophisticated clustering model. Edgewood ...

  • Database access for SQL Server business and reporting u

    SQL Server business users and reporting users have a common goal: a successful business. Their roles, however, are different as they compete to capture data. To successfully report against transact...