Proftpd on freebsd

let say you have 1 machine fresh install FreeBSD.
here the step by step to make this server as FTP server.

install proftpd

cd /usr/ports/ftp/proftpd
make config (depend on your setting & use)
make install (wait for several minutes)

after complete
rehash
setting up your proftpd
ee /usr/local/etc/proftpd.conf
my setting

# For more informations about Proftpd configuration
# look at : http://www.proftpd.org/
#
# This is a basic ProFTPD configuration file (rename it to
# 'proftpd.conf' for actual use. It establishes a single server
# and a single anonymous login. It assumes that you have a user/group
# "nobody" and "ftp" for normal operation and anon.

ServerName "ProFTPD Mediu"
ServerType standalone
DefaultServer on
ScoreboardFile /var/run/proftpd/proftpd.scoreboard

# Port 21 is the standard FTP port.
Port 21

# Use IPv6 support by default.
#UseIPv6 off

# Umask 022 is a good standard umask to prevent new dirs and files
# from being group and world writable.
Umask 022

# To prevent DoS attacks, set the maximum number of child processes
# to 30. If you need to allow more than 30 concurrent connections
# at once, simply increase this value. Note that this ONLY works
# in standalone mode, in inetd mode you should use an inetd server
# that allows you to limit maximum number of processes per service
# (such as xinetd).
MaxInstances 30

CommandBufferSize 512

# Set the user and group under which the server will run.
User nobody
Group nogroup

# To cause every FTP user to be "jailed" (chrooted) into their home
# directory, uncomment this line.
#DefaultRoot ~

# Normally, we want files to be overwriteable.
AllowOverwrite on

# Bar use of SITE CHMOD by default
DenyAll

# A basic anonymous configuration, no upload directories. If you do not
# want anonymous users, simply delete this entire section.

#########################################################################
# #
# Uncomment lines with only one # to allow basic anonymous access #
# #
#########################################################################

#
# User ftp
# Group ftp

### We want clients to be able to login with "anonymous" as well as "ftp"
# UserAlias anonymous ftp

### Limit the maximum number of anonymous logins
# MaxClients 10

### We want 'welcome.msg' displayed at login, and '.message' displayed
### in each newly chdired directory.
# DisplayLogin welcome.msg
# DisplayFirstChdir .message

### Limit WRITE everywhere in the anonymous chroot
# # DenyAll
#
#
# User guest
User ftp
# Group nobody
Group nogroup
AnonRequirePassword off
RequireValidShell off
UseFtpUsers off
# UserAlias anonymous guest
UserAlias anonymous ftp
UserAlias guest ftp
MaxClients 10
DenyAll
Umask 002
AllowAll
DenyAll
AllowAll

# Deny write access from all except trusted hosts.
##
## Order allow, deny
## Allow from 172.16.10.0.
## Deny from all
##
##

# FTPS
#Include /usr/local/etc/tls.conf

Reindexing Microsoft SQL Databases to Optimize Performance

Reindexing Microsoft SQL Databases to Optimize Performance

To reindex all the indexes in a Microsoft SQL database, follow these steps:

1. On the Start menu, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.

2. In the Connect to SQL Server dialog box, click OK.

3. On the Query menu, click Change Database.

4. In the Select Database of dialog box, click the Microsoft CRM database that you want to work on, and then click OK.

5. In the Query window, type the following commands:

DECLARE @TableName varchar(255)
DECLARE TableCursor CURSOR FOR
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'base table'
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'Reindexing ' + @TableName
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor

6. Click the Execute Query button on the toolbar, and the results will show in the results panel.

Thanks to webdigo