Tech Support Websites

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Thursday, 23 February 2012

Technical stats & info about IRCTC - India's largest e-commerce website

Posted on 10:31 by Unknown
Interesting info on IRCTC, India's largest e-commerce website, from today's edition of Economic Times- 
  • Successful transactions a minute - 1,500-2000
  • Servers - 52, with plans to add 18 more 
  • Value of tickets booked - $1.6 billion (@ 50 INR/$) or INR 8000 crore
  • Registered users - 250 million or 2.5 crore
  • Concurrent transactions (peak) - 800,000
  • Tickets booked per day - 4,50,000
  • Of the 8 lakh people who log on simultaneously between 8 am 8.10am, only 50,000 manage to get tickets. 
  • Advance money that IRCTC pays Indian Railways every day - 50 lakhs
  • It is built on the BroadVision platform.
  • The site was launched in Aug 2002. IRCTC, the organization, started in 1999.
  • Currently (October 2013), IRCTC which sells 4.7 lakh tickets (or nearly half a million tickets) a day on an average and generates a daily business of Rs 50 crore, making it the largest e-commerce portal in Asia Pacific.
Read More
Posted in India, IT, Trivia, Websites | No comments

Tuesday, 21 February 2012

HOW TO link directly to a certain part of a web page that you don't own

Posted on 08:59 by Unknown
This trick works only if the HTML container of the portion of the web page that you wish to link to has an ID attribute.

Generally, "named anchors" can be coded to allow jumping to links within the same page when you own those pages.

Named anchors are often used to create "table of contents" at the beginning of a large document. Each chapter within the document is given a named anchor, and links to each of these anchors are put at the top of the document.

The upcoming HTML5 standard suggests using the id attribute instead of the name attribute for specifying the name of an anchor. Using the id attribute actually works also for HTML4 in all modern browsers.

Now what if you were reading an long article on a site you don't own & wanted your friend to read only a specific portion that's interesting. As I discovered from this answer on the WebApps StackExchange forum, you can append the "id" of the HTML element that contains the interesting portion to the URL after preceding it with a hash.

This trick assumes that the portion of the page that's of interest is within a HTML element like p(ara) or div tag and is uniquely identified through an ID attribute. To check this, you have to scan the HTML source (Developer tools that come natively with browsers or Firebug or the View Selected Source option in Firefox can let you easily jump to a specific element) of the webpage that you want to link to and see if the container of interesting material has an ID

Let us say, I wanted to share a link that specifically explains what a "Fold-in" is. Rather than share the link to the Wikipedia article (http://en.wikipedia.org/wiki/Al_Jaffee) about the inventor of the "Fold-in", Al Jaffee, I can directly send you to the description of the "Fold-in" within that article -
http://en.wikipedia.org/wiki/Al_Jaffee#The_Fold-In
Read More
Posted in HOWTO, HTML5 | No comments

Monday, 20 February 2012

Free online services to find what a site is running on

Posted on 09:56 by Unknown
  • Netcraft is one of the oldest sites devoted to tracking technology on the Internet. Their service provides a site report that can tell you what web-server a site is running on, host info, uptime etc and also identify related subdomains.
  • BuiltWith lists technologies used by a specified site. As they profile thousands of sites, BuiltWith Trends provides consolidated information about the most popular technologies used on the web.
  • Snoopy is a bookmarklet for snooping on web pages. Snoopy can 'sniff' out of the page, such as the   doctype, what JS libraries are used in the page, what analytics, what font embedding technique is used, etc. I found it interesting that it also shows the generated source which can be useful to web developers for debugging.
     
Read More
Posted in WebApps | No comments

Saturday, 11 February 2012

Online IDEs for C# - frill free Visual Studio alternatives

Posted on 22:41 by Unknown
Got a quick C# snippet to try out but don't want to use Visual Studio or don't have the resources on your computer right-away? There are some great desktop alternatives to VS to run snippets but did you know, there are also online IDEs for running .NET code:
  • CodeRun
  • Compilr
  • ideone
  • MSDN Virtual Labs
This type of web applications that allow their users to upload snippets of text, usually samples of source code, for public viewing, are called Pastebins. There are plenty of Pastebins now, but the above list lets you run C# programs.

Also see:
Collaborative JavaScript debugging tools - jsFiddle & JS Bin
Read More
Posted in C#, Tools, WebApps | No comments

Friday, 10 February 2012

Beware of breaking changes in jQuery library versions

Posted on 22:37 by Unknown
I often re-use old code because it's mostly bug free and has withstood the test of time.

I recently copied a jQuery snippet from a perfectly working old project and was shocked to find that a particular piece of AJAX functionality wasn't working anymore. It turned out that there was a breaking change in the jQuery.ajax() method  in jQuery library version 1.5 and the code was failing because the original sample ran an older version of jQuery (1.4.2)!

The jQuery Blog appears to be the official place where breaking changes are announced along with the news of new releases.

Some jQuery plugins too will only work with a specific version of the jQuery library.

Related:
jQuery videos for ASP.NET developers
Free JavaScript & jQuery learning resources
Read More
Posted in Javascript, jQuery | No comments

Monday, 6 February 2012

Just using stored procedures doesn't prevent SQL Injection; use parameterized stored procedures

Posted on 21:47 by Unknown
This answer in dba.stackexchange.com puts in nicely -
Whether you use SQL statements or stored procedure doesn't matter. What matters is whether your SQL uses parameters or concatenated strings. Parameters prevent SQL injection; concatenated strings allow SQL injection.

The OWASP wiki has a more detailed explanation

The Stack Exchange family of websites lets you sort & view top voted questions in a specific area of interest identified through tags. They provide a RSS feed that you can keep following through a RSS Feed Reader like Google Reader, to stay abreast of hot questions in your favorite programming area.

The RSS feed for the top voted questions with the sql-injection tag on dba.stackexchange.com looks like this - http://dba.stackexchange.com/feeds/tag?tagnames=sql-injection&sort=votes
Read More
Posted in Security, SQL Server | No comments

Wednesday, 1 February 2012

Sample SQL Server database scripts

Posted on 12:21 by Unknown
From my old notes - a list of sample database scripts (.SQL files) that you can use for your SQL Server  experiments:

  • Pubs
  • Northwind  (download link:  archive.msdn.microsoft.com)   
  • BBC Countries Dataset
  • CIA World Factbook
  • Nobel Prize Winners
  • Music
  • Movie Database
  • ACME products
  • Top of the Pops
  • Musician
  • Southwind (download link: SQLzoo.net)
  • WordNet lexical database from Princeton University (download link: packaged as a SQL Server script by ObjectGraph )
  • Stack Exchange dump of public data 
Also see:
AdventureWorks OLTP Database Diagram
HOW TO use Wikipedia content in your application
HOW TO back up a database (schema and data) as a SQL Server script
Database Schema Samples
Read More
Posted in SQL Server, Trivia | No comments
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Popular Posts

  • Windows 8 keyboard shortcuts
    Win + X   - context menu to access common features like Control Panel, Task Manager, File Explorer, Programs & Features, Run, Search etc...
  • What is the difference between Browser Mode & Document Mode in IE
    If you're a web developer and your job actively involves building web pages that work the same in all browsers including the last three ...
  • My 30-day personal project - watch 100 hours of Pluralsight videos
    Inspired by Matt Cutts' 30-day challenges , I plan to watch 100 hours of Pluralsight online videos to get up-to-date with current ...
  • Archive tweets & favorites with Google Reader
    There are numerous ways to archive tweets but rather than use yet another tool, I prefer using Google Reader to preserve the tweets I mark ...
  • TWIL - Week #3
    This Week I Learned: New Azure VM Image Templates include SQL Server, BizTalk Server, and SharePoint Server (2013?) images . This can be han...
  • Dashboard-like info with Browser tabs, Windows 7 Taskbar tabs
    Browser tabs & Windows 7 Taskbar tabs are turning self-aware.  This is how my browser looked the other day: I had the summary of all tha...
  • The State Of HTML5 Video
    Key points from the  The State Of HTML5 Video  report by LongTailVideo (last updated on April 19, 2012): 75% of the desktop & mobile bro...
  • Azure in Pictures - overview of Windows Azure Features, Services and Common Uses
    Download the Windows Azure Poster in PDF format (1.1MB)
  • Indian comparison shopping sites
    Did you know, India has 120 million Internet users & the Indian e-commerce market is worth $7 billion ?  Travel accounts for over 80 per...
  • Things to consider before settling on a JavaScript Library or jQuery plugin for your project
    In the article, Which JavaScript Library Should I Pick? , Pamela Fox has listed some practical points to consider before you settle on a Jav...

Categories

  • AJAX
  • Android
  • APIs
  • App
  • ASP
  • ASP.NET
  • ASP.NET-MVC
  • Azure
  • Azure SQL Database
  • AzureInPictures
  • Bing
  • Book Review
  • Bookmarklet
  • Browsers
  • C#
  • chart
  • Chrome
  • Cloud
  • CSS
  • CSS3
  • DidYouKnow
  • E-Commerce
  • Excel
  • FB
  • Fiddler
  • Firefox
  • Gadgets
  • GeoLocation
  • GMail
  • Google
  • Google Docs
  • Google Reader
  • Health
  • Hotmail
  • HOWTO
  • HTML
  • HTML/CSS
  • HTML5
  • Humor
  • Hyderabad
  • IE
  • IIS
  • India
  • Internet
  • IT
  • Javascript
  • jQuery
  • JSON
  • JSONP
  • Laptop
  • Learning Resources
  • Lists
  • Map
  • Metrics
  • Microsoft
  • miscellaneous
  • Mobile
  • NAPA
  • Office365
  • Opera
  • PDF
  • Performance
  • Personal
  • PHP
  • PM
  • PowerShell
  • Privacy
  • Programming
  • Rant
  • Safari
  • Science
  • Search Engines
  • SearchEngines
  • Security
  • SEO
  • Sharepoint
  • SharePoint2013
  • Silverlight
  • Software Engineering
  • Solutions
  • SQL Azure
  • SQL Server
  • TFS
  • Tip
  • Tips
  • Tools
  • Tools/Utilities
  • Trivia
  • TWIL
  • Twitter
  • UX
  • VM
  • VS.NET
  • VS2010
  • VS2012
  • WCF
  • WebApps
  • Websites
  • WF
  • Windows Phone
  • Windows7
  • Windows8
  • Word
  • WP7
  • WPF

Blog Archive

  • ►  2013 (112)
    • ►  October (16)
    • ►  September (14)
    • ►  August (8)
    • ►  July (8)
    • ►  June (13)
    • ►  May (12)
    • ►  April (12)
    • ►  March (8)
    • ►  February (15)
    • ►  January (6)
  • ▼  2012 (127)
    • ►  December (11)
    • ►  November (14)
    • ►  October (13)
    • ►  September (14)
    • ►  August (16)
    • ►  July (16)
    • ►  June (6)
    • ►  May (5)
    • ►  April (11)
    • ►  March (12)
    • ▼  February (7)
      • Technical stats & info about IRCTC - India's large...
      • HOW TO link directly to a certain part of a web pa...
      • Free online services to find what a site is runnin...
      • Online IDEs for C# - frill free Visual Studio alte...
      • Beware of breaking changes in jQuery library versions
      • Just using stored procedures doesn't prevent SQL I...
      • Sample SQL Server database scripts
    • ►  January (2)
  • ►  2011 (98)
    • ►  December (5)
    • ►  November (2)
    • ►  October (5)
    • ►  September (7)
    • ►  August (7)
    • ►  July (15)
    • ►  June (10)
    • ►  May (7)
    • ►  April (8)
    • ►  March (10)
    • ►  February (11)
    • ►  January (11)
  • ►  2010 (163)
    • ►  December (14)
    • ►  November (19)
    • ►  October (19)
    • ►  September (15)
    • ►  August (18)
    • ►  July (17)
    • ►  June (20)
    • ►  May (17)
    • ►  April (19)
    • ►  March (5)
Powered by Blogger.

About Me

Unknown
View my complete profile