Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag Configuration Rss

   Items 1 to 11 of 11   

SQL Server Security Checklist

SQL Server security related tasks can be divided into four main categories: physical security, operating system level security, SQL Server configuration and user management. Here is your SQL Server security checklist.  Read more...
By Additional Articles 2014/02/20 | Source: | Category: security
Rating:  Rate this |   Briefcase | 3,001 reads

Global Configuration Settings

By Sean Smith 2013/08/30 | Category: sp_configure
Rating: (not yet rated) |  Discuss |   Briefcase | 2,359 reads

How to Document and Configure SQL Server Instance Settings

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.  Read more...
By Additional Articles 2012/02/13 | Source: SimpleTalk | Category: configuration
Rating:  Rate this |   Briefcase | 3,506 reads

Standardize SQL Server Installations with Configuration Files

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.  Read more...
By Additional Articles 2011/10/31 | Source: | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 2,697 reads

SSIS for Multiple Environments

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.  Read more...
Rating: |  Discuss |   Briefcase | 8,115 reads

Configure Windows Firewall to Work with SQL Server

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.  Read more...
By Additional Articles 2010/02/11 | Source: | Category: configuration
Rating:  Rate this |   Briefcase | 3,303 reads

SQL Server Configuration

The importance of correct configuration. Which default configuration options to change. Common mistakes.   Read more...
By Additional Articles 2009/10/22 | Source: SQL-Server-Pro | Category: configuration
Rating:  Rate this |   Briefcase | 4,310 reads

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

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?  Read more...
By Additional Articles 2009/02/26 | Source: | Category: configuration
Rating: (not yet rated)  Rate this |   Briefcase | 2,677 reads

SQL Server Options to Avoid - SQL School Video

Not every option in SQL Server is useful or appropriate. Brian Knight shows which ones you might not wish to mess with.  Read more...
By Brian Knight 2009/01/06 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 6,086 reads

Default port number

By Arup Chakraborty 2008/12/03 | Category: configuration
Rating: (not yet rated) |  Discuss |   Briefcase | 3,647 reads

Yet another way to include portability on DTS packages

An proposal about using simple server name resolution and INI files to make a DTS package portable.  Read more...
By Alceu Rodrigues de Freitas Junior 2008/04/10 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 4,169 reads
   Items 1 to 11 of 11   
administration (3)    
affinity mask (1)    
architecture (1)    
connecting (1)    
dts (1)    
etl (1)    
ini (1)    
integration services (ssis) (1)    
networking (1)    
portability (1)    
security (1)    
setup (1)    
sp_configure (1)    
tcp (1)    
t-sql (1)    
video (1)