Thursday, December 20, 2012

Interesting Facts ... from Google Conversions

I was just searching - Google about Conversions.

I found the following THREE interesting facts.

1.How many weeks in a year?
Ans: 1 Year = 52.1775 Weeks

2.How many days in a year ?
Ans: 1 Year = 365.242 Days

3.How many days in a week?


Sunday, December 09, 2012

Notepad Tips N Tricks - 1

To write your Personal Diary

Steps:

  1. Open the Notepad 
  2. Press F5 Button
  3. Now u can see the Result : Date and Time
  4. Note down your ideas and save your file. 


Wednesday, November 28, 2012

Lets Go Forward... SQL Server Series..No. 2

Life is full of challenges and twists.Before we Go Forward in this SQL Server series of Posts.

Few things to remember:
  1. Forget the Past Failures to make your Future Success.
  2. Control your life to move in positive direction.
  3. Don't run away from problems..Think twice to Solve them.
  4. 'No Procrastination"...Make a Action Plan to set your Goals.
  5. After each Completion of your goal,Appreciate your Success.  
Goal : SQL Server Certificaions



ExamCredit ForSelected Topics
70-461: Querying Microsoft SQL Server 2012
  • MCSA for SQL Server 2012
  • MCSE for SQL Server 2012 Data Platform
  • MCSE for SQL Server 2012 Business Intelligence
  • Create/design tables and views
  • Use joins, sub-queries, new data types and query features
  • Create/design/modify stored process, aggregate functions, triggers
  • Modify data with INSERT/UPDATE/DELETE/MERGE
  • Design/apply user-defined functions
70-462: Administering Microsoft SQL Server 2012 Databases
  • MCSA for SQL Server 2012
  • MCSE for SQL Server 2012 Data Platform
  • MCSE for SQL Server 2012 Business Intelligence
  • Install SQL Server 2012 and related services
  • Create and manage SQL Server instances, including a clustered instance
  • Diagnose and respond to blocking, locking, deadlocking
  • Backup and restore databases
  • Implement and maintain indexes
  • Contrast and compare AlwaysOn technologies
70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012
  • MCSA for SQL Server 2012
  • MCSE for SQL Server 2012 Data Platform
  • MCSE for SQL Server 2012 Business Intelligence
  • Design/implement star vs. snowflake schemas, fact tables, dimensions, keys
  • Create/apply project level connection managers, slowly changing dimensions, fuzzy lookups
  • Execute SSIS packages with SSMS, DTEXEC, SQL Server Agent
  • Create, assign, read variables and parameters
  • Plan and implement full and incremental loads for data warehouses
  • Implement solutions with Data Quality Services
70-464: Developing Microsoft SQL Server 2012 DatabasesMCSE for SQL Server 2012 Data Platform
  • Create/implement database objects without using built-in tools
  • Apply data types: CLR, sequential GUID values, spatial
  • Understand relative advantages of database tables, temporary tables, and table variables
  • Create, assign, read variables and parameters
  • Create and alter indexes, including filtered, semantic, XML
  • Optimize queries with execution plans and DTA
70-465: Designing Database Solutions for Microsoft SQL Server 2012MCSE for SQL Server 2012 Data Platform
  • Apply physical database issues, such as filestream and file groups
  • Monitor an instance using such tools as Profiler, Perfmon and DMVs
  • Automate (setup, maintenance, monitoring) across multiple databases and multiple instances
  • Design instance-level security, such as logon triggers, transparent data encryption, DDL triggers
  • Manage maintenance administration, such as rebuild vs. defrag indexes, online vs. offline index rebuild
  • Implement high availability via clustered servers, mirroring, replication
70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012MCSE for SQL Server 2012 Business Intelligence
  • Implement cubes: build cube with SQL Server Data Tools, configure additive and non-additive measures, and implement many-to-many relationships
  • Create and debug MDX queries
  • Contrast multidimensional and tabular data models
  • Deploy SSAS databases
  • Know SSRS report and design issues, such as crosstab report, drill-down reports, report parameters
  • Configure report data sources and datasets
70-467: Designing Database Solutions for Microsoft SQL Server 2012MCSE for SQL Server 2012 Business Intelligence
  • Specify and optimize MDX and DAX queries
  • Use partitioning to speed up the loading of a fact table
  • Design a BI reporting architecture, including such features as linked reports, drill-down reports, sub reports
  • Know when to choose between UDM and BISM
  • Possess a working knowledge of how to implement MDX calculations
  • Design SSIS deployments using the project deployment model, passing values at execution time, sharing parameters between packages
Microsoft Certified Solutions Master
The MCSM level consist of two platforms (SQL Server and Intelligence):
MCSM: Data Platform
Prerequisite: MCSE: Data Platform
  • Exam 986: MCSM Data Platform Knowledge
  • Exam 986: MCSM Data Platform Lab
  • This level of certification will require the completion of Lab-based and Technical exams

MCSM: Intelligence
Prerequisite: MCSE: Business Intelligence Platform
Microsoft Certified Architect
Prerequisite: MCSM: SQL Server and MCSM: Intelligence
MCA: SQL Server
Full requirements are still being finalised.  More information can be found at http://www.microsoft.com/learning/en/us/certification/MCSM-sql-server-data-platform.aspx

Tuesday, November 27, 2012

Testing Meetup @ Bangalore on Dec 1,2012


BDotNet UG - Dec 1 - Jim Holmes, Test evangelist

B.NET

Microsoft, Signature Building, Embassy Golf Links, Domlur, Bangalore

Saturday, December 1, 2012 from 10:30 AM to 1:00 PM (IST)

Bangalore, India


Speaker Bio:
Jim Holmes, Test Automation Veteran and Telerik Test Studio Evangelist.

Session 1: 
Title: UI Test Automation Isn’t All Shiny Toys.

Session 2: 
Title: Avoiding Brittle UI Tests

Note: Please register at eventbrite if you are making it to the UG meet.


Ticket Information

TYPEENDQUANTITY
FREEDec 1, 2012Free

TechDays 2013 - Chennai


Event ID: 1032536819

Chennai Trade Centre CTC Complex
NandambakkamChennai 600 089India
Product(s):  Windows 8 and Windows Phone.
Audience(s):  Developer Generalist.

Register for Event

Starts: 05 December 2012 08:30
Ends: 05 December 2012 23:00
Time zone: (GMT+05:30) India

Register

I am looking for Change... Lets Start with a New Series of Learning

Hello,

I always look for a change in what i do.

Why a Change?

"Change" - This word has a power in it,it can transform an ideas to thoughts and to make it reality.

Now this series of posts will be silent witness to the battles and struggles,to reach where i want to be.

I have started my journey as "Dot Net Developer" and Now At Present as a "Software Tester"..but the destination is not predefined.

New Series

I am hoping this series of posts will be useful and the series of articles will be  posted regularly.



This series of topics will be on "SQL Server" - My Favorite Technology.

Inspiration Quote:

"I’ve failed over and over and over again in my life and that is why I succeed – Michael Jordan"

Sunday, November 25, 2012

Introduction to Go & Google Cloud Offerings @ Bangalore,Nov 30



Time: 2.30pm  - 5.30pm

Fee: Free Entry

Agenda:
Introduction to GO

Speaker : Sathish V J 

Introduction to the Google Cloud for Developers
Speaker: Lynn Langi
Venue
Google India Pvt. Ltd
No. 3, RMZ Infinity - Tower E
3rd, 4th, and 5th Floors
Old Madras Road
Bangalore, 560 016
India
Phone: +91-80-6721-8000



SAP TechEd @ Bangalore on Nov 28-30







Saturday, November 24, 2012

jQuery Gems Book by Greg Sidelnikov released...

Buy jQuery Gems - A jQuery Tutorial book by Greg Sidelnikov


Click on Buy Now...




Thursday, November 22, 2012

SQL Server UG Meet @ Bangalore - Nov 24,2012






Microsoft User Group - Developer Day @ Hyderabad,Nov 24,2012







Developer Day – November 24, @ S&P Capital IQ (Hyderabad)


Interesting News: 

 S&P Capital IQ is hiring Software Engineers & Architects (Microsoft Developer Technologies) for their Hyderabad location and they will be at the event on 24th November to meet & interact with you. So be there and do not miss this opportunity at any cost. And do not forget to bring along your CV !



Session details are as follows:
--------------------------------------------------------------
2.00 pm - 2.15 pm : Opening Keynote by Amit Bansal (co-founder, HelloWorldGeeks.com).
2.15 pm - 3.15 pm : Hidden facts of .NET 4.5 language jems by Abhishek Sur (co-founder, HelloWorldGeeks.com, MVP)
Abstract: Languages are essential component of any developer technology. .NET languages have been enhanced a lot recently. This session will introduce new language features and show the internals of its implementations to help you decide when and where a feature could be optimally utilized.
3.15 pm - 3.30 pm : Session by S&P Capital IQ HR Team.
3.30 pm - 3.45 pm : Refreshments.
3.45 pm - 4.45 pm : Panel Discussion (open ended) on Microsoft Developer Technologies
Abstract: Feel free to ask any developer related question to our expert panel comprising of Ramesh Viswanathan (S&P Capital IQ), Abhishek Sur & Himabindu Vejella (Microsoft). Do not miss this opportunity to interact with our expert panel in an open ended discussion around Microsoft Developer Technologies.
4.45 pm- 5.00 pm : Closing note.

--------------------------------------------------------------

Date: November 24' 2012, Saturday
Time: 1.00 pm to 5.00 pm
Venue: S&P Capital IQ,
       SDE Prameela Techno Park, Survey No.12P, Kondapur Village,
       RR Dist, Hyderabad
       Opposite to Jayabheri Silicon valley or Google office
Parking: Parking arrangements have been made in SP Capital premises.

(Note: The event will start sharp at 1.30 pm. Please come by 1.00 pm for registration. Please bring a valid photo ID. For any clarifications, feel free to call Mamita Sinha at +91 9007009017) 

Wednesday, October 24, 2012

Quiz 1: Answers...

If you have missed the previous articles of the Quiz,Please Read:

http://itsmyslife.blogspot.in/2012/10/quiz-1-introduction-to-computer-science.html

The answers for the quiz questions are below:




1) Why does 53 represent the number 5 in ASCII?
In this context, we're representing characters through numbers. As such, the number 53 links to the character '5'.

2) An ASCII Table is a large reference guide that show which numbers represent which characters.
True

3) Express this binary number as a decimal number: 10010110
A: 150

4) One algorithm has a run time of n/1000. Another algorithm has a run time of log(n). Considering that n is a very large number, which of these will complete first?
The log(n) algorithm

5) In David's phonebook example, if he turns one page at a time, it will take him log(n) steps to complete the search.
False


----------------------------------------------------

Continued...

Happy Learning..Happy Programming :)

Tuesday, October 23, 2012

Day-1: What is the meaning of Dot(.) in Dot Net?????

Today is my first article on Dot Net.




I thought of starting my blog on "What is the meaning of Dot (.) in DotNet?"

According to Microsoft MSDN,Dot (.) in Dotnet means Accessors.

Dot (.) is used for accessing Properties,Classes and Methods within the .NET Framework class libraries.

This is an in-built mechanism of Dot Net Framework.

----------------------------------------------------

Continued...

Happy Learning..Happy Programming :)

Thursday, October 18, 2012

Quiz 1: Introduction to Computer Science and Programming

If you have missed the previous articles for the Quiz,Please Read:

http://itsmyslife.blogspot.in/2012/10/first-day-at-introduction-to-computer.html

http://itsmyslife.blogspot.in/2012/10/day-2-learn-introduction-to-computer.html

Today In this Article,I am posting 5 Quiz Questions..

These questions are with reference to Day-1 and Day-2 articles on 
"Introduction to Computer Science and Programming"




1) Why does 53 represent the number 5 in ASCII?
5 also represents 5 in ASCII. Either one will work

Numbers 1-47 actually represent negative numbers. 53 is the first positive number that links to 5 (going in order)

In this context, we're representing characters through numbers. As such, the number 53 links to the character '5'.

2) An ASCII Table is a large reference guide that show which numbers represent which characters.
True

False

3) Express this binary number as a decimal number: 10010110

4) One algorithm has a run time of n/1000. Another algorithm has a run time of log(n). Considering that n is a very large number, which of these will complete first?
The n/1000 algorithm

The log(n) algorithm

5) In David's phonebook example, if he turns one page at a time, it will take him log(n) steps to complete the search.
True

False


----------------------------------------------------

If you want to solve this quiz,comment to the following questions.

Answers will be posted on Monday.

Continued...

Happy Learning..Happy Programming :)

Wednesday, October 17, 2012

Day 2 -- Learn Introduction to Computer Science and Programming


As we discussed in our earlier article about Basics of Computation,

If you have missed the Day-1: 

Please Visit: http://itsmyslife.blogspot.in/2012/10/first-day-at-introduction-to-computer.html

Today we discuss about, Problem Solving.


Q: What is computer science?

A: Most of them believe that Computer Science is nothing but Programming.

This is the most Common Misconception.

 

Q: What is Programming?

A: Programming is a tool of computer science, to analyze large amounts of data.

 

Example – Phone Book

In old days, Before Mobiles were not developed: All of us used to store the Phone Contacts in a Phone Book.

If we want to search for “Karthikeyan”, we have to flip each page and search until the Contact is found.

This is an inefficient method.

Now we can reduce our search time, by flipping to the middle of the Phone Book.

Let divide the problem into two.

We know ‘K’ doesn’t lie in the right part of the book, let’s throw away this part.

Now we start searching in the left part of the book and Now again flip to the middle of the Left Part of the Phone Book.

We know ‘K’ lies in the right part of this book; let’s throw away the left part.

So now we again start searching the right part.

As we continue tearing the book in half and throwing away part of it, we will eventually be left with a single page on which the name “Karthikeyan” appears.


Approach – To Solve a Problem

In the graph below, the first steep line (n in red) represents the approach of turning one page at a time.

The second steep line (n/2 in yellow) represents a slightly improved approach of turning two pages at a time.

The curve (log n in green) represents our “tear and throw away” approach. As the size of the problem grows, the time to solve that problem doesn’t grow nearly as fast.


 In the context of this problem, n is the number of pages in the phonebook. As we go from 500 to 1000 to 2000 pages in the phonebook, we need only tear the phonebook in half one or two more times.

Algorithm : Counting Number of Students in a class


Let’s solve this problem...
  1. Everyone in the class should stand up and the first person should think of the number ‘1’
  2. Now pair off with second person – (example: number - 2) standing beside to first person, add the first number with second and adopt the sum as the new number to the second person.
  3. Now the first person should sit down, the second person should go back to step 2

With this algorithm, it’s very easy to break the problem into small pieces.

Binary Numbers

Everyone has studied in the schools, that computer deals with 0’s and 1’s.

These 0’s and 1’s comprise binary numbers system.

Binary means “Two”...Every solution to a problem represents in binary numbers.

In Real World, If the Switch of the Bulb is OFF – Then it represents 0 and

If the Switch of the Bulb is ON – Then it represents 1.

ASCII

As we have seen, Binary is used to represent the numbers.

We now represent the alphabetic characters in numbers.

ASCII is American Standard Code for Information Interchange. It is an encoding system.

For example, an uppercase “A” is represented by the number 65 and a lowercase “a” is represented by the number 97.


Byte
A byte is a sequence of 8 bits.

----------------------------------------------------
Continued...

Happy Learning..Happy Programming :)

Monday, October 15, 2012

First Day : Python Online Training

Few days back I have enrolled to "Python" online training course by RICE University.




Every Week, They have two sets of video Lectures with
• Concepts and Examples
• Two Quizes
( each quiz for a set)
• 1 Mini Project

This Course duration is 8 Weeks (Oct -15 to Dec - 10)

Today was my first class.

Here are some Concepts which i learnt:

1. Comments

Comments are Non-computational parts of the program that describe the behavior of the program to you and others.

Comments begin with #, everything after the hash symbol is ignored by Python.

# Hello,This is my first program in Python.

2. Print:

To return the values,we use print.

Example 1

# Hello,This is my first program in Python.

Print "Hello World"

Execute: The Output shows:

Line 3: SyntaxError: bad input on line 3 (''Hello world'')

Due to Case-Sensitiveness, In the statement : 'P' in Print should be in Lower-Case.

Example 2

# Hello,This is my first program in Python.

print "Hello World"

Execute: The Output shows:

Hello world 

3. Strings :

Sequence of characters enclosed by a pair of single or double quotes is called as Strings.

Example 1

# Hello,This is my first program in Python.

print "Hello World"

Execute: The Output shows:  Hello world 

 In this, "Hello world" / 'Hello World' results to same output.

Strings are one of the data types: They are denoted by 'str'.

----------------------------------------------------
Continued...

Happy Learning..Happy Programming :)