Microsoft SQL Server Administration

  • 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 backups? IT security specialist Kevin Beaver gives you ...  Continue Reading

  • 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 if there is a bulk-logged transaction in your backup...  Continue Reading

  • 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 Server e-book excerpt, author Hilary Cotter advises ...  Continue Reading

  • SQL Server disaster recovery: Recreating historical data

    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 options for putting the proper measures in place to ...  Continue Reading

  • 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 advantages, including sustaining additional concurrent ...  Continue Reading

  • 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 can run on a single node. Hilary Cotter walks you ...  Continue Reading