sql

  1. 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...
  2. 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/
  3. 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...
  4. C

    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...
  5. 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...
  6. 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...
  7. S

    Cape Town IT jobs

    Cape Town opportunities - Apply hiring@studio29.co.za www.studio29.co.za
  8. 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...
  9. T

    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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. C

    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...
  16. C

    C# Development options - JHB (University Graduates / Developers / Systems Analysts)

    Our client is a financial software solutions provider offering customised software and technical solutions to businesses. With a comprehensive range of products and solutions as well as extensive experience with the automation and integration of business processes and systems, we create software...
  17. T

    2nd Line Support Consultant

    The candidate will be required to fulfil and uphold the company values of personalised, high quality service by finding solutions to problems that users are experiencing. The candidate will become part of a young and dynamic team of technology enthusiasts. The candidate will be offered an...
  18. R

    C#/.Net Developer - Cape Town (Northern Suburbs)

    Based in the Northern Suburbs of the Western Cape, Capfin is the South African brand of the global Southern View Finance group of companies. We offer technologically-driven, cost effective and accessible financial services products and solutions to South Africans. We offer dynamic careers for...
  19. D

    Microsoft MCSA 70-461: Querying Microsoft SQL Server 2012 self study ?

    With my MTA: Database Fundamentals done and dusted I am looking for the next step to become a MCSE. So I have 3 courses / exams to complete. The cost of all 3 courses is around R 23 000. The cost of only the exams is around R 3000. So self study is looking like a good option to me. The first...
  20. D

    Microsoft MTA 98-364 Databse Fundamentals Exam

    Hey guys, so I am going to write the MTA 98-364 Database Fundamentals next week (18-02-2016) and I was wondering who did this course in the last couple of days / weeks / months to give me some pointers on how it is structured and what to expect. I have worked through the MVA (Microsoft Virtual...
Top