Posted in Microsoft, Microsoft, Microsoft Azure

How to Scale Queries Using Azure Stream Analytics


Learn how to scale queries using Streaming Units and partitions in this tutorial by Krishnaswamy Venkataraman, a big data and cloud architect.

In a traditional static data scenario, a query can be executed against a fixed data set and results will be available after a known interval. On the other hand, with a streaming data scenario involving constant changes to a dataset, the queries will run for a longer duration or might not even complete.

Additionally, a constant stream of data will increase the volume of the data, and the query might drain the working memory. One way to draw a data boundary is through the context of time. For example, with a streaming dataset, you can specify a data boundary that resides within the start and end time. This will restrict the query execution between known boundaries. There are two types of timing constraints you can use to set time boundaries for the streaming data, application and arrival time.

Continue reading “How to Scale Queries Using Azure Stream Analytics”

Advertisements
Posted in Cloud Computing, Microsoft

Microsoft Azure Service Bus Integration with Dynamics CRM: Convenient Retrieval of Data


Innovations have kept on taking place, since the technology came into existence. Enterprises today look for the acute computing solutions that are not only effective but at the same time, fast and active too to deal with the everyday challenges for their campaign. This is when analyzing the demands of market, Microsoft; the core software company came up with its innovative product- Azure. Continue reading “Microsoft Azure Service Bus Integration with Dynamics CRM: Convenient Retrieval of Data”

Posted in Cloud Computing, Microsoft

Biz Talk Server – Enabling Maximum Interoperability for a Business


Understanding Biz Talk Server

Biz Talk Server is an ESB (enterprise service bus) developed by Microsoft to provide various business functionalities. It is a Microsoft registered trademark that acts as the central platform for business process management (BPM) and enterprise application integration. Additionally, Biz Talk Server embodies the automation and integration of Web services and XML technologies. Generally, Biz Talk Server provides the following functionalities to business enterprises; Continue reading “Biz Talk Server – Enabling Maximum Interoperability for a Business”

Posted in Microsoft

Delete duplicate text in Microsoft Excel 2010 and Excel 2007


How to delete duplicate text in Microsoft Excel 2010 and Excel 2007 from single column?

Microsoft Excel is a spreadsheet application developed by Microsoft having features such as graphing tools, calculation, a macro programming language called Visual Basic, and pivot tables for Applications. It comes as a part of Microsoft Office suit. It comes with all basic features available in spreadsheet. It is more useful in data storage and communication. There are many requirements from users on how to delete duplicate data from the worksheet. You can use find or replace functionality as well. But what if you want to remove all duplicate data available in single column without taking pain of find and replace duplicate content manually?

We can do it by using Advanced Filter feature. Let’s say you are using Google Web Master Tools to monitor your Blog and you download list of Crawl Errors in a Excel sheet format. You would like to find out unique errors reported by Google Web master tools. In this case, you can easily find it out with the use of Advanced Filter.

Cloud Computing – Download Free EBooks and Whitepapers
Java – Download Free EBooks and Whitepapers
Windows – Download Free EBooks and Whitepapers

Open Microsoft Excel 2010

  1. Select the column with DUPLICATE Records.
  2. Go to Filter | Advanced Filter.
Advanced Filter in Excel Sheet - Microsoft Excel 2010
Advanced Filter in Excel Sheet – Microsoft Excel 2010
  1. Click in the Copy To Another Location text box, then click on a cell in the same worksheet of Microsoft Excel 2010 Workbook where you want to store the new list.
  2. Click the Checkbox Unique Records.
  3. Click OK.

 

Posted in Cloud Computing, Microsoft

Microsoft Project 2013


Microsoft Project 2013-- Free Quick Reference Card
Microsoft Project 2013– Free Quick Reference Card

Download

This Microsoft Project 2013 Quick Reference offers the fundamentals, as well as tips and shortcuts for using the various applications within the software.

This printable quick reference is yours to use, distribute, and share at your organization!

Along with this free reference card, you will also receive a 30-day trial of CustomGuide training, including over 7,000 Online Skills Assessments and Interactive Tutorials.

Cloud Computing – Download Free EBooks and Whitepapers
Java – Download Free EBooks and Whitepapers
Windows – Download Free EBooks and Whitepapers