Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Configuration Rss

Search for any content tagged configuration

   Items 1 to 11 of 11   

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 | 3,015 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: | Category: configuration
Rating: |  Discuss |   Briefcase | 4,478 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: | Category: security
Rating:  Rate this |   Briefcase | 4,139 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,835 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 | 3,186 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,248 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,693 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,473 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,831 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,225 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,175 reads
   Items 1 to 11 of 11