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 13 of 13   
 

Setting Up Your SQL Server Agent Correctly

It is important to set up SQL Server Agent Security on the principles of 'executing with minimum privileges’, and ensure that errors are properly logged and alerts are set up for a comprehensive range of errors. SQL Server Agent allows fine-grained control of every job step that should allow tasks to be run entirely safely even if they occasionally need special privileges.  Read more...
By Additional Articles 2014/06/13 | Source: SimpleTalk | Category: sql server agent
Rating:  Rate this |   Briefcase | 2,559 reads

Context Is Everything - Check Your Settings

Check 96 server and database settings to make sure they match your expectations in your databases with this script.  Read more...
By William Talada 2014/05/06 | Source: SQLServerCentral.com | Category: configuration
Rating: |  Discuss |   Briefcase | 4,399 reads

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: MSSQLTips.com | Category: security
Rating:  Rate this |   Briefcase | 3,241 reads

Global Configuration Settings

By Sean Smith 2013/08/30 | Category: sp_configure
Rating: (not yet rated) |  Discuss |   Briefcase | 2,388 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,550 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: MSSQLTips.com | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 2,747 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,152 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: MSSQLTips.com | Category: configuration
Rating:  Rate this |   Briefcase | 3,382 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,357 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: MSSQLTips.com | Category: configuration
Rating: (not yet rated)  Rate this |   Briefcase | 2,711 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,126 reads

Default port number

By Arup Chakraborty 2008/12/03 | Category: configuration
Rating: (not yet rated) |  Discuss |   Briefcase | 3,655 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: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 4,173 reads
   Items 1 to 13 of 13   
 
Tags
administration (3)    
affinity mask (1)    
architecture (1)    
connecting (1)    
defaults (1)    
dts (1)    
etl (1)    
ini (1)    
integration services (ssis) (1)    
networking (1)    
portability (1)    
properties (1)    
security (1)    
settings (1)    
setup (1)    
sp_configure (1)    
sql server agent (1)    
tcp (1)    
t-sql (1)    
video (1)