Tuesday, December 23, 2014

Online technical videos, go to pluralsight.com/


For better online technical videos, go to http://www.pluralsight.com/

This was paid site, but we will get trail period. Good enough to get something from best resources :p

Why Source control ??

Source control is a mechanism that allows a development team to track individual changes of files in a project over time.

Have you ever used "Change Tracking" feature inside a Microsoft Word file? As you type, Word will track what you write, what you delete, and other assorted changes that you make. You are able to comment on each change, and later accept or reject them.

Source control works the same. As you work on a project that probably contains tens to hundreds of files, the source control system manages what is happening. You can audit the changes, and even rollback changes if they are not acceptable.

VS.NET Provides FREE version of TFS, Team Foundation Server.

Use it, feel it :)

Friday, November 7, 2014

TSQL - Auto ID for Temporary table variable


Today, I was trying optimize the query. 
For SQL Server temporary table variables, we cannot reseed for Identity ID. So I followed below approach:
This process is used while you are trying to use the same temp table variable in while loop.
Delete all the records from the table.
Then while Inserting you can use Row_Number() to freshly start with new IDs from 1,2,3, etc.

DECLARE @index int
SET @index =0
DECLARE  @TAB TABLE (ID INT ,VALUE VARCHAR(100)) 
INSERT INTO @Tab
SELECT TOP 2 ROW_NUMBER() OVER (ORDER BY name) AS Row ,EmployeeName FROM dbo.Employee llb --ORDER BY llb.LoBName
SELECT * FROM @Tab
DELETE FROM @tab  -- deleted two reords
INSERT INTO @Tab
SELECT TOP 4 ROW_NUMBER() OVER (ORDER BY name DESC ) AS ID ,EmployeeName FROM dbo.Employee llb --ORDER BY llb.LoBName desc
SELECT * FROM @Tab  -- now we got new 4 records starting from ID : 1,2,3,4


Monday, November 3, 2014

SQL - Intelligent SQL auto-complete add-in

Hey Guys,

For SQL Server 2008, sometimes we might not get auto-complete feature.
In scripts, keywords to be in UPPER case. While formatting, it would be difficult. 
So we have a FREE tool from APEX, it is an add-in for both SSMS and VS-IDE.

http://www.apexsql.com/sql_tools_complete_features.aspx 

For Intelligent SQL auto-complete add-in Code smarter, faster, and easier.

Try it, its worth installing the tool.

Enjoy guys!!

Tuesday, October 28, 2014

Careful with IIF in VB.NET

In VB.NET, We generally use ternary operator, IIF. Today we came across with some atypical behaviors.

 Dim a As Boolean = True 
        Dim b As Integer = 1 
        Dim c As Integer = Nothing   
        Dim d As Integer = CInt(IIf(a = True, b = 3, c.ToString()))  
What is the result?
It throws error. Null cannot be converted to string.
 But if we use same statements with IF..ELSE, it will give you correct result.

If (a = True) Then 
            b = 3 
        Else 
            Response.Write(c.ToString()) 
        End If 
It works fine.
First observation:  In IIF, it evaluates both true and false conditions. That’s why it gives error.

Another example:
 Dim a As Boolean = True 
        Dim b As Integer = 1 
        Dim c As Integer = 2   
        Dim d As Integer = CInt(IIf(a = True, b = 3, c=4))  
What is the value of B now?
It should be 3, right?

But, it will be 1. Yes One 

Second observation:
a= true is right, so it goes to b=3 statement. 
But it won’t consider it as assignment, instead it treats as conditional EQUAL operator. So b= 3 means is 1=3 ? 
Obviously 1 is not equal to 3. So it returns false, which is 0.

Note: When Visual Basic converts numeric data type values to Boolean, 0 becomes False and all other values become True.

So my dear folks, please be careful while using IIF in VB.NET. Few things seems to be simple but very dangerous.

Wednesday, October 22, 2014

Telugu bhasha

Aamani thari kosari koosedi koyala kannanu,,
Muddhulolikedi javarali momvi kanna teeyanadhi mana mathru bhasha, telugu bhasha.
Don't ignore our telugu language. Learn it, teach it.

Manchi padhyam

Thananu telusukunnavadu thathvagnudu
Paruluni telusukunnavadu paramagnudu
Anthu teleyadhannavadu aathmagnudu
Anni telusu anukunnavadu alphagnudu

My thoughts

Suddenly I got this in my mind: In his speech, Obama said - There is No north america, No south america, No latin america, No asian america. Only one that is Unites States of America. We are one people, all of us pledging allegiance to the stars and stripes, all of us defending the United States of America. But in India, We are for state's and religion wise. This should change.

Friday, August 15, 2014

Vande Matharam - Aug 15, 2014

Vande Matharam..
Manade Eetharam..
Aanadu Eenadu ade mana ninadham..

Tharalu ga Desam sadhinchivi enti ??

Mukkalu ga Rastralu..
Aakali tho chaavulu..
Aavineethi kumbakonalu..
Bangapadda aadavalla manaalu..
Upadhi leni nirojyogulu..
Vignanam, vaidhyam purogathi chendhina samanyudiki adi andhani dhrakshalu..

Lekkapette Konni Manchi panulu..

**Manam marakunte, maarpu radhu..**

Ina Ea yedu ka yedu Janda vandhanam chestu, Jathiyageetham paduthu, enka purogathi sadhinchalani aasisthu mariyu aakankshisthu.

Me lo okkadu..
- Sri

Friday, May 16, 2014

FaceBook on technical perspective

 I collected some information on technical perspective from online.

·         Web front-end written in PHP. Facebook's HipHop Compiler [1] then converts it to C++ and compiles it using g++, thus providing a high performance templating and Web logic execution layer.
·         Because of the limitations of relying entirely on static compilation, Facebook's started to work on a HipHop Interpreter [2] as well as a HipHop Virtual Machine which translate PHP code to HipHop ByteCode [3].
·         Business logic is exposed as services using Thrift [4]. Some of these services are implemented in PHP, C++ or Java depending on service requirements (some other languages are probably used...)
·         Services implemented in Java don't use any usual enterprise application server but rather use Facebook's custom application server. At first this can look aswheel reinvented but as these services are exposed and consumed only (or mostly) using Thrift, the overhead of Tomcat, or even Jetty, was probably too high with no significant added value for their need.
·         Persistence is done using MySQL, Memcached [5], Hadoop's HBase [6]. Memcached is used as a cache for MySQL as well as a general purpose cache.
·         Offline processing is done using Hadoop and Hive.
·         Data such as logging, clicks and feeds transit using Scribe [7] and are aggregating and stored in HDFS using Scribe-HDFS [8], thus allowing extended analysis using MapReduce
·         BigPipe [9] is their custom technology to accelerate page rendering using a pipelining logic
·         Varnish Cache [10] is used for HTTP proxying. They've prefered it for its high performance and efficiency [11].
·         The storage of the billions of photos posted by the users is handled by Haystack, an ad-hoc storage solution developed by Facebook which brings low level optimizations and append-only writes [12].
·         Facebook Messages is using its own architecture which is notably based on infrastructure sharding and dynamic cluster management. Business logic and persistence is encapsulated in so-called 'Cell'. Each Cell handles a part of users ; new Cells can be added as popularity grows [13]. Persistence is achieved using HBase [14].
·         Facebook Messages' search engine is built with an inverted index stored in HBase [15]
·         Facebook Search Engine's implementation details are unknown as far as I know
·         The typeahead search uses a custom storage and retrieval logic [16]
·         Chat is based on an Epoll server developed in Erlang and accessed using Thrift [17]
·         They've built an automated system that respond to monitoring alert by launching the appropriated repairing workflow, or escalating to humans if the outage couldn't be overcome [18]. 
About the resources provisioned for each of these components, some information and numbers are known:
·         Facebook is estimated to own more than 60,000 servers [18]. Their recent datacenter in Prineville, Oregon is based on entirely self-designed hardware [19] that was recently unveiled as Open Compute Project [20].
·         300 TB of data is stored in Memcached processes [21]
·         Their Hadoop and Hive cluster is made of 3000 servers with 8 cores, 32 GB RAM, 12 TB disks that is a total of 24k cores, 96 TB RAM and 36 PB disks [22]
·         100 billion hits per day, 50 billion photos, 3 trillion objects cached, 130 TB of logs per day


VS.NET Add-on's for Regular Expression Testing

In order to check and validate the regular expression, we generally use online sites (http://www.regexr.com, http://regex101.com etc.)
Due to outdated version of Internet Explorer which is no longer supported by above mentioned web sites.

To validate regular expressions, we can use .NET Add-on’s
- Regular Expression Tester
- RegxTester

Saturday, February 22, 2014

Samanyudu..


Samanyudu mamuluga - 
Bhayameste bederevadu..
Bhadeste Aedchevadu..
Kopamoste arichevadu..
Sahanam chaste teginchevadu..

Mari samanya bharateyudu ??
Aedythe adhaiendi..
manaku voregedemundhi.. 
enka poidemundhi anukoni pattinchukovadam manesevadu..

Btw, lite teesko 
-Sri

Tuesday, February 18, 2014

Viluvalaku manugadaleni e visala jagathi lo

Viluvalaku manugadaleni e visala jagathi lo
Edyna cheyalane aakanksha
Cheyagalama ane sandheham
Cheyileni chetaganitanam

Alochanalu anni prasnardhkalu
Kaanarani dharulu
Chesedhileka thalavanchi saginche jeevitham

 Ae geetha samanyudi thala raatha marchuno mari!!

- Sri

Sunday, February 9, 2014

Design Patterns for Java Script and jQuery

Do you know there are design patterns implementation for Java Script and jQuery?
Please refer this eBook for hands-on   http://addyosmani.com/resources/essentialjsdesignpatterns/book/

instead of writing  either inline java script or .js file with set of client side java script functions, if we could follow few pattern(s) respect to our development, coding implementation would be much more easy and reusable.

Spend some time to read this.


Happy Java Script coding J

Thursday, January 30, 2014

Putthadi bomma nivevaro..



Putthadi bomma nivevaro.. 
Pachhani chilaka nivevarao..
Indhradhanssulo ranguluni indhiravani ga marchinavarevaro..

Monday, January 27, 2014

Company stratigies.. Saradha ga vunna edi Nizam.. kaadha?

Enti bhava emi company ?
Enka Ade thinking... Ave strategies.. Elanti companies marava..

Employee ni Retain cheyidaniki Salary penchadam tappu kaadu..
But Ekkuva salary evvali ani Role change cheyidam correct kaaduga..
Position e kada este emundi, Resource ekkade padi vuntadu anukunte, vadu tappa migatha team members Resign chesi potharu..

Pani ranivadiki pettanam este ... ... ani

Exp. team members lekapothe Hire chesukovali.. Soap vese prathivadiki positions echhi company reputation, Team members ego chedagottakoodadhu  ga..

Lead/Manager ki first technical/application knowledge lekapoina team ni ardham chesukune minimum common sense vundali ga..

Eappudu maaratharo e so called management mi company lo Bhava.. :)
Company elago maradhu.. Nuvvena maru mi company nunchi..

Btw, Lite Teesko.. :)

Sunday, January 26, 2014

Happy Republic Day

Happy Republic Day.. 

We enjoy every right in theory, but not in practice.

It is a government OFF the people, FAR the people and BUY the people.

Even after more than sixty years of Independence, one forth of the population today goes to bed with an empty stomach, live below the poverty line without access to safe and clean drinking water, sanitation or proper health facilities. Governments have come and gone, politics have been framed and implemented, crores of rupees have been spent, yet many people are still struggling for existence.

IT zone still unsafe for women techies...

IT zone still unsafe for women techies...
Crime rate has gone in a jet speed..
Nobody takes responsibility other than ourselves..
So friends
- Start early from office or 
- Ask for Work From Home option or 
- Change your work style (timings or travel plan) or
- Change to other Project or company

If possible drop your collegues to thier home, dont leave to their way on night times..

Thursday, January 16, 2014

Regular Expressions - http://regex101.com

 http://regex101.com
Online regex tester that highlights pattern and matches on the fly.

Thursday, January 9, 2014

Win 7 : Always open applications with Admin priviliges

Recently upgraded my system from XP to Win 7, thats a good news rite.. 

But everytime while opening regular applications like VS.NET, SQL Server, etc, it was causing annoyance to run them as Administrator.

So I followed below trick to open application as Administrator:
1. Right click on application's, go to Properties -> Compatibility Tab  -> Privilige level section -> Select checkbox, Run this program as Administrator - > Click OK.

Anthe, by default application will open with Administrator access.

What an Idea Sir'G :)