tag:blogger.com,1999:blog-46211686837099132312023-06-21T10:34:59.762+05:30Technology overflowSivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.comBlogger23125tag:blogger.com,1999:blog-4621168683709913231.post-35364238542969415172014-03-19T08:29:00.002+05:302014-03-19T08:29:50.915+05:30Vote now
Who will be the next Indian Prime minister
Narender Modi
Rahul Gandhi
Manmohan Sign
Jayalalitha
Arvind Kejriwal
pollcode.com free polls
Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com0tag:blogger.com,1999:blog-4621168683709913231.post-22296377829220379352014-03-09T22:18:00.002+05:302014-03-09T22:19:24.268+05:30Big Data - My Journey
I have just started the journey in Big data. While reading hadoop I have decided to setup hadoop in Ubuntu. After couple of tries,I came across an article in the below url, which works 100 %
http://goo.gl/F9gudz
Thanks Udemy and Nitesh Jain.
Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com0tag:blogger.com,1999:blog-4621168683709913231.post-39284412403578477922011-08-20T04:42:00.000+05:302011-08-20T04:42:04.541+05:30Out of memory exception Why and How ?
We often encounter out of memory exception while working with .net application (or in real life Asks by wife!). In a 32 bit environment , by default 2 GB virtual memory is available apart from Physical RAM memory . It should be noted that all 2 GB can not be utilized.
AS there are free, reserved and committed states in virtual memory and if we run out of virtual address space to further Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com2tag:blogger.com,1999:blog-4621168683709913231.post-8814068657575962302011-04-01T22:50:00.001+05:302011-04-01T22:50:24.707+05:30April Fool - Gmail Motion this year's hoaxGmail Motion is this year's April Fool hoax.
But it will be nice if we have this feature in Gmail :)
Enjoy watching
Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com0tag:blogger.com,1999:blog-4621168683709913231.post-75531546842645059622011-04-01T22:06:00.001+05:302011-04-01T22:08:57.641+05:30Funny Side -- What if Kollywood heros handle IT Project
What if Tamil Heros handle IT Project.
First comes 'Captain' Visaya kanth as Project manager.Project Meeting starts
(Please read numbers in tamil)Intha project'la mottham 1,19,738 line code irukku,athula naama eluthunathu 45,434 line, athula 30,114 line comments mattum outsource pannathu 74,304 line, athula 52,314 line comment.Intha project armbichapo iruntha team size 54 paer,&Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com0tag:blogger.com,1999:blog-4621168683709913231.post-63185633470471295602011-03-31T22:49:00.003+05:302011-04-01T05:51:25.340+05:30Alternate for Cursors in SQL Server
T-SQL provides us with a CURSOR statement to work on the data on a row-by-row basis. Cursors are especially handy when you are using OUTPUT stored procedures and need to pass one ID to the stored procedure at a time. However, this kills the whole theory of set-based operations, which are inherently faster than their row based counterparts. The following is one way of converting your CURSOR Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com0tag:blogger.com,1999:blog-4621168683709913231.post-61043266421666089902011-03-30T07:52:00.000+05:302011-03-30T07:52:36.520+05:30SQL Server 2008 New Features
New features in SQL SERVER 2008
Analysis Scale and Performance
SQL Server 2008 drives broader analysis with enhanced analytical capabilities and with more complex computations and aggregations. New cube design tools help users streamline the development of the analysis infrastructure enabling them to build solutions for optimized performance.
Star Join Query Optimizations
SQL Server 2008 Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com2tag:blogger.com,1999:blog-4621168683709913231.post-29080954265088237462011-03-29T07:28:00.003+05:302011-03-30T19:45:22.294+05:30Could not record and playback Coded UI test for web part enabled ASP.Net application
Today one of the interesting problem was reported by our test team. They were facing issues while playing back the recorded coded UI automated test scripts. One of the application they were trying to automate was built with webparts.
Because of this test script written by one tester , could not be executed by other so team member.After examining the source of html, we found that Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com0tag:blogger.com,1999:blog-4621168683709913231.post-48096097195885249372011-03-28T23:10:00.003+05:302011-03-29T21:20:23.269+05:30What's New on SharePoint 2010
SharePoint is always a flagship MS Product. And 2010 adds more feathers to its crown.
From Integration of Peformance Point Server to use of Powershell in SharePoint administration, Microsoft added so many new features to SharePoint 2010. Visit dedicated MSDN link for more details.
http://technet.microsoft.com/en-us/sharepoint/ee518662.aspx
Now I have added SocialVibe in my blog. Just Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com0tag:blogger.com,1999:blog-4621168683709913231.post-69573533378390951712011-03-27T12:36:00.002+05:302011-03-27T12:54:40.710+05:30SQL Server transaction isolation level
Application developers who work in an environment where users retrieve data while others save/update data are probably familiar with the challenges of concurrency and isolation levels. In this article, I'll cover the following:What are Isolation Levels in general?
An overview of the Isolation Levels in SQL Server prior to SQL Server 2005
The new Snapshot Isolation Level and how it improves Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com0tag:blogger.com,1999:blog-4621168683709913231.post-87621386397705832832011-03-27T12:22:00.001+05:302011-03-27T12:22:34.274+05:30SQL Server Few Tips & TricksCursor Optimization Tips *****Try to avoid using SQL Server cursors, whenever possible. SQL Server cursors can results in some performance degradation in comparison with select statements. Try to use correlated subquery or derived tables, or temp table if you need to perform row-by-row operations. *****Do not forget to close SQL Server cursor when its result set is not needed.To close SQL Server Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com0tag:blogger.com,1999:blog-4621168683709913231.post-30167671746817832582011-03-26T02:20:00.000+05:302011-03-26T02:20:21.104+05:30Lock types and Query hints in SQL Server
Lock typesThere are three main types of locks that SQL Server 7.0/2000 uses:
Shared locks Update locks Exclusive locks
Shared locks are used for operations that do not change or update data, such as a SELECT statement.
Update locks are used when SQL Server intends to modify a page, and later promotes the update page lock to an exclusive page lock before actually making the changes.
Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com0tag:blogger.com,1999:blog-4621168683709913231.post-16728678961726583332011-03-26T01:05:00.002+05:302011-03-26T01:06:58.685+05:30Setting up Windows 2003 Server for ASP.Net Application - From ground upThe following guide is the collection of my day to day experience in Windows 2003 Server.I hope this will helpful for ASP.Net Lead programmers who are performing Server setup also.The guide gives in depth configuration in hosting a ASP.Net public web site and configuring DNS/IIS server.
You can download the guide from the following linkWindows 2003 Essential Guide for DotNet Programmers.
I Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com2tag:blogger.com,1999:blog-4621168683709913231.post-3611289946584314592011-03-26T00:28:00.003+05:302011-03-29T21:24:03.420+05:30Essential DBCC Commands in SQL ServerDBCC CHECKALLOC - Check consistency of disk allocation.
DBCC CHECKCATALOG - Check catalog consistency
DBCC CHECKCONSTRAINTS - Check integrity of table constraints.
DBCC CHECKDB - Check allocation, and integrity of all objects.
DBCC CHECKFILEGROUP - Check all tables and indexed views in a filegroup.
DBCC CHECKIDENT - Check identity value for a table.
DBCC CHECKTABLE - Check integrity of a table orSivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com1tag:blogger.com,1999:blog-4621168683709913231.post-53158071143207918602011-03-20T13:44:00.003+05:302011-03-20T13:46:04.776+05:30SQL Server Performance using Dynamic management Views Part 2
In this part we will see the use of DMVs in the following areas1. TempDB uusage and Tuning Temp DB
2. I/O usage and optimzation of I/O
1. TempDB usage in SQL Server
Apart from using temporary (#) and gloabl temporary (##) table , tempDB will be used in the following sceario
When DBCC CHECKDB command is used &Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com0tag:blogger.com,1999:blog-4621168683709913231.post-19179434227075343012011-03-19T01:18:00.010+05:302011-03-23T07:43:26.724+05:30SQL Server Performance Using DMVsSQL Server Performance using Dynamic management Views Part 1
1 Introduction
1.1 What are DMVs ?
Dynamic managment views (DMVs) are introduced in SQL Server 2005 onwards. They are Views and System functions built on top of internal structures.DMVs are handy to troubleshoot performance issue when there is no option of using profiler since troubleshooting with the aid of profiler will take lot of Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com1tag:blogger.com,1999:blog-4621168683709913231.post-91889914372983094482010-07-18T02:09:00.002+05:302010-07-18T02:12:06.791+05:30Consuming web services in ASP applicationThere are two ways to use web service in asp page1. Using SOAP request by means of xmlhttp Ajax request2. USE COM+ service.Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com0tag:blogger.com,1999:blog-4621168683709913231.post-39519373591039716802010-01-24T05:31:00.001+05:302011-03-26T08:36:25.103+05:30T-SQL Puzzles and Challengeshttp://beyondrelational.com is hosting brain twisting T-SQL puzzles. For more information visit
http://beyondrelational.com/Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com1tag:blogger.com,1999:blog-4621168683709913231.post-16761500230680283192010-01-17T08:09:00.000+05:302010-01-17T08:13:49.544+05:30Installing PHP in windows 2003 x64 EditionFollow the steps in1) http://www.webcheatsheet.com/php/install_and_configure.php2) Copy this php.ini in C:\windows3) For x64 execute the following commandGot two problems1) %1 is not a valid win32 applicationhttp://forums.iis.net/t/1151152.aspx2) No input file foundhttp://www.iis-aid.com/forums/iis_aid_php_installer/no_input_file_specifiedcscript F:\inetpub\adminscripts\adsutil.vbs SETW3SVC/Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com0tag:blogger.com,1999:blog-4621168683709913231.post-88475450152651488382009-11-29T10:43:00.000+05:302009-11-29T10:55:53.657+05:30Office Communications Server R2 2007 Installation - Few undocumented time saving tipsAlthough OCS 2007 R2 installation has beautiful step by step by wizard and makes complex installation very simple, here are the few tips to make the installation even simpler that avoids errors in the middle of the installation.Prerequisite 1. Windows 2003 x64 SP22. Raise domain functional level to windows 2003 (Active directory trusts and services) in casedomain functional level is Windows Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com0tag:blogger.com,1999:blog-4621168683709913231.post-19170707736832623682009-05-23T05:26:00.001+05:302009-05-23T05:26:46.610+05:30Get Own Poll
Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com0tag:blogger.com,1999:blog-4621168683709913231.post-15871118068406884192008-12-30T18:57:00.000+05:302008-12-30T19:13:04.903+05:30SQL Server 2008 Express Installation experienceFinally I had just completed installing SQL Server Express 2008 in my Acer Laptop(AMD Athlon X2 2 X 1,9 , 2 GB RAM ,160 GB HDD).It took nearly three days to source all pre-requestie and install updates , service pack even though I had a VS 2008 Express DVD including dotnet 3.5.At first installer seems it had good tools to verify pre-validation and well organized, But even after passing thru' Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com14tag:blogger.com,1999:blog-4621168683709913231.post-71548943380058730972008-12-14T08:10:00.000+05:302008-12-22T16:10:40.198+05:30What BI is doing ?BI - Business Intelligence is big talk in recent days. It is more of old wine - Dash board or Decision Services software (DSS) in a new bottle. Only difference is BI tools gives 360 degree entrise reporting, integrated in one place. As of now there is not much intelligence is there in any of B.I tools be it Microsoft 's Reporting Services or Business objects ...etc., It gives organized data and Sivahttp://www.blogger.com/profile/01543234612725647446noreply@blogger.com1