Databases
StackOverflow2013
Usersdbo
USDavid Schwartz
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USDavid Schwartz
    primarykey
    data
    text
    <p>I am a <em>software engineer</em> with a focus on <em>Microsoft platforms and technologies</em>, including a decade of experience leveraging the <strong><a href="http://msdn.microsoft.com/en-us/library/z1zx9t92.aspx" rel="nofollow noreferrer">C# programming language</a></strong> and the <strong><a href="http://msdn.microsoft.com/en-us/library/zw4w595w.aspx" rel="nofollow noreferrer">.NET Framework</a></strong> to build a wide variety of client and <a href="http://msdn.microsoft.com/en-us/library/d56de412(v=vs.110).aspx" rel="nofollow noreferrer">server applications</a> for the <em>Retail</em>, <em>Cloud Services</em>, and <em>Insurance</em> industries. </p> <p>The majority of my career has been <a href="http://msdn.microsoft.com/en-us/library/bb400852(v=vs.110).aspx" rel="nofollow noreferrer">web applications</a> and <a href="http://msdn.microsoft.com/en-us/library/dd456779(v=vs.110).aspx" rel="nofollow noreferrer">services</a> using <strong><a href="http://www.asp.net/mvc" rel="nofollow noreferrer">ASP.NET MVC</a></strong> (<em>incl.</em> <strong><a href="http://www.asp.net/web-api" rel="nofollow noreferrer">Web API</a></strong>) and <strong><a href="http://msdn.microsoft.com/en-us/library/dd456779.aspx" rel="nofollow noreferrer">Windows Communication Foundation</a></strong> (WCF) in <a href="http://msdn.microsoft.com/en-us/library/e80y5yhx(v=vs.110).aspx" rel="nofollow noreferrer">tandem</a> with database technologies such as <strong>Microsoft SQL Server</strong>, <strong>MongoDB</strong>, and <strong>Apache Solr</strong> (Lucene). I also spent several years working with less common .NET technologies such as legacy <strong><a href="http://msdn.microsoft.com/en-us/library/96bef039(v=vs.110).aspx" rel="nofollow noreferrer">Windows Forms</a></strong>, current-generation <strong><a href="http://msdn.microsoft.com/en-us/library/ms754130(v=vs.110).aspx" rel="nofollow noreferrer">Windows Presentation Foundation</a></strong> (WPF), and the <strong><a href="http://msdn.microsoft.com/en-us/library/cc838158(VS.96).aspx" rel="nofollow noreferrer">Silverlight</a></strong> browser plugin.</p> <p>I am especially interested in the .NET Framework's <a href="http://msdn.microsoft.com/en-us/library/hh156536(v=vs.110).aspx" rel="nofollow noreferrer">unique performance characteristics</a>, due to factors like <a href="http://msdn.microsoft.com/en-us/library/f144e03t(v=vs.110).aspx" rel="nofollow noreferrer">automatic memory management</a>, <a href="http://msdn.microsoft.com/en-us/library/zcx1eb1e(v=vs.110).aspx" rel="nofollow noreferrer">type safety</a>, and <a href="http://msdn.microsoft.com/en-us/library/8a3x2b7f(v=vs.110).aspx" rel="nofollow noreferrer">reliability guarantees</a>; further, I study practical high-performance design techniques such as <a href="http://msdn.microsoft.com/en-us/library/hh156548(v=vs.110).aspx" rel="nofollow noreferrer">parallelization</a> and <a href="http://msdn.microsoft.com/en-us/library/dd997357(v=vs.110).aspx" rel="nofollow noreferrer">caching</a>. Historically, developers have been able to ignore performance, but the advent of the cloud has changed things. Often, leveraging the cloud means taking a given task and breaking it into sub-tasks that can be processed at different speeds organically. That division of labor necessitates a better understanding of any given operation's cost. As a result, I find that my performance expertise is getting called upon more and more by my employer.</p>
    plurals
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCode contracts build reference assembly actions
      1. USDavid Schwartz
      1. VTFavorite
    2. VO
      singulars
      1. POMicrosoft Roslyn vs. CodeDom
      1. USDavid Schwartz
      1. VTFavorite
    3. VO
      singulars
      1. POGeneric logging of function parameters in exception handling
      1. USDavid Schwartz
      1. VTFavorite
    1. CO@Scott Agreed, esp. because redrawing the UI is so slow. I am probably not going to update the example code, however, because it's pretty verbose already and every added line makes it more difficult to digest. In some situations, it may be desirable that setting the property (even if the value didn't change) cause a refresh. Not exactly how it was meant to be used, but I've seen it before. As a nit of my own, I would not use `Object.Equals` because we know the type, so `EqualityComparer<T>.Default.Equals(backingValue, value)` would be a better choice.
      singulars
      1. PO
      1. USDavid Schwartz
    2. COI haven't tested this myself, but assuming that environment variables are only reset when you sign-out and -in again, I think you can use a different `REG` command to retrieve it. Yeah, it's ugly as can be, but if it's your only option, take a look at [this answer](http://stackoverflow.com/a/3214966/399124) which explains how to get a specific value in an arbitrary registry key, and getting an environment variable should be easier.
      singulars
      1. PO
      1. USDavid Schwartz
    3. CO@Jon You're probably referring to [this page](http://eternallyconfuzzled.com/tuts/algorithms/jsw_tut_hashing.aspx), which you mentioned in [this answer](http://stackoverflow.com/a/263416/399124).
      singulars
      1. PO
      1. USDavid Schwartz
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload