January 2007

  • 32-bit to 64-bit SQL Server migrations

    Migrating from 32-bit to 64-bit in SQL Server is an involved process, but you can build a bridge away from any 32-bit dependencies. Serdar Yegulalp discusses 32-bit and 64-bit platform issues inclu...31 Jan 2007

  • About SearchSQLServer.com

    29 Jan 2007

  • Replicated stored procedure options with SQL Server 2005

    Replicating stored procedures between SQL Server environments is a process for which you have many technologies to choose from, including native replication features, log shipping and manual and au...29 Jan 2007

  • RAID configurations for data recovery in SQL Server

    RAID configurations for data recovery in SQL Server is key defense strategy. Learn about this redundancy hardware approach, including RAID level options, RAID configurations and steps to take from ...25 Jan 2007

  • Microsoft Access 2007 integration with SQL Server

    Microsoft Access 2007 introduces new features to boost integration with SQL Server.19 Jan 2007

  • Clustered and non-clustered indexes in SQL Server

    Rules for using a clustered index vs. a non-clustered index are tough to decipher. In this tip, you'll see the fundamentals to consider when making your choice, along with some best practice techni...18 Jan 2007

  • Troubleshoot SQL Server queries and improve I/O

    SQL Server performance success often relies on I/O activity. Edgewood Solutions' Jeremy Kadlec first takes you through the steps applying Performance Monitor to troubleshoot I/O problems. A poorly ...16 Jan 2007

  • Top products named for SQL Server

    Quest Software's LiteSpeed for SQL Server 4.6 took the Gold for backup and recovery along with SQL Sentry Event Manager Enterprise Edition v2.7 for performance. Tableau v2.0 earned the top spot fo...15 Jan 2007

  • Database security policies to think about

    Government and industry regulations are tightening up on information security policies. Is it time to update your organization's database security beyond basic policies for passwords and data backu...08 Jan 2007

  • SQL Server bulk-logged recovery

    Minimal space requirements for transaction logs and best performance for bulk operations are among the advantages to the bulk-logged recovery model in SQL Server. However, one disadvantage is that ...03 Jan 2007

  • Data cleansing techniques in SQL Server

    Data that is collected and used for decision-making purposes must be accurate from the start in your SQL Server environment. Refer to this checklist of data cleansing techniques and ensure data acc...02 Jan 2007

  • SQL Server consolidation: Why, when and how to consolidate SQL Servers

    To get control of SQL Server sprawl, you must consider consolidation. This new SearchSQLServer.com expert e-book, Consolidate SQL Servers for availability, scalability and cost savings, by SQL Server...02 Jan 2007

  • Testing your SQL Server consolidation environment

    A SQL Server consolidation testing environment must have a number of factors in place to reap representative results. You must consider SANs, disk and array, CPUs, memory and network. In this SQL S...02 Jan 2007