Antonio Olmedo :: personal website

Standard procedure to migrate SQL Servers

Fri, 18 Sep 2009 08:42:29 PDT

This document intends to define standard steps for moving a specific SQL Server database to a new server, optionally migrating from SQL Server 2000 to 2005 as well.

1. Different approaches of migration

Depending on the size of the database to be migrated and the downtime window of production server, different approaches can be used to move the database from the current server to a new one.

1.1. Attach/detach

If we can afford to bring the old server offline as much time as needed, we can use the attach/detach approach.

First of all, we need exclusive access...

Move to Infrastructure department

Tue, 31 Mar 2009 17:00:00 PDT

There have been some organization changes in the company and I have been moved to the Infrastructure Corporate department. My new job title is IT Solutions DBA and my duties will be:

Maintain existing systems, suggest improvements, optimize performance, re-design and re-implement where appropriate, after analysing workload in the production environment.
Create and apply the standard procedure for migrating servers from old machines to new ones, optionally upgrading from SQL Server 2000 to 2005/2008.
Consolidate several physical servers into one virtualized server (VMWare).
Create tailored maintenance plans in T-SQL for all the SQL servers in the company to keep these databases performing at a...

Promotion to Development DBA

Sun, 13 Jul 2008 16:00:00 PDT

I've changed department in Transcom, promoting to a new position: Development DBA. My duties will be:

Fully manage all development and testing databases related to LanceNG.
Logical and physical database design.
Support infrastructure department with requirements to ensure stable backup and restore activities.
Support developers with SQL efficiency and performance.
Responsible for SQL Server 2005 monitoring and troubleshooting.
Responsible for ETL design, implementation and support. SSIS, T-SQL and VB.NET.
Provide support by being available on call out of office hours in case of outage in production.

Promotion: IVR & Inbound Analyst

Sun, 03 Feb 2008 14:00:00 PST

After eight months working as IT developer in Transcom, I've been promoted to the position of IVR & Inbound Analyst. During these eight months I've acquired knowledge in the following areas:

SQL Server 2000 and 2005: development of ETL processes (DTS and SSIS),� automated jobs, creation and improvement of Transact-SQL queries and stored procedures.
C# and Python: development and improvement of projects concerning treatment of audio files taking advantage of the use of regular expressions.
Altitude software development.

From now...

My first job as computer engineer

Sun, 20 May 2007 18:00:00 PDT

Transcom WorldWide has a new Junior Developer who will begin to work in their offices at Barcelona next 11^th of June. I don't even have finished my degree yet (thesis left) but time has come for me to begin my career as computer engineer in the CRM operator with the largest geographic coverage in Europe, which serves some of the most successful and demanding international companies.

My duties will be:

Software development of interfaces between applications in the production environment as well as tools to automate manual procedures.
Development of custom software components and scripts to support...

New projects added: Shell and Tasks Scheduler

Mon, 23 Apr 2007 21:21:30 PDT

New projects added to the "University" section: a command line shell terminal and a tasks scheduler for Unix/Linux. Both of them were implemented in C under Linux for "Operative Systems Fundamentals " course.

�

New project added: Directed Graph

Thu, 19 Apr 2007 19:23:55 PDT

New project added to the "University" section: a directed graph definition and implementation in Java 1.5.

New project added: MIDP Application

Thu, 19 Apr 2007 19:03:44 PDT

New project added to the "University" section: a MIDP application that consists in a quiz game.

New project added: Ciao Prolog FTP

Thu, 19 Apr 2007 19:01:43 PDT

New project added to the "University" section: a FTP client and server, text interface implemented in Ciao Prolog, functional programming language.

New project added: FTP Applet

Thu, 19 Apr 2007 18:56:14 PDT

New project added to the "Other" section: a FTP-client Java Applet.