text:
THE SQL Server Blog Spot on the Web
To coincide with the release of Microsoft SQL Server 2014, Microsoft StreamInsight has been updated to version 2.3. StreamInsight 2.3 is strictly a licensing update to version 2.1 that allows you to use StreamInsight with a SQL Server 2014 license. Any code written against StreamInsight 2.1 works the same in version 2.3.
You can get a copy of StreamInsight 2.3 from the SQL Server 2014 Feature Pack located in the Microsoft Download Center: http://www.microsoft.com/en-us/download/details.aspx?id=42295
See the StreamInsight 2.3 documentation on MSDN for installation instructions: http://msdn.microsoft.com/en-us/library/ee378749(v=sql.111).aspx
Note: Microsoft SQL Server media normally includes a copy of StreamInsight, but the SQL Server 2014 media erroneously includes the wrong version of StreamInsight. You can get the correct version at the Download Center as described above. More information is available here: http://support.microsoft.com/kb/2971131.
If you're evaluating StreamInsight you should know that it's more than just an API for writing streaming queries. Included with the StreamInsight installation are powerful tools that allow you to manage, monitor, tune, and troubleshoot your streaming data applications. These tools range from diagnostic methods and properties built into the API to a full graphical debugging application.
To read more, see the TechNet Wiki article, StreamInsight: More Than Just an API.
The StreamInsight Team
Are you trying to figure out whether StreamInsight might be something you could use, but you're having trouble sifting through all the programming jargon that's used to describe it? StreamInsight is, ultimately, a set of programming tools, and at some point it takes a programmer to implement a StreamInsight solution. But it really should be possible to get a handle on what StreamInsight is all about even if you're not a programmer yourself.
A new article published in the TechNet Wiki may be able to help: StreamInsight for Non-Programmers. It gives an overview of the technology, but it leaves out the C# references and relates StreamInsight to more familiar SQL databases and queries. Check it out.
When you're done there and are ready to dig a little deeper, take a look at Get Started with StreamInsight 2.1. That article should help you navigate through the StreamInsight official documentation and other resources.
And, as always, you can post questions or comments here or on the TechNet Wiki.
If you're just beginning to get familiar with StreamInsight, you may be looking for a way to get started. What are the basics? How can I get my first StreamInsight application running so I can see how it works? Where is the 'front door' that will get me going?
If that describes you, then this blog entry might be just what you need.
If you're already a StreamInsight wiz, keep reading anyway - you may find some helpful links here that you weren't aware of. But here's what we'd like from you experienced readers in particular: if you know of other good resources that we missed, please feel free to add them in the comments below. We appreciate you sharing your expertise.
The basic documentation for StreamInsight is located in the MSDN Library (Microsoft StreamInsight 2.1). You'll notice that previous versions of StreamInsight are still there (1.2 and 2.0), but if you're just getting started you can stick to the 2.1 section.
The documentation has been organized to function as reference material, which is fine after you're familiar with the technology. But if you're trying to learn the basics, you might want to take a different path instead of just starting at the top.
The following is one map you can use.
Here is a sequence of topics that should give you a good overview of what StreamInsight is and how it works:
Once you have this background, go ahead and install StreamInsight and get a basic example up and running:
That's it - you now have a real, functioning StreamInsight system!
Now that you have a handle on the basics, you might want to start digging deeper.
Here's a suggested path through the documentation to help you understand the next layer of StreamInsight technologies:
Finally, to get a handle on some of the more complex things you can do with StreamInsight, dig into these:
As you're designing and developing your StreamInsight solutions, you probably will find it helpful to see working examples or to learn tips and tricks from others. Or maybe you need a place to post a vexing question.
Here are some community resources that we have found useful. If you know of others, please add them in the comments below.
The following case studies are based on earlier versions of StreamInsight, but they still are useful examples:
That should get you going. Please add any other resources you have found useful in the comments below.
Until now, we've released StreamInsight through the Microsoft Download Center, and also released it out through Microsoft Update. Going forward, we will only release new StreamInsight versions through the Microsoft Download Center and only use MU to release service packs and security fixes (should any be needed). As a result of this decision, we are pulling off the recent StreamInsight 2.1 release from MU; this release is still available in Download Center.
Don't worry: there's nothing wrong with the versions we've shipped in MU, we've just adjusted how we use MU. There is no action necessary from our customers as a result of this change, and we are not rolling back any changes to your current installation, so if you have installed StreamInsight 2.1 recently through the Microsoft Update, they will still work fine.
In the previous blog posting, we showed how to construct and deploy query fragments to a StreamInsight server, and how to re-use them later. In today's posting we'll integrate this pattern into a method of dynamically composing a new query with an existing one.
The construct that enables this scenario in StreamInsight V2.1 is a Subject. A Subject lets me create a junction element in an existing query that I can tap into while the query is running.
To set this up as an end-to-end example, let's first define a stream simulator as our data source:
This 'generator' produces a new instance of SourcePayload with a period of t (system time) as an IObservable. SourcePayload happens to have a property of type double as its payload data.
Let's also define a sink for our example—an IObserver of double values that writes to the console:
The observer takes a string as parameter which is used as a label on the console, so that we can distinguish the output of different sink instances. Note that we also deploy this observer, so that we can retrieve it later from the server from a different process.
Remember how we defined the aggregation as an IQStreamable function in the previous article? We will use that as well:
Then we define the Subject, which acts as an observable sequence as well as an observer. Thus, we can feed a single source into the Subject and have multiple consumers—that can come and go at runtime—on the other side:
Subject are always deployed automatically. Their name is used to retrieve them from a (potentially) different process (see below).
Note that the Subject as we defined it here doesn't know anything about temporal streams. It is merely a sequence of SourcePayloads, without any notion of StreamInsight point events or CTIs. So in order to compose a temporal query on top of the Subject, we need to 'promote' the sequence of SourcePayloads into an IQStreamable of point events, including CTIs:
In a later posting we will show how to use Subjects that have more awareness of time and can be used as a junction between QStreamables instead of IQbservables.
Having turned the Subject into a temporal stream, we can now define the aggregate on this stream. We will use the IQStreamable entity avg that we defined above:
In order to run the query, we need to bind it to a sink, and bind the subject to the source:
Lastly, we start the process:
Now we have a simple query running end-to-end, producing results. What follows next is the crucial part of tapping into the Subject and adding another query that runs in parallel, using the same query definition (the "AverageQuery") but with a different window length. We are assuming that we connected to the same StreamInsight server from a different process or even client, and thus have to retrieve the previously deployed entities through their names:
The attached solution demonstrates the sample end-to-end.
Regards, The StreamInsight Team
The changes in our APIs enable a set of scenarios that were either not possible before or could only be achieved through workarounds. One such use case that people ask about frequently is the ability to parameterize a query and instantiate it with different values instead of re-deploying the entire statement. I'll demonstrate how to do this in StreamInsight 2.1 and combine it with a method of using subjects for dynamic query composition in a mini-series of (at least) two blog articles.
Let's start with something really simple: I want to deploy a windowed aggregate to a StreamInsight server, and later use it with different window sizes. The LINQ statement for such an aggregate is very straightforward and familiar:
Obviously, we had to use an existing input stream object as well as a concrete TimeSpan value. If we want to be able to re-use this construct, we can define it as a IQStreamable:
The DefineStreamable API lets us define a function, in our case from a IQStreamable (the input stream) and a TimeSpan (the window length) to an IQStreamable (the result). We can then use it like a function, with the input stream and the window length as parameters:
Nice, but you might ask: what does this save me, except from writing my own extension method? Well, in addition to defining the IQStreamable function, you can actually deploy it to the server, to make it re-usable by another process! When we deploy an artifact in V2.1, we give it a name:
When connected to the same server, we can now use that name to retrieve the IQStreamable and use it with our own parameters:
Convenient, isn't it?
Keep in mind that, even though the function "AverageQuery" is deployed to the server, its logic will still be instantiated into each process when the process is created. The advantage here is being able to deploy that function, so another client who wants to use it doesn't need to ask the author for the code or assembly, but just needs to know the name of deployed entity.
A few words on the function signature of GetStreamable: the last type parameter (here: double) is the payload type of the result, not the actual result stream's type itself. The returned object is a function from IQStreamable<SourcePayload> and TimeSpan to IQStreamable<double>.
In the next article we will integrate this usage of IQStreamables with Subjects in StreamInsight, so stay tuned!
Regards, The StreamInsight Team
Back in 2010 we released the first version of an educational guide to StreamInsight Queries to help developers mind shift into the new paradigm. With the release of StreamInsight 2.1 and introducing the New Programming Model, we thought this was the right time to freshen up this document.
The format and the storyline stay mostly untouched from the original. There are several improvements to the document. It is updated to the new programming model introduced in v2.1. As a consequence we do not talk about adapters anymore, as they are not necessary to introduce the query language, and it helps simplify the narrative. We have also improved and extended event data visualizations, which makes it easier to understand and follow the queries.
The guide consists of a PDF document and a Visual Studio solution that accompanies the paper.
The VS solution is also part of the StreamInsight 2.1 samples on CodePlex and the queries discussed in the paper are also included in the StreamInsight 2.1 LinqPad samples.
I tend to partition StreamInsight operators into three classes: the basic "temporal/relational" operators; the "time travel" operators, and; the "elephant" operators. The basic operators illustrate the rules. The time travel operators bend the rules. The scan operators break them altogether. While I'd like to focus on time travel today, we can't bend the rules before knowing what they are. Let's begin with the basics!
A StreamInsight query describes how the results of a normal relational query change over time. The start time of an event indicates the time that a row is inserted into the relational input. The end time indicates when that row is deleted. StreamInsight's basic temporal/relational operators can be understood in those terms. For instance, the StreamInsight 'join' operator produces output for coincident input tuples matching some predicate. Tuples are coincident if their time intervals overlap. Another way of looking at it: all matching tuples across all time logically produce output, but that output may have an empty temporal intersection. The basic temporal/relational operators:
Time travel operators bend the rules because they allow an input event to contribute to results outside of their original time interval! The time travel operators:
The fundamental time travel operator is alter event lifetime because the others can be expressed in terms of it. (I'll leave this as an exercise for the reader). A hint for hopping window operators: one way of thinking about a hopping window is that events belonging to the same window are reassigned to the same time interval so that they can contribute to the same output time interval!) While there are several variations on the alter lifetime operator, they all boil down to the following components:
If you do modify start times and durations, make sure that the modifications to start and end times are monotonic. In other words, make sure that the changes do not affect the relative order of start and end edge events. Otherwise, you risk introducing CTI violations. CTI violations bring down the query: they indicate that a new event has arrived affecting a result that has already been committed! Like traveling through time to alter the past, violating CTIs causes (can I even use that word here?) bad things to happen.
Shifting all events forward or backward by a fixed amount is safe because the CTIs are moving with the events*:
Making time pass faster or slower doesn't violate the monotonicity requirement, but depending on the nature of the input can introduce CTI violations. If the input stream contains end edge events, then they could also violate CTIs if not modified, as in the following example which attempts to double the speed at which time passes:
We can address the failure by ensuring that end edges also advance at double-speed:
There is a very important loophole that can be exploited for duration modifications. If the duration selector returns a fixed value for every event, StreamInsight no longer needs to produce end edges internally, and those non-existent end edges no longer pose a CTI violation risk:
In summary, there are several completely safe forms of time travel in StreamInsight:
While it may be safe to stray from these rules for specific data and query combinations, I suggest playing it safe!
* Notice that the start time selector function does not allow behavior to be affected by event payload. This is because CTI events, which are also modified by the selector, do not carry payloads.
Regards, Colin Meek/The StreamInsight Team
Someone recently called LINQ "magic" in my hearing. I leapt to LINQ's defense immediately. Turns out some people don't realize "magic" is can be a pejorative term. I thought LINQ needed demystification. Here's your best demystification resource: http://blogs.msdn.com/b/mattwar/archive/2008/11/18/linq-links.aspx. I won't repeat much of what Matt Warren says in his excellent series, but will talk about some core ideas and how they affect the 2.1 release of StreamInsight.
Let's tell the story of a LINQ query.
It begins with some code:
When the code is compiled, the C# compiler (among other things) de-sugars the query expression (see C# spec section 7.16):
Overload resolution subsequently binds the Queryable.Where<Product> and Queryable.Select<Product, int> extension methods (see C# spec sections 7.5 and 7.6.5). After overload resolution, the compiler knows something interesting about the anonymous functions (lambda syntax) in the de-sugared code: they must be converted to expression trees, i.e.,"an object structure that represents the structure of the anonymous function itself" (see C# spec section 6.5). The conversion is equivalent to the following rewrite:
If the "products" expression had type IEnumerable<Product>, the compiler would have chosen the Enumerable.Where and Enumerable.Select extension methods instead, in which case the anonymous functions would have been converted to delegates.
At this point, we've reduced the LINQ query to familiar code that will compile in C# 2.0. (Note that I'm using C# snippets to illustrate transformations that occur in the compiler, not to suggest a viable compiler design!)
When the above program is executed, the Queryable.Where method is invoked. It takes two arguments. The first is an IQueryable<> instance that exposes an Expression property and a Provider property. The second is an expression tree. The Queryable.Where method implementation looks something like this:
Notice that the method is really just composing a new expression tree that calls itself with arguments derived from the source and predicate arguments. Also notice that the query object returned from the method is associated with the same provider as the source query.
By invoking operator methods, we're constructing an expression tree that describes a query. Interestingly, the compiler and operator methods are colluding to construct a query expression tree. The important takeaway is that expression trees are built in one of two ways: (1) by the compiler when it sees an anonymous function that needs to be converted to an expression tree, and; (2) by a query operator method that constructs a new queryable object with an expression tree rooted in a call to the operator method (self-referential).
Next we hit the foreach block. At this point, the power of LINQ queries becomes apparent. The provider is able to determine how the query expression tree is evaluated! The code that began our story was intentionally vague about the definition of the "products" collection. Maybe it is a queryable in-memory collection of products:
The in-memory LINQ provider works by rewriting Queryable method calls to Enumerable method calls in the query expression tree. It then compiles the expression tree and evaluates it. It should be mentioned that the provider does not blindly rewrite all Queryable calls. It only rewrites a call when its arguments have been rewritten in a way that introduces a type mismatch, e.g. the first argument to Queryable.Where<Product> being rewritten as an expression of type IEnumerable<Product> from IQueryable<Product>. The type mismatch is triggered initially by a "leaf" expression like the one associated with the AsQueryable query: when the provider recognizes one of its own leaf expressions, it replaces the expression with the original IEnumerable<> constant expression. I like to think of this rewrite process as "type irritation" because the rewritten leaf expression is like a foreign body that triggers an immune response (further rewrites) in the tree. The technique ensures that only those portions of the expression tree constructed by a particular provider are rewritten by that provider: no type irritation, no rewrite.
Let's consider the behavior of an alternative LINQ provider. If "products" is a collection created by a LINQ to SQL provider:
the provider rewrites the expression tree as a SQL query that is then evaluated by your favorite RDBMS. The predicate may ultimately be evaluated using an index! In this example, the expression associated with the Products property is the "leaf" expression.
For the in-memory LINQ to Objects provider, a leaf is an in-memory collection. For LINQ to SQL, a leaf is a table or view.
When defining a "process" in StreamInsight 2.1, what is a leaf? To StreamInsight a leaf is logic: an adapter, a sequence, or even a query targeting an entirely different LINQ provider!
How do we represent the logic? Remember that a standing query may outlive the client that provisioned it. A reference to a sequence object in the client application is therefore not terribly useful. But if we instead represent the code constructing the sequence as an expression, we can host the sequence in the server:
Example 1: defining a source and composing a query
Let's look in more detail at what's happening in example 1. We first connect to the remote server and retrieve an existing app. Next, we define a simple Reactive sequence using the Observable.Range method. Notice that the call to the Range method is in the body of an anonymous function. This is important because it means the source sequence definition is in the form of an expression, rather than simply an opaque reference to an IObservable<int> object. The variation in Example 2 fails. Although it looks similar, the sequence is now a reference to an in-memory observable collection:
Example 2: error referencing unserializable local object
The Define* methods support definitions of operator tree leaves that target the StreamInsight server. These methods all have the same basic structure. The definition argument is a lambda expression taking between 0 and 16 arguments and returning a source or sink. The method returns a proxy for the source or sink that can then be used for the usual style of LINQ query composition. The "define" methods exploit the compile-time C# feature that converts anonymous functions into translatable expression trees!
Query composition exploits the runtime pattern that allows expression trees to be constructed by operators taking queryable and expression (Expression<>) arguments. The practical upshot: once you've Defined a source, you can compose LINQ queries in the familiar way using query expressions and operator combinators. Notably, queries can be composed using pull-sequences (LINQ to Objects IQueryable<> inputs), push sequences (Reactive IQbservable<> inputs), and temporal sequences (StreamInsight IQStreamable<> inputs). You can even construct processes that span these three domains using "bridge" method overloads (ToEnumerable, ToObservable and To*Streamable).
Finally, the targeted rewrite via type irritation pattern is used to ensure that StreamInsight computations can leverage other LINQ providers as well. Consider the following example (this example depends on Interactive Extensions):
Within the definition, StreamInsight has no reason to suspect that it 'owns' the Queryable.Where and Queryable.Select calls, and it can therefore defer to LINQ to SQL! Let's use this source in the context of a StreamInsight process:
When we run the binding, the source portion which filters on product ID and projects the product name is evaluated by SQL Server. Outside of the definition, responsibility for evaluation shifts to the StreamInsight server where we create a bridge to the Reactive Framework (using ToObservable) and evaluate an additional predicate.
It's incredibly easy to define computations that span multiple domains using these new features in StreamInsight 2.1!
At first glance, hopping windows seem fairly innocuous and obvious. They organize events into windows with a simple periodic definition: the windows have some duration d (e.g. a window covers 5 second time intervals), an interval or period p (e.g. a new window starts every 2 seconds) and an alignment a (e.g. one of those windows starts at 12:00 PM on March 15, 2012 UTC).
Logically, there is a window with start time a + np and end time a + np + d for every integer n. That's a lot of windows. So why doesn't the following query (always) blow up?
A few users have asked why StreamInsight doesn't produce output for empty windows. Primarily it's because there is an infinite number of empty windows! (Actually, StreamInsight uses DateTimeOffset.MaxValue to approximate "the end of time" and DateTimeOffset.MinValue to approximate "the beginning of time", so the number of windows is lower in practice.)
That was the good news. Now the bad news. Events also have duration. Consider the following simple input:
Because the event has no explicit end edge, it lasts until the end of time. So there are lots of non-empty windows if we apply a hopping window to that single event! For this reason, we need to be careful with hopping window queries in StreamInsight. Or we can switch to a custom implementation of hopping windows that doesn't suffer from this shortcoming.
The alternate window implementation produces output only when the input changes. We start by breaking up the timeline into non-overlapping intervals assigned to each window. In figure 1, six hopping windows ("Windows") are assigned to six intervals ("Assignments") in the timeline. Next we take input events ("Events") and alter their lifetimes ("Altered Events") so that they cover the intervals of the windows they intersect. In figure 1, you can see that the first event e1 intersects windows w1 and w2 so it is adjusted to cover assignments a1 and a2. Finally, we can use snapshot windows ("Snapshots") to produce output for the hopping windows. Notice however that instead of having six windows generating output, we have only four. The first and second snapshots correspond to the first and second hopping windows. The remaining snapshots however cover two hopping windows each! While in this example we saved only two events, the savings can be more significant when the ratio of event duration to window duration is higher.
Figure 1: Timeline
The implementation of this strategy is straightforward. We need to set the start times of events to the start time of the interval assigned to the earliest window including the start time. Similarly, we need to modify the end times of events to the end time of the interval assigned to the latest window including the end time. The following snap-to-boundary function that rounds a timestamp value t down to the nearest value t' <= t such that t' is a + np for some integer n will be useful. For convenience, we will represent both DateTime and TimeSpan values using long ticks:
How do we find the earliest window including the start time for an event? It's the window following the last window that does not include the start time assuming that there are no gaps in the windows (i.e. duration < interval), and limitation of this solution. To find the end time of that antecedent window, we need to know the alignment of window ends:
Using the window end alignment, we are finally ready to describe the start time selector:
To find the latest window including the end time for an event, we look for the last window start time (non-inclusive):
Bringing it together, we can define the translation from events to 'altered events' as in Figure 1:
Finally, we can describe our custom hopping window operator:
By switching from HoppingWindow to HoppingWindow2 in the following example, the query returns quickly rather than gobbling resources and ultimately failing!
As you can see, instead of producing a massive number of windows for the open start edge e0, a single window is emitted from 12:00:15 AM until the end of time:
Adjusted Events
Regards, The StreamInsight Team
In previous versions of StreamInsight (1.0 through 2.0), CepStream<> represents temporal streams of many varieties:
When adding support for new programming primitives in StreamInsight 2.1, we faced a choice: Add a fourth variety (use CepStream<> to represent streams that are bound the new programming model constructs), or introduce a separate type that represents temporal streams in the new user model. We opted for the latter. Introducing a new type has the effect of reducing the number of (confusing) runtime failures due to inappropriate uses of CepStream<> instances in the incorrect context. The new types are:
The syntax of temporal queries composed over IQStreamable<> is mostly consistent with the syntax of our existing CepStream<>-based LINQ provider. However, we have taken the opportunity to refine certain aspects of the language surface. Differences are outlined below. Because 2.1 introduces new types to represent temporal queries, the changes outlined in this post do no impact existing StreamInsight applications using the existing types!
StreamInsight does not support the SelectMany operator in its usual form (which is analogous to SQL's "CROSS APPLY" operator):
It instead uses SelectMany as a convenient syntactic representation of an inner join. The parameter to the selector function is thus unavailable. Because the parameter isn't supported, its type in StreamInsight 1.0 – 2.0 wasn't carefully scrutinized. Unfortunately, the type chosen for the parameter is nonsensical to LINQ programmers:
Using Unit as the type for the parameter accurately reflects the StreamInsight's capabilities:
For queries that succeed – that is, queries that do not reference the stream selector parameter – there is no difference between the code written for the two overloads:
The Take operator used in StreamInsight causes confusion for LINQ programmers because it is applied to the (unbounded) stream rather than the (bounded) window, suggesting that the query as a whole will return k rows:
The use of SelectMany is also unfortunate in this context because it implies the availability of the window parameter within the remainder of the comprehension. The following compiles but fails at runtime:
The Take operator in 2.1 is applied to the window rather than the stream:
We are introducing an explicit multicast operator in order to preserve expression identity, which is important given the semantics about moving code to and from StreamInsight. This also better matches existing LINQ dialects, such as Reactive. This pattern enables expressing multicasting in two ways:
Notice the product translates an expression using implicit multicast into an expression using the explicit multicast operator. The user does not see this translation.
Only default window policies are supported in the new surface. Other policies can be simulated by using AlterEventLifetime.
Not supported
Representation of LASJ as a correlated sub-query in the LINQ surface is problematic as the StreamInsight engine does not support correlated sub-queries (see discussion of SelectMany). The current syntax requires the introduction of an otherwise unsupported 'IsEmpty()' operator. As a result, the pattern is not discoverable and implies capabilities not present in the server. The direct representation of LASJ is used instead:
The ApplyWithUnion methods have been deprecated since their signatures are redundant given the standard SelectMany overloads:
The representation of UDOs in the StreamInsight LINQ dialect confuses cardinalities. Based on the semantics of user-defined operators in StreamInsight, one would expect to construct queries in the following form:
Instead, the UDO proxy method is referenced within a projection, and the (many) results returned by the user code are automatically flattened into a stream:
The "many-or-one" confusion is exemplified by the following example that compiles but fails at runtime:
The above query must fail because the UDO is in fact returning many values per window while the count aggregate is returning one.
Original syntax
New alternate syntax
Notice that this formulation also sidesteps the dynamic type pitfalls of the existing "proxy method" approach to UDOs, in which the type of the UDO implementation (TInput, TOuput) and the type of its constructor arguments (TConfig) need to align in a precise and non-obvious way with the argument and return types for the corresponding proxy method.
UDSO currently leverages the DataContractSerializer to clone initial state for logical instances of the user operator. Initial state will instead be described by an expression in the new LINQ surface.
ShiftEventTime => AlterEventStartTime: The alter event lifetime overload taking a new start time value has been renamed.
CountByStartTimeWindow => CountWindow
We are announcing the availability of the LinqPad driver for StreamInsight 2.1. The purpose of this blog post is to offer a quick introduction into the new features that we added to the StreamInsight LinqPad driver. We'll show you how to connect to a remote server, how to inspect the entities present of that server, how to compose on top of them and how to manage their lifetime.
Info on how to install the driver can be found in an earlier blog post here.
As you click on the "Add Connection" link in the left pane you will notice that now it's possible to build the data context automatically. The new driver appears as an option in the upper list, and if you pick it you will open a connection dialog that lets you connect to a remote StreamInsight server.
The connection dialog lets you specify the address of the remote server. You will notice that it's possible to pick up the binding information from the configuration file of the LinqPad application (which is normally in the same folder as LinqPad.exe and is called LinqPad.exe.config).
In order for the context to be generated you need to pick an application from the server. The control is editable hence you can create a new application if you don't want to make changes to an existing application. If you choose a new application name you will be prompted for confirmation before this gets created.
Once you click OK the connection is created and you can start issuing queries against the remote server. If there's any connectivity error the connection is marked with a red X and you can see the error message informing you what went wrong (i.e., the remote server could not be reached etc.).
Let's take a look at what happens after we are connected successfully. Every LinqPad query runs inside a context – think of it as a class that wraps all the code that you're writing. If you're connecting to a live server the context will contain the following:
The picture below shows a snapshot of the left pane of LinqPad after a successful connection. Every entity on the server has a different icon which will allow users to figure out its purpose. You will also notice that some entities have a string in parentheses following the name. It should be interpreted as such: the first name is the name of the property of the context class and the second name is the name of the entity as it exists on the server. Not all valid entity names are valid identifier names so in cases where we had to make a transformation you see both.
Note also that as you hover over the entities you get IntelliSense with their types – more on that later.
As you play with the entities exposed by the context you will notice that you can't read and write directly to/from them. If for instance you're trying to dump the content of an entity you will get an error message telling you that in the current version remoting is not supported. This is because the entity lives on the remote server and dumping its content means reading the events produced by this entity into the local process.
Will yield the following error:
Reading from a remote 'System.Reactive.Linq.IQbservable`1[System.Int32]' is not supported. Use the 'Microsoft.ComplexEventProcessing.Linq.RemoteProvider.Bind' method to read from the source using a remote observer.
Reading from a remote 'System.Reactive.Linq.IQbservable`1[System.Int32]' is not supported. Use the 'Microsoft.ComplexEventProcessing.Linq.RemoteProvider.Bind' method to read from the source using a remote observer.
This basically tells you that you can call the Bind() method to direct the output of this source to a sink that has to be defined on the remote machine as well. You can't bring the results to the LinqPad window unless you write code specifically for that.
You may ask – what's the purpose of all that? After all the same information is present in the EventFlowDebugger, why bother with showing it in LinqPad? First of all, What gets exposed in LinqPad is not what you see in the debugger. In LinqPad we have a property on the context class for every entity that lives on the server. Because LinqPad offers IntelliSense we in fact have much more information about the entity, and more importantly we can compose with that entity very easily. For example, let's say that this code creates an entity:
If later we want to compose with the source we have to fetch it and then we can bind something to
This means that we had to know a bunch of things about this: that it's a source, that it's an observable, it produces a result with payload Int32 and it's named "ObservableSource". Only the second and last bits of information are present in the debugger, by the way.
As you type in the query window you see that all the entities are present, you get IntelliSense support for them and it's much easier to make sense of what's available.
Let's look at a scenario where composition is plausible. With the new programming model it's possible to create "cold" sources that are parameterized. There was a way to accomplish that even in the previous version by passing parameters to the adapters, but this time it's much more elegant because the expression declares what parameters are required. Say that we hover the mouse over the ThrottledSource source – we will see that its type is Func<int, int, IQbservable<int>> - this in effect means that we need to pass two int parameters before we can get a source that produces events, and the type for those events is int – in the particular case of my example I had the source produce a range of integers and the two parameters were the start and end of the range. So we see how a developer can create a source that is not running yet. Then someone else (e.g. an administrator) can pass whatever parameters appropriate and run the process.
Here's an interesting scenario – what if someone created a source on a server but they forgot to tell you what type they used. Worse yet, they might have used an anonymous type and even though they can refer to it by name you can't figure out how to use that type.
Let's walk through an example that shows how you can compose against types you don't need to have the definition of. This is how we can create a source that returns an anonymous type:
Now if we refresh the connection we can see the new source named O1 appear in the list. But what's more important is that we now have a type to work with. So we can compose a query that refers to the anonymous type.
You will notice that the anonymous type defined with this statement: new { I = i } can now be manipulated by a client that does not have access to it because the LinqPad driver has generated another type in its stead, named StreamInsightDynamicDriver.TypeProxies.AnonymousType1_0. This type has all the properties and fields of the type defined on the server, except in this case we can instantiate values and use it to compose more queries.
It is worth noting that the same thing works for types that are not anonymous – the test is if the LinqPad driver can resolve the type or not. If it's not possible then a new type will be generated that approximates the type that exists on the server.
In addition to composing processes on top of the existing entities we can do other useful things. We can delete them – nothing new here as we simply access the entities through the Entities collection of the application class. Here is where having their real name in parentheses comes handy.
There's another way to find out what's behind a property – dump its expression. The first line in the output tells us what's the name of the entity used to build this property in the context.
So let's create a process to see what happens. We can bind a source to a sink and run the resulting process. If you right click on the connection you can refresh it and see the process present in the list of entities. Then you can drag the process to the query window and see that you can have access to process object in the Processes collection of the application. You can then manipulate the process (delete it, read its diagnostic view etc.).
The wait is over—we are pleased to announce the release of StreamInsight 2.1. Since the release of version 1.2, we have heard your feedbacks and suggestions and based on that we have come up with a whole new set of features. Here are some of the highlights:
Here is how simple coding can be with the 2.1 Programming Model:
class Program
static void Main(string[] args)
using (Server server = Server.Create("Default"))
// Create an app
Application app = server.CreateApplication("app");
// Define a simple observable which generates an integer every second
var source = app.DefineObservable(() =>
// Define a sink.
var sink = app.DefineObserver(() =>
Observer.Create<long>(x => Console.WriteLine(x)));
// Define a query to filter the events
var query = from e in source
where e % 2 == 0
select e;
// Bind the query to the sink and create a runnable process
using (IDisposable proc = query.Bind(sink).Run("MyProcess"))
Console.WriteLine("Press a key to dispose the process...");
That's how easily you can define a source, sink and compose a query and run it. Note that we did not replace the existing APIs, they co-exist with the new surface.
Stay tuned, you will see a series of articles coming out over the next few weeks about the new features and how to use them.
Come and grab it from our download center page and let us know what you think! You can find the updated MSDN documentation here, and we would appreciate if you could provide feedback to the docs as well—best via email to email@example.com.
Moreover, we updated our samples to demonstrate the new programming surface.
Fresh from the press – The March 2012 issue of MSDN Magazine features an article about the Internet of Things. It discusses in depth how you can use StreamInsight to process all the data that is continuously produced in typical Internet of Things scenarios. It also gives you an end-to-end perspective on developing Internet of Things solutions in the .NET world, ranging from the .NET Micro Framework application running on the device, the communication between the devices and the server-side all the way to powerful cross-device streaming analytics implemented in StreamInsight LINQ.
You can find an online version of the article here. Happy reading!


text:
Quality CareFind out why Mayo Clinic is the right place for your health care. Make an appointment.
Meet the StaffFind a directory of doctors and departments at all Mayo Clinic campuses. Visit now.
Research and Clinical TrialsSee how Mayo Clinic research and clinical trials advance the science of medicine and improve patient care. Explore now.
Visit Our SchoolsEducators at Mayo Clinic train tomorrow's leaders to deliver compassionate, high-value, safe patient care. Choose a degree.
Professional ServicesExplore Mayo Clinic's many resources and see jobs available for medical professionals. Get updates.
Give to Mayo ClinicHelp set a new world standard in care for people everywhere. Give now.
Subscribe to Housecall
Our general interest e-newsletter keeps you up to date on a wide variety of health topics.
Alkamides, alkylamides, American coneflower, Asteraceae (family), black sampson, black susan, caffeic acid derivatives, caffeoyl derivatives, cichoric acid and polysaccharides, cock-up-hat, combflower, compositae, cynarin, dodeca-2E,4E,8Z,10Z(E)-tetraenoic acid isobutylamide, dodecanoic acid derivatives, EC31J0, Echinacea® (Strong Nature, Serbia), Echinacea angustifolia, Echinacea laevigata, Echinacea Moench, Echinacea pallida, Echinacea Plus®, Echinacea purpurea, Echinacea purpurea L. Moench, Echinacea simulata, Echinacea tennesseensis, Echinacin®, Echinacin® EC31, echinacoside, Echinaforce®, Echinaforce® Forte, EchinaFresh® (Enzymatic Therapy, Green Bay, WI), Echinaguard®, Echinilin® (Factors R & D Technologies, Burnaby, BC, Canada), echino (Greek), EFLA® 894, glycoconjugates, hedgehog, hydrophilic polysaccharides, Igelkopf (German), Indian head, Kansas snake root, Kegelblume (German), narrow-leaved purple coneflower, N-isobutyldodeca-2E,4E,8Z,10Z-tetraenamide, Pascotox®, pentadeca-(8Z,13Z)-dien-11-yn-2-one, Polinacea™, polysaccharide, purple coneflower, red sunflower, rudbeckia, SB-TOX, scurvy root, sea urchin, snakeroot, solhat (Danish), sonnenhut (German), sun hat, undeca-2-ene-8,10-diynoic acid isobutylamide, undecanoic acid derivatives, unsaturated N-alkylamide lipids.
Combination product examples: ChizukitTM, an echinacea product that contains 50mg/mL of the extract of the upper plant parts of Echinacea purpurea and roots of Echinacea angustifolia, 50mg/mL of propolis, and 10mg/mL of vitamin C; Cold-X® (Vitamin C 100mg, Echinacea purpurea root extract 20.1mg, eucalyptus leaf extract 12.3mg, fennel seed extract 10.3mg); Kan Jang® (Adhatoda vasica, Echinacea purpurea, and Eleutherococcus senticosus); Esberitox® liquid (ethanolic-aqueous extracts of herba Thuja occidentalis 2mg, radix Echinacea 7.5mg, and radix Baptisia tinctoria 10mg); Esberitox® tablets (vitamin C 20mg, Thuja occidentalis 2mg, radix Echinacea 7.5mg, and radix Baptisia tinctoria 10mg); the transmucosal herbal periodontal patch, provided by Izun Pharmaceuticals (New York, NY) (plant extracts from Centella asiatica (gotu kola), Echinacea purpurea, and Sambucus nigra (elderberry)); Erbavita® (Andrographis paniculata, Echinacea, grapefruit, papaya, Tabebuia, and Uncaria); Imoviral® Junior (an herbal combination therapy that contains Echinacea angustifolia, arabinogalactan, vitamin C, beta-glucan, and zinc).
Portions of this document last updated: Nov. 01, 2013
This evidence-based monograph was prepared by The Natural Standard Research Collaboration
Mayo Clinic does not endorse companies or products. Advertising revenue supports our not-for-profit mission.
Check out these best-sellers and special offers on books and newsletters from Mayo Clinic.
Any use of this site constitutes your agreement to the Terms and Conditions and Privacy Policy linked below.
We comply with the HONcode standard for trustworthy health information: verify here.

subset: commoncrawl


text:
It's really quite sad if you think about it; not so long ago, Baz Luhrmann was the darling of Hollywood, a breath of fresh air in an increasingly formulaic industry. Audiences aren't so easily distracted these days by shiny colours and slick cinematography. More and more, they crave inner beauty over outer beauty. And perhaps it is that Baz Luhrmann hasn't quite realised this yet.
If we study the Gatsby phenomenon in detail, we would realise that every society has its Jay. But the factors that produce a Gatsby can be amazingly different. For instance, in the case of India it was not war, but economic reforms which gave birth to this culture. Here I shall discuss the strange case of three Indian tycoons who had shades of Jay, and like him met violent deaths.


text:
Shields stays in rhythm against Cubs
SURPRISE, Ariz. -- If it hadn't been for a ground ball up the middle that second baseman Johnny Giavotella couldn't quite corral, Royals pitcher James Shields might have had six perfect innings on Saturday.
As it was, Christian Villanueva got an infield single and was the only baserunner against Shields, who dominated a Cubs split squad with a 10-strikeout performance.
"I was giving Gio a little hard time in that inning. I said, 'If I don't give up a hit, it's all your fault, right?' " Shields said with a smile.
"I felt really good out there. Me and [catcher Salvador Perez] were on the same page the entire game, I hardly had to shake with him. When you get in a rhythm and groove with your catcher, you get in a rhythm on the mound and execute your pitches, so today went real well."
Shields has been working to refine his delivery with pitching coach Dave Eiland and it's apparently working well. He's allowed just one earned run in 14 2/3 innings for a 0.61 ERA.
"One of the things we talked about before Spring Training started is really honing in that delivery right out of the gate," Shields said. "I feel really good out of the mound. Obviously, the stamina part is not quite there yet, but that's just normal Spring Training stuff. Everything else is good."
Left-hander Tim Collins did not have a good day, giving up three runs in the ninth as the Cubs rallied for a 6-5 victory on a wind-blown afternoon.
"It was a combination of factors," manager Ned Yost said. "One was it's his first time back-to-back and the elements played [a role]. I mean, he's out of the inning if we catch a fly ball. It's one of those Arizona things."
Dick Kaegel is a reporter for MLB.com. This story was not subject to the approval of Major League Baseball or its clubs.


text:
A large donation by AT&T will provide support for site coordinators working with the Coweta Communities In Schools (CIS) program.
The $60,000 donation was presented by AT&T Regional Director of External Affairs Rich Johnson to the Coweta County Board of Education at its March 11 meeting. CIS is the nation's leading drop-out prevention program.
"We want to invest in organizations that are making a measurable impact on the students they serve, and Communities In Schools is doing just that," said Johnson. "By coupling this contribution with the power of our employees, we hope to take our collaboration to the next level and help even more students graduate high school ready for their futures."
AT&T made the presentation to Dennis McEntire, Chairman of Coweta County's CIS board of directors. McEntire was joined by board members and by CIS Field Support Coordinator Nancy Stone, according to school system spokesman Dean Jackson.
McEntire thanked AT&T for their support, saying the Coweta CIS board has worked over the past year to provide funding and marketing for CIS programs in Coweta schools. AT&T's donation will provide the organization's first school-based site coordinator in Coweta County next school year, at East Coweta High School, Jackson said.
"AT&T has demonstrated unparalleled leadership in supporting efforts to create a 21st century education system and American workforce," said Neil Shorthouse, President of Communities In Schools of Georgia. "We are grateful for AT&T's support and long-standing collaboration."
Jackson said CIS is considered the nation's leading drop-out prevention organization, providing at-risk children with academic assistance, school supplies, healthcare, counseling, family support, food and positive community role models. The organization began in the 1970s, when founder Bill Milliken created an organization focused on bringing community resources inside public schools and developing a model that keeps the efforts accessible to students, coordinated and accountable.
"By partnering with businesses, social service agencies, health care providers and volunteers, the organization places site coordinators inside schools to assess students' needs and provide resources to help them succeed academically and socially," said Jackson. "In addition to strengthening community outreach to children most in need through their schools and school systems, the organization also encourages greater involvement by parents in their children's education and offers students ways to take greater responsibility for their own learning and development."
Johnson noted that AT&T and CIS share a sense of urgency to advance the national movement focused on improving student success in an increasingly competitive global economy that demands a skilled workforce and informed citizenry.
Communities In Schools (CIS) of Georgia is part of the Communities In Schools national network. CIS is the nation's leading drop-out prevention organization. Its mission is to surround students with a community of support, empowering them to stay in school and achieve in life. CIS of Georgia provides support and resources to 37 locally-managed local affiliates who serve more than 200 school and community-based sites. Together the partnership helps school districts increase school success and graduation rates. Communities sponsoring CIS programs have seen an increase in their school graduation rates, a decrease in violence and disruptions, and an increase in attendance and academic achievement, according to CIS Georgia.


text:
For several years, you've been able to book charter flights on the Internet and now, as we've reported in Business Jet Traveler, there's a retail store in London–The Jet Business–where you can actually walk in off the street and buy an airplane.
I think I can see where this trend is headed.
The year is 2050. Joe Jetbuyer calls his local Jet Depot. That's the 4,257-location chain that Home Depot launched after the number of Silicon Valley and hedge-fund zillionaires mushroomed out of control.
"Please listen carefully, as our options have recently changed," says a recorded voice. "Press 1 for a Jet Depot store near you. Press 2 to order VVLJs. Press 3 to order supersonic jets. Press 4 for Virgin Galactic spaceships. Press 0 to speak to a 'live' robot."
Joe presses 1, deciding he's not about to purchase a $250 million airplane (did I mention the inflation spike of 2023?) sight unseen. Then his Google-controlled car drives him to Jet Depot.
"Can I help you?" says the salesman. "We have some great models on special this week."
"I was looking for that new one from Hawker-Dassault-Bombardier-Embraer-Gulfstream," says Joe. "The merged company really has built some good stuff."
"Yes," the salesman agrees. "But ever since Beijing Industries bought it, we've been getting a lot of returns. Still, the price is right: I can let you have that little beauty over there for $289,999,999.99."
"That's a bit more than I wanted to spend," says Joe, "but I have a coupon for $20 million off." He hands it to the salesman.
"I'm afraid you can't use that," says the salesman. "The $20 million discount applies only when you buy three or more. But I'll tell you what. I'll let you have it for $5 million off and no money down. No interest either, if you pay in full within six months. Would you like an extended-protection plan? Repairs can be expensive so I'd definitely advise it."
"That all sounds pretty good," says Joe, "but hold on a minute while I check something." He pulls out his iPhone 43, scans a product barcode on the side of the jet he's been examining, studies some information on the phone and then looks up at the salesman.
"Sorry," Joe says. "It's cheaper on Amazon."


text:
Find the word or phrase
Full text search on activities in this channel containing specific keywords
- Show :
- events. You may view all the past events here.
- Filteby:
- Tag: project
3rd Energy Efficiency SymposiumApr 25, 2010
source: German American Chamber of Commerce, Inc., California Branch
The third "Energy Efficiency Symposium", focusing on energy efficiency in construction, will be held on Monday, April 26th. The 2010 conference will take place at...
Solar Expert Luncheon - PhiladelphiaMay 10, 2010
source: http://www.gaccny.com/en/events/singleview/?no_cache=1&tx_mjseventpro_ ...
The German American Chambers of Commerce are introducing this year the Expert Luncheon Series of Events. Renowned German experts will introduce the state of the...
German American Photovoltaics Conference - New JerseyMay 17, 2010
source: http://www.gaccny.com/en/events/singleview/?no_cache=1&tx_mjseventpro_ ...
The German American Chamber of Commerce, Inc. is proud to present the German American Photovoltaics Conference at the New Jersey Meadowlands Commission Center on May...
BioEnergy Conference and DelegationJun 20, 2010 to Jun 24, 2010
source: German American Chamber of Commerce of the Midwest, Inc.
The German American Chambers of Commerce are organizing a delegation for German companies in the bioenergy industry looking to enter the North American Market. The initiative is supported by...
1st Texas Offshore Wind Energy Roundtable (TOWER) & Offshore Wind Law (OWL) ConferenceOct 18, 2010 to Sep 21, 2010
source: German American Chamber of Commerce of the Southern US, Inc.
Houston, TX – July 21, 2010 - The Texas Offshore Wind Energy Roundtable (TOWER) and the Offshore Wind Law (OWL) conferences come ashore in Houston...
Training Program: Grid Integration Of Renewables: Capacity Building on the Integration of Large Amounts of Renewable Energy in Electricity GridsApr 13, 2011 to Dec 30, 2013
source: Renac
Target Countries: Morocco, Tunisia, Algeria, Egypt, Lebanon, Jordan and Syria
India: IGCC: Energy Efficiency Business Trip to IndiaMay 23, 2011 to May 26, 2011
source: Exportinitiative Energieffizienz
From 24 May to 27 May there will be a delegation focusing on energy efficiency from Germany in the Indian city of Pune.
Solar Energy Business Conference and Delegation to ColoradoJun 26, 2011 to Jun 30, 2011
source: German American Chamber of Commerce of the Midwest
Germany has long been a pioneer in solar energy technologies, and its high-quality, advanced technology is used around the world to generate energy from sunlight....
India: 5th Renewable Energy Expo India 2011Aug 9, 2011 to Aug 11, 2011
source: Energetica India
The Indian economy is experiencing tremendous growth over the past several years. Energy, in all its forms, underpins both past and future growth. For the...
Canada: Canada: DAS HAUS - Travelling Pavilion shows German IngenuityMar 11, 2012 to May 19, 2012
source: Canadian German Chamber
The Canadian German Chamber of Industry and Commerce Inc. is happy to announce Vancouver will mark the fifth stop on the North American tour of...


text:
BP Comment Quick Links
|Strength of Schedule Report
January 3, 2013
Prospect Profile
Three Late-Inning Relievers
Relievers are a fickle species; every year, many relievers come out of nowhere to make an impact at the major-league level. There doesn't seem to be a clear formula for short-term success as a big-league reliever, but there are combinations that can be lethal in short doses, and right now the minor leagues house multiple arms that could impact a game near you in 2013. Today, we'll look at three of them.
Marcus Stroman, Toronto Blue Jays
Stroman was used as a starter at Duke, but the Blue Jays used him exclusively as a reliever after they nabbed him with the 22nd overall pick in last June's draft. There has never been a successful 5'9" starter in the major leagues, so Stroman as a starter would be unprecedented. He also struggled to hold his velocity as a starter, and so the move makes sense. Personally, I look at a guy with three weapons and a feel for pitching, which would have been enough for me to give him a chance as a starter before relegating him to a relief role, but Toronto has taken the road that most would have given Stroman's issues.
People know that Stroman tested positive for a banned substance, but in 2013 he should provide additional reasons to remember his name. He's going to be an impact, late-inning reliever.
Jake Diekman, Philadelphia Phillies
Jake Diekman has a sexy package of tools, but here's my favorite fact about him: he was a 30th round pick out of Cloud County Community College in Concordia, Kansas. (Sorry, alliteraphobes. Next time, I'll bold my alliteration so you skip it over.) I don't know if alliteraphobia is actually a thing or not, but alliteration is only one reason to fear Diekman. He isn't perfect, but he misses a ton of bats and also has what it takes to be an impact, late-inning reliever.
Mark Montgomery, New York Yankees
Fortunately, Montgomery has one of the most contact-defying pitches in the minor leagues. "That slider is vicious," said one scout. "All kinds of two-plane break. Nasty." The same scout noted, however, that Montgomery's reliability on the pitch could get the 22-year-old in trouble at times. It has the makings of a 7 pitch, but there's still room for refinement in the approach.
Stroman, Diekman, and Montgomery are all going to miss big-league bats. Their roles at the major-league level will have to be earned, but the present tools are good enough to shut down hitters, and each arm figures to get a long look in 2013.
9 comments have been left for this article.
BP Comment Quick Links
Hmm. 5'9" starters/ Bobby Schantz? Whitey Ford- no sorry, 5'10". That's a short search. But "never"? No.
Jan 03, 2013 13:15 PM
Arm Side Run
I'm not sure how much predictive value there is in the fact that the Jays used him a reliever after he signed. Isn't that what happened with most college pitchers drafted in 2012 to keep their workload manageable after the college season?
Jan 04, 2013 01:50 AM
The way they used him indicates that he's a reliever. With many college arms who were worked heavily, you often see teams start them with easy workloads but still in starting roles. Not only did the Jays use him exclusively as a reliever, they also bumped him to Double-A pretty quickly, which put him in line for a possible September look (isn't on the 40-man, but could have been added), if not for the suspension.
Jan 04, 2013 12:49 PM
Anyone else realize that Philadelphia could potentially have a really good bullpen? Papelbon, Adams, and Bastardo are all really good at what they do. If Aumont and Diekman can be effective (big IF with Aumont), that's a top 5 MLB bullpen.
Jan 06, 2013 11:37 AM
Not a subscriber? Sign up today!


text:
Homeopathic Ear Drops for Otitis Media Study
This study has been completed.
University of Washington
Information provided by (Responsible Party):
James Taylor, University of Washington
ClinicalTrials.gov Identifier:
First received: October 26, 2009
Last updated: July 23, 2014
Last verified: July 2014
- Full Text View
- Tabular View
- Study Results
- Disclaimer
- How to Read a Study Record
The purpose of this study is to determine if a commercially available homeopathic ear drop preparation is effective in reducing symptoms in children 6 months - 11 years old with acute otitis media in whom the health care provider has recommended that antibiotics not be immediately administered. A total of 150 study patients with otitis media will be randomized to receive homeopathic ear drops, or no ear drops, in addition to receiving standard care. It is postulated that children using the ear drops will have more rapid resolution of symptoms and need fewer antibiotics than those randomized to not receive the ear drops.
|Otitis Media
|Drug: Hyland's earache drops
|Study Type:
|Study Design:
|Allocation: Randomized
Intervention Model: Parallel Assignment
Masking: None (Open Label)
Primary Purpose: Supportive Care
|Official Title:
|Homeopathic Ear Drops for Children With Otitis Media Study
Resource links provided by NLM:
MedlinePlus related topics: Ear Infections
Drug Information available for: Carbamide Carbamide peroxideU.S. FDA Resources
Further study details as provided by James Taylor, University of Washington:
Primary Outcome Measures:
- Severity of Symptoms of Otitis Media [ Time Frame: 15 days ]
- Administration of Antibiotics [ Time Frame: 15 days ]Number of participants who filled antibiotic prescription (or called back for promised antibiotic prescription) after being diagnosed with acute otitis media at index visit.
Secondary Outcome Measures:
- Side Effects From Study Remedy [ Time Frame: 15 days ]Any "other symptoms" reported by parents in logbooks. Logbooks were returned by 72/105 participants randomized to the homeopathic ear drops group and 78 of those randomized to standard therapy alone.
|Study Start Date:
|October 2009
|Study Completion Date:
|December 2013
|Primary Completion Date:
|April 2013 (Final data collection date for primary outcome measure)
|Assigned Interventions
Experimental: Homeopathic ear drops
Commercially available homeopathic ear drops
Drug: Hyland's earache drops
3-4 drops in affected ear 3 times a day as needed for up to 5 days
No Intervention: standard therapy
standard therapy for otitis media, no ear drops
|Ages Eligible for Study:
|6 Months to 11 Years (Child)
|Sexes Eligible for Study:
|Accepts Healthy Volunteers:
Inclusion Criteria:
- Age 6 months - 11 years old
- Diagnosed with otitis media by clinician at participating clinic
- Clinician determines that a "watch and wait" antibiotic prescription treatment plan is optimal management
Exclusion Criteria:
- Antibiotic treatment during past 7 days
- Homeopathic treatment within past 30 days
- History of serious chronic illness (e.g. diabetes, autoimmune disease, cystic fibrosis
- Perforated tympanic membrane
- Immediate antibiotic treatment plan decided by examining clinician
Contacts and Locations
Choosing to participate in a study is an important personal decision. Talk with your doctor and family members or friends about deciding to join a study. To learn more about this study, you or your doctor may contact the study research staff using the Contacts provided below. For general information, see Learn About Clinical Studies.
Please refer to this study by its ClinicalTrials.gov identifier: NCT01003210
Please refer to this study by its ClinicalTrials.gov identifier: NCT01003210
|United States, Washington
|Mercer Island Pediatric Associates
|Mercer Island, Washington, United States, 98040
|Valley Children's Clinic
|Renton, Washington, United States, 98055
|University of Washington Medical Center-Roosevelt Pediatric Care Center
|Seattle, Washington, United States, 98195
Sponsors and Collaborators
University of Washington
|Principal Investigator:
|James A Taylor, MD
|University of Washington
More Information
Keywords provided by James Taylor, University of Washington:
Additional relevant MeSH terms:
ClinicalTrials.gov processed this record on September 21, 2017
|Responsible Party:
|James Taylor, Professor, University of Washington
|ClinicalTrials.gov Identifier:
|NCT01003210 History of Changes
|Other Study ID Numbers:
|Study First Received:
|October 26, 2009
|Results First Received:
|May 19, 2014
|Last Updated:
|July 23, 2014
Keywords provided by James Taylor, University of Washington:
otitis media
Additional relevant MeSH terms:
Otitis Media
Ear Diseases
Otorhinolaryngologic Diseases
ClinicalTrials.gov processed this record on September 21, 2017


text:
Stroman holds down Red Sox in Blue Jays' rout
Phenom loses no-no in seventh; Francisco falls double shy of cycle
TORONTO -- At 23 years old, Marcus Stroman is the youngest member of the Blue Jays' rotation.
Since joining it on May 31, he has been the best.
Stroman carried a no-hitter into the seventh and extended his scoreless innings streak to 14 with a one-hit gem, while Juan Francisco fell a double shy of the cycle in the Blue Jays' 8-0 series-clinching win over the Red Sox in front of a sellout crowd of 46,683 at Rogers Centre on Thursday.
"[Stroman's] pitching like a veteran who has been around a long time," Blue Jays manager John Gibbons said. "He has the great arm, he has the pitches and all that, but the big thing about him is that he is a great competitor."
In 10 starts, Stroman is 6-2 with a 2.21 ERA and he leads Toronto starters in almost every meaningful statistic, including strikeout and walk rate. The rookie has lived up to the massive hype that has surrounded him since the Blue Jays made him a first-round Draft pick in 2012, and he had the best game of his career against the division-rival Red Sox.
Stroman had little trouble navigating through Boston's lineup, and save for a pair of walks, no Boston hitters reached base until Shane Victorino hit a bloop single to center to lead off the seventh inning. Victorino's single was the first ball the Red Sox hit out of the infield, and it spoiled Stroman's chances of joining right-hander Dave Stieb (Sept. 2, 1990) as the only pitchers in franchise history to throw a no-hitter.
Stroman, who said Victorino hit a hanging curveball, kept his composure, and followed it up by getting David Ortiz to fly out before inducing an inning-ending double play.
The New York native walked two, punched out a career-high-tying seven batters and recorded his eighth quality start. Stroman, who entered the start with the top ground ball rate among Toronto starters, recorded nine outs on the ground -- compared to one in the air -- and guided the Blue Jays to their fifth with in six contests.
"It has definitely been a ride so far," Stroman said about the success he has had in the big leagues. "I'm not surprised, it's kind of all the hard work that goes into it and going out and having a game plan."
During warmups, Stroman didn't feel like it was going to be a day on which he would flirt with history. And early in the contest, he had trouble locating his four-seam fastball, which nearly forced him to abandon the pitch and turn to a recently discovered two-seamer.
Stroman messed around during recent bullpen sessions and landed on a two-seam grip he was happy with, and said it was a big reason for the success he had vs. Boston, which lost its third straight game and was shut out for the 10th time this season.
"A couple of different types of breaking balls, with a pretty good power slurve along with a cutter," Red Sox manager John Farrell said, when asked what he saw from Stroman.
It wasn't until Stroman struck out Brock Holt for the third time in the sixth inning -- the 11th consecutive Red Sox hitter he retired -- that the possibility of a no-hitter entered his mind.
"I honestly didn't think about until I sat down after the sixth," Stroman said. "I kind of looked up and saw a zero and was like, 'Wow, that's pretty crazy.' I went back out there and ended up letting up the hit to Victorino, and that's just how it kind of played out. It was definitely a fun game."
Catcher Dioner Navarro showered the young pitcher with praise.
"This guy, he's really special," said Navarro, who went 2-for-3 with two walks and a run scored. "He's young, still in the process of learning, and he works hard every day and wants to get better. That's the beauty of it."
Stroman was handed an early lead to work with and didn't look back, as the Blue Jays plated one run in the first, two in the second and another pair in the third off Red Sox starter Rubby De La Rosa to go ahead, 5-0.
Francisco led off the third with a triple, coming around to score on an RBI double from Ryan Goins, and then launched a two-run homer -- his 15th -- in the third to give the Blue Jays a five-run lead. The 27-year-old followed with a bases-loaded two-run single in his third at-bat, giving Toronto a commanding 7-0 advantage. Francisco, looking to become the third player in Blue Jays history to hit for the cycle and first since Jeff Frye in 2001, lined out to left field in his final at-bat. He went 3-for-4 and drove in a season-high four runs.
Melky Cabrera had a big day at the plate, too, going 3-for-4 with a walk, a career-high three doubles and two RBIs. It was Cabrera's fourth three-hit game in his last six contests.
After taking two of three games from Texas, the Blue Jays won three of four against the Red Sox to conclude their seven-game homestand with a 5-2 mark. It marked the first time Toronto has won back-to-back series since May 13-28, when the club reeled off five straight series wins.
"It was a good homestand," Gibbons said. "We have been playing good baseball, getting good, solid pitching and scoring a bunch of runs. Run with it, hang close."
Toronto, which one-hit a team for the first time since Aug. 21, 2011, against Oakland, will begin a three-city, 10-game road trip starting in the Bronx on Friday night.
Chris Toman is a contributor to MLB.com. This story was not subject to the approval of Major League Baseball or its clubs.


text: At RevZilla we are continiually adding new Adventure riding motorcycle gear for your long distance, adventure touring as well as dualsporting needs. We started this business as Adventure motorcycle riders and have always "geeked" out on new motorcycle products, accessories and gear. Check out the most recent additions to the site and all of the new motorcycle gear which could accompany you on your next ride.


text:
Nicole Scherzinger vamped it up for the London X Factor auditions earlier today wearing a racy leather dress.
The judge chose a black trench coat-style dress which featured three-quarter length sleeves, belt and asymmetric zip. Gold detailing set off the frock, which she paired with a red patent peep toe heels.
The Xtra Factor host Caroline Flack gave her a run for her money in the style stakes, arriving at the ExCeL Centre wearing a chic monochrome outfit.
She chose an oversized white blazer with the sleeves rolled up, black shorts and a pair of minimal strappy heels. A slick of bright red lippie and slightly dishevelled hair finished off the look.
Sharon Osbourne, meanwhile, went for a black suit, white shirt and orange pointed heels for the event.
The boys scrubbed up well too, with Gary Barlow opting for a navy blue polo shirt with black jeans, while Louis Walsh went for a shirt and blazer combo.
Take a look at some photos from the X Factor London auditions below.
Nicole Scherzinger
Caroline Flack
Sharon Osbourne
Gary Barlow
Louis Walsh


text:
SVA Undergraduate Catalogue
VISUAL ARTS Press Ltd., New York, New York, 2008
The objective of the School of Visual Arts' undergraduate catalogue, "Proof," is to show prospective students why SVA is the preeminent training ground for the next generations of artists. We want to prove that SVA, located in New York City, is the best art school to attend. Our solution is to present visual and factual evidence, first by giving dozens of facts about New York, SVA and its students, and then by presenting literally hundreds of examples of student work throughout the book, setting a new standard for publications of its kind.
Juror Notes
I was anticipating a much heavier book just before picking it up. The lightness of it was a pleasant surprise. The cover that turns into a poster and the interior both make me want to go to school there.
- Design firm
- VISUAL ARTS Press Ltd.
- Creative director
- Anthony P. Rhodes
- Art director
- Michael J. Walsh
- Designers


text:
Precision trimmer
safely shape, trim or shave unwanted hair anywhere and everywhere. No brow, lip, or bikini line will stand between you and that perfect look with Philips PrecisionPerfect, the ultimate precision trimmer and luxury smart tweezer set.
Precise bikini shaping and gentle bikini trimming with the adjustable length trimming comb.
Precise eyebrow shaping with the precision trimming head (2 trimming lengths)
Additional portable tweezers with light and mirror for the finest precision
Easy and safe removal of facial hairs with the regular trimming head for soft and silky skin.
Cordless battery operated


text:
Vertical Wall Fence Brackets, Set of 2
Item# 40-444
This item is currently not available.
Additional Information
Hang your Vertical Wall Garden on a Fence or Wall
Designed specifically for use with the Vertical Wall Garden, these brackets allow you to hang it on a fence or wall from 1" to 3-1/2" thick. Simple, no-tools installation. Set of 2 brackets.
Product Details
- Powder-coated steel
- Adjustable; fits a fence or wall from 1" to 3-1/2" thick
- Set of 2


text:
Word TrianglesMath brain teasers require computations to solve.
A word triangle is created by taking a word, putting the first letter on the first line, putting two of the second letter on the next line, three of the third letter on the third line, et cetera. Given the word TEASER, the word triangle would look like this:
If you begin at the top and start spelling TEASER by either moving to the letter directly below the letter you are currently on or by moving to the letter that is immediately to the right of the letter below the letter you are currently on, you could use several different paths to spell the word. For instance, if your path takes you to the third 'A' you could either go to the third 'S' or the fourth 'S', but not to the first or second 'S'.
Can you determine how many possible paths there are for this word triangle? How about for word triangles with words of different lengths?
HintThis relates to the work of a famous theologian and mathematician.
Answer2^5 = 32
For any word of given length, L, the number of paths, P, can be found by P = 2^(L-1).
This is essentially Pascal's Triangle. Usually, these are seen as more of a pyramid shape, but since spacing can't be done consistently, the teaser had to limit the paths to either the letter below the current letter or the letter below and to the right of the current letter.
What Next?
See another brain teaser just like this one...
Or, just get a random brain teaser
If you become a registered user you can vote on this brain teaser, keep track of
which ones you have seen, and even make your own.
Back to Top


text:
Training Program
- Dorothy Stubbe, MD: Training Director
- Michael Bloch, MD: Associate Training Director
- James F. Leckman, MD: Deputy Training Director
- Andrés S. Martin, MD: Deputy Training Director
General Description of Clinical and Research Training: PGY-1 through PGY-6
"The parents exist to teach the child, but also they must learn what the child has to teach them; and the child has a very great deal to teach them."
Arnold Bennett
The Integrated Child, Adolescent, and Adult Psychiatry Program is designed to provide the clinical experiences essential for the development of basic knowledge and skills necessary for practice in all sectors of contemporary psychiatry. The specialized objective of the training program is to insure that each resident demonstrates clinical competence in the evaluation and treatment of children and adolescents with psychiatric disturbance, the training and knowledge necessary to succeed in research endeavors, and a commitment to high ethical standards.
Residents are engaged throughout PGY1 - PGY6 in specialized didactics and individualized career guidance meetings. Didactics range from an intensive six week small group seminar in a Developmental Approach to the Assessment of Children and Families to a monthly research seminar with visiting senior faculty, case conferences and reviews of resident research.
Upon completion of the child, adolescent, and adult psychiatry residency at the Yale Child Study Center, each resident is expected to be able to provide competent evaluations and appropriate treatment to children, adolescents and adults with psychiatric disorders, and their families. Additionally, the graduate should be able to provide competent consultation services to a variety of professionals in medical and non-medical disciplines about children and adolescents with psychiatric disorders. And finally, a strong commitment to the treatment of patients and high ethical conduct will have been demonstrated.


text:
Tennessee Titans Business Card Holder
Do you own a small business or work for a company where you use business cards? Well show off who your favorite team is with these Tennessee Titans crystal business cardholders! These are a great way to dress up your desk at home or in the office and can be a great conversation starter between you and your potential clients. These heavy duty cardholders weigh over a pound and re cut from water clear glass and features crisp team graphics that reflect off of the beveled edges of the cardholders to create a striking 3D effect from any angle.
How long will my items take to ship?Most of the items we sell will ship within 1-2 business days from the date ordered. Every item on our website will tell you how long it takes to ship under the availability section when that item.
Once an item leaves the warehouse, Regular Ground shipments will be in transit for 2-5 business days & expedited shipments will be in transit for 1-3 business days.
You can click the "Estimated Delivery Dates" link next to the add to cart button on each product page to get an idea of when your merchandise will arrive to you.
How much does shipping cost?Our shipping charges are automatically calculated by our shopping cart after you enter your shipping information. Our shipping rates are based on the total cost of merchandise in your order:
|Order Amount
|Regular Ground Cost
|Orders Under $10
|Orders $10-$19.99
|Orders $20-49.99
|Orders $50-$74.99
|Orders $75-$99.99
|Orders $100-$149.99
|Orders $150-$199.99
|Orders $200-$299.99
|Orders $300-$399.99
|Orders $400-$499.99
|Orders $500-$599.99
|Orders $600-$699.99
|Orders $700-$799.99
|Orders $800-$899.99
|Orders $900-$999.99
|Orders $1,000 or More
*To obtain the shipping costs to Hawaii, Alaska, APO addresses & also for expedited shipping, please add your items to the shopping cart, enter your shipping address and use our shipping calculator for current rates.
You May Also Like
Regular price: $13.95
Sale price: $10.00
Regular price: $15.95
Sale price: $13.95


text:
Lost Coast Brewery is gaining national recognition.
The Eureka company was named No. 37 out of the top 50 U.S. craft brewing companies for 2013, and No. 48 out of the top 50 overall U.S. brewing companies by the Brewers Association. The list is determined by beer sales volume.
"It feels good to be one of the top echelon breweries in the United States," owner Barbara Groom said, adding that the business has made the list for a few years in a row. "When we get the new brewery built, we hope to move that up into the top 20."
The company is in the middle of expanding to a 9.3-acre parcel located east of South Broadway between Sunset Road and the Ocean View Cemetery.
When the new 55,000-square-foot building is complete, beer lovers will find a brew house from Germany, a bottling line, small store, tasting area, new fermentors and a 120-barrel brew house in the facility. Groom said she hopes to start testing the new equipment at the end of June.
The company produced 70,000 barrels of beer in 2013, she said. The new location will top out at 300,000.
With the ability to quadruple its sales, Groom said the company hopes to start selling to states in the South and on the East Coast.
"We have a lot of places to expand into, but I've kept it at a certain limited number of states so we would not disappoint distributors," Groom said.
The Brewers Association -- a membership-based trade organization that promotes small brewers -- conducts the survey every year. Staff economist Bart Watson said the data is compiled from each business' taxable sales.
"We see this as one of the most effective fiscal tools we can use," Watson said. "Basically, what we're looking for is growth in the industry, growth in the number of barrels. This allows us to get a comprehensive survey of what's going on in the industry."
The craft beer industry grew 18 percent in volume and 20 percent by dollar sales in 2013, according to the association.
"We saw growth across the country at a variety of size points," Watson said. "It's really a great time to be in the craft brewing industry."
Humboldt County Convention and Visitors Bureau Executive Director Tony Smithers said recognition by the Brewers Association increases the county's visibility.
"There are beer tourists out there who go to destinations to check out their favorite brewery," Smithers said. "Lost Coast is definitely in that category."
The attention also will help the existing breweries in the region grow, Eureka Councilman Mike Newman said.
"The economic impact would be to attract more of these microbreweries into the area, and also it will help expand the other ones in the area," Newman said.
Groom said making the list was welcome news.
"It means our beer's popular, and that's gratifying," she said.
Lorna Rodriguez can be reached at 441-0506 or email@example.com. Follow her on Twitter @LornaARodriguez.


text:
Stones Throw Store
Four Tet Remixes
EP Stones Throw STH2102
Description: Usually the only person to remix Madlib records is Madlib. But following the success of MF DOOM & Madlib's album Madvillainy in 2004, our partners in Europe proposed having producers not normally associated with MF or Madlib to remix some of the tracks for Europe-only vinyl releases. These became the Four Tet and Koushik remixes.
Store info: Payment & shipping
Artist page: Madvillain
Listen to samples and buy Individual MP3s
Digital MP3 Downloads: 320 kbps, non-DRM, playable in any mp3 player.


text:
Achieve show stopping eyes with the Japonesque Velvet Touch Shadow, a highly pigmented, super soft eyeshadow that lasts. Formulated with mirco-pearls and minerals for a multi-dimensional look, this silky eyeshadow is also perfect for creating smokey eyes. Available in a range of colours, it comes presented in a unique compact and small mirror for easy application. K.D.
Directions for use:
- Blend and build for maximum versatility using a shadow brush or use a dampened liner brush for intense eye lining.


text:
Safety and Effectiveness of TRIZIVIR (Abacavir/Lamivudine/Zidovudine) With Efavirenz in HIV-Infected Patients Who Have Never Taken Anti-HIV Drugs
The recruitment status of this study is unknown. The completion date has passed and the status has not been verified in more than two years.
Verified March 2002 by NIH AIDS Clinical Trials Information Service.
Recruitment status was: Active, not recruiting
Recruitment status was: Active, not recruiting
Information provided by:
NIH AIDS Clinical Trials Information Service
ClinicalTrials.gov Identifier:
First received: March 2, 2001
Last updated: June 23, 2005
Last verified: March 2002
- Full Text View
- Tabular View
- No Study Results Posted
- Disclaimer
- How to Read a Study Record
Detailed Description:
The purpose of this study is to determine the effect of treatment with Trizivir (TZV) plus efavirenz (EFV) or TZV alone on viral load (level of HIV in the blood).
|HIV Infections
|Drug: Abacavir sulfate, Lamivudine and Zidovudine Drug: Efavirenz
|Phase 4
|Study Type:
|Study Design:
|Primary Purpose: Treatment
|Official Title:
|A Phase IV Multicenter Study of the Efficacy and Safety of 48-Week Induction Treatment With TRIZIVIR (Abacavir 300 Mg/Lamivudine 150 Mg/Zidovudine 300 Mg Combination Tablet BID) With Efavirenz (600 Mg QD) Followed by 48-Week Randomized, Open-Label, Maintenance Treatment With TRIZIVIR With or Without Efavirenz in HIV-1 Infected Antiretroviral Therapy Naive Subjects
Resource links provided by NLM:
MedlinePlus related topics: HIV/AIDS
Drug Information available for: Zidovudine Lamivudine Abacavir Efavirenz Abacavir sulfate TrizivirU.S. FDA Resources
Further study details as provided by NIH AIDS Clinical Trials Information Service:
|Estimated Enrollment:
|Study Start Date:
|February 2001
Patients receive TZV plus EFV in the 48-week Induction Phase. Eligible patients, defined as those with plasma HIV-1 RNA under 50 copies/ml, participate in the 48-week Maintenance Phase. Patients are randomized equally to receive either TZV plus EFV or TZV alone.
An immunology substudy will be conducted, including approximately the first 100 patients enrolled who agree to participate.
|Ages Eligible for Study:
|13 Years and older (Child, Adult, Senior)
|Sexes Eligible for Study:
|Accepts Healthy Volunteers:
Inclusion Criteria
Patients may be eligible for this study if they:
- Are at least 13 years old.
- Are HIV-positive.
- Have a viral load of at least 5,000 copies/ml.
- Agree to use adequate and reliable methods of birth control. Note: Hormonal birth control is not considered adequate.
- Provide written consent of a parent or guardian, if under 18 years of age.
Exclusion Criteria
Patients will not be eligible for this study if they:
- Have taken nonnucleoside reverse transcriptase inhibitors.
- Have taken other anti-HIV drugs for 2 weeks or more.
- Have an opportunistic (AIDS-related) infection.
- Are pregnant or breast-feeding.
- Have had hepatitis within the past 6 months.
- Are allergic to the study drugs or their ingredients.
- Have a mental, physical, or substance abuse disorder.
- Have a serious medical condition, such as diabetes, congestive heart failure, or other heart disease.
- Have a gastrointestinal disorder that affects drug absorption or makes it difficult to take medication by mouth.
- Have received within 4 weeks before study entry, or may require during the study period, radiation therapy, chemotherapy, or drugs that affect the immune system (such as steroid drugs, interleukins, vaccines, or interferons).
- Have received an HIV vaccine within 3 months before study entry, or are scheduled to receive one during the study period.
- Require foscarnet or other drugs that are shown to be effective against HIV.
- Are taking astemizole, cisapride, midazolam, triazolam, or ergot derivatives.
- Are taking experimental drugs.
- Are unlikely to complete the study or take the drugs.
Contacts and Locations
Choosing to participate in a study is an important personal decision. Talk with your doctor and family members or friends about deciding to join a study. To learn more about this study, you or your doctor may contact the study research staff using the Contacts provided below. For general information, see Learn About Clinical Studies.
Please refer to this study by its ClinicalTrials.gov identifier: NCT00011895
Show 42 Study Locations
Please refer to this study by its ClinicalTrials.gov identifier: NCT00011895
Show 42 Study Locations
Sponsors and Collaborators
More Information
Keywords provided by NIH AIDS Clinical Trials Information Service:
Additional relevant MeSH terms:
ClinicalTrials.gov processed this record on September 21, 2017
|ClinicalTrials.gov Identifier:
|NCT00011895 History of Changes
|Other Study ID Numbers:
|Study First Received:
|March 2, 2001
|Last Updated:
|June 23, 2005
Keywords provided by NIH AIDS Clinical Trials Information Service:
Drug Therapy, Combination
Drug Combinations
RNA, Viral
Reverse Transcriptase Inhibitors
Anti-HIV Agents
Viral Load
Additional relevant MeSH terms:
HIV Infections
Lentivirus Infections
Retroviridae Infections
RNA Virus Infections
Virus Diseases
Sexually Transmitted Diseases, Viral
Sexually Transmitted Diseases
Immunologic Deficiency Syndromes
Immune System Diseases
Lamivudine, zidovudine drug combination
Reverse Transcriptase Inhibitors
Nucleic Acid Synthesis Inhibitors
Enzyme Inhibitors
Molecular Mechanisms of Pharmacological Action
Anti-Retroviral Agents
Antiviral Agents
Anti-Infective Agents
Anti-HIV Agents
Cytochrome P-450 CYP2C9 Inhibitors
Cytochrome P-450 Enzyme Inhibitors
Cytochrome P-450 CYP2C19 Inhibitors
Cytochrome P-450 CYP2B6 Inducers
Cytochrome P-450 Enzyme Inducers
Cytochrome P-450 CYP3A Inducers
ClinicalTrials.gov processed this record on September 21, 2017


text:
THE woman killed in a suspicious fire at her flat has been named locally as Sharron McQuarrie as detectives work to establish what caused the blaze.
The 32-year-old former Royal Navy steward was pronounced dead after firefighters pulled her from the third-floor flat she shared with Robert Vaughan at Thorley Court, Abbey Meads, in the early hours of Monday.
Twenty-five year-old Mr Vaughan, better known as Sam, was taken by helicopter to Frenchay Hospital, in Bristol, suffering from burns and the effects of smoke inhalation. He was still in a critical condition last night.
A post-mortem examination by a Home Office pathologist began yesterday and Sharron's next of kin have been informed but police are awaiting formal identification.
More floral tributes were laid just inside the police cordon by friends and people touched by the tragedy.
One note read: "I don't know who you were or why you did not get out in time RIP x. All my thoughts are with your family and friends, stay strong."
Meanwhile, a source close to Sam's family said they hoped he would recover.
He said: "He's a very nice lad, never the kind to get into trouble. "He was always a little bit shy but always pleasant and I just hope he gets better and can recover from the burns and the smoke inhalation."
Last night police said they were still treating Sharron's death as unexplained.
At the building yesterday a detailed search of the surrounding paths, lawn and shrubs for any evidence that could aid the investigation has been completed by police.
Specialist Crime Scene Investigators worked all day inside the flat, assisted by investigators and specialist resources from Wiltshire Fire and Rescue Service.
Residents who spent Monday night with friends and relatives were told they would be able to return to their homes yesterday.
Detective Inspector Matt Davey, of the Brunel major crime investigation team, said: "We have an unexplained death and we have to keep an open mind while we establish the cause of the fire.
"We have been contacted by several potential witnesses who were in the area at the time and we appreciate their co-operation."
Anyone who has information, or was in the area of Thorley Court between 10.30pm on Sunday and 2.30am on Monday is asked to contact Wiltshire Police via 101 or call Crimestoppers on 0800 555 111.


text:
Ever since the start of the 'new era' Saracens, the way in which they go about their team bonding has set them apart from the rest.
From Brighton to the Oktoberfest, Verbier or South Africa, they have set their sights on making memories as well as giving themselves an edge over their opponents.
The latest installment in the adventures of Saracens took them to New York and the team will be hoping their trip to the big apple has the same impact as previous spring outings.
Next stop for the team is Ravenhill, for their Heineken Cup quarter-final challenge against Ulster.
The game is a reverse of last season's fixture in which Saracens ran out 27-16 victors, knocking out arguably form team of the 2012/2013 tournament.
This year the challenge they face is different.
Going to Ireland and winning is no easy task.
You can guarantee that all but a few packed into the stadium will be noisy Irishmen and women willing their side through every ruck, maul, tackle and try.
Most sides would fear the intense pressure they will face but it seems to be something Saracens relish.
Since the change in Saracens fortunes they have conquered some of the most revered fortresses in English rugby.
Their recent record at Welford Road is something Saracens fans would have thought they would only ever dream of while their winning ratio at Frankins Gardens in the last five years isn't bad either.
On the European stage, Saracens have yet to take the step up and win against a fellow knockout stage contender on the road.
However, Saracens have their own Irish weapon in their ranks and if anybody can mastermind a win away in Ireland, it would be Mark McCall.
It is time for Saracens to put their big apple adventure to the test and take on the might of the Ravenhill faithful.


text:
Arm soreness to sideline Andrus for a few days
SURPRISE, Ariz. -- Rangers shortstop Elvis Andrus will be sidelined for a few days with flexor tendinitis in his right arm, assistant general manager Thad Levine said Saturday.
The soreness likely arose from Andrus' arm being overworked early in camp. Wary of Andrus trying to overcompensate, the Rangers decided to hold him out of game action for a brief stint.
Andrus believes the soreness comes as a result of his deciding to skip out on winter ball in the offseason for the first time, meaning it will take a bit more exertion this spring to get his arm back into proper playing shape.
"My elbow and my arm are good to go," Andrus said. "That's not a pain I'll be concerned with now. know the process this year is going to be a little longer. This is the first time for me that I didn't throw a ball in winter ball, so it's going to get longer than in previous years."
Still, Andrus took part in the Rangers' hitting workout and was able to go through a light throwing regimen.
"It's just kind of localized soreness in his forearm," Levine said before Saturday's workout. "We're going to try and knock it out early in camp rather than continue to play him every day and not give him a chance to recover."
Levine did not say how long Andrus will be out. But with the calendar having only just turned to March, Texas will likely be cautious with its 25-year-old shortstop.
Andrus said he began feeling the soreness "a couple days ago," and after an errant throw in Friday's game against Kansas City, the Rangers decided not to take any chances.
"I think he would've liked to have played through it, and I think we took matters out of his own hands and said, 'Listen, let's just try and knock this out,'" Levine said.
In 156 games last season, Andrus posted a .271 average with a .659 OPS and 42 stolen bases.
AJ Cassavell is a reporter for MLB.com. Follow him on Twitter @ajcassavell. This story was not subject to the approval of Major League Baseball or its clubs.


text:
Virtual Press Room 2010
March Meeting Information
The APS March Meeting is the biggest physics meeting of the year. It is a showcase for cutting-edge research results that often lead to new technologies, from electronics and communications breakthroughs to better computers and medical diagnostic products. These technologies, in turn, will shape modern science and culture.
The 2010 March Meeting was held in Portland, Oregon
News Stories from March Meeting Presentations
March Meeting Press Releases
March Meeting Images
Press Releases


text:
No Surrender? What happened to Bound for Glory?
Last edited by Cabers; 10-13-2012 at 03:37 PM.
Last edited by Cabers; 10-13-2012 at 04:27 PM.
Last edited by Amerinaine; 10-14-2012 at 02:24 PM.
The Future of the WWE Women's Division: Brittani Knight AKA Paige!
I wish I was sad and lonely enough to spam hate