SQL SERVER LOVER

Training Schedule August-September 2007

2007-07-23T08:54:00.001+07:00

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

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

30 July-3 August 2007

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

6-10 August 2007

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

13-17 August 2007

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

20-24 August 2007

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

SELECT "YYYYDD" datetime

2007-05-30T16:02:00.001+07:00

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

2007-05-30T15:41:00.000+07:00

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

2007-05-30T15:35:00.001+07:00

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)

Transaction Log Optimization

2007-05-24T17:27:00.000+07:00

* 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

How to Creating Databases

2007-05-24T17:25:00.001+07:00

* Inherit initial properties from model database

* Change to model will affect ALL databases created AFTER the change made.
Note : TempDb is re-Created on each system restart. Might be a good idea for data types that are needed for temp table/objects

* Define logical file names

* Define physical location

* Define auto growth setting

* Create DataBase [junkDb] on Primary
(Name = N'JunkDbData', FileName = N'Physical FileName',
Size = 10, --kb, mb, gb, tb
FileGrowth = 10%, --kb, mb, gb, tb
MaxSize = 15) --kb, mb, gb, tb

Log on
(Name=N'JunkDbLog',
FileName = N'Physical FileName',
Size = 10, --kb, mb, gb, tb
FileGrowth = 10%, --kb, mb, gb, tb
MaxSize = unlimited)

* Default for filegrowth is 10%

* Default for MAXSIZE is Unlimited

Example of creating a table for application versioning

2007-05-24T11:52:00.001+07:00

If you need an example of creating a table for application versioning, maybe this script will help :

CREATE TABLE [dbo].[dnn_Version](
   [VersionId] [int] IDENTITY(1,1) NOT NULL,
   [Major] [int] NOT NULL,
   [Minor] [int] NOT NULL,
   [Build] [int] NOT NULL,
   [CreatedDate] [datetime] NOT NULL,
CONSTRAINT [PK_dnn_Version] PRIMARY KEY CLUSTERED
(
   [VersionId] ASC
) ON [PRIMARY],
CONSTRAINT [IX_dnn_Version] UNIQUE NONCLUSTERED
(
   [Major] ASC,
   [Minor] ASC,
   [Build] ASC
) ON [PRIMARY]
) ON [PRIMARY]

Note : This script taken from dotnetnuke database

How to get store procedure result set

2007-05-23T17:38:00.001+07:00

This is the sql script to get other SP resultset in our store procedure:

CREATE PROC PROC_X
AS

CREATE TABLE #TmpTable( ... )

INSERT INTO #TmpTable EXEC usp_MySP @1, @2

How to make a julian date format( yyyyddd )

2007-05-23T17:37:00.001+07:00

Sql script:

select
    convert(varchar,
                dateadd(d,
                               cast(right('2007265',3) as int)-1,
                                cast(left('2007265',4)+'0101' as datetime)
                               ) ,
               112) as the_date

How to delete log file

2007-05-23T17:36:00.001+07:00

If you want to delete the log file, this the command:
(database eq : SASB)

USE SASB
BACKUP LOG SASB WITH TRUNCATE_ONLY
GO
DBCC SHRINKDATABASE(SASB,0,TRUNCATEONLY)
GO
EXEC sp_addumpdevice 'disk', 'DumpDisk','e:\program_files\data\dumpdisk.bak'
GO
BACKUP DATABASE SASB TO DumpDisk
GO

What is Notification Services

2007-05-23T09:48:00.000+07:00

Notification Services is an environment for developing and deploying applications that generate and send notifications. You can use Notification Services to generate and send timely, personalized messages to thousands or millions of subscribers, and can deliver the messages to a variety of devices.

What is Service Broker

2007-05-23T09:47:00.000+07:00

Service Broker helps developers build scalable, secure database applications. This new Database Engine technology provides a message-based communication platform that enables independent application components to perform as a functioning whole. Service Broker includes infrastructure for asynchronous programming that can be used for applications within a single database or a single instance, and also for distributed applications.

- - -

source : books online

Hellooo

2007-05-23T09:10:00.000+07:00

Welcome to sql server lover blog.
It's all about sql server technology.
Enjoy.

SQL SERVER LOVER

Training Schedule August-September 2007

COURSE TITLE

Code

Schedule

Designing High Availability Database Solutions Using Microsoft SQL Server 2005

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

Core Data Access with Microsoft Visual Studio 2005

Advanced Data Access with Microsoft Visual Studio 2005