Rajesh Sankaran Blog: 2015

Tuesday, 30 June 2015

Microsoft Parallel Data Warehouse ( Microsoft PWD)

This article is shared from the link

http://www.pdwtutorial.com/2014/06/parallel-data-warehouse-introduction.html

Parallel Data Warehouse Introduction

The SQL Server 2008 R2 Parallel Data Warehouse (PDW) edition is its first product in the Massively Parallel Processor (MPP) data warehouse space.

PDW uniquely combines MPP software acquired from DATAllegro, parallel compute nodes, commodity servers, and disk storage.

PDW lets you scale out enterprise data warehouse solutions into the hundreds of terabytes and even petabytes of data for the most demanding customer scenarios. In addition, because the parallel compute nodes work concurrently, it often takes only seconds to get the results of queries run against tables containing trillions of rows. For many customers, the large data sets and the fast query response times against those data sets are game-changing opportunities for competitive advantage.

The simplest way to think of PDW [Parallel Data Warehouse Tutorial] is a layer of integrated software that logically forms an umbrella over the parallel compute nodes. Each compute node is a single physical server that runs its own instance of the SQL Server 2008 relational engine in a shared-nothing architecture. In other words, compute node 1 doesn't share CPU, memory, or storage with compute node 2.

The smallest PDW will take up two full racks of space in a data center, and you can add storage and compute capacity to PDW one data rack at a time. A data rack contains 8 to 10 compute servers from vendors such as Bull, Dell, HP, and IBM, and Fiber Channel storage arrays from vendors such as EMC, HP, and IBM. The sale of PDW includes preconfigured and pretested software and hardware that's tightly configured to achieve balanced throughput and I/O for very large databases. Microsoft and these hardware vendors provide full planning, implementation, and configuration support for PDW.

The collection of physical servers and disk storage arrays that make up the MPP data warehouse is often referred to as an appliance. Although the appliance is often thought of as a single box or single database server, a typical PDW appliance is comprised of dozens of physical servers and disk storage arrays all working together, often in parallel and under the orchestration of a single server called the control node. The control node accepts client query requests, then creates an MPP execution plan that can call upon one or more compute nodes to execute different parts of the query, often in parallel. The retrieved results are sent back to the client as a single result set.

This introduction taken from http://sqlmag.com/sql-server-2008/getting-started-parallel-data-warehouse

For your Reference

Friday, 19 June 2015

The 21 toughest interview questions you'll have to answer if you want to work at Yahoo

This article was taken from the TechGig...

The 21 toughest interview questions you'll have to answer if you want to work at Yahoo

"What gets you out of bed in the morning?" - Marketing associate candidate

"For mobile, which new application would you suggest Yahoo to develop? Why do you think Yahoo should develop it?" - Associate Product Manager candidate

"How would you handle correcting a mistake that your manager made?" - Software Engineer candidate

"Use this white board to explain how multiple regression works. " - Research Scientist candidate

"Given a string that contains a sentence, reverse each individual word in the sentence. For example, 'Hello to this world' becomes 'olleH ot siht dlrow'." - Software Engineer Intern candidate

"How would you distribute 1000 potatoes in 10 baskets?" - Software engineer candidate

"How does the internet work?" - Software Engineer candidate

"What is a company that is marketed poorly, and how would you market it differently? " - Associate Product Marketing Manager candidate

"You have a 10x10x10 rubix cube. You paint the outside. How many cubes have paint on them? " - Software Engineer candidate

"What is one thing you could teach the people in the other room?" - Service Engineering Operations candidate

"You're wearing a nametag. Tell me what you think about it." - Associate Product Manager candidate

"You have 10 jars, each filled with many marbles. Each marble weighs exactly 1.0 grams. One of the jars is a bad batch meaning each marble inside weighs 1.1 grams instead of 1.0 grams. You have a scale that will give you back a number of how much things weigh on it. Using only one measurement, determine how would you be able to find the bad batch." - Software Developer candidate

"Design the game Tic Tac Toe." - Software Engineer Intern candidate

"What will you do if the internet is not working?" - Software Engineer candidate

"Find all the possible ways to reach a floor in a building if you can only take 1, 2, or 5 steps at a time." - Software Developer candidate

"How will Google self-drive car change the public transit system if they are made available for general audience." - Product Manager candidate

"Who are key stakeholders for Yahoo paid search? How would you balance their interests as a product manager?" - Product Manager candidate

"How would you monetize YouTube?" - Product Manager candidate

"How would you design an elevator?" - Software Engineer candidate

"There are n gas stations positioned along a circular road. Each has a limited supply of gas. You can only drive clockwise around the road. You start with zero gas. Knowing how much gas you need to get from each gas station to the next and how much gas you can get at each station, design an algorithm to find the gas station you need to start at to get all the way around the circle." - Technical Architect candidate

"Estimate the volume of water on the Earth." - Senior Product Manager candidate

Tuesday, 9 June 2015

The 5 daily habits of the world’s most successful people

I would like to share an article I read on the LinkedIn .....

The 5 daily habits of the world’s most successful people

We all like to borrow from people we admire to get more productive. Highly successful Square founder Jack Dorsey strictly copied Steve Jobs, using much of Jobs’ onstage rhetoric when describing Square’s features and even insisting on being referred to as an ‘editor’ as soon as he heard that Jobs had adopted that title in some circles at Apple!

‘Editor’ may not suit you and your line of work, but there is a lot that you can glean from studying the working style of high performers.

The most successful people tend to share a striking number of similar habits that help them maximise their productivity and effectiveness.

Here are the top 5 things you can learn from the daily habits of the most successful people:

Wake up early

The early bird really does catch the worm! It’s no coincidence that many of the most successful people wake up early, many of the world’s top CEOs are well known for getting up as early as 430am.

Quite apart from giving you more time to get stuff done, getting up early sets a positive tone for the day – it’s satisfying to quell the inner voice that’s asking for ‘just 5 more minutes’ in bed.

Addicted to the snooze button? Joel Gascoigne, co-founder of Buffer, has a couple of great tips to help you create a morning routine that lasts (he’s up at 5am every day!)

Joel puts a lot of stock by:

1 - Getting to bed early every night to make sure you get enough sleep (he makes sure he gets around 7.5 hours a night)

2 - Waking up early on weekends – if he’s not up around 6am he finds it hard to keep up his routine

You may not need to be up quite so early every day, but establishing a routine to help you get a jump on the day and give yourself a little extra time should definitely help you become more efficient.

Exercise regularly

Quite apart from staying in shape, keeping your body active also goes along way to helping you feel more alert during the day.

Exercise increases the blood flow to your brain, keeping you sharp and helping you stay on top of everything

It’s also proven to keep you happy! Working up a sweat releases Serotonin, the neurotransmitter in the brain that sends messages to your body to stimulate mood and emotion.

It’s not just happiness though, studies have indicated that there are a range of other cognitive benefits:

- Improved concentration

- Sharper memory

- Faster learning

- Prolonged mental stamina

- Enhanced creativity

- Lower stress

The benefits are so clear that, no matter how busy you are, you should always try and find the time. Vogue editor-in-chief Anna Wintour commits to playing tennis for one hour every day – if she has time so do you!

Focus, don’t multitask

It might be tempting to try and maximise your daily productivity by doing as many things as possible, but sadly this only reduces efficiency and effectiveness (multitasking may even be bad for our brains!)

Instead of flitting between different tasks and trying to do everything at once, take the time to plan your day. Work out the 3-5 things that you need to accomplish over the course of the day and focus on them first. This will help you cut down on all the extra work that seems important but gets in the way.

I would advocate setting aside time the night before to think through the your major goals for the next day – I scribble mine down before I go to bed in my notepad. It’s the first thing I look at when I wake up and it helps me get my day off to a good start.

Many highly successful figures also point to meditation as a great tool to increase focus - Oprah Winfrey for example, finds time for two daily 20 minutes sessions of yoga and contemplation despite her packed schedule. She uses this time to focus and help our prioritize different tasks and projects.

Learn from mistakes

We all make mistakes, it’s inevitable. What separates the most successful people though, is their ability to constantly learn from their mistakes.

It’s easy to blame other people when things start to go wrong – throughout life (school, family and work) we’re taught to feel guilty about failure, so it’s no surprise that people are keen to pass the buck.

Smart people tend to admit their mistakes easily – it’s the first step towards understanding what went wrong, and it’s this understanding that helps you make positive changes to your life.

Take this quote from basketball legend Michael Jordan:

“I’ve missed more than 9000 shots in my career. I’ve lost almost 300 games. 26 times, I’ve been trusted to take the game winning shot and missed. I’ve failed over and over and over again in my life. And that is why I succeed.”

It’s ok not to be perfect, no one is. What’s really important though is that you’re constantly focused on learning how to get better.

Make personal investments

The world’s most successful people are always prepared to invest time and resources in their own personal development.

If you stripped someone like Bill Gates of his assets and dumped him on the street I’d be willing to bet he’d be ok – he’s constantly invested in himself and built up huge reserves of human capital, major companies would be falling over themselves to offer him a job.

Not everyone can hit the daunting heights that Gates has reached, but we can all work on ourselves and become invaluable to whatever business we’re involved with.

This can seem daunting initially, but there are a few good ways that you can kick off this process and start investing in yourself:

- Set weekly goals and review your progress.

We’re often too caught up in life that we fail to step back and look at the things that are most critical. Try setting 2-3 weekly goals and reviewing your progress every Sunday.

- Get a mentor (this may take time)

Make a list of the most experienced people in your industry, read everything they right and reach out on Twitter to start a relationship. Once you have a healthy amount of back and forth dialogue, ask for feedback on your career and your goals.

- Build your personal brand

The advent of social media makes it easy for anyone to become an industry expert. Start a blog, promote your work and engage with other influencers to develop your personal brand. You need to be careful here – there are a lot of people using Twitter to talk about how great they are, try and be different.

I hope these tips are helpful, if there are any other habits that you’ve used to achieve success I’d love to hear about them!

SELECT INTO vs INSERT INTO on Columnstore

This is one of the useful SQL tips from the article on SQLCentral.Com

http://www.sqlservercentral.com/articles/Performance+and+Tuning/126527/

SELECT INTO vs INSERT INTO on Columnstore

Monday, 11 May 2015

Daily Routines Makes You Smarter...!!!

Exercise your brain.

Want to expand your mind? A little bit of effort every day goes a long way.

In the Quora thread, "What would you do to be a little smarter every single day?", readers shared the habits they follow to fuel their brains.

Here are some simple actions that could help you become a smarter person.

1. Come up with 10 ideas every day.

Think about how to reduce poverty, how to solve a daily problem you have, interesting movie ideas, or anything. It doesn't matter what subject your ideas fall into, as long as you're working your brain and your idea muscles. Your list might even lead to a new startup idea or writing subject. -Claudia Azula Altucher

2. Read the newspaper.

It will help you become more aware of the important things happening around the word. You'll learn to form your own opinions and connect the dots between seemingly unrelated things. You'll also have a lot more to talk about at parties or with friends. -Manas J Saloi

3. Play devil's advocate.

Take something you recently learned and generate a unique opinion on it that wouldn't immediately come to mind. Try to support it with evidence, and be open to the idea that new evidence will change your opinion. Repeat this every day, and you'll become much better at thinking outside the box.

If you're feeling stuck, try reading and critically evaluating the editorial section of papers. They will help you understand how other people form arguments and express their opinions. -Peter DePaulo

4. Read a chapter in a fiction or non-fiction book.

Aim to read a book a week. You can always find pockets of time to read, whether on your daily commute or while you're waiting in line. Goodreads is a great way to keep track of everything you read and to also find a community of other readers.

Fiction books are great for understanding characters and getting absorbed into another perspective, while non-fiction books are great for introducing you to new topics, from politics to psychology. -Claudia Azula Altucher

5. Instead of watching TV, watch educational videos.

Sometimes, it's more fun to watch things about a subject you love than to read about it, and you can learn a lot from other people's experiences.

You can find fun, educational videos on Khan Academy or watch TED talks. You can also find good ones on Youtube's channel SmarterEveryDay. In videos, the information is often presented in a digestible, memorable way, so you can be assured they'll stick. -Hendrik Sleeckx

6. Subscribe to feeds of interesting information.

Follow interesting voices on Facebook and Twitter, so you'll always learn something new when you look at your newsfeed or dashboard. For example, if you want to keep up with the latest news in science and technology, subscribe to the "I Fucking Love Science" page on Facebook. You can also follow email newsletters, such as Cal Newport's Study Hacks and Today I Found Out. -Saurabh Shah

7. Check in with your favorite knowledge sources.

Every day, scroll through Quora, Stack Overflow, specialty blogs, or any other sources that satiate your hunger for knowledge. This is an extremely easy habit, because other users are curating the content for you, so all you have to do is follow the ones who write about topics interesting to you. Try using Pocket to save articles for later reading, and then try to get through them before going to sleep at night. -Manas J Saloi

8. Share what you learn with other people.

If you find someone to debate and analyze ideas with, you can add to each other's knowledge and gain new perspectives. Also, when you can explain ideas to someone else, it means you've definitely mastered the concept. You can even share what you learn without directly talking to someone. Many people like to start blogs so they can engage others in online dialogue. -Mike Xie

9. Make two "To Do" lists: one of work-related skills you want to learn now, and another of things you want to achieve in the future.

Google Docs is a convenient way to keep track of your lists. For both, decide what you want to learn, compile sources that will teach you these skills, and then work on them each day.

For example, if you work in a computer-science related field, your first list might suggest you learn something new in Python one day or that you try using MongoDB another day.

For your second list, you can think about long-term goals, such as whether you want to go into marketing or architecture. Write down the small steps you need to take to reach that goal, whether it's by reading the experts in those fields or taking classes at a local college. -Manas J Saloi

10. Write an "I Did" list.

At the end of each day, write down what you completed. This will help you feel better about all the things you accomplished, especially if you're feeling discouraged. It will also help you reflect on how productive you were and how you can re-structure your to-do lists for the next day. -Claudia Azula Altucher

11. Start a "Stop Doing" list.

To clear out the mental clutter, take note of the mindless ways you spend your time. Break old habits, and make time for new, better ones. As Warren Buffett says, "The difference between successful people and very successful people is that very successful say 'no' to almost everything." -Shane Parrish

12. Write down what you learn.

You can start a blog or use an app like Inkpad to help you keep track of everything you learn. Not only will this be a great way to keep a record of everything you're doing, but it's also a good source of motivation to keep you accountable. You will want to learn more if you know that at the end of the day you'll have to write about it. -Manas J Saloi

13. Stimulate your mind.

Going on a daily run is a great way to get your brain flowing and to keep your mental health in shape. It's also a great way to think through difficult decisions or process new information. -Rick Bruno

14. Take online courses.

Check out this list of the most popular online courses for professionals. Make sure you don't overload yourself; commit to one to two and truly focus on them. The syllabus will also keep you on track, so you know you will be doing something every day, whether it's listening to a lecture or working on an assignment. -Manas J Saloi

15. Talk to someone you find interesting.

Even if they're strangers, don't be afraid to approach them. Ask about their interests and how they discovered them. Oftentimes, you learn the most from people you barely know. -Manas J Saloi

16. Hang out with people who are smarter than you.

Spend as much time as you can with smart people. Every day, you should strive to have a coffee date or walk with someone who inspires you.

Always be humble and willing to learn. Ask as many questions as possible. If you are always around people who are more knowledgeable than you, you'll have no choice but to learn more. -Manas J Saloi

17. Follow your questions.

If you see or hear about something cool, don't just let the moment pass. Follow up - pursue your curiosity and find the answer to your question. -Mike Xie

18. Use a word-of-the-day app.

You will increase your vocabulary, which can help you in competitive tests like the SAT or GRE, or even just sound more eloquent in daily interactions.

You can also try to learn new vocabulary in a different language. Every day, try to add five to 10 more words to the foreign language you are trying to pursue. You can use LiveMocha, Basuu, or DuoLingo. -Manas J Saloi

19. Do something scary.

"Getting out of our comfort zone always makes us wiser." Every day, push yourself a little further. Try public speaking by joining a ToastMasters class, lead a meeting by volunteering a proposal at work, or reach out to someone you really admire by sending a quick letter or email. -Claudia Azula Altucher

20. Explore new areas.

If you can't travel every day, at least try to find something new within your hometown. You'll meet different people, learn new facts, and understand something new about the world. It's a lot more productive than staying at home and watching TV. -Manas J Saloi

21. Play "smart" games.

Some games, like chess and Scrabble, expand your mind. Challenge yourself when you play them. For example, play Scrabble without a dictionary. You can also solve puzzles via games like Sudoku, 2048, and Doors. -Saurabh Shah

22. Set aside some time to do nothing.

Oftentimes, sitting in silence can help you get inspiration and reflect on your day. -Claudia Azula Altucher

23. Adopt a productive hobby.

If you have something you can work on every day, from knitting to fly fishing, you can actively learn more just from doing. For instance, you may try to play a new piece of music every day, read a physics textbook, write a few more pages in your novel, or learn a new computer skill. -Mayank Rajput

24. Apply what you learn.

If you recently learned a new coding skill or how to play an instrument, make sure you are using that skill in your life as often as possible. Learning by doing is one of the most effective ways to become smarter. -Himanshu Pal

25. Exercise, and eat a healthy diet.

Opt for brain foods to fuel your thinking, and avoid alcohol and heavy meals that will make you sluggish. When your energy dips, take a walk. "The more blood flowing into your brain, the better your performance. Great thinkers like Mahatma Gandhi and Charles Darwin were famous for their long walks." -Janne Piiroinen

Courtesy :

http://www.techgig.com/readnews.php?category=Hiring&tgnews_link=http%3A%2F%2Fwww.businessinsider.in%2F25-daily-habits-that-will-make-you-smarter%2Farticleshow%2F47205412.cms%3Futm_source%3Dten_minutes_with%26utm_medium%3DReferral%26utm_campaign%3DContent_Patnership&tg_type=rss&tgnews_id=55426

Wednesday, 15 April 2015

SQL Server Practice...

Need to start...........

Wednesday, 11 February 2015

17 Skills Required to Succeed as an Entrepreneur

1. The ability to manage money
2. The ability to raise money
3. The ability to relieve stress
4. The ability to be productive
5. The ability to make entrepreneur friends
6. The ability to identify strengths and weaknesses
7. The ability to hire effective people
8. The ability to train new staff
9. The ability to manage staff
10. The ability to conduct basic SEO
11. The Ability to A/B split test
12. The ability to connect via social networking
13. The ability to focus on your customers
14. The ability to close a sale
15. The ability to spot new trends
16. The ability to deal with failure
17. The desire to improve your world

Courtesy : http://www.techgig.com/readnews.php?category=Hiring&tgnews_link=http%3A%2F%2Ffeedproxy.google.com%2F~r%2Fentrepreneur%2Flatest%2F~3%2FIjoMPkaZE_M%2F242327&tg_type=rss&tgnews_id=53503

Thursday, 5 February 2015

Leadership Skills

Develop These 5 Skills to Become a Tremendous Leader

1. Being a good listener
2. Possessing moral courage
3. Asking better questions
4. Offering support
5. Relinquishing control

Courtesy : The below URL

http://www.techgig.com/readnews.php?category=Hiring&tgnews_link=http%3A%2F%2Ffeedproxy.google.com%2F~r%2Fentrepreneur%2Flatest%2F~3%2FJ0TE-TE9MeM%2F242477&tg_type=rss&tgnews_id=53367

Apple's - SWIFT - for iOS and Mac OS

Apple has introduced a new programming language called Swift - specifically for iOS and Mac OS.

Go through this link to get more insight on the same...

http://news.dice.com/2015/02/04/javascript-tops-popular-languages-as-swift-rises/?CMPID=EM_RE_UP_JS_AD_DA_CP_&utm_source=Responsys&utm_medium=Email&utm_content=&utm_campaign=Advisory_DiceAdvisor