Microsoft

Technology Showcase

 

SQL Server Data Migration Approaches: SSIS vs. SQL Server Stored Procedure SQL Server Data Migration Approaches: SSIS vs. SQL Server Stored Procedure
SQL Server integration Services (SSIS) is the de-facto standard for data migration and ETL (Extract, Transform and Load) operations in the Microsoft BI suite of Technologies. Nevertheless, SQL Stored Procedures are still the preferred choice in some of the applications for carrying out data migration activities like loading a delimited flat file into a SQL Server table. This white paper provides a brief understanding of these two data migration approaches, followed by a detailed generic and contextual comparative analysis.

Next Generation Software Factories, using Microsoft Blueprints Next Generation Software Factories, using Microsoft Blueprints
Microsoft has been developing technologies to address the challenges in software development. In this white paper, Infosys’ experts focus on Blueprints, and demonstrate how Microsoft's contextual guidance technology helps build Software Factories.

 

Facial Recognition: A Primer Facial Recognition: A Primer
Facial recognition is an upcoming area that can be used in a lot of potential scenarios. Applications are being developed, for identification, authentication and artificial intelligence across different industry verticals. This white paper provides a holistic approach towards facial recognition technology, its applications, and challenges faced in the areas. It lists some of the standard 2D models of facial recognition techniques adopted till date. It also provides an overview of the algorithms for 3D facial recognition methods.

ASP.NET to Silverlight MigrationASP.NET to Silverlight Migration
With the advent of Web 2.0 Rich Internet Applications (RIA) more and more organizations are keen to get their applications RIA enabled. When it comes to RIA, Silverlight is the platform of choice. However, some basic considerations should be kept in mind before migrating from ASP.NET to a Silverlight based application. This white paper brings together key aspects that should be kept in mind and provides a checklist that can guide the migration effort.

Spatial Data in SQL ServerSpatial Data in SQL Server
Despite information systems making use of spatial data, its technical capabilities has not been entirely tapped. Developers must have specialized knowledge of spatial information to utilize all its features. Database system providers such as Oracle and IBM have extended the use of spatial techniques by providing the features as optional add-ins. This paper discusses the features of spatial data introduced as part of the SQL Server 2008 suite.

SQL Azure™ PrimerSQL Azure™ Primer
Software giants have started offering their products on cloud after it took over application development, and hence the IT industry. Cloud computing utilizes infrastructure capabilities and technologies on a need basis. This model is similar to utility based services - pay for what you use. Due to a large subscriber base, the cost to implement IT applications is far lesser than what enterprises pay for on-premise infrastructure and technologies. SQL Azure™ is a cloud-based relational database service provided as part of the Windows® Azure™ platform. This paper discusses the benefits and challenges involved while targeting the SQL Azure™ platform for development and deployment.

Towards Environmental Sustainability - Environmental Resources ManagementTowards Environmental Sustainability - Environmental Resources Management
Environmental sustainability is no longer a choice; it is an imperative. Measuring and tracking an organization's environmental resource usage is a vital step towards environmental sustainability. However, this invariably leads to the challenge of assessing what data to capture, how to capture that data from disparate systems, how to convert the captured raw data to useful information and report it. Our experts have proposed a 3M model to overcome this challenge and achieve environmental sustainability - Measure, Monitor and Manage. The 3M model will give organizations greater visibility into their performance and usage patterns.

Multicore Programming with .NET 4 Parallel ExtensionsMulticore Programming with .NET 4 Parallel Extensions
Most personal computers and workstations today have multicore processors. However, most software programs are not designed to make use of these multicore processors; hence we don't see much improvement in application performance. The key to improved performance is in parallelizing the code and distributing the work amongst multiple cores. This paper gives a brief overview of the .NET 4 Parallel Extensions using which programmers can write efficient, fine-grained and scalable code..

Microsoft Data Access Technologies - SWOT AnalysisMicrosoft Data Access Technologies - SWOT Analysis
While architecting .NET applications, an architect has to make a choice from the gamut of data access technologies available on Microsoft platform. Our experts track the Microsoft Data Access Technology evolution through ADO.NET, LINQ to SQL, Entity Framework, to WCF Data Services; benchmark it for performance and provide insights on how each has helped overcome limitations over its predecessors. SWOT (Strengths, Weaknesses, Opportunities, and Threats) Analysis is used to provide perspective on each technology and showcase its suitability in various scenarios.

SQL Server Integration Services Package ConfigurationsSQL Server Integration Services Package Configurations
During the deployment of SQL Server Integration Services (SSIS) packages, managing changes to environment-dependent variables is a critical aspect, as in any ETL application. These changes, though common, need to be modified appropriately to ensure smooth deployment. SSIS has various methodologies for efficiently managing such configurations. Our expert describes available package configuration methodologies and provides recommendations for each of them. It helps in selecting an appropriate configuration method, based on the requirement.

Infosys - Microsoft .NET 4 And Visual Studio 2010 For EnterpriseInfosys - Microsoft .NET 4 And Visual Studio 2010 For Enterprise
.NET 4 and VS2010, with several significant features, can benefit enterprise application development strategies on .NET platform. Our expert lists various technical challenges in enterprise application development and explains how adoption of .NET 4 can neutralize them effectively.

 

 

Primer - Windows AzurePrimer - Windows Azure
Windows Azure is Microsoft's Cloud Computing offering. It helps customers realize the benefits of Cloud Computing. Infosys' experts introduce Windows Azure and provide insights into different aspects of Azure-based development, especially for those who are interested in adopting Windows Azure within their Enterprise IT landscape. Azure development lifecycle has been described to provide enterprise project teams insights into how existing methodologies would be altered for those projects targeted to be developed on Azure.

 

UI Prototyping with SketchFlowUI Prototyping with SketchFlow
When developing applications, User Interface (UI) design often gets neglected. Designing a good UI ensures application users are comfortable with it. Our experts explore how the SketchFlow tool in the Expression Suite helps in building fast and intuitive UI prototypes.

 

 

Empowering Power Information Workers through Composites Workload of SharePoint 2010Empowering Power Information Workers Through Composites Workload of SharePoint 2010
Composites built using Access Services of SharePoint 2010 enable creation of rapid transient applications, analytics and reports from existing data. Our expert examines how power information workers can utilize Microsoft Office Access 2010 and improve business agility in short notice.

 

 

Enhancing Search in SharePoint 2010 Using Managed Metadata Services and AnalyticsEnhancing Search in SharePoint 2010 Using Managed Metadata Services and Analytics
Metadata management involves significant content management in organizations. Managing metadata is critical to enhance consistency and accessibility of information. Our experts describe the challenges in metadata management and shares real-world techniques for initiating an enterprise metadata approach using SharePoint Server 2010.

 

 

Dynamic Language RuntimeDynamic Language Runtime
Dynamic Language Runtime (DLR) is Microsoft's new addition on top of the CLR. It enables web developers easily create and use dynamic languages on the .NET framework. DLR brings more variety to the framework and it can also be used to build Domain Specific Languages (DSL). Our expert provides an overview of DLR and how it works. Find out how DLR facilitates meta-programming and enables C# and VB developers work with COM, JSON and XML objects with greater ease.

 

Functional Programming: New Champion on the .NET PlatformFunctional Programming on the .NET Platform
Functional programming in the .NET framework gains credence when you look for languages to write powerful software programs. Our expert explores functional programming and the role of FSharp (F#). Embedded with unique features, it has an edge over functional languages like Lisp and Haskell. Ideas of functional programming have crept into C#, resulting in the creation of Language Integrated Query (LINQ). Where can we use languages like F#? And where can we fit them?

 

Architecture Modeling Using Microsoft Visual Studio 2010 Architecture Modeling Using Microsoft Visual Studio 2010
Microsoft Visual Studio 2010 embraces Unified Modeling Language for seamless architecture, design, development, and testing through an integrated development environment. It has features such as forward engineering, reverse engineering, architecture rules validation, version control, and traceability support. Our expert discusses how the Visual Studio 2010 modeling capability supports various stages in the Software Development Life Cycle (SDLC).

 

Performance Parameters: Analysis and Tuning Methodologies in SQL Server Performance Parameters: Analysis and Tuning Methodologies in SQL Server
The performance monitoring tools released by Microsoft with each release of SQL Server to tune databases help Database Administrators (DBAs) avoid performance bottlenecks. Our expert discusses the evolution of the tool set and how the tools enable developers/ DBAs to optimize code. It also maps tool usability across the Software Development Lifecycle (SDLC).

 

Handling Device Diversity with ASP.NET 2.0 Mobile Handling Device Diversity with ASP.NET 2.0 Mobile
The latest mobile devices support different markup languages, form factors, device capabilities and browsers.
ASP. NET 2.0 Mobile provides the technology and tools to build, deploy and maintain sophisticated mobile applications quickly. Our expert demonstrates how ASP.NET 2.0 Mobile addresses the challenges with the help of mobile server controls.

 

Reasons for adopting .NET Framework 3.5 Reasons for adopting .NET Framework 3.5
With the release of .NET Framework 3.5, developers gain new and powerful tools and technologies to develop applications. .NET Framework 3.5 builds on the success of .NET Framework 2.0 and .NET Framework 3.0. It can be deployed by enterprises seamlessly, without breaking existing applications. .NET Framework 2.0 and 3.0 applications can easily be modified to capitalize on the features of .NET Framework 3.5.

 

Next Generation Software Factories, using Microsoft Blueprints Next Generation Software Factories, using Microsoft Blueprints
Markets are in a state of flux and business dynamics are constantly changing. Customers demand faster time-to-market and maximum ROI with minimum investment. System integrators need to reduce the duration of software development, increase productivity and predictability, and accelerate testing. Infosys' experts focus on Blueprints, and demonstrate how Microsoft's contextual guidance technology helps build Software Factories.

 

Business Intelligence (BI) using SQL Server 2008 Business Intelligence (BI) using SQL Server 2008
BI technologies from Microsoft have continuously evolved over the past decade. With SQL Server 2008, Microsoft has further enhanced their BI offering. This white paper explains some of these key features around Integration, Analysis and Reporting Services.

 

 

DTS to SSIS 2008 Migration DTS to SSIS 2008 Migration
SQL Server Integration service (SSIS) has been enriched with lot of new features in SQL server 2008. To take advantage of these new features, one needs to migrate from DTS to SSIS. This white paper explains the approach to deal with this sort of migration.

 

 

Tutorial: Change Data Capture (CDC) Tutorial: Change Data Capture (CDC)
Change Data Capture (CDC) is a generic database engine feature added to SQL Server 2008. It helps in minimizing the overhead in loading the data warehouses incrementally. This document helps understand the feature and its usage in an Extract-Transform-Load (ETL) scenario.

 

 

Tutorial: Using SQL Server FILESTREAM to store BLOBs Tutorial: Using SQL Server FILESTREAM to store BLOBs
FILESTREAM is a new feature introduced in SQL Server 2008 to store unstructured binary files in the database. This white paper will help understand and use this feature.

 

 

 

Visual Studio 2008 Database Edition Visual Studio 2008 Database Edition
The Visual Studio 2008 Database Edition allows database professionals to take complete control over database development. It has offline database development support and also Visual Studio project-centered source-code representation of the production database system. This white paper assists in understanding the tool and its various features.

 

101 Reasons to Adopt Microsoft Office SharePoint Server 2007 101 Reasons to Adopt Microsoft Office SharePoint Server 2007
Authors: Prashanth Govindaiah and Ravi Prasad V.V.

Microsoft Office SharePoint Server (MOSS) 2007 provides rich solutions that connect people, processes and information leading to greater organizational productivity. It takes care of diverse needs of enterprises through its compelling features such as document management, content management, search, integration with Office suite of products and integration with line-of-business applications.

 

Visual Studio 2005 Visual Studio 2005
The white paper 'VSTE 2005 for Database Professionals' discusses features and benefits that help technical architects, database architects, project managers and developers improve their productivity. It includes perspectives and recommendations from Infosys' experts who have viewed the technology from a practitioner's standpoint.

 

 

Visual Studio Team System Visual Studio Team System
Microsoft's Visual Studio Team System (VSTS) is a productive, integrated and extensible Software Development Life Cycle (SDLC) platform to manage applications. It focuses on personalized productivity and team productivity through client-side tools for all major roles in the SLDC and a server product called the Team Foundation Server.

 

 

BizTalk Server 2006 BizTalk Server 2006
Organizations are looking for a software platform that allows them to easily and seamlessly connect people, processes and information, within their enterprise and beyond. The Microsoft BizTalk Server 2006 helps organizations meet these demands and also gives them the capability to build BPM-based solutions.

 

 

BizTalk Server 2006 with SQL Server 2005 takes performance to a new high BizTalk Server 2006 with SQL Server 2005 takes performance to a new high
The new Microsoft® BizTalk® Server 2006 features numerous enhancements designed to improve the overall performance of business process oriented applications. This report presents the results of tests conducted to compare the performance levels of BizTalk Server 2006 on a non-enterprise hardware configuration and a modest load with those of its predecessor - BizTalk Server 2004.

 

101 Reasons to go for .NET Framework 2.0101 Reasons to go for .NET Framework 2.0
Microsoft .NET Framework 2.0 offers higher performance and reliability over the earlier versions of the framework. This handbook is a collection of 101 best features of the .NET framework 2.0, selected after a thorough evaluation at our Microsoft Product Competency Center. The handbook serves as a guide to .NET 2.0 by providing a description of its features, Infosys' viewpoint on the utility of these features, and the business values they provide.

 

Evaluating Microsoft Visual Studio Team System for EnterprisesEvaluating Microsoft Visual Studio Team System for Enterprises
With the release of Visual Studio Team System (VSTS), Microsoft endeavors to solve some long-standing issues in the execution of software engineering life-cycle and project management.