Keep smiling and make it contagious. Happy New Year 2014

 

May this new year brings lots of inspiration inside you to make you self efficient in the area you are growing.

 

Keep smiling and make it contagious.

 

Hope
Smiles from the threshold of the year to come,
Whispering ‘it will be happier’…
Alfred Tennyson

 

A new year report http://manasdash.wordpress.com/2013/annual-report/

#3 MS-Office Gyan for the day: OCR in OneNote

 

onenote

Optical Character Recognition, usually abbreviated to OCR, is the mechanical or electronic conversion of scanned or photoed images of typewritten or printed text into machine-encoded/computer-readable text.

 

I tried exploring the OCR and other features of Microsoft One Note and its really cool. I might present in a layman style but believe me its awesome tool for your day to day notes. Just take a look how I explored One Note.

 

If you are using One Note get the One Note  apps for free from http://www.onenote.com/

 

Just open your OneNote and create your Tab and your page… yes all set. This is a simple note taking application but the capabilities what One Note has is mind-blowing.

Select the Insert menu and take a look at the Ribbon. Lets try couple of feature. We will start with the OCR.

We will read text from an image!!! Cool …Right. Lets do it.

 

Copy Text From Picture

image

Here I have inserted one of my picture where some quotes are there. I will try extracting the text from the picture. Its just two step.

 

 

image

Right click on the picture & select  “copy Text From Picture”  and when you are ready “paste your text any where”.

image

 

Now you try with various picture and explore the power of One Note.

Screen Clipping

How about taking screen shot in a  quick and effective way with time stamp. Now I am not talking about that old “Print Screen” method of taking screen print and paste it and then write timestamp by your own. Lets see how One Note helps.

 

imageSelect the Insert menu and select “Screen Clipping” and then suddenly you see One Note will disappear and will go to the background. Its giving a chance to you to capture a portion of the screen you are interested for. (next time Try the keys (Shift+ Windows + s) for a twist.)

image

 

Now once you select one area OneNote will take that portion and will paste in the text area of OneNote with a time stamp which reads like “Screen clipping taken <Date>”. I took a screen capture from my blog.

 

 

 

 

Now a task for you , If you have a scanner attached try the other option “Scanned Images”

 

Where next

http://office.microsoft.com/en-in/onenote/

https://play.google.com/store/apps/details?id=com.microsoft.office.onenote&hl=en

https://itunes.apple.com/in/app/microsoft-onenote-for-iphone/id410395246?mt=8

 

Till next “Keep Smiling”.

Computer Science Education Week: Dec 9th to 15th 2013

logo_text

Anybody can learn

If you have never learned computer , now this is your chance to learn and support for the “Computer Science Education Week”. If you are willing to learn the course materials are free. Just learn and spread the word.

 

Computer Science Education Week (CSEdWeek) is an annual program dedicated to inspiring K-12 students to take interest in computer science.

Originally conceived by the Computing in the Core coalition, Code.org is producing CSEdWeek for the first time this year, held in recognition of the birthday of computing pioneer Admiral Grace Murray Hopper (December 9, 1906).  (Source http://csedweek.org/about)

 

Code.org says

If you haven’t already, start your own Hour of Code. Help us reach 1 billion lines of code!

 

Some stats so far

395,695,793 LINES OF CODE WRITTEN BY STUDENTS

12,241,183 have learned an HOUR of CODE

 

Different organization and BIG Boss of the industry are supporting for this cause.

Word from the Leaders and trendsetters

 

Aaron Skonnard from pluralsight said

We’ll award a full Pluralsight grant to the first 50 schools that participate in ‪#‎HourOfCode‬ and apply by Dec 15: http://blog.pluralsight.com/hour-of-code-grants ~ Aaron Skonnard

 

Even Khan Academy is supporting for this cause.

 

About Code.org

Code.org is a non-profit dedicated to expanding computer science education. The Code.org vision is that computer science should be part of the core curriculum in every school, alongside other science, technology, engineering, and mathematics (STEM) courses, such as biology, physics, chemistry and algebra.

 

I am learning courses from CodeAcademy and I am really happy with the content and the presentation.

http://www.codecademy.com/users/scriptRunner69432/achievements

 

Don’t wait , learn and be a part of the HISTORY.

New Mail Window–Just a line of code

In most of the website you might have noticed, the contact us or contact me link at the end. Once you click that it will open a new mail window of your default mail client and it will have the mention subject and a mail id in the to box. So we can achieve that with the below line of code.

   1: <a href="mailto:simplymanas@gmail.com?Subject=query">Contact Me</a>

 

in HTML5 I wrote this in the footer section in this way.

 

   1: <footer>&copy; simplymanas 2013

   2: <a href="mailto:simplymanas@gmail.com?Subject=From BR">Contact Me</a>

   3: <a href="http:\\www.twitter.com\simplymanas">@simplymanas</a>

   4: </footer>

 

and it will appear like this

© simplymanas 2013

Contact Me @simplymanas

 

This article was also published by me in

Beyond Relational

Quote of the Day:

No person was ever honored for what he received. Honor has been the reward for what he gave.

–John Calvin Coolidge

#2 MS-Office Gyan for the day… (PowerPoint 2013)

In my last post I wrote about the new feature eye dropper” in PowerPoint 2013, this time I am writing about another features of PowerPoint.

 

How many of you used a screenshot in your presentation?

 

So you have used the paintbrush or other such tool to make it more good looking and then copy it to the presentation in your PowerPoint. You might have saved it and inserted it as a picture as well.

How about using any open window’s screen shot on the fly while designing your presentation and without  any help of picture editing tools. Yes no need to take it to the paintbrush and giving it a final touch. Everything is ready for you in PowerPoint itself.

image

 

Open the Microsoft PowerPoint and you can start with a blank page or a template of your choice.

Now open the window from which you want to copy a screen shot to your PowerPoint presentation. Navigate to the page or the window and you are done. No copy, no screen capture, nothing. For example I opened my blog in IE i.e. web browser window.

image

 

Now lets get back to the PowerPoint presentation and click on Insert menu and take your mouse to the Screen Shot button of the Images area. Just keep it there and read the tooltip.

Take a screenshot!!!!!

image

Now click the Screenshot button with small camera and a plus image on it. It will display you a list of Available Windows, (the current opened one in your system). Now its time to pick up the one you want to insert as a screen shot. The dialogue box that appears is asking for a hyperlink to the page if it’s a browser window. Choice is yours…just go ahead Smile

image

Remember my choice !!

image

…and what you thought … easy right Smile Smile Smile . Just a few steps and we are ready with the screen shot.

image

Guess what… it opens with an option to edit the image , the picture tools is all set for you. Now edit your picture inside PowerPoint, instead of going to other picture editing tools.

Power point 2013 has more features and options like this and you can learn More From Here & Here.

Till next time “Happy Learning & Sharing” :)

SQL Bang UG…Completed A Quarter…Sharing is fun, sharing is learning

430589_10151249803289029_384269882_n       I joined SQL Bangalore User Group (#SQLBangUG) as one of the first 4 members and till date I am part of this “knowledge Hub”, where sharing is fun while learning.

It was Saturday, November 24, 2012 when the first SQLBangUG was hosted at Microsoft Signature Building, Bangalore, India. Vinod Kumar delivered the key note for the event with his unique style of welcoming all and introduced the speakers while explaining the core  purpose of SQLBangalore User Group.

 

"Sharing is fun, sharing is learning"

 

I was lucky enough by getting a chance to present a session on SQL Server 2012 and would like to thank Vinod and Pinal for giving  me an opportunity to deliver a a session at such a big event. Being a learner and a student this forum is going to help me a lot.

The First UG meet sessions were

1: T-SQL Pitfalls  Speaker: Vinod Kumar M, MTC – Technology Architect
2: Top 5 SQL Server 2012 functions Speaker: Manas Ranjan Dash
3: Contained databases Speaker: Sudeepta Ganguly, Sr. Systems Engineer – Atos
4: Column Store Index in SQL Server 2012 Speaker: Pinal Dave, Evangelist – Pluralsight

Also we had two surprise session by International Speaker Lynn Langit, BigData and BI consulting & Raj Chaudhuri from Microsoft, Mumbai on Index and Big Data.

 

66022_500051696693269_1000969640_n386525_500052030026569_538144332_n556795_500052376693201_541434094_n68306_500053216693117_15063029_n14157_500054453359660_704467154_n311241_500054380026334_746315131_n66092_500056346692804_1377774993_n543012_500056250026147_948877610_n63767_500057260026046_1298326439_n

Photo courtesy: Sandip Pani

Pinal Dave from Pluralsight gave away one year free subscription coupon of Pluralsight courses to one of the lucky audience and also he gave couple of his books and monthly coupons of Pluralsight to other attendees.

Sahal blogged about this event and  this was written prior to the event which shows the excitement level of the participants and the enthusiasm to learn something new.

http://www.get-exchange.info/2012/11/20/nosql-ug-meet-sqlbangalore-ug-meet-on-24-nov-2012/

By December 18 the group had added 300 members to its list Smile

 

The Second UG Meet was on Saturday, December 22, 2012

The sessions were as follows

1. Better together: Excel + SQL for Database Developers By Kamlesh Rao
2. Basics of Backups with SQL Server By Balmukund Lakhani, Microsoft
3. Intro to Indexing – Basics rediscovered By Sourabh Agarwal, PFE – Microsoft
4. Knowing sp_server_diagnostics output By Amit Banerjee, PFE, Microsoft
5. Tips and Tricks Session By Vinod Kumar, MTC – Architect

548847_10151382283862803_764516271_n398713_491457330906098_1042803860_n393140_491457207572777_853433763_n406697_491457440906087_1815952124_n66702_491457484239416_1348497391_n483196_492572390794592_826425171_n

Amit Banerjee wrote a blog about the event which is the fastest ever published blog on SQLBang UG http://troubleshootingsql.com/2012/12/22/sql-bangalore-ug-meet/

Also an excellent coverage by our Super Star Balmukund Lakhani in his blog http://sqlserver-help.com/2012/12/23/coverage-report-sql-server-bangalore-user-group-meeting-2-22-december-2012/

 

and we did it! Crossed 400 Mark on 1st Jan 2013 ~ Balmukund Lakhani

 

Also we wished our members on new year day with this unique poster

SQLBangUG_2013

 

The Third UG Meet was on Saturday, Jan 19, 2013 which focused on EXCEL based visualizations

1: Tour of PowerPivot with Excel by Vinod Kumar

2: Advanced Excel Visualizations by S Anand

3: Introduction to PowerView with Excel by Selvakumar

4: Surprise SharePoint Session by Pinal Dave

image814801_10200454388025068_553314515_n14871_498864596821477_2055710638_nimage_thumb18image_thumb13274938_497847073589896_1324110356_n

SQL Bangalore se Balmukund Lakhani without Cameraman

http://sqlserver-help.com/2013/01/22/coverage-report-sql-server-bangalore-user-group-meeting-3-19-january-2013/

We were forced to postpone the SQL user group meeting (scheduled for 23 Feb 2013) by a week due to some issues with the availability of speakers.

Great Discussion and Knowledge Sharing in FB page

 

In between all these sessions the FB page of SQLBang was fully occupied by members where they discussed some live issues and shared great knowledge about SQL Server and the trend is going on with a lot of enthusiasm.

 

Next UG meet on 2nd March 2013

So What are you waiting for… join the SQL Bangalore User Group and experience the power of sharing through learning and be a part of the next UG meet on 2nd March 2013

This UG meeting is about multi-dimensional concepts. This is completely different from the relational engine we are aware off. Register at here

1: Start your journey with Multidimensional using SSAS -by Sudhir Rawat (Microsoft)
2: Introduction to Cubes -by Deepthi Anantharam (Technology Evangelist)
3: SQL Server 2012 Analysis Services – Tabular Mode by Karan Gulati (Microsoft)

Smile Smile Smile Today the group has welcomed its 791th member Smile Smile Smile

 

What & where

 

Facebook: https://www.facebook.com/groups/SQLBangalore/

Events Page: https://www.facebook.com/groups/SQLBangalore/events/

Twitter: @SQLBangalore

Twitter Hash Tag: #SQLBangUG

Download PPT from the Past sessions

https://www.facebook.com/groups/SQLBangalore/files/

 

SQL Bangalore UG se Manas Ranjan Dash

Till next “Keep Smiling”