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

Installing SQL Server vNext on an AWS EC2 RHEL Instance

The steps required to create an Amazon Web Services EC2 instance and install the latest SQL Server version on the EC2.  Read more...
By Kenneth Igiri 2017/03/16 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 525 reads

Target Recovery Interval and Indirect Checkpoint

Indirect checkpoint is the recommended configuration, especially on systems with large memory footprints and default for databases created in SQL Server 2016.  Read more...
By Igor Micev 2016/07/21 | Source: SQLServerCentral.com | Category: configuration
Rating: |  Discuss |   Briefcase | 789 reads

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,439 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,483 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 | 4,788 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 | 4,158 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 | 3,532 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,264 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,957 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,545 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,915 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,242 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,176 reads
   Items 1 to 13 of 13