Most RecentMost ViewedMost LikesFundamentals: DBCC - SQL Server's FDISKFirst published on TECHNET on May 20, 2011 [Prior Post In Series] [Backup Series] [Next Post in Series]In a time long long ago (last millennium), DBCC was known as Database Consistency Checker; today it stands for Database Console Command.Backups: Doing it right so you can recover quickly!– Automating the backupsFirst published on TECHNET on May 13, 2011 [Prior Post] [Next Post]Getting backups scheduled appropriately tends to be a slow process with a lot of keying and mouse clicks.Backups: Doing it right so you can recover quickly!– Don’t keep your eggs in one basketFirst published on TECHNET on May 06, 2011 [Prior Post] [Next Post]In my prior post I looked atconfirming that backups were happening, and if they were the right type.Backups: Doing it right so you can recover quickly! - Checking backups have occurred.First published on TECHNET on Apr 26, 2011 [Next Post]Over the last few months I have been reviewing presentations at user conferences and talking to consultants about their experiences.Fundamentals: Cloning a production database to a test serverFirst published on TECHNET on Apr 22, 2011 Recently Ihad aconversation with someonewho maintainsan ISV offering.Fundamentals: Improving Insert and Update Performance by Dropping Unused IndexesFirst published on TECHNET on Apr 15, 2011 [Prior Post in Series] [Next Post in Series]In my prior posts, I looked at adding indexes with Database Engine Tuning Advisor.Fundamentals: Running Database Engine Tuning Advisor and Selecting IndexesFirst published on TECHNET on Apr 08, 2011 [Prior Post in Series] [Next Post in Series]In my last postFundamentals: Creating a Workload by Using a Trace Log,I illustrated how to create a workload.Tuning ISV SQL Server databases - OverviewFirst published on TECHNET on Apr 07, 2011 [Next Post in Series - SmarTeam Tuning]In the following months, I hope to do some hands-on tuning of various ISV SQL Server databases in use at client sites.Adding enhanced password constraints to SQL ServerFirst published on TECHNET on Mar 29, 2011 [Prior Post in Series] [Next Post in Series]In my prior posts on applying PCIDSS standards to protect your company’s data I showed now a DDL trigger (FOR LOGON) may be used to enhance logon security.Best Practices Analyzer for ISV SQL Servers to protect your company’s propertyFirst published on TECHNET on Mar 07, 2011 The intellectual property(IP) or other valuable information may be stored on SQL Server in your ISV product.
