Browse DevX
Sign up for e-mail newsletters from DevX


More articles by Hannes Du Preez

For DevX | November 14, 2019
See how to use the Object Explorer feature in SQL to find a particular stored procedure from a long list of available options.
For DevX | November 7, 2019
When dealing with large lists of information, we, as developers, sometimes need to copy them, then add commas manually. See a neat trick to automatically add the required commas.
For DevX | October 31, 2019
See how to find a specific data type across all tables and columns in a database.
For DevX | October 17, 2019
Follow these three tips to help improve your SQL query performance.
For DevX | October 10, 2019
See how to construct a query that can generate dynamic LIKE statements in SQL.
For DevX | October 4, 2019
Follow these three tips to help increase the performance of your SQL queries.
For DevX | September 25, 2019
See what the Top with Ties clause actually does in SQL.
For DevX | September 18, 2019
Learn more about how to use three very different SQL statements.
For DevX | September 11, 2019
Learn more about the levels of data abstraction employed in SQL to hide irrelevant details from users.
For DevX | September 4, 2019
Explore to how to safely delete data in SQL.
For DevX | August 28, 2019
Explore a list of the names of all normalization forms in SQL.
For DevX | August 21, 2019
Explore some of the reasons why your query performance might not be up to expected speed.
For DevX | August 14, 2019
Get an overview of the index types available in SQL.
For DevX | August 7, 2019
Learn more about three ways in which you can easily limit your query results.
For DevX | July 29, 2019
See why you should avoid prefixing your Stored Procedure names with sp_.
Thanks for your registration, follow us on our social networks to keep up-to-date