Databases
StackOverflow2013
Usersdbo
USPatrick
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USPatrick
    primarykey
    data
    text
    <p>I take pride in writing elegant, readable, performant code for a wide variety of use-cases, and am looking for a position as a software engineer that will help me continue to refine and grow these abilities.</p> <p>I have over 20 years of development experience and am currently working with the latest web development technologies to develop cutting-edge internet experiences. I have worked with the Microsoft .Net Framework since beta in 2000, on both the client-side and server-side. I have worked extensively with object-oriented code bases in C# and VB.Net, including WinForms and ASP.Net (WebForms and MVC). I am familiar with ORM frameworks such as Entity Framework, as well as patterns such as IoC/DI, mocking, and unit testing. I am familiar with both the full .Net Framework as well as .Net Core and the .Net Standard concept.</p> <p>I’m am familiar with the latest client-side web technologies including HTML5, JavaScript, jQuery, and Bootstrap, I also have extensive experience with the entire stack, such Microsoft Azure, SOAP XML and REST services, Web API, and JSON. </p> <p>I have over 15 years of Microsoft SQL Server work, including complex T-SQL, advanced debugging, enterprise-scale relational database architecture, complex query plan optimization, terabyte-scale databases, geolocation, and SQL Azure.</p> <p>I am experienced with version control systems including Team Foundation Server and Git, including tagging, branching, merging, and resolving conflicts, and with fundamental Object Oriented Design Patterns.</p> <p>I have been heavily involved in the build and release process for large, complex projects, including ensuring correct source migration and resolving complex build and deployment issues. As a project lead, I have been involved in code reviews, employee hiring and performance reviews, and overall team performance to meet all of the client’s needs on time and on budget.</p>
    plurals
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTTagWikiExerpt
    3. PO
      singulars
      1. PTTagWikiExerpt
    1. POT-SQL query - GROUP BY issue
      singulars
      1. PTQuestion
    2. PORebuilding large SQL indexes isn't changing the fragmentation percentage
      singulars
      1. PTQuestion
    3. POSQL 2005 - Query to Find Tables with Most Rows
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. COYou can use the OleDbCommandBuilder class to generate INSERT/UPDATE/DELETE statements automatically based off of your SelectCommand.
      singulars
      1. PO
      1. USPatrick
    2. COThis may help? [remove red rectangle around combobox](http://stackoverflow.com/questions/4135955/remove-red-rectangle-around-combobox)
      singulars
      1. POMysterious red border appears around ComboBox
      1. USPatrick
    3. COThink of a situation where you have two procs, A and B, both which begin a transaction. If you call A, which calls B, then the transaction is ignored in B because it was started in A. If you call B directly, it is not ignored.
      singulars
      1. PO
      1. USPatrick
 

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