Monday, July 23, 2007

Training Schedule August-September 2007

Just receive an email from Iverson Technology. Maybe you need this: 

B elow is our training schedule that will run on August-September 2007.

 

23-27 July 2007

  1. Citrix Presentation Server 4.5 Administration (CTX-1256AI)
  2. Cisco Certified Network Associates (CCNA)
  3. Implementing & Maintaining a Ms Win Server 2003 Active Directory (2279)
  4. Implementing a MS SQL Server 2000 database (2779)
  5. Programming with Microsoft ADO.NET (2389) –- 23-25 July
  6. Core Web Application Technologies with MS VS 2005 (2543) -- 23-25 July
  7. Core Data Access with Microsoft Visual Studio 2005 (2541) -- 26-28 July
  8. Ms Excel 2003 Basic-Advance Level -- 25-27 July
  9. Oracle 9i Intro to SQL
  10. Ms Project Professional 2003 –- 23-24 July
  11. Ms Excel using VBA –- 25-26 July

 

30 July-3 August 2007

  1. Cisco Certified Network Associate (CCNA)
  2. Maintaining a MS SQL Server 2000 Database (2780)
  3. Managing & Maintaining a Ms Win Server 2003 Environment (2273)
  4. Developing Ms ASP.NET Web applications using VS.NET (2310)
  5. Managing Messaging Security using Ms Exchange Server 2007 (5049) -- 3 Aug
  6. Implementing a Microsoft Windows 2000 Network Infrastructure
  7. Introduction to Visual Basic.NET Programming with Microsoft.NET (2559)
  8. MS Visual Basic Scripting Edition and MS Windows Script Host Essentials (2433) -- 30 Jul-1 Aug
  9. Scripting Microsoft windows Management Instrumentation (2439) –- 2-3 Aug

 

6-10 August 2007

  1. Administering a Microsoft SQL serve 2000 Database (2072)
  2. IT Project Management
  3. Windows System Programming
  4. Oracle 9i Database Administration I
  5. Implementing and Administering Security in a MS Windows Server 2003 Network (2823)
  6. Administering Microsoft Windows SharePoint Services and SharePoint Portal Server 2003 (2554)
  7. Configuring Windows Vista Application and Tools (5116) –- 6-7 Aug
  8. Installing and Configuring the Windows Vista Operating System (5115) –- 8-10 Aug
  9. Managing & Maintaining a Ms Win Server 2003 Environment (2273)

 

13-17 August 2007

  1. Programming a Microsoft SQL Server 2000 Database (2073)
  2. Developing Secure Web Applications (2300) -- 13-15 Aug
  3. Developing XML Web Services using Microsoft ASP.NET (2524) –- 13-15 Aug
  4. Designing High Availability Database Solutions using MS SQL server 2005 (2788) –- 13-15 Aug
  5. Administering and Automating Microsoft SQL server Dbase and Server (2789) –- 16 Aug
  6. Introduction to Installing & Managing a MS Exchange Server 2007 (5047) – 13-15 Aug
  7. Managing Messaging Security using MS Exchange Server 2007 (5049) -– 16 Aug
  8. Maintaining and Configuring Windows Vista Computers (5118) –- 13-15 Aug
  9. Supporting Win Vista Comp with Desktop Images & Application Packages (5119)--16-17 Aug

 

20-24 August 2007

  1. IT Infrastructure Library –- 20-22 Aug
  2. Implementing a Microsoft Internet Security and Acceleration Server 2004 (2824)
  3. Developing Microsoft.NET Application for Windows (VB.NET) (2565)
  4. Oracle 10g Database Administration I
  5. Implementing, Managing & Maintaining a MS Win Server 2003 Network Infrastructure (2277)
  6. Core-Advanced Data Access with Microsoft Visual Studio 2005 (2541-2542)
  7. Designing a Microsoft SQL Server 2005 Server Side Solutions (2781) –- 20-22 Aug
  8. Designing a Microsoft SQL server 2005 database (2782) –- 23-24 Aug
  9. Microsoft Project Professional 2003 –- 20-21 Aug
  10. Microsoft Access 2003 Basic-Advance –- 22-24 Aug
  11. Microsoft Excel 2003 Basic-Advance

 

 

TRAINING SCHEDULE AUGUST – SEPTEMBER 2006

 

COURSE TITLE

Code

Schedule

IT Project Management

IT PM

6-10 August

IT Infrastructure Library (IT- Service Management)

IT-IL

20-22 Aug

Citrix Presentation Server 4.0: Administration

CTX-1256AI

13-16 Aug

Cisco Certified Network Associate (CCNA)

CCNA

30 Jul-3 Aug

3-7 September

Building Scalable Cisco Internetworks

BSCI

20-24 August

Implementing Secure Converged Wide Area Networks

ISCW

ON CALL

Cisco Internetwork Troubleshooting  Support

CIT

ON CALL

Implementing a Microsoft Windows 2000 Network Infrastructure

2153

30 July – 3 Aug

Managing and Maintaining Win Server 2003 Environment

2273

6-10 Aug

10-14 September

Implementing, Managing & Maintaining a MS Win Server 2003 Network Infrastructure: Network Services

2277

20-24 Aug

17-21 September

Planning, Implementing and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure

2279

27-31 Aug

24-28 September

Planning and Maintaining a Microsoft Windows Server 2003 Network Host

2278

27-31 Aug

17-21 September

Implementing & Administering Security in a MS Windows Server 2003 Network

2823

6-10 August

3-7 September

Implementing Microsoft Internet Security and Acceleration Server 2004

2824

20-24 August

Implementing & Managing Microsoft Exchange Server 2003

2400

27-31 Aug

17-21 September

Microsoft Certified Desktop Special Technician :

1.       Supporting Users Running the MS Windows XP Operating System

2.       Supporting Users Running Applications on MS Windows XP OS

MCDST

2261

2262

3-7 September

Administering a MS SQL Server 2000 Database

2072

6-10 August

10-14 Sept

Programming a Microsoft SQL Sever 2000 Database

2073

13-17 Aug

17-21 September

SQL Performance Tuning 2000 Database

Tuning 2000

ON CALL

Designing High Availability Database Solutions Using Microsoft SQL Server 2005

2788

13-15 August

Administering and Automating Microsoft SQL Server 2005 Database and Servers

2789

16 August

Implementing a MS SQL Sever 2005 Database

2779 B

23-27 July

Maintaining a MS SQL Server 2005 Database

2780 B

30 July-3 August

Mastering Object Oriented Analysis and Design with UML

UML

ON CALL

Developing Microsoft ASP.NET Web Applications using Visual Studio.NET

2310

30 July-3 Aug

3-7 September

Developing Microsoft.NET Applications for Windows Visual Basic.NET

2565

20-24 Aug

Developing XML Web svc using Microsoft ASP.NET

2524

13-15 Aug

Getting Started with Microsoft Visual Studio 2005 for Microsoft Visual Basic 6.0 Developer

2562

6-7 September

Core Data Access with Microsoft Visual Studio 2005

2541

20-22 Aug

24-26 September

Advanced Data Access with Microsoft Visual Studio 2005

2542

23-24 Aug

27-28 September

Core Web Application with Microsoft Visual studio 2005

2543

10-12 September

Advanced Web Application with Microsoft Visual Studio 2005

2544

13-14 September

Core Windows Form Technologies with Microsoft Visual Studio 2005

2546

27-29 Aug

17-19 September

Advance Windows Forms Technologies with Microsoft Visual Studio 2005

2547

30-31 August

20-21 September

Administering Microsoft Windows SharePoint Services and SharePoint Portal Server 2003

2554

6-10 August

Introduction to Installing and Managing Microsoft Exchange Server 2007

5047

13-15 August

5-7 Sept

Managing Messaging Secirity using Microsoft Exchange Server 2007

5049

16 Augst

10 Sept

Implementing Microsoft Office Share Point Server 2007

5061

1-3 August

3-5 Sept

Intalling and Configuring the Windows Vista Operating System

5115

13-15 August

5-7 Sept

Configuring Windows Vista Applications and Tools

5116

6-7 August

10 Sept

Maintaining and Configuring Windows Vista Computers

5118

10,13-14 Augst

12-14 Sept

Supporting Windows Vista Computers with Desktop Images and Application

Packages

5119

16-17 Augst

-

MS Project Professional 2003

PRO 2003

20-21 Aug

Microsoft Access 2003 Professional - Advance

ACS 251-252

22-24 Aug

Microsoft Excel 2003 Professional - Advance

Exc 251-252

13-15 Aug

Microsoft Excel using VBA

Exc VBA

25-26 July

30-31 August

24-25 September

Oracle 9i Database Administration Fundamentals I

9i DBA I

6-10 August

Oracle 10g Database Administration Fundamentals I

10g DBA I

20-24 August

Oracle 10g Intro to SQL

10g Intro

27-31 August

Oracle 9i Intro to SQL

9i Intro

23-27 July

PHP Fundamental

 

ON CALL

Java Programming Language

 

ON CALL

   

Please click to http://www.iverson.co.id to find our others training schedule and the syllabus.

For further information that you may need regarding the course (syllabus, promo, schedule) please do not hesitate to contact me.

 

Best Regards,

PT. Iverson Technology -- http//:www.iverson.co.id

Chase Plaza , 9th Floor

Jl. Jend. Sudirman Kav. 21 Jakarta 12920

Telp.+62 21 520 8210  l  Fax. +62 21 520 8209

Wednesday, May 30, 2007

SELECT "YYYYDD" datetime

Can you explain about this ?

1st sql script :

SELECT CONVERT(VARCHAR(6),GETDATE(), 112)

------
200705

(1 row(s) affected)


2nd sql script :

SELECT CONVERT(VARCHAR(4),YEAR(GETDATE()), 112) + CONVERT(VARCHAR(2),MONTH(GETDATE()), 112)

------
20075

(1 row(s) affected)


Why 2nd sql script doesn't show the same result with the 1st sql script ?

UNION and GROUPING

Still about using UNION, how sql server grouping this result?

SELECT '200701'
UNION
SELECT '200701'
UNION
SELECT '200701'
UNION
SELECT '200701'
UNION
SELECT '198001'

output
------
198001
200701

(2 row(s) affected)

How can SQL Server order this result

How can SQL Server order this result?

SELECT '200702'
UNION
SELECT '200701'
UNION
SELECT '200703'
UNION
SELECT '200705'
UNION
SELECT '198001'

output
------
198001
200701
200702
200703
200705

(5 row(s) affected)

Thursday, May 24, 2007

Transaction Log Optimization

* Pre-allocate the log to appropriate size

* Minimize auto growths

* Log might NOT show 0 Percent Log Used after backup for example - the % Log Used will be ~6%

* Disk Bound Systems might experience some performance degradation at log backup

* Consider RAID 1+0 instead of RAID 1, RAID 5 generally is not recommended

* Optimize existing file – minimize VLFs

- - -

source : SQL Server Community In touch