ADVICE: >> Restoring a database from another SQL Server TIP :Restoring a database from another SQL Server is simple -- matching up the logins and users again is not. Get the steps you ... >> Hacker's-eye view of SQL Server TIP :This tip outlines the four primary methods used to hack into SQL Server and offers defenses to prevent such security ... >> SQL Server performance tuning worst practices TIP :Here are some recommendations for correcting SQL Server performance tuning worst practices and improving overall system ... >> Selecting a SQL Server recovery model TIP :SQL Server 2000 offers three recovery models: full recovery, simple recovery and bulk-logged Recovery. Greg Robidoux ... >> Selecting a SQL Server backup model TIP :Greg Robidoux looks at some of the components to help define a backup strategy as well as the different backup options that ... >> Stored procedure: List SQL Server database objects by selected type(s) TIP :Brian Walker presents a simple stored procedure to return a list of all the objects of selected types in the current ... >> Top 10 new features in SQL Server 2005 TIP :From programming to administrative capabilities, SQL Server 2005 enhances many existing SQL Server 2000 features and goes ... >> 15 SQL Server replication tips in 15 minutes TIP :This list of tips and tricks will help you enhance your replication techniques. It is broken up into three groups: ... >> Maintenance checks for SQL Server TIP :SQL Server's maintenance plan wizard can automate all maintenance tasks for you -- but beware what's really going on behind ... >> SQL Server backup and restore, part I: The basics TIP :This indepth tip analyzes the various options available for your backup and recovery process with SQL Server 2000.

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Microsoft SQL Server Performance Monitoring and Tuning Using traces in SQL Server Profiler SQL Server Mailbag: CALs, witnesses and unwanted changes SQL Server Mailbag: Data restoration and DB property management Working with IntelliSense in SQL Server 2008 Management Studio SQL Server Mailbag: Stored procedures, triggers and SSRS reports Troubleshooting Distributed Transaction Coordinator errors in SQL Server Clearing the Windows page file and its effect on server performance Optimizing SQL Server indexes –- even when they're not your indexes Performance implications of transaction log autogrowth in SQL Server The short course on how SQL Server really works

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary contiguity  (SearchSQLServer.com) contiguous  (SearchSQLServer.com) drilldown  (SearchSQLServer.com) hashing  (SearchSQLServer.com) hybrid online analytical processing  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary