Let's Talk about .. Visual Studio 2003-Create SAP Web Service

P'Aoi, expert of dotNet in IT-BOT teached me how to create SAP Web Service.

The instruction to Create SAP Web Service

-Right Click at Your Project
-Click Add
-Click Add New Item
-Select Web Service
-Type Name: [Your Web Service Name].asmx
-Click OK

-In the .vb code, import the following libraries
[VB.Net]
Imports System.Web.Services
Imports System.Web.Services.Protocols
Imports System.ComponentModel
Imports System.Configuration

-Set
[VB.Net]
{system.web.services.webservice(namespace:=http://localhost/[Your Project]/[Your Web Service Name])> _
{system.web.services.webservicebinding(conformsto:=wsiprofiles.basicprofile1_1)> _
{toolboxitem(false)> _

-Declare and define SAP Connection String
[VB.Net]
Dim cs As String = System.Configuration.ConfigurationSettings.AppSettings("[Your SAP Connection String]")

-Declare Get SAP Connection Function
[VB.Net]
Private Function GetSAPConnection() As SAP.Connector.Connection
Dim objDest As New SAP.Connector.Destination
objDest.AppServerHost = System.Configuration.ConfigurationSettings.AppSettings("AppServerHost")
objDest.SystemNumber = System.Configuration.ConfigurationSettings.AppSettings("SystemNumber")
objDest.Client = System.Configuration.ConfigurationSettings.AppSettings("Client")
objDest.Language = System.Configuration.ConfigurationSettings.AppSettings("Language")
objDest.Username = System.Configuration.ConfigurationSettings.AppSettings("Username")
objDest.Password = System.Configuration.ConfigurationSettings.AppSettings("Password")
Return SAP.Connector.Connection.GetConnection(objDest)
End Function

-Create Your Function accoring to your SAP RFC like the example Hello World

Let's Talk about .. Visual Studio 2003-Add SapConnectorProxy and Add Function Filter [R/3]

Yesterday, P'Aoi teached me how to set the SAP Connector Proxy and create the Function Filter.

The instruction to add the SAP Connector Proxy
-Check out all project
-Create Folder of SapProxy (to put whatever it's automatically generated)
-Create Folder of SapClass (to put what you create yourself)
-Add New Item
-Select SapConnectionProxy (Note: you need to install SapDotNetConnector)
-Select SAPConnectorProxy
-Type name.sapwsdl
-Click OK

-Select Server Explorer
-Expand SAP
-Right click at Application Servers
-Click Add Application Server
-Type the Server Destination
-Type Username, Password, Client, and Language that are used to log on the SAP Server
-Check whether you can expand the Alphabetical and Hierarchical or not.

-If Yes, it's ok. But otherwise, set the properties with the following SPECIAL STEPS suggestions:-
SPECIAL STEPS
AppServerHost: [Your SAP Server name]
Client: [Your Client number]
DestinationType: Custom Logon Settings
Internal: SAP.Connector.Destination
AbapDebug: False
AppServerHost: [Your SAP Server name]
Client: [Your Client number]
HttpPath: /sap/bc/soap/rtc
HttpPort: 80
HttpProtocol: http

The instruction to Add Function Filter
-Right click at SAP->Application Servers->[Your SAP Server name]->Functions
-Click Add Function Filter...
-Type Name (to display in your Visual Studio)
-Type GroupFilter (which is your Function Group name you wanna filter)
-Click OK

Let's Talk about .. Visual Studio 2003-Create Web Application with virtual directory

P'Aoi just teached me how to create the web application with virtual directory by Visual Studio 2003. The reason why I've to use 2003 instead of 2005 is I'm gonna create web services to call RFC from SAP R/3 which needs to use SAP Connector that is suitable for dotNET 1.1.

The Instruction to Create Web Application with virtual directory

-Create folder
-Right Click at your folder
-Click Properties
-In Security tab, make sure you have the necessary permissions
-In Web Sharing tab, click Add
-Type the Alias
-In Access permissions, set Read and Directory browsing
-In Application permissions, set Scripts
-Click OK

-Enter IIS
-Right Click at Default Web Site
-New->Virtual Directory...
-Click Next
-Type Alias (as your set for your folder)
-Browse the directory (your folder of Step 1)

-Open Visual Studio 2003
-File->New->Project...
-Select Project Types: Visual Basic Projects or Visual C# Projects
-Select ASP.NET Web Application
-Type Location: http://localhost/[your alias]
-Type OK

Let's Talk about .. IIS-Settting Timeout

Today, my team got a problem to upload a large file to MOSS DocLib, so P'Roj from SysTeam told me how to configurate the timeout in IIS.

There are three kind of timeout:-

1. The instruction to set Web Site Connection Timeout

-Log in to Server

-Enter IIS Manager

-Right click at your website

-In Web Site tab, set the connection timeout in seconds unit

-Restart IIS

2. The instruction to set Application Session Timeout

-Log in to Server
-Enter IIS Manager
-Right click at your website

-In Home Directory tab, click Configuration button

-In Options tab, set the Session timeout in minutes unit

-Restart IIS

3. The instruction to ASP script timeout

-Log in to Server-Enter IIS Manager-Right click at your website
-In Home Directory tab, click Configuration button
-In Options tab, set the ASP script timeout in seconds unit

-Restart IIS

Let's Talk about .. MOSS2007-Modify blocked file list

Today I received the Error "The following file(s) have been blocked by the administrator" from my team when she uploaded the .exe file into DocLib. So I searched in the internet and I found this http://techblog.udayakumar.net/2007/10/how-to-upload-exe-files-in-sharepoint.html describes how to solve it. Thanks to Uday's Tech Home so much.

The instruction to modify blocked file in MOSS

-Log in to MOSS Server
-Go to Central Administration
-Go to Operation Tab
-In Security, click Blocked file types
-Then, you can add/remove file extension(s).

SQL Server 2008 & Application Compatibility

Microsoft SQL Server 2008 comes with the concept "Your Data, Any Place, Any Time."

SQL Server 2008 provides a trusted, productive, and intellisent data platform that enables you to run your most demanding mission-critical applications, reduce time and cost of development and management of applications, and deliver actionable insight to your entire organization.

Yesterday I participated SQL Server 2008 & Application Compatibility seminar at Microsoft (Thailand) presented by Mr.Chulladej Aramsri.
I summarized this seminar as the following information..

SQL Server 2008 Upgrade Technical Value Proposition
Minor change:-
-Data/Backup Compression or even transaction by DB Server resource (Needs more CPU)
-TDE: Transparent Data Encryption by creating encrypted key which one of the easy ways is certificate (Needs more CPU)
-Resource Governor (Uses memory and CPU)
-Filtered Indexes / Statistic-Query Optimizer
-Auditing for database, object, and schema level (no coding) but it needs space for audit logs
-Reporting Services e.g. cube in many partitions and in many servers

Moderate Application:-
-Policy Based Management i.e. it can register as group of servers
-Performance Data Collection (PDC) which is a data warehouse to collect all database data for example, cube usage (SQL Profiler needs more time to process)
-Enhanced data and time, we can select only date or time. And there is new data type, Datetime2, which keeps in nanosecond unit
-New SQL commands and Intellisense in SQL Studio
- Sparse Column, it will not keep the column whose value is null, thus it needs less disk storage
-Service Broker Enhancements-SSIS/SSRS/SSAS Enhancements: For SSRS, no needing of web server

Significant Application:-
-Spatial Support: it can keep Geographic data
-File Stream Support: it can keep unlimited size of file stream depended on your hardware
-Hierachy data type
-CDC (Change Data Capture) and Change Tracking
-LINQ Support: LINQ is a new computer language that makes developers do connection easier.
-Entity Framework Support
-ADO.Net (Only Data Services Support)

Develing on Vision
1.Enterprise Data Platform e.g. Nasdax
2.Beyond Relation
3.Dynamic Development
4.Pervasive Insight

ImprovePerformance:-
-PDC
-Backup
-Partition
-Star Join
-Plan Guides
-Minimally Logged Insertion

Scalability:-
-Up to 64 bit CPU and 1 TB RAM
-Scale out by Data Dependent Routing, Service Broker, and Peer-to-peer replication
-Table Locked Escalation
-File Stream
-Data Compression

Availability:-
-"Hot-Add CPU", which was Hot-Add Memory in SQL Server 2005. Anyway, users has to log off, then log in after adding the CPU.
-Auto Page Repair in Database Mirroring
-Improve Online Operation, for example, Online Restore

Security:-
-Extensible Key Management

Managiability:-
-Policy-based Management

Resource Governor:-
-Control COU and Memory

It reduces Support Costs since Policy, Data Collection, and Plan Guide & Validation

What's new
-T-SQL:- -MERGE command (aka UPSERT)
-Table-Valued Parameter
-Row Constructors
-Change Data Capture
-Peer-to-peer: Graphic design
-Extensive Key Management
-Report Designer Client (GUI like Office 2007)which is called Report Builder 2.0
-TABLIX (=Table + Matrix) Dynamic number of columns-Data Minding: drill-through to structure

New Market for SQL Server 2008
-Build location-aware Application
-Build Occasionally Connected System
-Expand Content Management Solution

Important Trends
1. Consolidation
2. Virtualization (SQL Server 2008 supports 100%)
3. Data in the Cloud

Upgrade Methodology

Identify requirement
1. SQL Server Edition
2. HCL (Hardware Consideration List) Run Upgrade Advisor
3. Perform Application Compatibility Testing

What's not in SQL Server 2008
-Undocumented system stored procedure
-Virtual Cube
-DUMP/LOAD database
-Backup with TRUNCATE ONLY
-Some are deprecated
e.g. Notification Services

More info..SQL Server 2008
TechCenter
http://technet.microsoft.com/sqlserver
SQL Server 2008 Developer Center
http://msdn2.microsoft.com/sqlserver