Browse DevX
Sign up for e-mail newsletters from DevX


More articles by Hannes Du Preez

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_.
For DevX | July 22, 2019
Learn the difference between using not in and not exists in T-SQL.
For DevX | July 15, 2019
Learn more about why you should use explicit column names in T-SQL.
For DevX | July 8, 2019
Learn more about how to improve query performance by including owner or schema name.
For DevX | July 1, 2019
Learn more about what happens in the SQL Server query optimizer when Forceplan is set to on.
For DevX | June 24, 2019
Learn how to control whether error messages will be returned from overflow or divide-by-zero errors occurring during a query.
For DevX | June 17, 2019
See several math functions that can be used in T-SQL.
For DevX | June 10, 2019
See how to specify how long a statement should wait for a lock to be released.
Thanks for your registration, follow us on our social networks to keep up-to-date