Step 7: Plan next assessment

Chip Andrews, Contributor

Until Microsoft incorporates SQL Server service packs and hotfixes into Windows Automatic Updates and the Windows Update Services, you'll need to repeat this process periodically to stay current as new service packs and hotfixes are released. Be sure to pick a time that is convenient for you and the people that rely on those systems.

In the meantime, several commercial products can help with SQL Server patch assessment and deployment, including Shavlik Technologies' Shavlik HFNetChk Pro; St. Bernard Software's UpdateEXPERT; and GFI Software Ltd.'s GFI LANguard Network Security Scanner. Most of them have free or demonstration versions available so you can assess whether or not their products are right for your environment.

    Requires Free Membership to View


 Home: Introduction
 Step 1: Segregate your scan results
 Step 2: Obtain service packs and prepare for deployment
 Step 3: Deploy service packs
 Step 4: Obtain hotfixes and prepare for deployment
 Step 5: Deploy hotfixes
 Step 6: Re-assess network
 Step 7: Plan next assessment
 Back: How to patch SQL Server, part 1


Chip Andrews is the director of research and development for Special Ops Security Inc. and the founder of the Web site, which focuses on Microsoft SQL Server security topics and issues. He is also the author of SQL Server Security.

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: