Pages

Monday, March 10, 2014

5 SQL Server 2014 Features to Keep an Eye On


According to Microsoft, SQL Server 2014 is designed to deliver new hybrid cloud scenarios, faster data insights, and built-in in-memory capabilities. Many people believe the biggest feature in the upcoming SQL Server 2014 release is the In-Memory OLTP Engine (formerly code named Hekaton). As we await the general release of SQL Server 2014, let's take a look at a few of the most talked about enhancements and features. 
Backup Encryption
Encrypting backups gets simpler in SQL Server 2014.  Check out a great illustration of the how you can prevent anyone from taking your backup file and restoring it to another database server with the new SQL Server 2014 encryption capabilities by reading My Favorite New Feature in SQL Server 2014 by Joey D'Antoni.
Business Intelligence
SQL Server 2014 includes business intelligence (BI) improvements to help build and support vast databases and data warehouses. Learn more about what SQL Server 2014 will do for your business intelligence efforts in Upcoming Business Intelligence Enhancements in SQL Server 2014 by Kevin Kline.
In-Memory OLTP Engine
In-Memory OLTP significantly improves the OLTP workload and reduces the time required for processing. The performance gains depend on the hardware infrastructure you have and how you are writing your queries. Get more details from Arshad Ali in SQL Server 2014 In-Memory OLTP Architecture and Data Storage.
Memory Optimization Advisor
The SQL Server 2014 Memory Optimization Advisor will help you quickly analyze your tables and walks you through reviewing and migrating disk-based table to In-Memory OLTP tables. Greg Larsen give you a walk-through of how to use the Memory Optimization Advisor tool to migrate a table in the AdventureWorks2012 database. See,SQL Server 2014 Memory Optimization Advisor.
Windows Azure Integration
SQL Server 2014 includes the ability to use Windows Azure for offsite backup storage and as a disaster recovery site. With SQL Server 2014 you can backup and restore your databases from copies stored in Windows Azure, which can quickly and easily provide off-site storage for all backups. More specifics are available in SQL Server 2014 CTP2 and Azure Backups by Joseph Karnes.

Friday, March 7, 2014

Hadoop Summit 2011 Facebook Messages Infrastructure by Karthik Ranganathan


11 Awesome Features That Make The Android 4.4 KitKat Incredibly Sweet

10099728803 bfd722103c z 11 Awesome Features That Make The Android 4.4 KitKat Incredibly Sweet
Have you gotten your hands on the LG-made Nexus 5 yet? You haven’t? That’s a shame, because you’re missing out on Google’s latest Android 4.4 KitKat mobile operating system. What’s the big deal about the most recent sweetly named Android OS? We’re glad you asked. Because KitKat has some very cool features that make it a must-have purchase.
But, if you’re not going to invest in the Nexus 5, no worries. Google is claiming that KitKat will become available on the Nexus 4, Nexus 7, Nexus 10, and Google Play Edition HTC One, and Galaxy S4 phones sometime “in the coming weeks”. Until then, check out these 11 awesome features. We’re pretty sure that these will give you a really nasty case of sweet-tooth.

11. Easter Egg

This doesn’t really reflect the performance of the Android 4.4 KitKat, but it’s a neat feature if you want to have fun with the new OS. Included in the operating system is an Easter egg that converts your smartphone into a virtual KitKat chocolate bar. This is done by constantly tapping the ‘Android 4.4′ text within the About Phone section of the Settings menu.

10. Emojis

Here’s another fun feature that Google has added into the Android KitKat’s Google Keyboard. Emoji, which is a Japanese term for those cartoonish ideograms and smileys seen in text messages and websites, can now be used in your messages instead of traditional text.

9. Contact Prioritization

KitKat will prioritize your contact list by sorting it by the people who you chat with the most often. You can also do a search for places and businesses that are near your location from the search box at the top. The KitKat Contacts app can also link up with your Google Apps contacts.

8. Message Consolidation

The latest Android OS will consolidate all of your SMS , MMS, video calls and Google Hangouts chat messages into one convenient location. Another nifty feature in here is being able to share location and animated GIFs via Google Hangouts.

7. Quickoffice Integration

After Google purchased Quickoffice several years ago, it’s nice to see that is has been integrated into KitKat. Quickoffice is preinstalled and allows users to edit documents, spreadsheets, and presentations that have been created with Microsoft Office or Google Docs.

6. Enhanced Caller ID by Google

How else can Google Search be used? How about by improving caller ID? If you’re tired of getting calls from unrecognizable numbers, this feature will resolve that issue by retrieving Caller ID information from local listings within Google Maps.

5. Full-Screen Album And Movie Art Combined With Controls

Here’s another fun feature for those who stream music or movies. KitKat allows not only full-screen album and movie art to appear, there’s also controls that let users play, pause, skip ahead or lock the device’s screen.

4. Support for Integrated Pedometer

If you’ve been looking to invest into something like a FitBit, or are looking to lighten-up your gadget load, you’ll really enjoy this feature. Since the Nexus 5 is equipped with sensors that support pedometer functions, KitKat can enable this hardware through apps like Move.

3. Immersive Display

Unlike previous versions of Android, where those intrusive status bar and navigation buttons remained on the screen, KitKat comes with a feature that will hide everything while reading or watching a movie. If you want to get back the status bar and navigation buttons simply swipe the edge.

2. Unlimited Home Screen Panels

If you ever wanted an unlimited amount of app shortcuts, folders, and widgets on your home screen panels, you’re in luck. KitKat contains such an ability. So go wild and crazy.

1. “OK Google”

Are you tired of touching that grimy screen to perform searches, send texts, get directions or play your favorite tunes? If so, or if you’re just lazy, there’s now voice control capabilities. Simply say “Ok Google” and the command you want when on the home screen, or when Google Now is open, and voilĂ . You’re done.
What’s your favorite feature in the Android 4.4 KitKat? And, what would you like to see in future operating systems?

Thursday, March 6, 2014

SQL Server 2012 Certification Path

It’s always good to give Certifications, it enhances your technical skills and prove your knowledge, and more over it looks good on your Resume!
People ask me about study materials, dumps (which I don’t recommend strongly). Few people have confusion to give which exam in what order. Some are not aware of the exams that lies in the Certification Path.
So, I have created a visual snapshot of all these exams for all SQL Server 2012 Certification exams at different levels:


So, you can start with any of the 3 exams at the bottom (first) level based upon your area of interest. A Dev can take 70-461, a DBA can start with 70-462, and a DataWarehouse Engineer can go with 70-463, and you can take them in any order.
1. Microsoft Certified Professional: As soon as you pass any one exam you are an MCP.
2. Microsoft Certified Solution Associate: After you are done with all three (70-461 + 70-462 + 70-463) you are an MCSA.
3. Microsoft Certified Solution Expert: After achieving MCSA, you can either go for MCSE inData Platform (70-464 + 70-465) or Business Intelligence (70-466 + 70-467).
4. Microsoft Certified Solution Master: After achieving MCSA in Data Platform, you can go even further to MCSM by taking 70-468 & 70-469 exams.
- 70-986: Not yet available
- 70-987: Not yet available
For more details about the Certification Path and exams you can check Microsoft Official site:http://www.microsoft.com/learning/en-us/sql-certification.aspx

Storing and Querying Big Data in Hadoop ( HDFS )

There is so much happening in the world of Big Data that it is not even funny any more. In this calendar year alone, companies would have spent US$ 4.5 billion on big data.
Sadly I find that most IT practitioners and leaders know the term but have to reach for Wikipedia to know what it means. So where do you start. One good anchor point would be with a basic understanding of what is Big Data and how does it get stored and retrieved to and from a distributed file system like Hadoop.
I was mulling whether to write a post on Hadoop Architecture and how to query big data or simply stick to a graphical explanation. For a change I decided to stick to the latter and will probably supplement the graphic with a little more explanation in my next post.
Click the graphic for a full-screen view and don’t forget to leave me your comments.
Storing and Querying Big Data in Hadoop ( HDFS )
Storing and Querying Big Data in Hadoop ( HDFS )

How to Send Personalized Emails using Mail Merge in Gmail

Say you work for the PR department of a company and you have been asked to invite some journalists for a private briefing with company executives. Or you are having a birthday party at home and need to invite your friends over email.
In either of these scenarios, you would like to send personalized email messages to all the recipients and that’s where this Mail Merge program for Gmail can come in handy. Mail Merge is a built-in feature of Microsoft Outlook and Word but if you happen to live in the Gmail or Google Apps cloud, no worries as even Gmail users can use the magic of Google Scripts to perform mail merge in the browser.
Before we get started, watch this video demo to know what’s in store for you:

Mail Merge with Gmail – Step by Step

Open your Gmail mailbox and compose a new message. This will be just like any other email message except that you need to mark text that will vary in different messages. For instance, the first line of your messages could read Dear First-Nameand you need a way to tell Gmail that First-Name is a variable field.
That’s easy. You just need to replace First-Name in the message with $%First-Name%as shown in the following screenshot. Similarly, replace all variable fields that are either in the body or the subject line of your Gmail message.
You can also include one or more attachments in your Gmail message. If you wish to include inline images in the mail, please upload them to a site like imgur.com and then drag and drop them into your Gmail message (see PDF Tutorial).
Save the draft message in Gmail and then make a copy of this spreadsheet in your Google Drive.
Gmail Mail Merge
Open the Mail Merge spreadsheet that you’ve just copied and you’ll find some dummy data here to help you get started. You just need to change the column names in the spreadsheet such that they match the various variable fields that you marked in your Gmail draft message.
You can add (or remove) any number of columns but the one mandatory column that should exist in your spreadsheet is labeled Email Address. Just ensure that the column names in the spreadsheet and the variable fields in the Gmail messages are exactly same and that every Gmail variable to mapped to a column in Google Docs.
You need to have one row of data in the Google Spreadsheet for every recipient and the values of that particular row will be used to send a personalized message to that recipient. Please note Gmail has a daily sending limit and you can send a maximum of 100 messages in a day. If you would like to send more, switch to Mail Merge Premium.
Once you’ve filled the rows in the sheet with the necessary data, go to the Mail Merge menu in the Google Sheet and click Initialize. It may require authorization the first time you run this program so just click Grant Access. Don’t worry, you are just granting access to the sheet to access your Gmail account – no one else will have access to your data (Video).
start mail merge

Start Mail Merge in Google Docs

Now that you have granted access to Google Docs, click “Start Mail Merge”, choose the Gmail template you earlier created from the drop-down, enter the Sender’s name (this will show in the FROM field of your outgoing messages), tick the BCC option (if you want to get a copy of the outgoing emails) and hit Start Mail Merge. That’ it.
Once the mail merge is complete, a new column “EMAIL_SENT” will be added to every row indicating that the row need not be processed should you run Mail Merge again on the same set of data. If you plan to include that row in mail merge again, just change the Mail Merge status column for that row from EMAIL_SENT to blank.

10 URLs That Every Google User Should Know

ere can you get a list of every ad that you have clicked on Google? Where should you go if you don’t remember your administrator password? What are your interests as determined by Google?
Here are 10 important links that every Google user should know about. They are tucked away, somewhere deep inside your Google dashboard.
1. Create a new Google Account using your existing email address. The regular sign-up process uses your @gmail.com address as your Google account username but with this special URL, you can use any other email address as your username.
2. Google creates a profile of yourself based on the sites you visit, your Google+ account and other signals. They try to guess your age, gender and interests and then use this data to serve you more relevant ads. Use this URL to know how Google sees you on the web.
3. Google lets you export all your data out of the Google ecosystem. You can download your photos, contacts, Gmail messages and even your YouTube videos. Head over the the Takeout page to grab the download links.
4. If you ever find your content appearing on another website that is using one or more Google products – say Blogger, AdSense, Google+ or YouTube - you can raise a DMCA complaint with Google against that site to get that content removed. This wizard can also be used to remove websites from Google search results that are scraping your content.
5. Your Android device may be reporting your recent location data and velocity (are you moving and if yes, how fast are you moving) back to Google servers. Head over to the Google Maps website to see your entire location history and you also have the option to export this data as KML files that can be viewed inside Google Earth or even Google Drive.
6. Google records every search term that you’ve ever typed into their search boxes. They even keep a log of every ad that you have clicked on various Google websites.
Google URLs
7. You need to login to your Gmail account at least once every 9 months else Google may terminate your account according to their program policies.
This can be an issue if you have multiple Gmail accounts so as a workaround, you can setup your main Gmail account as the trusted content for your secondary accounts. Thus Google will keep sending you reminders every few months to login to your other accounts. Not available for Google Apps.
8. Worried that someone else is using your Google account. Go to the activity report to see a log of every device that has recently been used to log into your Google account. You also get to know the I.P. Address and their approximate geographic location. Unfortunately, you can’t remotely log out of a Google session.
9. This is a complete list of web apps, browser extensions, Google Scripts and mobile apps that have any read or write access to your Google data. If the permission level says “access to basic account info”, it basically means that you have used your Google account to sign-in to that app.
10. This is important URL for Google Apps users. If your Google Account ever getshacked, use this secret link to reset your admin password. You’ll be asked to verify your domain name by creating a CNAME record in your DNS.
https://admin.google.com/domain.com/VerifyAdminAccountPasswordReset
[*] Replace domain.com in the above URL with your own web domain name.