Logo

Navigation
 

Exforsys Services

Home Services Exforsys Services ERP Solutions Implementation Solutions Upgrade Solutions Support and Maintenance Solutions Custom Solutions Training and Mentoring Web Solutions Production Support Architecture Designing Independent Validation and Testing Services Infrastructure Management
November 30, -0001 - - Comments:

Exforsys Expertise

Home Expertise Exforsys Expertise SQL Server Database and BI SQL Server Administration SQL Server Database Support and Maintenance MS SQL Server QA/Testing Remote DBA Database Development Database Architecture Designing Microsoft Development expertise MS WinForms Development expertise MS ASP.NET, MVC & .NET Web Application Development MS Application Development expertise .NET System Designs C# .Net Development Microsoft Access Development expertise Mobile Development Android Apps Development Blackberry Apps Development iPhone Apps Development iPad Apps Development Windows Mobile Apps Development Mobile Web Apps Development Oracle and BI Oracle Business Intelligence Solution Business Intelligence & Data Warehousing Oracle Services Oracle Business Intelligence Workshop & Training…
November 30, -0001 - - Comments:

Expertise – SQL Server Database and BI

Home Expertise SQL Server Database and BI SQL Server Administration SQL Server Database Support and Maintenance MS SQL Server QA/Testing Remote DBA Database Development Database Architecture Designing
November 30, -0001 - - Comments:

Expertise – Oracle and BI

Home Expertise Oracle and BI Oracle Business Intelligence Solution Business Intelligence & Data Warehousing Oracle Services Oracle Business Intelligence Workshop & Training
November 30, -0001 - - Comments:

Expertise – Oracle RAC

Home Expertise Oracle RAC Oracle Real Application Clusters Consulting Oracle Real Application Clusters Support Oracle Remote DBA Support Oracle RAC Administration
November 30, -0001 - - Comments:

How to prepare for an Interview

How to prepare for an Interview – 2004/07/19 01:29  Pls. find some interview preparation tips given below, which may helpful for you. Point 1 : You need to prepare all the skills mentioned in your resume. Point 2 : Come up with the priority for all the skills that you need to prepare. If you are not sure, ask us. Point 3 : Make a time plan based on the skills priority. Point 4 : Go thru our interview questions package so that you will get some idea what types of questions will be asked in the interview. Point 5…
July 18, 2004 - - Comments:

Resume Preparation Tips

Resume Preparation Tips: I am getting some emails and phone calls, in which the people are asking questions like : 1)can you provide some tips for resume preparation ? 2)whether can we put experience in resume. It will create any problem for us? 3)why we are not getting any interview calls even if we put some experience in our resume? So i came up with this article, which might be helpful for students/experienced professionals who were looking for job/change in job. When coming to resume preparation, Our(Job seeker) target is :- 1)Resume has to reach the client.(Once it crossed all…
July 18, 2004 - - Comments:

Technical Support Position Interview Questions

Please find Technical Support Position Interview Questions. If you have any from your experience please send them to us. We will update this article. These questions can be found in EFS Repository in PDF format. Technical Support Position Interview Questions (74 Questions) Programming 1) What is a stored procedure?2) What is a trigger? Novell (server)1) How do you see different Novell servers from a Console prompt?2) What is the autoexec.ncf?3) What is RIP/SAP?4) How do you bind the IPX protocol to a card? IP protocol? Novell(client) 1) What utility would you use if you were having problems with you NDStree?2)…
August 4, 2004 - - Comments:

Benefits of Oracle Certification

Benefits of Oracle Certification Beyond OCA, by becoming an Oracle Certified Professional (OCP) you demonstrate your understanding of the full range of skills required by Oracle professionals in your chosen job role. An OCP is in high demand in today’s marketplace. The level of demand continues to grow with each new installation of Oracle technologies around the world. An OCP Certification raises your visibility and increases your access to the industry’s most challenging opportunities. The demand for professionals in the information technology (IT) industry is high, and the competition for jobs is intense. Individuals, experienced or new to the profession,…
August 27, 2004 - - Comments:

Tips on How to face an Interview!

Author: Kamal, Bangalore Freshers. A JOB interview can be a nerve-wracking experience if you are not prepared and lack self-confidence. We present a few tips that will help you to brush up on your interview skills and come out as a winner from your next interview! 1. Plan to arrive 10 minutes early. This will give you ample time to catch your breath, gather your thoughts and make a quick trip to the washroom to give your appearance one final check. To avoid unnecessary stress, choose your interview attire the night before. 2. Greet the interviewer by his or her…
September 3, 2004 - - Comments:

Importance of Body language in interviews

Interpreting your body language: Body language is one of the very powerful ways of communicating. When it comes to your career, especially while attending interviews, every small movement you make will amplify and suggest what’s going on in your mind. You might unknowingly minimize the chances of getting into a job that fits your profile because of faulty actions. Lets look at a few ‘wrongful actions’ commonly committed during interviews so that you can try to avoid them in your next interview. Face is the index of mind. Your face is the most transparent medium in your body and every…
September 4, 2004 - - Comments:

Introduction to Oracle 9i SQL, PLSQL, and SQL *Plus

We are excited to let you know that we are launching shortly The New Technology Learning Series. We will be starting with Oracle 9i: SQL, PLSQL, and SQL *Plus. Below is the course schedule by week. Please let us know if you have suggestions. Oracle 9i: SQL, PL SQL, and SQL *Plus Course Description: This course introduces students to data server technology, and explores the concepts of relational databases and the powerful SQL and PL/SQL programming languages. Students will learn and practice how to create and maintain database objects. You will also learn to store, retrieve, and manipulate data. Finally,…
October 24, 2004 - - Comments:

Oracle 9i Software Installation, SQL, PLSQL and SQL *Plus References

Before we actually start with the lessons, we need to install and setup Oracle on your pc to be able to practice. I would recommend all of you to install Oracle before you start with any of our lessons in the following weeks. Please use discussion board for any questions you might have in this Learning Series. That helps other users answering the same questions. Next week we will be starting with our first lesson. In the mean time please setup your pc with Oracle Software. Follow the link to download the appropriate version according to your operating system. Download…
October 25, 2004 - - Comments:

Few tips and strategies for getting job

There are some common strategies when seeking employment in the high-tech industry.  Certainly, if you have any personal contacts that work in the industry, don’t hesitate to call upon them! Many jobs are found through personal references.     Resumes Certainly, you must present yourself in a professional manner, beginning with your resume. Study books on resume writing for examples of how to write a resume that will appeal to the "high-tech" industry. One tip is to make sure your resume includes a "buzzword" section near the beginning. This would include every type of computer hardware and software you have knowledge about, no…
January 25, 2005 - - Comments:

Finding Your First Job – Adjusting to a New Job

The first few weeks of a new job are always difficult. You want to impress your co-workers as a hard-working, honest, intelligent team member. You want to show your boss that you are competent and talented. And all the while, you can’t remember which cabinet holds the office supplies, you’ve forgotten at least two officemates’ names, and your computer seems to be haunted.  by ResumeEdge.com – The Net’s Premier Resume Writing and Editing Service Even seasoned professionals say starting a new job is rough – it’s even harder if you’re a recent college graduate getting acquainted with the real world….
January 30, 2005 - - Comments:

Oracle 9i Tables and Constraints

In week 6 of our Oracle 9i training course we will be learning about Data types with the differences between different Oracle versions, creating tables, altering tables, dropping tables, Integrity constraints supported by Oracle, Inserting records, Modifying the records and deleteting the records. If you can’t see the screen shots, please save them on to your hard disk. Table: Tables are basic units of data storage. A table is defined as intersection of rows and columns. Data is stored in rows and columns. Oracle Data Types: CHAR: Char data type stores fixed-length character strings. Max Size: Oracle 7 255 bytes…
February 2, 2005 - - Comments:

XML Unit Testing tools Series 1

Avignon allows for true test-first design by letting users express test cases in XML prior to the start of unit development. Avignon is an acceptance test system that allows you to write executable tests in a language that you define.  It uses XML to define the syntax of the language but, if you choose to extend the language, leaves the semantics of the tests up to you.FeaturesRunning Tests : Avignon is implemented in Java, and is configurable for many different forms of test execution.Requirement: Junit, HTTPUnit, JAXP, Xalan Avignon is being released freely under the GPL license. The single ZIP…
February 6, 2005 - - Comments:

More Oracle 9i Database Objects

This week we will be learing about Sequences, Synonyms, Indexes, Views, Data Dictionary View, Controlling Database Objects, GRANT, REVOKE Roles and Privileges. COMMIT, ROLLBACK and SAVEPOINT SQL*PLUS has a facility to automatically commit all the work, without explicitly issuing the commit command i.e. SET AUTOCOMMIT ON — Enables autocommit feature. SET AUTOCOMMIT OFF — Is the default and disables the automatic committing Note: Certain actions automatically force a commit. DDL Commands CREATE, DROP, ALTER and DCL commands EXIT, GRANT, REVOKE, CONNECT, DISCONNECT, AUDIT and NOAUDIT are example for this. (i.e. the work done by these commands can not be taken…
February 14, 2005 - - Comments:

Building PL/SQL Blocks in Oracle 9i

This Week we will be learning about Creating PL/SQL Blocks which includes Declaration Section, Variables, Scope of Variables, Constants Records, Manipulating Data in PL/SQL and Using DML in PL/SQL . PL/SQL is a procedural extension for Oracle’s Structured Query Language. PL/SQL is not a separate language rather a technology. Mean to say that you will not have a separate place or prompt for executing your PL/SQL programs. PL/SQL technology is like an engine that executes PL/SQL blocks and subprograms. This engine can be started in Oracle server or in application development tools such as Oracle Forms, Oracle Reports etc. As…
February 16, 2005 - - Comments:

ASP.NET with C# Training Launch

ASP.NET with C# training series is packed with skill enhancing, step-by-step tutorials to help you successfully build database-driven Web applications and Web services. ASP.NET with C# training provides Sample Code along with articles links from external sites (if any). Please use Discussion Board if you have any questions. ASP.NET Training Prerequisites At least one year of consistent object-oriented or object-based development experience in Java, C++, Visual Basic, or another modern object-oriented or object-based language and solid knowledge of HTML and should know SQL and relational databases. ASP.NET Features and Advantages ASP.NET is a compiled, .NET-based environment; you can code the…
February 19, 2005 - - Comments:

ASP.NET with C# Training Course Outline

This article contains list of topics covered in ASP.NET with C# training series.ASP.NET with C# Training Course Outline Introduction to ASP.NET with C# A Review of Classic ASP ASP.NET Web Applications Rendering HTML with Server Controls Using ASP.NET to Deliver XML Web Services Working with Web Forms Controls and C# Introduction to Web Forms Controls Simple Input Controls HyperLinks Button Controls List Controls Validating User Input with C# Overview of ASP.NET Validation Controls Client-Side Validation Server-Side Validation Required Field Validator Summarizing Results with the ValidationSummary Control Using Rich Server Controls with C# Introduction to Rich Controls The Calendar Control The…
February 19, 2005 - - Comments:

Introduction to ASP.NET with C#

Introduction: In this tutorial we will introduce the new technology for building websites. This new technology is known as ASP.Net. ASP.Net allows the developer to build applications faster. This is achieved due to the fast that ASP.Net makes use of the rich class libraries provided by Microsoft. net framework. Topics Introduction Classic ASP ASP.Net Web Applications Use of Controls HTML Controls HTML Server Controls Web Server Controls Special Note Language Options Caching features Tools ASP.Net Web Services References Classic ASP: Asp, which is now more commonly known as Classic Asp was used extensively in 1990's. The idea of creating dynamic…
February 20, 2005 - - Comments:

Microsoft Analysis Services Training

  Microsoft Analysis Services Training   We are glad to let you know that we are starting with Microsoft Analysis Services Training in the following topics. We will be publishing the tutorials as we complete. Please use discussion board if you have any questions and would like to discuss any. We will be providing step by step screen shots and the sample code. 1: Introduction to Data Warehousing and OLAP Introducing Data Warehousing Defining OLAP Solutions Understanding Data Warehouse Design Understanding OLAP Models Applying OLAP Cubes 2: Introducing Analysis Manager Wizards Defining Terms Previewing Analysis Manager Preparing to Create a…
February 25, 2005 - - Comments:

Introduction to Data Warehousing

This tutorial starts with the introduction to Data Warehousing, Definition of OLAP, difference between Data warehouse and the OLTP Database, Objectives of data warehousing and data flow. Computerization of business processes; technological advances in transmission and storage of data; and powerful database management tools have opened up new possibilities of data manipulation and analysis. Business managers are eager to explore the repositories of current and historical data to identify trends and patterns in the wrap and hoof of business. They hope to mine data and use them for taking intelligent business decisions. In this context, industries are increasingly focusing on…
February 25, 2005 - - Comments:

Data Warehouse database and OLTP database

In this tutorial we will learn about the differences between Data Warehouse database and OLTP database and the objectives of a Data warehouse and Data flow. The data warehouse and the OLTP data base are both relational databases. However, the objectives of both these databases are different. The OLTP database records transactions in real time and aims to automate clerical data entry processes of a business entity. Addition, modification and deletion of data in the OLTP database is essential and the semantics of the application used in the front end impact on the organization of the data in the database….
February 25, 2005 - - Comments:

ASP.NET Web Forms Controls

Working with Web Forms Controls and C# covers Introduction to Web Forms Controls, Simple Input Controls, HyperLinks and Button Controls and List Controls Introduction: In this tutorial we will introduce some of the most commonly used controls used in Asp.net web programming. We will see all the different types of controls and their behavior. I will not talk about complex, data bound or template controls in this tutorial since we are going to look at that in later tutorials. Web Form Controls: As in the previous tutorial I explained that there are three types of controls in Asp.net namely, HTML…
February 26, 2005 - - Comments:

Oracle 9i PL/SQL Control Structures

This tutorial teaches about how to structure flow of control through a PL/SQL program. The control structures of PL/SQL are simple yet powerful. Control structures in PL/SQL can be divided into selection or conditional, iterative and sequential. Control Structures This chapter teaches about how to structure flow of control through a PL/SQL program. The control structures of PL/SQL are simple yet powerful. Control structures in PL/SQL can be divided into selection or conditional, iterative and sequential. Conditional Control (Selection): This structure tests a condition, depending on the condition is true or false it decides the sequence of statements to be…
February 26, 2005 - - Comments:

Defining OLAP Solutions and Data Warehouse design

This tutorial covers OLAP solutions used by Data warehouses and understanding Data Warehouse design. The enterprise needs to ask itself certain fundamental questions before actually launching on the process of designing the data warehouse. It must begin with a conviction that a data warehouse would really help its business and the return on investment will make it worth it.Defining OLAP Solutions The data warehouse offloads data from a multitude of sources. The cleaned, validated and loaded data is voluminous and daunting. This data needs to be organized, categorized and arranged in meaningful order for analytical purposes. OLAP solutions are specifically…
February 27, 2005 - - Comments:

Oracle 9i Cursors

In this week tutorial 10 as part of Oracle 9i SQL and PL/SQL training explains about the Introduction to Cursors, different types and the Cursors and Loops with sample code and screen shots. CURSOR For every SQL statement execution certain area in memory is allocated. PL/SQL allow you to name this area. This private SQL area is called context area or cursor. A cursor acts as a handle or pointer into the context area. A PL/SQL program controls the context area using the cursor. Cursor represents a structure in memory and is different from cursor variable. When you declare a cursor,…
February 27, 2005 - - Comments:

Design of the data warehouse: Kimball Vs Inmon

This tutorial covers the basic design concepts, The top down approach, The Bottom-Up Approach , Hybrid Approach and Federated approach.Ralph Kimball and Inmon, the co-founders of the data warehouse, significantly had their own differences in the design and architecture of the data warehouse. Inmon advocated a “dependent data mart structure” whereas Kimball advocated the “data warehouse bus structure”. The Dependent Data Mart structure:The top down approachBill Inmon saw a need to transfer data from diverse OLTP systems into a centralized place where the data could be used for analysis. He insisted that data should be organized into subject oriented, integrated,…
February 28, 2005 - - Comments:

Designing the Dimensional Model and Preparing the data for OLAP

This tutorial covers Designing the Dimensional Model, Dimensional Model schemas like Star Schema, Snowflake Schema, Optimizing star schema and Design of the Relational Database, OLAP Cubes and Data mining tools, Security considerations, metadata and backup and recovery plans.Preparing the data for OLAP The global issues out of the way, the enterprise must begin to focus on the granular design issues. The data in the data warehouse must be prepared for the application of Online Analytical Processing (OLAP) solutions and such preparations will be driven by the business needs of the enterprise. Designing the Dimensional Model User requirements and data realities…
March 1, 2005 - - Comments:

Understanding OLAP Models

This tutorial covers the different types of OLAP models like Relational Online Analytical Processing mode( ROLAP), Multidimensional Online Analytical processing mode(MOLAP) and Hybrid Online Analytical Processing mode or HOLAP. Cubes in a data warehouse are stored in three different modes. A relational storage model is called Relational Online Analytical Processing mode or ROLAP, while a Multidimensional Online Analytical processing mode is called MOLAP. When dimensions are stored in a combination of the two modes then it is known as Hybrid Online Analytical Processing mode or HOLAP.MOLAPThis is the traditional mode in OLAP analysis. In MOLAP data is stored in form…
March 2, 2005 - - Comments:

MSAS – Applying OLAP Cubes

This tutorial covers the types of changes that impact on cubes and Synchronization OLAP and data warehouse data. Multidimensional cubes are created out of the data stored in the data warehouse. Numerical measures are also summarized into pre-aggregated values when cubes are constructed. These cubes are then stored in multidimensional structures that are designed for rapid query. The pre-aggregated information is combined with raw fact data to respond to a wide variety of queries. Types of changes that impact on cubesSince cubes contain summarized data from the data warehouse, any changes to the data in the warehouse also affects the…
March 3, 2005 - - Comments:

Download example SQL Scripts used in Oracle 9i Tutorials

Above are the SQL scripts used in the tutorials form 1 through 10. Please find the link for to download all the scripts in zip file. Download Examples [catlist id=172].
March 3, 2005 - - Comments:

Oracle 9i Exception Handling

This week tutorial covers Oracle Exception Handling and the different types in it with sample SQL scripts along with the screen shots. Topics covered in this week, Introduction to Exception Handling – Propagation of Errors Types of Exceptions – Named System Exceptions; Unnamed System Exceptions; User-Defined Exceptions. Exceptions An Exception is an error situation, which arises during program execution. When an error occurs exception is raised, normal execution is stopped and control transfers to exception-handling part. Exception handlers are routines written to handle the exception. The exceptions can be internally defined (system-defined or pre-defined) or User-defined exception. Predefined exception is…
March 3, 2005 - - Comments:

ASP .NET: Validating User Input with C#

This tutorial covers Validating User Input with C# covers Overview of ASP.NET Validation Controls , Using the Simple Validators , Using the Complex Validators and Summarizing Results with the Validation Summary Control. In this tutorial we will see the validation controls. The purpose of the validation controls is to validate the user input. Asp.net provides the developer with different types of validation controls. One most important point to note is that the validation is done on the client side as well as on the server side. You can always turn the validation on the client side off using the enable…
March 4, 2005 - - Comments:

Microsoft Analysis Services Installation

This tutorial covers the download and step by step installation instructions along with the screen shots which helps with your PC setup to contine learning MSAS. Download or order the SQL Server 2000 120-day Trial Software. SQL Server is a complete database and data analysis package that opens the door to a new generation of enterprise-class business applications. SQL Server CE is the compact database for rapidly developing applications that extends enterprise data management to mobile and embedded devices. This fully functional trial software will be automatically turned off after four months. You can obtain the fully purchased version at any…
March 5, 2005 - - Comments:

Oracle 9i PL/SQL Collections

This tutorial covers Defining and Using Collections – Declaring, Initializing, and Referencing PL/SQL Collections and Collection Methods – Using the Collection Methods. Oracle 9i: PL/SQL Collections Introduction Version 8.0 and higher versions of Oracle are referred to as ORDBMS (Object-Relational Database Management System). The traditional Oracle database management system is extended to include Object-Oriented Concepts and structures such as abstract data types, nested tables, varying arrays, object views and references. Abstract Datatypes Also called user-defined datatypes are those that consist one or more subtypes. Apart from using standard oracle datatypes they can also use other abstract datatypes. An abstract datatype…
March 6, 2005 - - Comments:

MSAS : Introducing Analysis Manager Wizards

This tutorial covers brief introduction to Analysis Manager Wizards, how to start, Previewing and Defining terms which helps to understand the navigation along with the screen shots.Introducing Analysis Manager WizardsThe Analysis Manager is a console application in Microsoft SQL Server 2000. It provides an interface for accessing Analysis servers and their metadata repositories. The Analysis manager console can be used to administer servers, create databases, cubes, data mining objects, or for specifying storage options and optimizing query performance. The console also allows the user browse data sources, shared dimensions and security roles. It snaps into the Microsoft Management console, which…
March 7, 2005 - - Comments:

MSAS : Preparing to Create the Cube

This tutorial explains the steps to create the cube and the preparation like settip the datasource.Preparing to Create the CubeA cube is the fundamental unit of data storage and retrieval in the Analysis Server. A cube can be created with either the Cube Wizard or the Cube Editor. The cube wizard provides very limited options as against the options available in the Cube Editor. In this section of the tutorial we propose to concentrate on the Cube Wizard and learn how to create a cube, process a cube and browse the results using the Wizard.Setting up the Data source NameEvery…
March 7, 2005 - - Comments:

MSAS : Setting up the Database in Analysis Server

This tutorial explains Setting up the Database in Analysis Server and how to connect and test the connectivity.Setting up the Database in Analysis ServerThe first step in creating a cube is the setting up of the Database. Double click on the server and connect to it. Once the connection is established, the user can proceed to create the database. Right click on the server node and select ‘New Database’. On clicking on “New Database” a tiny window opens prompting the user to enter the name of the database and a description of it. The database has been named Sample and…
March 7, 2005 - - Comments:

MSAS : Building the Cube Part #1

This three part tutorial explains about cubes, Dimensions and how to create them using the wizards. You need to understand and learn how to create the cubes since it’s very critical step.Tutorial 12: MSAS : Building the Cube Part #1A cube is a multidimensional structure consisting of dimensions and measures. Therefore, we need to know what dimensions we intend to use and what measures will be captured. In short, we need to know what quantitative values we want to analyze or monitor from our database. Usually organizations capture actual measures such as revenues, sales in context of expenses, costs along…
March 9, 2005 - - Comments:

MSAS : Building the Cube Part #2

This is part 2 in MSAS : Building the Cube series, If you have not completed reading part1, please do so before continuing with this tutorial.Tutorial 13: MSAS : Building the Cube Part #2Click ‘New Dimension…’ button to launch the Dimension Wizard. The welcome dialog box of the Dimension wizard appears. The Check box option is to be checked if we want to skip this screen in future. For the present we leave it as it is and click the Next button.The next requirement is to select the kind of schema we want for our cube. On clicking Next we are taken…
March 10, 2005 - - Comments:

MSAS : Building the Cube Part #3

This is part 3 in MSAS : Building the Cube series, If you have not completed reading part 1 and 2 , please do so before continuing with this tutorial. Tutorial 14: MSAS : Building the Cube Part #3The next dimension that we need to create is the Time dimension. This is the most common dimension and inevitably forms a dimension of every cube. However, there are certain specific conditions that arise when we create the time dimension. In the Select Dimensions dialog box of the Cube Wizard we will chose time_by_day dimension table. The time dimension table is usually…
March 10, 2005 - - Comments:

MSAS : Designing Storage and Processing the Cube

This tutorial covers the storage modes for the cube before it can be processed. The kind of storage selected will determine the query performance and enhance the cube efficiency.Tutorial 15: MSAS : Designing Storage and Processing the CubeWe have already discussed in detail the type of storage options that are available in OLAP. Analysis Services offers the end user all the different storage options of the OLAP. Multidimensional OLAP (MOLAP), Relational OLAP(ROLAP) and Hybrid OLAP(HOLAP) are available in Microsoft Analysis services. Now that the design of the cube has been completed the user will have to designate one of the…
March 10, 2005 - - Comments:

MSAS : Browsing the Cube

This tutorial explains about the Cube Browser,  it’s a tool provided within the Analysis Services to display the results of the cube process without the need to add external software.Tutorial 16: MSAS : Browsing the CubeThe processed cube can now be analyzed. For the purpose of this tutorial we will use ‘slice and dice’ and drill down capabilities of the Cube Browser to browse the cube. The Cube Browser is a tool provided within the Analysis Services to display the results of the cube process without the need to add external software. It is a relatively useful data analysis tool that can…
March 10, 2005 - - Comments:

SQL Server 2000 Training Details

We are glad to let you know that we have started SQL Server 2000 training series. See the topics below which we will be providing the tutorials. Please let us know if there anything you would like to add to the topics.SQL Server 2000 Training1. Introduction to Microsoft SQL Server 2000 Overview of SQL Server 2000 | Components of SQL Server 2000 | Overview of SQL Server 2000 Architecture 2. Installing SQL Server 2000 Planning to Install SQL Server 2000 | Deciding SQL Server 2000 Setup Configuration Options | Running the SQL Server 2000 Setup Program | Using Default, Named,…
March 11, 2005 - - Comments:

Using Rich Server Controls with C#

In the last article we saw some of the simple controls. Those included validation controls, TextBox, Label and other simple controls. Microsoft.net framework provides the developer with more advanced controls. Among those are the Calendar, AdRotator and the Xml Control. In this Tutorial we will see how we can make use of the rich controls provided by the framework.Using Rich Server Controls with C# Introduction: In the last article we saw some of the simple controls. Those included validation controls, TextBox, Label and other simple controls. Microsoft.net framework provides the developer with more advanced controls. Among those are the Calendar,…
March 12, 2005 - - Comments:

SQL Server 2000:Creating and Using Stored Procedures

This tutorial series covers the basic concepts of Stored Procedures in SQL Server and hot create and execute a simple stored procedure.Using Stored ProceduresSome of the most important concerns to a database user are speed and efficiency. Faster data retrieval provides applications to responds and behaves quickly. SQL Server provides “Stored Procedures” for faster and quick data access. Stored Procedures is a query that is stored in a database on SQL Server rather than being stored in the front-end code on users machine. You may think that storing queries in the form of Stored Procedures will be an overhead itself???…
March 12, 2005 - - Comments:

SQL Server 2000: Creating Stored Procedure with Input and Output Parameters

This tutorial explains how to create and use Stored Procedures with Input Parameters and output parameters along with the screen shots and sample code. Creating Stored Procedure with Input ParametersInput Parameters in Stored Procedures are placeholders for data that the user needs to send. Technically, input parameters are memory variables because they are stored in memory. For creating Stored Procedure with Input Parameters, just change the above code to look like CREATE PROCEDURE Show_Customer @City varchar(50) AS SELECT FirstName, LastName FROM Customer WHERE Location=@City ORDER BY FirstName Here the placeholder i.e. Input parameter is @City variable. It accepts the value,…
March 12, 2005 - - Comments:

SQL Server 2000: Securing Your Stored Procedure

This tutorial explains how to secure your stored procedures if you ever need to.  Procedures resides on the database server in open fashion. It means that every body can easily access and view its code. Securing Your Stored ProcedureStored Procedures resides on the database server in open fashion. It means that every body can easily access and view its code. They are present in “syscomments” system table in each database and completely accessible. In order to secure it, we can encrypt them by using “WITH ENCRYPTION” keyword. Remember that encrypting stored procedures is a single step process and you can’t…
March 13, 2005 - - Comments:

SQL Server 2000: Using System and Extended Stored Procedures

This tutorial covers how to use System Stored Procedures which are stored in master and msdb databases and normally begin with ‘sp_’ and Extended Stored Procedures normally begin with ‘xp_’.Using System Stored Procedures Whenever you add a database, add a login, create a table or modify any object, the changes reflect in the system tables. System tables are used by the SQL server’s for its own reference but we can also view their contents. But the information stored in them is somewhat in binary or unreadable format, therefore Microsoft has given us System stored procedures (almost 650) to read or…
March 13, 2005 - - Comments:

Oracle 9i Procedures and Functions

This tutorial covers Developing Procedures and Functions, Creating a Procedure, Executing a Procedure, Creating a Function, Executing a Function, Passing Parameters – IN Parameters, OUT Parameters, IN OUT Parameters, Purity of a User-Defined Function and Positional and Named Notations. Oracle 9i : Procedures and Functions PL/SQL subprograms A subprogram is a named block of PL/SQL. There are two types of subprograms in PL/SQL namely Procedures and Functions. Every subprogram will have a declarative part, an executable part or body, and an exception handling part, which is optional. Declarative part contains variable declarations. Body of a subprogram contains executable statements of…
March 13, 2005 - - Comments:

MSAS : Microsoft Data Warehousing Overview

This tutorial explains various functions available and the tools available for building and managing data warehouses. MSAS : Microsoft Data Warehousing OverviewModern day enterprises believe that mission critical decisions should be information based. Vast information repositories and historical data available with them need to be analyzed and emerging patterns examined before any decisions are taken. Data warehousing and business intelligence solutions were looked upon as means of achieving this purpose. This need triggered off a proliferation of data warehousing and business intelligence solutions in the market. Initially these solutions were scattered, disparate and focused on specific areas of Data warehousing such…
March 15, 2005 - - Comments:

MSAS : The Data warehousing framework of SQL Server 2000 – Part 1

The Data warehousing framework is a set of components and API’s that implement the data warehousing features of the SQL server 2000. The common interface of the server known as the Enterprise Manager can be used by various components to build and use the data warehouse or a data mart.The Data warehousing framework of SQL Server 2000The following illustration details the Microsoft SQL Server 2000 data warehousing overview.The relational database engine of the SQL server is a modern, highly scalable and reliable engine for storing data. The database stores data in tables and each table represents objects that are of…
March 15, 2005 - - Comments:

SQL Server 2000: Using Views in SQL Server

This tutorial on Views in SQL Server covers the concept of views, Creating Simple View, deleting views and how to use them.Using Views in SQL ServerViews are nothing but saved SQL Statements, and are sometimes referred as “Virtual Tables”. Views cannot store data; rather they only refer to data present in tables. As the name implies, they are just used to view the contents of the tables by means of joins etc. They can be used to provide row- or column-level access to data, to wrap up complex joins, to perform complex aggregate queries, and to otherwise customize the display…
March 17, 2005 - - Comments:

MSAS : The Data warehousing framework of SQL Server 2000 – Part 2

This is part 2 of  MSAS : The Data warehousing framework of SQL Server 2000.  It’s very important that you understand the concepts if you are really trying to get job in Data Warehousing field.MSAS : The Data warehousing framework of SQL Server 2000 – Part 2The Online Analytical Processing (OLAP) tools offered by Microsoft are impressive, considering the fact that Microsoft entered the OLAP market only in 1998. A review of the growth of Microsoft tools in this area, clearly indicates that they have grown from being a mere entrant to being a market leader in the field. What…
March 18, 2005 - - Comments:

MSAS : The Analysis Manager and Analysis Server

Analysis services is the middle tier server component of the MS SQL 2000. It manages multidimensional OLAP cubes of data and ease of access to such data to end users. It also enables user to create data mining models from the data in the cubes or in the relational databases. The Analysis Manager and Analysis ServerThe Analysis Manager: The MS SQL Server 2000 Analysis services, includes the Analysis manager, which is a console application. This application provides user interface for accessing the Analysis servers and the meta data repositories associated with them. The Analysis Manager is represented as a folder…
March 18, 2005 - - Comments:

Microsoft .NET Unit testing Tools

Here are the few Microsoft .NET Unit testing Tools available. Most of them are opensource and free.Microsoft .NET Unit testing Tools csUnit http://www.csunit.org/ Description: csUnit is a unit testing framework for the Microsoft .NET Framework. It targets test driven development using C#, Visual Basic .NET, and managed C++. Requirement : csUnit has been tested using the Microsoft .NET framework 1.0 Service Pack 2 runtime on an Intel-compatible platform. Unit Testing with C# Tutorial How do I make use of the Assert class? How do I implement simple test cases for my class? How do I integrate csUnit with my code?…
March 18, 2005 - - Comments:

SQL Unit Testing Tools

Please find the Open source SQL Unit Testing tools available. SQL Unit Testing Tools SPUnit SPUnit  Description: SPUnit is an application of the popular xUnit framework concept to enable unit testing of SQL Server stored procedures.  SPUnit is (loosely) based on the xUnit family of Unit Test Frameworks. It is intended for testing MS SQL Server stored procedures using actual stored procedures. The idea was to make it really painless to test the code in stored procedures, and facilitate test-first programming of stored procs. It is a port inspired by JUnit, a testing framework for Java, developed by Kent Beck…
March 18, 2005 - - Comments:

Accessing Data with C#

This tutorial explains about Accessing Data with C# with an Overview of ADO.NET, Connecting to Data , Executing Commands , Working with Data and Choosing an ADO.NET Provider along with the Project files used in this.   ASP.NET: Accessing Data with C#  Introduction: When working with classic asp we had ADO, object model for communication with the database. Microsoft.NET has introduced ADO.NET components that lets the developer communicate with the database more efficiently and easily. In this article we will see how we can make use of the ADO.NET classes to perform different operations on the database. ADO. NET Classes:…
March 19, 2005 - - Comments:

MSAS : The Wizards

The primary aim of Microsoft was to ease the process of building and using data warehouses. A large number of wizards, editors and tools have been built into the Analysis services to fulfill this objective. The wizards available for use are: The Cube wizard that helps the user build all the structures necessary to create an OLAP cube. It walks the user through the entire cube design and implementation process. The user can map the data sources, create dimensions and define measures using this wizard. The Cube Editor is useful in editing cube structures or in creating new cubes. The…
March 23, 2005 - - Comments:

MSAS : Analysis services Tools for Extended Functionality

Analysis services provides various tools that can be programmatically used to extend its functionality. Analysis services supports OLE DB to meet the OLAP specific requirements and is also designed to meet the requirements for Data mining specifications. The Analysis services is made compatible with the ActiveX Data Objects(ADO) and its multidimensional counterpart ADO MD. User defined functions for creating Component Object Model(COM) libraries enable the Analysis services to extend its capabilities of using automation languages such as Microsoft Visual Basic or Microsoft Visual C++. These libraries can be registered and the functions can be used in calculated member definitions and…
March 23, 2005 - - Comments:

MSAS : Meta data Repository

Metadata is a description of data. It provides a consistent way to describe data structures. It is used to describe data as it is being transformed and gives a clear explanation of the meaning of different fields, measures, levels and dimensions. All releases of Microsoft development and data management tools support and allow access to the Repository. The storage of data about data in a central location has some advantages.Reusability: With the storage at a central location the data can be used and reused. Dependency tracking: the repository stores information about different objects and the relationships between stored objects. Hence…
March 23, 2005 - - Comments:

MSAS : Cube Storage options

In the first tutorial of this series “Introduction to Data Warehousing and OLAP” we briefly touched upon storage options that are used in data warehousing. In the second chapter “ Introducing Analysis Manager Wizards” we learnt how to use the cube Storage wizard to set storage options for the cube we had created. In this section of the tutorial we will be going into a little more detail on the various kinds of storage options available in Analysis Services and will be touching on the pros and cons of the different storage modes. To recapitulate, a cube is a multidimensional…
March 23, 2005 - - Comments:

MSAS : Client Architecture

The PivotTable Service:The interfaces used by client applications to access OLAP data and data mining data on the server are provided by the PivotTable Service. The PivotTable service is a set of tools that enable the transfer of OLAP cubes to client applications from the OLAP server. Two programming interfaces for querying data are available to the developer from the PivotTable Services:–The OLE DB for OLAP and the ActiveX Data objects Multidimensional (ADO MD). Tools such as those available in VisualStudio.Net are harnessed to create applications that query multi dimensional data sources. The figure below illustrates the relationship scenario.Using the…
March 25, 2005 - - Comments:

MSAS : Office 2000 OLAP Components

PivotTable component in Office 2000 is the PivotTable report feature. It allows the user select and cross tabulate numerical values in ways that are similar to the processes of a cube. The earlier versions of this report in Excel could only extract values from relational data sources. The version under reference can present data directly form an OLAP cube.There is another PivotTable in Office 2000 which is a PivotTable list feature. This is a part of the Office Web Components. This component has the same functionalities as the PivotTable report, but includes capabilities that aren’t available in Excel component. It…
March 25, 2005 - - Comments:

ASP.NET Using the DataList and Repeater, Datagrid Controls

In this tutorial of Week 6 we will be learning about Overview of List-Bound Controls, Creating a Repeater Control, Creating a DataList Control, Introduction to the DataGrid, Setting Up the DataGrid , Using Advanced DataGrid Features and Adding Advanced Features. Overview of List-Bound Controls As we have seen in the previous tutorials that Asp.net ships with many controls. We already discussed different types of buttons, validation controls and the calendar controls. But the most power of Asp.net comes with the Databound controls. Databound controls are those controls which can be binded to any data source. They are also known as…
March 26, 2005 - - Comments:

Oracle 9i Database Triggers

This Weeks tutorial explains about Oracle Triggers, Building a Trigger, Trigger Execution, Trigger Restrictions and Testing Mutating Tables.Database Triggers A database triggers is stored PL/SQL program unit associated with a specific database table or view. The code in the trigger defines the action the database needs to perform whenever some database manipulation (INSERT, UPDATE, DELETE) takes place. Unlike the stored procedure and functions, which have to be called explicitly, the database triggers are fires (executed) or called implicitly whenever the table is affected by any of the above said DML operations. Till oracle 7.0 only 12 triggers could be associated…
March 28, 2005 - - Comments:

Understanding Dimension Basics

The next 6 tutorials explains Building Dimensions using Dimensions Editor. Dimensional modeling is the conceptualization and visualization of numerical data models as a set of measures that are derived from the common parameters used in a business. It summarizes and rearranges data and presents views of data to support data analysis. Dimensional modeling focuses on data such as counts, weights, balances and occurrences. Understanding Dimensions BasicsDimensional modeling is the conceptualization and visualization of numerical data models as a set of measures that are derived from the common parameters used in a business. It summarizes and rearranges data and presents views…
March 29, 2005 - - Comments:

MSAS : Shared vs Private Dimensions

This tutorial explains how to create Shared dimension using Dimension Editor , Private dimension using Dimension Editor and the differences between them.Creating Shared Dimension using Dimension Editor 1. In the Analysis Manager tree pane, expand the database in which you want to create the shared dimension.2. Right-click the Shared Dimensions folder, point to New Dimension, and then click Editor3. In the Choose a Dimension Table dialog box, expand a data source, click the dimension table for the dimension, and then click OK.Dimension Editor appears with the dimension table showing in the Schema tab.4. To add more tables to the dimension,…
March 31, 2005 - - Comments:

MSAS : Working with Standard Dimensions

Dimensions are created, based on dimension table columns, member properties, or from the structure of OLAP data mining models. When a dimension is defined, there are a number of possible approaches. Each approach produces a different dimension variety. Standard Dimensions are regular dimensions. They can be of two types. The standard star schema dimension and the standard snowflake dimension.Within the Dimension editor a new standard dimension can be created in two ways:-Using the Dimension Wizard or multiple dimension tablesOpen the Dimension editor and select <new> from the dimension drop down list box on the tool bar. The Editor displays the…
March 31, 2005 - - Comments:

MSAS : Basics of Levels

A level is an element of a dimension hierarchy that describes the hierarchy from the highest level to the lowest level of data. Levels exist within dimensions and are based on columns in the dimension table or member properties in the dimension. They specify the contents and structure of the dimension’s hierarchy and determine the members that are included in the hierarchy and their positions relative to one another within the hierarchy.Levels get created when a dimension is created using the Dimension Wizard, Editor or the Cube Editor. The levels can then be maintained and their properties can be set….
March 31, 2005 - - Comments:

MSAS: Working with Parent-Child Dimensions

Parent child dimensions when viewed from within a cube reveal some interesting features. We will add an private employee parent child dimension to the sales cube and study the features thereof.In the cube Editor right click the Dimensions folder and click New Dimension to launch the Dimension wizardSelect the parent child option and click Next. Select the Employee dimension table and click Next. Select the Employee_ID in the member key list, Supervisor_ID in the Parent Key List, and Full_Name in the Member Name list. Then click Next. Click Next to skip the Advanced options screen. Type Employee as the dimension…
March 31, 2005 - - Comments:

MSAS: Working with Levels and Hierarchies

Dimensions are defined as structural attributes of a cube made up of levels arranged in hierarchies. A level is a set of members of a dimension organized such that all members of the set are at an equal distance from the root of the hierarchy. A hierarchy is the set of members in a dimension and their positions relative to one another.Working with Levels and hierarchiesThe basic facts relating to levels was discussed in “Building Dimensions using Dimension Editor”. In this tutorial we will go a little deeper into how to work with levels and hierarchies. Before proceeding with the…
April 3, 2005 - - Comments:

MSAS: Dimension Storage Modes and Levels

Dimensions are stored in the Multidimensional OLAP or Relational OLAP. The storage mode determines the location and form of the dimensions data. While MOLAP stores data in a multidimensional structure on the Analysis server, ROLAP stores the data in the relational tables. The storage mode can be set using the Dimension or cube editor.When a Dimension’s storage mode is set to ROLAP the following settings have to be made to the levels in the dimension. The lowest level’s Member Keys Unique property is to be set to TRUE.The dimension must not contain member groups.If the dimension is a private one,…
April 3, 2005 - - Comments:

MSAS: Understanding Hierarchies

A hierarchy defines the relative positions of members in a dimension. Hierarchies are sometimes represented as pyramidal structures. The members in this structure are arranged in an expansive order—from the most summarized to the most detailed. For instance in a geography dimension the country may the most summarized and the individual cities and localities may be the most detailed members of the hierarchy.Analysis Services supports three kinds of hierarchies. Balanced, unbalanced and ragged. A balanced hierarchy is a hierarchy in which all branches descend to the same level and each member’s logical parent is the level immediately above the member….
April 3, 2005 - - Comments:

MSAS: Creating a Time Dimension

Time dimensions are part and parcel of OLAP cubes. At the lowest level of detail a time dimension may contain a month, minute or even a second. At the most summarized level it may contain a year, a decade or a century. The repetitive nature of time encourages users to view data in terms of a time dimension. How much sales of x product occurred during the month of March or April in the year 2000 compared to the year 2001? This would be a query on a sales cube with a time dimension.A frequent issue that arises while dealing…
April 7, 2005 - - Comments:

MSAS: Creating Custom Rollups

To enable proper aggregation of values along a dimension each member of the dimension needs its own aggregation rule. These rules are provided by custom roll up. Custom rollup operators provide a simple way of controlling the process of rolling up a member to its parents values. Custom rollup operators assigned to a column during the process of creating a dimension. The rollup then, uses the contents of the column as custom rollup operator for each member and is used to evaluate the value of the member’s parents.Custom rollups are enabled when the Unary Operators property of the level is…
April 7, 2005 - - Comments:

MSAS: Introducing Member Properties

Member properties are attributes associated with members. They contain some additional information about a member but cannot be used to create a level in the dimension by themselves. For example each member of the Month level has an associated Boolean number property called Bonus month.If records the bonus given during the month, if any. Since the frequency of bonus is irregular, all months may not have Bonus awarded during the month. This attribute of the month therefore may be 0 or 1 and provides additional information about the month. It does not qualify to be a level by itself. The…
April 7, 2005 - - Comments:

MSAS: Virtual Dimensions

A logical dimension created out of the columns of a physical dimension is a virtual dimension. The contents of a virtual dimension are member properties of the physical dimension or columns and tables of a physical dimension. For instance the Store name level of the Store dimension has a member property named Store Sqft. This member property identifies the area of the store in square feet. This member property can be used to create a virtual dimension and this can be added to any cube that contains the Store Dimension.The virtual dimension can be used like any other dimension by…
April 7, 2005 - - Comments:

Oracle 9i Packages

This weeks tutorial explains about Oracle Packages, Developing Packages, Package Specification, Package Body; Overloading, Oracle Supplied Packages and Dbms_output. Oracle Packages A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification or spec or package header and Package Body. Package Specification acts as an interface to the package. Declaration of types, variables, constants, exceptions, cursors and subprograms is done in Package specifications. Package specification does not contain any code. Package body is used to provide implementation for the…
April 7, 2005 - - Comments:

Managing Data with ADO.NET DataSets and C#

This tutorial explains about The Role of DataSets in ADO.NET , Using DataSets in ASP.NET , Saving DataSets in Session State, Using DataTable Constraints, DataSet, DataRelations Using DataSets with DataAdapters to Modify Data and the Transactional Model in DataSets.   ASP.NET: Managing Data with ADO.NET DataSets and C#   Introduction In this article we will explore the DataSet, DataTable and DataRelations classes. Those who have worked with classic asp will be familiar with record sets. Record set was the individual rows that were retrieved from the database and than binded to the screen using html table or any other html…
April 8, 2005 - - Comments:

MSAS: Introduction and Working with Cubes

The main object in Online Analytical processing is the cube. A cube is defined as a subset of the data in the data warehouse, organized and summarized into multidimensional structure that consists of dimensions and measures. Introduction to Cubes The purpose of creating cubes is to provide an easy to use mechanism for data access and quick and uniform response time for queries. User interface controls are inbuilt into Analysis Services to enable end users to connect to the server for queries and manipulate the cube. Aggregations built into the cube at the time of creation of the cube, enable…
April 9, 2005 - - Comments:

MSAS: Introduction and Working with Measures

The quantitative and numerical columns from a fact table of a cube are the measures of the cube. When the cube is processed the data in the measures get aggregated across the dimensions of the cube. These measures are of primary interest to the end user and are the central values that get analyzed in a cube.Introduction to Measures The quantitative and numerical columns from a fact table of a cube are the measures of the cube. When the cube is processed the data in the measures get aggregated across the dimensions of the cube. These measures are of primary…
April 9, 2005 - - Comments:

MSAS: Defining Cube Properties

Each object in the properties pane of the Cube Editor has its own set of properties which can be used to modify the settings of the object.  The properties of a cube defined in the properties pane are as tabulated below.  In this section we shall use these properties to set the properties of our cubes. Aggregation Prefix: This is a prefix appended to aggregation name for the cube’s partitions, provided that the partition’s aggregation prefix begins with a plus sign (+). In this case, this property’s value is appended to the beginning of the partition’s aggregation prefix. If the…
April 9, 2005 - - Comments:

MSAS: Analysis Server Cube Storage

Online Analytical Processing (OLAP) is essentially data presented as Cubes, dimensions, hierarchies and measures. Users can navigate a complex set of data intuitively using these objects. In this context, consistent response times for each view or slice of data become important. Therefore modes of storing and retrieving data became the key tenet of storage design. In the early days OLAP technology focused upon specialized, non-relational storage models as the only possible mode for OLAP. They called this technology Multidimensional OLAP(MOLAP). Later vendors discovered that the use of database structures(Star and snowflake schemas) helped in indexing, and storage of aggregates, and…
April 12, 2005 - - Comments:

MSAS: The Storage Design Wizard

The Storage Design Wizard helps the user set the storage options and design the aggregations for a cube. While choosing from the three available storage modes the user has to keep certain factors in mind. ROLAP stores aggregations in a relational database and hence it does not make sense to select ROLAP as a storage mode for cubes if the aim is to have speed of performance in analysis. Aggregations in Relational databases are slow and bulky and it defeats the very purpose of creating the aggregations. However, if the user wants to look at the aggregations and understand how…
April 12, 2005 - - Comments:

QuickTest Professional 8.0 CBT Tutorial and Evaluation Copy

Please find the step to get QuickTest Professional 8.0 CBT Step by Step Tutorial and Evaluation copy of the software. It takes couple of min to register and you get everything you need to learn and practice. The best part is comes with 1200 Page PDF Manual with kind of step by step instructions along with screen shots.Introduction to QuickTest Professional 8.0, Computer Based Training Register for free account, you will be able to download QuickTest CBT and Evaluation Copy software. QuickTest Professional is today’s answer for keeping pace with fast-changing software development. And now getting up to speed is…
April 12, 2005 - - Comments:

MSAS: Analysis Services Aggregations

Pre-calculated summaries of data that improve query response time are called aggregations. OLAP technology organizes data into the multidimensional structures of cubes. The dimensions and their hierarchies define the queries that can be asked of the cubes.Cells store the value at the intersection of dimension coordinates. Whenever a query is made on the data, the results have to be fetched from the various locations of cells on the multidimensional structure, affecting response time.  Aggregations consist of all the possible combinations of one level from each dimension in the cube. This makes query response time optimal. However storage and processing time…
April 13, 2005 - - Comments:

MSAS: Usage-Based Optimization

This tutorial explains the usage of the Usage Based Optimization Wizard, The Server Cache , Query Usage and Manipulating the query log. Using the Usage Based Optimization Wizard. 1. When a set of queries have accumulated in the Usage log, the Usage based Optimization wizard can be pressed into service. 2. The task on hand is to select the Logged queries that should be applied and then design aggregations based on them 3. Let us assume that a user has browsed the sales cube and accumulated log entries by manipulating data. 4. Now Right click the Sales cube, click the Usage Based…
April 13, 2005 - - Comments:

MSAS: Optimization Tuning Part 1

SQL Server 2000 Analysis services comes with certain features that optimize performance without the intervention of the Administrator. The Storage Engine is optimized by incorporating the following features;Record size and Data types should be kept as short as possible in the Fact tables and should only include fields for measures and indexed key columns. The Measure fields should use the smallest data type consistent with the measure data but the data type should be large enough to contain summarized values and prevent overflow when aggregations are calculated. Even saving two bytes per row can result in smaller fact tables in…
April 14, 2005 - - Comments:

MSAS: Optimization Tuning Part 2

The SQL Server Query Analyzer is a feature rich Query Analyzer. The tool can provide a graphical representation of a query and helps the user mould queries into more efficient shapes. It also helps identify faulty queries. +To Tune the index created the user will have to open the SQL query analyzer and open a query or enter one. On the Query menu click on Index Tuning Wizard and follow the steps of the wizard. On the Specify workload screen select SQL Query Analyzer Selection and click Next. Select the tables and their indexes View the recommendations made by the…
April 14, 2005 - - Comments:

Creating and consuming XML Web Services with C#

Introduction: We all talk about webservices, webservices can do this and webservices can do that. But when we are asked to make one, we hesitate. Maybe it’s because we never made a webservice before, and all the time playing with Webforms and Windows Forms or even Console Applications. By the way, I love Console applications. In this article, I will show you how to create a simple webservice that is consumed by a Console application client. Motivation of the XML Web Services Most of the people does not understand that why we need a web service and make a wrong…
April 14, 2005 - - Comments:

MSAS – Introducing Dimension and Cube Processing

The Analysis server is like a black box. Everything that happens in the server is recorded, but the end user sees a multidimensional cube created out of the data in the data warehouse and has very little taste of what really goes on behind the scenes. In this section we will be examining this black box to understand how the Analysis server processes Dimensions and cubes. We will also learn how to optimize cube processing and how to troubleshoot cube processing.Processing Dimensions: Introduction Dimensions are building blocks on which the cubes are constructed. When a dimension is processed the Analysis…
April 17, 2005 - - Comments:

MSAS – Processing Dimensions and Cubes

As stated earlier, maps are created when a dimension is processed. However, existing maps of a dimension are destroyed when it is processed and new maps are created. Consequently all cubes accessing the dimension will find it inaccessible and the cube will be invalid. The dimension will become accessible only when the cube is reprocessed.When cubes contain a large number of dimensions and some of the dimensions undergo a change, reprocessing a cube can become a daunting task. However, Analysis server has a solution to this problem. It is possible to Incremental update a dimension. This process does not destroy…
April 17, 2005 - - Comments:

MSAS – Optimizing Cube Processing

Cubes are made up of a fact table and several dimensions. Optimizing cube processing therefore, involves optimizing dimensions also. Let us look at two scenarios. One in which the dimensions are not optimized and the cube is processed and another in which the dimensions are optimized and the cube is processed.
April 18, 2005 - - Comments:

MSAS – Troubleshooting Cube Processing

Microsoft SQL Server 2000 Analysis Services provides the user with many ways of tracking and solving errors. A large number of error logs built into the service help the user pinpoint the exact nature of errors and find solutions for them. Microsoft Tech Net also provides the user online support to troubleshoot problems. This requires paid membership. FAQs of different kinds are available for the reference of users. SQL Server Books Online FAQ SQL Server Enterprise Manager FAQ Administration Tools FAQ Failover Clustering FAQ Multiple Instance FAQ Programming FAQ Replication FAQ Server FAQ Setup and Installation FAQ Upgrading to SQL…
April 18, 2005 - - Comments:

MSAS – Introduction and Managing Partitions

The cube is a storage container that contains data and aggregations of data. Every cube must have at least one partition which must be stored in the Analysis server in which the cube is defined. Partitions are stored as separate files in the Partitions folder under the cube. If a cube contains multiple partitions, some of them can be stored in different physical locations. Partitions of a cube can also have different data sources. The aggregations of the data in the partitions can also be stored in different locations. The end user sees the cube as a single unit and…
April 19, 2005 - - Comments:

MSAS – Merging Partitions

Cubes with multiple partitions can be extremely confusing. Users may like to organize the cubes into a cube with fewer partitions by merging some of the partitions together. The preconditions to the merger of cubes is that the Storage and aggregation design should be the same in the partitions being merged. To merge partitions with different storage designs, the partitions being merged must be edited to have the same storage design. The cubes must then be reprocessed before the merger is attempted. We will merge the Sales 97 partition back into the sales. Right click the Sales 97 partition and…
April 19, 2005 - - Comments:

Exforsys e-Newsletter

ebook
 
© 2024. All Rights Reserved.IT Training and Consulting