SQLServerCentral.com Articles tagged Configuration

How to Document and Configure SQL Server Instance Settings

Mon, 13 Feb 2012 07:00:00 UT

There are around seventy SQL Server instance settings, and a DBA needs to be aware of the effect that many of them have. Brad McGehee explains them in enough detail to help with most common configuration problems, and suggests some best practices.

Standardize SQL Server Installations with Configuration Files

Mon, 31 Oct 2011 06:00:00 UT

If you have a requirement to install multiple SQL Server instances with the same settings, you most likely want to do it without following the numerous manual installation steps. The below tip will guide you through how to install a SQL Server instance with less effort.

SSIS for Multiple Environments

Tue, 27 Apr 2010 06:00:00 UT

In this article, Zach Mattson shows us how you can set up SSIS to handle multiple application environments and easily move packages from development to QA to production.

Configure Windows Firewall to Work with SQL Server

Thu, 11 Feb 2010 07:00:00 UT

Windows Firewall is an OS level software firewall. It can be a crucial part of OS level security if you are not using other firewall hardware or software. Since I do not have another firewall I have a need to enable Windows Firewall for my SQL Server database server. In this article I go through the process of configuring Windows Firewall for different scenarios along with the associated considerations.

SQL Server Configuration

Thu, 22 Oct 2009 06:00:00 UT

The importance of correct configuration. Which default configuration options to change. Common mistakes.

How to move a SQL Server database within the same instance without losing settings

Thu, 26 Feb 2009 07:00:00 UT

I want to move my database on my SQL Server 2005 system to a new drive, but I have database options, like cross-database ownership chaining, that I don't want to lose or have to remember to re-apply. How can I do this?

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

SQL Server Options to Avoid - SQL School Video

Tue, 06 Jan 2009 07:00:00 UT

Not every option in SQL Server is useful or appropriate. Brian Knight shows which ones you might not wish to mess with.

Yet another way to include portability on DTS packages

Thu, 10 Apr 2008 06:00:00 UT

An proposal about using simple server name resolution and INI files to make a DTS package portable.