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.
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”→
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.