Knowing the rules that guide code development—known as syntax—are important in a new project.
Project syntax is commonly covered in code reviews, but before reaching that stage, it is essential for the team to follow certain rules and conventions.
For the purposes of our discussion, we will address SQL, since this programming language is both specifically designed and commonly used for managing data in a relational database management system.
The project syntax is part of a triumvirate, with procedure and structure, forming a project’s foundation.
If you were not able to attend Chuck Ezell’s IOUG Webinar on Performing Oracle Health Checks using APEX, you can still learn a lot from his presentation slides. Datavail has just made Chuck’s presentation available online. Here are some of the highlights:
Proactive vs. Reactive
Too much DBA time is spent repairing problems instead of creating positive outcomes. We need to go beyond “preparedness” and “emergency response.” We need to manage databases proactively.
Proactivity is more than just having…
We frequently encounter developers who love to use cursors throughout their code, but these are an impediment to SQL database performance.
You really don’t need cursors in your code. Here’s why.
A cursor is typically used in databases to identify a record location. As Techopedia explains, when a file is open, a cursor, “points to the first record in the file, and using various commands the cursor can move to any location within the file.”
This uses memory. Although the amount of memory…
It’s 2015 and you can now establish totally respectable MS SQL DBA credibility just by mentioning you have been in the game since SQL Server version 9. You may even get the same gasps of shock from some colleagues that used to be reserved for the version 6 veterans. It’s true – SQL 2005 is 10 years old and if you’ve been working with SQL Server that long it’s likely you’re a seasoned pro. However unlike DBAs, a given SQL version does not get…