F5 Debug…

Building & Debugging the Technology!!!

Archive for May, 2011

1TB in 30 Minutes with SSIS, and So Can You

Posted by Karthikeyan Anbarasan on May 30, 2011

Writers: Len Wyatt, Tim Shea, David Powell

In February 2008, Microsoft announced a record-breaking data load using Microsoft® SQL Server® Integration Services (SSIS): 1 TB of data in less than 30 minutes. That data load, using SQL Server Integration Services, was 30% faster than the previous best time using a commercial ETL tool. This paper outlines what it took: the software, hardware, and configuration used. We will describe what we did to achieve that result, and offer suggestions for how to relate these techniques to typical scenarios. Even for customers who don’t have needs quite like this benchmark, such efforts can teach a lot about getting optimal performance.

http://msdn.microsoft.com/en-us/library/dd537533.aspx

Posted in .Net, SSIS | Leave a Comment »

Microsoft SQL Server 2008 R2 SP1 CTP

Posted by Karthikeyan Anbarasan on May 30, 2011

Microsoft SQL Server 2008 R2 Service Pack 1 CTP is ready to download using the below link.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=bd200f8e-ba8a-45e3-af59-e28a9e2d17df&displaylang=en

We can use these packages to upgrade any of the following SQL Server 2008 R2 editions:

(1) SQL Server 2008 R2 Parallel Computing Edition
(2) SQL Server 2008 R2 Datacenter Edition
(3) SQL Server 2008 R2 Enterprise Edition and Developer Edition
(4) SQL Server 2008 R2 Standard Edition
(5) SQL Server 2008 R2 Web Edition
(6) SQL Server 2008 R2 Workgroup Edition
(7) SQL Server 2008 R2 Express Edition

New Features in this service pack 1 are as follows

  1. Dynamic Management Views for increased supportability
  2. ForceSeek for improved querying performance
  3. Data-tier Application Component Framework (DAC Fx) for improved database upgrades
  4. Disk space control for PowerPivot

Note : These packages are available for testing purposes only in a non-production environment. To upgrade SQL Server 2008 R2 Express Edition, obtain the SP1 version of Express Edition or Express Edition with Advanced Services.

 

 

Posted in SQL Server 2008 | Tagged: , | Leave a Comment »

Top New features in SSIS 2008

Posted by Karthikeyan Anbarasan on May 23, 2011

Below are some of the top new features of SSIS 2008

  • Create Script tasks by using Microsoft Visual C# and Microsoft Visual Basic .NET.
  • Use ADO.NET for tasks as well as for source and destination components.
  • Improve scalability with thread pooling and enhanced lookup transformations.
  • Perform more functional and scalable data transfers with the improved SQL Server Import and Export Wizard.
  • New SSIS connectors for SAP BW, Oracle and Teradata.

Reference – http://www.microsoft.com/sqlserver/2008/en/us/integration.aspx

Posted in SSIS | Tagged: , | Leave a Comment »

Introduction and Prerequisities of Windows Phone 7

Posted by Karthikeyan Anbarasan on May 23, 2011

Introduction:

Before starting with the development process of the Windows Phone 7, let’s seen on what the prerequisites are required.

Software Requirement:

Hardware Requirement:

Below are the minimum requirements for windows mobile phone 7 manufacturers taken into consideration in order to maintain some standard across the manufacturers.

 Hardware

 Description

 Display  WVGA (800 x 480) Should have a minimum resolution of 800X480 for providing a good user interface.
 Multi Touch (4 Ways)  This is for providing option for multi user processes like accessing shared portion, used for games etc
 DirectX 9 Acceleration  This is specifically for the GUI based processes, like games, rich user application to maintain the standards.
 Global Positioning System(GPS)  This is for providing location specific processes like GPS navigator, to integrate with Maps etc.
  Accelerometer  This is for providing the proper acceleration of the device normally used in games, location-based applications.
  Compass  This is for detecting the position like North, South, East, and West.
 Light  This is for using like a Flash light in the phone. Also we can enhance to use it across some external application for flash
 Camera  This is for taking pictures that can be stored and accessed online, also to integrate with the social networking sites like Facebook, Twitter etc.
  Button Controls(Up, Down, Side buttons)  This is for providing the functionality that normally all phone will have like attending the call, navigation etc.
 Network Connection  This is for providing the connectivity process like normal phones to make calls, text and similar purposes.
  Data Connection  This is for providing the functionality of internet to the phone with the technologies of 2G, 3G etc.
 256 MB of RAM  This is the base requirement for a windows phone 7 manufacturer because 90 MB of memory can be used by the application our of 256Mb. This is strictly followed if fails then the application will fail in the Market Place
 8GM flash storage  This is for the storage among the applications

Windows Phone Platform:

Microsoft has provided windows phone 7 with existing .net core functionalities and libraries like Threading, LINQ, Multi threading, XML programming, Security, Reflection , Localization and Globalization. Apart from these available resources in Windows Phone 7 they have added 2 more major frameworks: Silverlight and XNA.

Silverlight:

Silverlight is basically used for light weight business applications and normal 2D games development using the XAML (Extensible Application Markup Language) Programming. Developers will have much flexibility using this framework along with much used UI tools like Microsoft Blend, Adobe Photoshop etc. to create a vector based process that can be easily transported to XAML. This is really a not new topic compared to the XNA development since Silverlight is already in market for developing rich browser applications and it provides an option of creating applications with XAML which is highly advantageous of creating a vector based application. So it gives the developers on full control of the layout, design, structure and also the data binding components.

XNA:

XNA is basically used for developing rich games where the framework comes with a game engine (with 3D) which helps the game developers to provide rich 3D games. Unlike Silverlight XNA is not much known across the developers since it has been used to develop Xbox games using Managed code. Why Microsoft provided the XNA engine with the windows phone 7 is mainly because of integration of Xbox live integration with Windows Phone 7. XNA engine provides the rich user experience that ever y developers take advantage in providing next generation games with 2D and 3D game loop engines.

Using Azure:
When we create an application with Windows Phone 7, we need to save some data for future retrieval which is going to be bit tough here. Windows phone 7 doesn’t provide the direct connectivity with database to save the data. To overcome this we need to use AZURE, Windows azure provides the platform of Cloud Computing in storing and retrieving the data from different locations using Windows Phone 7. Say today we created a small application in windows phone 7 using Silverlight. Day to-day when the development increases and finally we get an excellent product, then the number of user visit gets increased which eventually requires an enterprise database to save the details. So at this case we can use the Azure availability of extending the size of the database as per the need since it maintains in the cloud. If we use Azure for the development of the Windows Phone 7, Microsoft has provided with an additional advantage of using Bing Maps which is given free of cost only for the windows phone 7. Additionally Push notification services are also been provided in the cloud where we can use it to send notifications to the mobiles as Text which is eventually a bitter process for the business needs.

Development Life Cycle:

We as developers of windows phone 7 we need to register with App hub using the below link http://create.msdn.com/en-US/  and giving our Windows Live credentials which acts like a single sign on for all the process which Microsoft provides. The main idea behind registering with App hub is once registered and developed an application in Windows Mobile phone 7 we can use our registered hand set as a physical device tester to test our application. App Hub provides developers with up to 3 devices can be registered and test it in real-time.
Now let us jump through the steps involved in the application development life cycle of the windows phone 7.
Step 1 – Register with App Hub
As mentioned above App hub is the Microsoft place where we need to register and use for testing the application in real-time. Please follow the below steps to register in App Hub.
Steps to register the APP HUB
Step 2 – Market Place Certification procedures.
Once we are registered with the App Hub, before proceeding with the development consider reading the certification process document in order to avoid rejection of the product at the market level. Please refer to the below link for the Application Certification process checklist and validation.
http://go.microsoft.com/?linkid=9730558
Once the development is completed and the validation process is checked and passed by the Market, then the application will be available online for downloads. Microsoft reserves the rights to give 5 free applications downloads and unlimited number of paid application downloads.
Microsoft charges an amount of 99$ for the market place registration to submit the application developed. And for each download the Microsoft takes 30% of the fees paid and the developer will get 70% for his development charge.

Conclusion:

In this article we have seen on the prerequisites required before starting development process with windows phone 7.

Posted in Windows Phone 7 | Tagged: , , , , , , | Leave a Comment »