Hardware Configuration and Software Installation: |
LEJ Technology can help you install new servers or upgrade your existing servers, install MS SQL Server 7.0/2000 (Personal, Standard and Enterprise Editions), Microsoft Windows 2000/XP/Windows 2000 Server/Windows Server 2003 and configure SQL Server System for capacity, performance, scalability, and growth.
|
Sizing and Capacity Planning: |
We will determine whether your system can handle the anticipated workload, perform sizing and capacity-planning tasks, schedule capacity increases well in advance of any potential problems. |
|
Database Design and Development: |
Database:
- Database creation
- Modifying an existing database (adding new tables, creating or rebuilding indexes etc.)
- Loading the database ( BCP, Data Transformation Services)
- T-SQL Scripting (stored procedures, triggers etc.)
Batch Processing Systems:
- Daily refresh of data
- Data transformation
- Data cleansing
|
|
Security: |
The scope of access to your system determines the type and the amount of security that your database needs. A system that is accessed by only a few trusted employees and is not connected to the Internet requires less security than a database that is accessed from the Internet. The security of the system is important because if someone were to break into your system and steal or destroy data, the expense to your company could be high.
LEJ Technology will help you to design and implement the right security solution for your company including network and SQL Server security plans. |
|
Backup and Restore: |
The planning and implementation of a suitable backup and restore strategy is vital. Without a clear commitment to protecting corporate data, organizations will inevitably experience a compromise of data integrity, possibly resulting in irretrievable loss of data. SQL Server has built in functionality, which, if correctly configured, can help protect against data loss in a wide range of scenarios.
LEJ Technology will write scripts for monitoring and maintenance of the databases. For example, we will write scripts that will alert the administrator for any failures, scripts for back-up of logs and archives, etc. |
|
Performance Tuning and Monitoring: |
We will monitor the performance and the resource usage of your system and if performance problems are indicated we will troubleshoot those problems and develop solutions. If your applications are not performing as well as they should, they may benefit from a performance audit also. |
|
Replication Administration: |
MS SQL Server replication is a set of solutions that allow you to copy, distribute, and potentially modify data across your enterprise. SQL Server includes several methods and options for replication design, implementation, monitoring, and administration to give you the functionality and flexibility needed for distributing data and maintaining data consistency.
Using replication, you can distribute data to different locations, to remote or mobile users over a local area network, using a dial-up connection, and over the Internet. Replication also allows you to enhance application performance, physically separate data based on how it is used (for example, to separate online transaction processing (OLTP) and decision support systems), or distribute database processing across multiple servers
|
|
Documentation: |
Configuration documentation should give you all the information you need to rebuild your system in the event of a major breakdown. This information will include the following:
Hardware configuration:
A detailed record of the existing hardware (i.e. disk drive performance characteristics), any equipment that was added, such as additional hard disks or memory modules.
Software components:
A detailed record of which components were added to the system and how each component was configured. Details such as which subcomponents were installed and what options were chosen are vital.
Database configuration:
Database configuration specs will include the database layout and schema, the names and locations of all data files, which file groups each file belongs to, and how the groups were created. This information gives you a reference by which to identify what data files have been lost in the event of a disk array failure.
|
|
|
