article thumbnail

Just Make It Faster

Feld Thoughts

He then dissects a simple SQL query ( DELETE FROM some_table WHERE id = 1234; ) and gives several quick reasons why performance could vary widely when this query is executed. One of our software engineers wrote all the code. This turns out to be especially valuable for performance & optimization work.&#.

article thumbnail

Programmer Competency Matrix

www.starling-software.com

Software Engineering. Can do basic database administration, performance optimization, index optimization, write advanced select queries, able to replace cursor usage with relational sql, understands how data is stored internally, understands how indexes are stored internally, understands how databases can be mirrored, replicated etc.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

A Comprehensive Guide to Web Application Penetration Testing: Features, Importance, and Tips

Women Entrepreneurs Can

SQL injection, Cross-site scripting (XSS), and directory traversal are some of the most prevalent web application flaws that may be exploited. It has protection against SQL injection, cross-site scripting, and other frequent assaults. Penetration testers use a variety of approaches to try to exploit flaws in online applications.

Web 52
article thumbnail

The art of hiring a data scientist

Version One Ventures

When looking for a data scientist, the default approach for many companies is to go after software engineers with a strong interest in statistics, data mining and machine learning. However, drawing math-loving engineers from the tech talent pool isn’t a sustainable strategy. Finding a data scientist is hard.

Hiring 60
article thumbnail

What is Drupal? or, My retraining in Software Development

Scalable Startup

The world has changed – software development, app dev, and software engineering are taking over the center of the conversation, and Drupal/PHP is taking over the lead. In the birthplace of Java, BSD, SQL and many other critical software technologies, Drupal and PHP are spreading like a California wildfire.

article thumbnail

So you say you want to be a Product Manager …?

Austin Startup

there is much value in learning SQL and either Python or R. I learned that software engineers?—?or often referred to as business analytics?—?is is another critical product management skill. In addition to being an expert using Excel or Google Sheets (know your pivot tables!), or developers?—?are

article thumbnail

CEO Friday: Why we don’t hire.NET programmers

blog.expensify.com

If someone comes to you with Ruby on Rails experience, do you assume they are ignorant of SQL? I learned C# and.NET (along with HTML/CSS/JS/SQL/etc) because that’s what they used. I’ll put my MVC/C#/SQL Server against your LAMP any day. It is clear that good software engineers avoid you. Matt Sherman.

Java 107