Databases
StackOverflow2013
Usersdbo
USammills01
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USammills01
    primarykey
    data
    text
    <p>I have degree in Computer Science with an emphasis on programming. My passion lies in providing solutions to business problems, which doesn't always result in a technological solution. However, when it does, I frequently manage the entire SDLC. For me, doing the research behind a problem, understanding the users needs, and designing an elegant solution is just as rewarding as actually building out that solution.</p> <p>I have been doing business application development as a career since 2010. At the beginning of my career I focused purely on SQL development, creating new procs, view, triggers, tables, etc... I've also done quite a bit of data mining, data imports, SSIS, and reporting work (Excel and SSRS). This SQL experience also allowed me to become a DBA for my development group, reviewing and approving most DB changes before going to production. After grasping DB architecture fairly well I moved into application development, where I worked with a team to create new solutions and manage a variety of legacy ones. I've worked mostly with web applications and web services, both traditional and WCF, however I have built console and desktop apps as well.</p> <p>Technologies and applications I've worked with, in no particular order, include: C#.NET, VB.NET, XML, JSON, PHP, JavaScript, HTML, CSS (bootstrap), TSQL, PostgreSQL, Azure (SQL, Storage, CDN, Redis, VM's, and Web Apps), AWS (RSD - PostgreSQL, EC2 - Linux VM's, Elastic Load Balancer, and Elastic IP), SSRS, Tableau, Excel (PowerPivot and PowerMap), SharePoint, LINQ, MVC5, Entity Framework, Angular, DI (Ninject), Owin, Redis (Windows version, built out a cluster managed by Sentinel), SignalR (Redis backplane), Linux, Spark, Spark Streaming, Java, Scala, Eclipse IDE, IntelliJ IDE, Kafka, Zookeeper, Cassandra, Ambari, YARN, and HDFS.</p>
    plurals
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. POC# - Passing DataTable vs. SqlDataReader
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COThat is strange and I don't have any other ideas off the top of my head outside of it being an order of operations issues. This thread might help: http://stackoverflow.com/questions/7883985/ajax-accordion-issues-in-firefox-chrome
      singulars
      1. POWhy doesn't my code to expand all panes in an AjaxControlToolkit Accordion work in Firefox?
      1. USammills01
    2. COCheck to see what CSS is being applied to the content of the panels. It is possible that the Accordion CSS is being applied then any default CSS you have set on the content is being applied, causing it to be hidden.
      singulars
      1. POWhy doesn't my code to expand all panes in an AjaxControlToolkit Accordion work in Firefox?
      1. USammills01
    3. COThis might sound silly but make sure that you have 'using System.Linq;' in place before trying to write this statement. I was able to write all of the Linq stuff without it complaining however when I tried to do the implicit cast (from GridViewRow msgRow) the compiler complained about not have a definition for 'Cast' in the GridViewRowCollection and nothing in Intelli-sense told me that I needed a using.
      singulars
      1. PO
      1. USammills01
 

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