sql

  1. Project_Balance

    Data Modeler and ETL Developer - Work from home

    Based in Austin, TX, Project Balance is a consulting firm specializing in web applications, data warehousing and data visualizations. Project Balance is growing and we are looking for a skilled and creative full stack .Net developer that can work well with a distributed team. Start Date...
  2. Mike Rockétt

    Experienced Laravel+Vue developer wanted

    Megafreight, a leading freight forwarding and customs clearing company in South Africa, is seeking an experienced full-stack software developer to join our team, responsible for designing, building, and maintaining a new cloud-based platform that aims to re-imagine the role of technology in the...
  3. OkPlankton

    T-SQL Help; CASE Statement and GROUP BY

    Hey SQL Guru's :) I'm stuck on something that may be very simple but can't wrap my head around it. I have a few columns with a GROUP BY and a simple join. I also have one aggregration column; [No of Employees] SELECT H.CALL_CENTER AS [Site], H.TEAM_LEAD_NAME...
  4. H

    Wordpress site gives a 404 when attempting to log into back end

    Afrihost hosting. The site itself works fine. Initially I got an "error establishing connection to database", I changed the SQL user password and updated the wp-config.php file, then I got a 404. Any idea what I'm missing? Actual noob here.
  5. E

    Building a datascience bootcamp for Africa

    Over the last couple of months I have been enrolled in an international data-science bootcamp. Having had a keen interest in the field for quite some time, while I have found the opportunity great, I have noticed a lot of flaws in how some bootcamps seem to operate. For starters, 6 months is...
  6. Thor

    MySQL Questions

    Just a general thread for questions related to MySQL. Here is my question, when should one use stored procedures? I use PHP with PDO and almost always have a dynamic where clause, is it wrong to use prepared statements throughout the app instead of stored procedures, how do you even make use...
  7. RedViking

    What SMMEs can learn from SA’s biggest data leak

    Read ful larticle here: http://www.htxt.co.za/2017/11/03/what-smmes-can-learn-from-sas-biggest-data-leak/
  8. M

    MS SQL Certification

    Hi folks Some advice please. I'm interested in up-skilling with a SQL certification or the like. I'm in a role that borders Finance and IT, whereby I need to pull data from SQL tables. I need to improve my SQL skills to the point that I can create tables, query data etc. Fundamental...
  9. ChantalMichelle

    Analysts / Developers - JHB and Cape Town options

    Junior Systems Analyst (JHB), Mid Level Systems Analyst (JHB), Senior Systems Analyst (JHB), Team Lead (JHB), Junior Developer (JHB), Mid Level Developer (JHB), Junior Developer (Cape Town), Mid Level Developer (Cape Town), Junior Systems Analyst (Cape Town), Product Owners Assistant/Junior...
  10. V

    SQL Help - Review Required, Is my solution sound?

    ID SCHOOL Grade Student Status TUT sYear Active 2 NH ONE DAN 1 2017 TRUE 3 NH ONE JON 1 12017 2017 TRUE 4 NH ONE MAY 1 2017 TRUE 5 SC TWO PAM 4 22010 2016 FALSE 6 SC TWO PAT 2 22010 2017 TRUE 7 SC TWO FAF 5 22010 2010 FALSE 8 SC TWO RON 3 2017 TRUE 9 SC THREE SAM 6 2017 TRUE 10 SC...
  11. Project_Balance

    Freelance web application developer - .Net MVC

    This is an opportunity for a freelance consultant to work with a small but dynamic US-based company. We work in a casual and supportive work environment. We are looking for talented freelance software developers based in South Africa. Start Date: ASAP Hours: Contract, full time opportunity (40...
  12. S

    Cape Town IT jobs

    Cape Town opportunities - Apply [email protected] www.studio29.co.za
  13. V

    Sql Server Date processing overhead / best practices

    Hi, I am querying a SQL server database with over 500 000 records every 2 to 5 minutes and the query i plan to execute is "SELECT MAX(actual_date) AS Max_unit_id FROM dbo.trackingTable Where (tracking_area_Id=12) and ( product_id in " & Res & ")" I am using the IN statement in the query...
  14. Tag11

    Microsoft server software

    I'm urgently looking for EOL or older (cheaper) Microsoft server software. If you happen to have any of these lying around or you know that perhaps your company/employer might have these and upgraded or for whatever reason isn't using them anymore, please could you let me know! Microsoft...
  15. bchip

    Certification

    Hi Guys Hoping for a bit of guidance here on this. Im looking to get certifications for SQL. Which ones would you recommend? How much do they cost? It all seems a bit confusing as on the Micro$oft website there are prices for 12 different courses @ R7,500 (excl VAT) and the on Groupon...
  16. D

    Full Stack Developer - dHub

    Overview Full stack developers will have a range of responsibilities from shaping and implementing strategic products to ensuring that Liberty stays on the leading edge of technology Our Full stack developers contribute across the technology stack, from database and DevOps infrastructure that...
  17. A

    JOB: Ruby on Rails Developer Needed (Sandton)

    ANVIL PropertySmith is a cutting edge commercial & industrial property services company. Using disruptive technology to rapidly gain market share. ANVIL PropertySmith presents a unique opportunity for a coder who wishes to learn about the Commercial & Industrial Property Industry. Working in a...
  18. A

    Ruby on Rails Developer Needed

    ANVIL PropertySmith is a cutting edge commercial & industrial property services company. Using disruptive technology to rapidly gain market share. ANVIL PropertySmith presents a unique opportunity for a coder who wishes to learn about the Commercial & Industrial Property Industry. Working in a...
  19. F

    BI Developers (Microsoft Stack)

    The Company A well established South African owned company is searching for BI Developers to join their Team. At present the team is 8 developers strong and due to demand the company would like to double the size of the team by the end of 2016. Basic Information You will be...
  20. ChantalMichelle

    Recent Graduate - Development and Analysis options - JHB / Cape Town

    JHB options: - Junior Systems Analyst./University Graduate: - Technologies: - .Net, C#, SQL, Oracle Responsibilities: - Hands-on implementer that will be configuring and supporting client solutions. IT-sense (strong on database) with an interest in application design/implementation and the...
Top
Sign up to the MyBroadband newsletter