SQL

PL/SQL

� SQL

Transact-sql

1-20 of 241 Previous Next
What Is Data Integrity? by Hannes du Preez Language: SQL, Expertise: Intermediate: Explore what the term data integrity really means.
Finding Object Dependencies in SQL by Hannes du Preez Language: SQL, Expertise: Intermediate: Choose one of these three SQL queries that will return all the database objects that depend on it.
T-SQL Performance Tip: Stored Procedure Names by Hannes du Preez Language: SQL, Expertise: Beginner - See why you should avoid prefixing your Stored Procedure names with sp_.
Recompile a Stored Procedure by Hannes Du Preez Language: SQL, Expertise: Intermediate - Learn how to recompile certain stored procedures.
Using DBCC SHRINKDATABASE by Hannes du Preez Language: SQL, Expertise: Intermediate: See how to easily shrink the size of the data and log files in a database.
Find Error Log Location by Hannes du Preez Language: SQL, Expertise: Intermediate: Learn an easy way to find where your error logs are being stored.
SQL Injection Tips, Part 3 by Hannes du Preez Language: SQL, Expertise: Intermediate: SQL injection is probably the most common hacking technique out there. Learn more about hacking techniques to keep your data secure.
Get the First Day of the Current Month by Hannes du Preez Language: SQL, Expertise: Beginner - Learn how to find the first date of the current month.
Get All the Tables with a Count of Their Records by Hannes du Preez Language: SQL, Expertise: Intermediate - Use this query to get all the tables with a count of their records.
SQL Injection Tips, Part 2 by Hannes du Preez Language: SQL, Expertise: Intermediate: Learn more about how to avoid issues with SQL injection.
SQL Injection Tips, Part 1 by Hannes du Preez Language: SQL, Expertise: Intermediate: Learn more about how to avoid SQL injection issues.
Read All SQL Server Log Files by Hannes du Preez Language: SQL, Expertise: Intermediate - Learn a script that allows you to read through all SQL Server Log files.
SQL Statistic Tests to Look Into by Hannes du Preez Language: SQL, Expertise: Beginner: Check out these six tests if you want to explore statistics in SQL.
How to Set hibernate.format_sql in a Spring Boot Application by Octavia Anghel Language: Java, Expertise: Intermediate: See how to format the SQL statements for a Spring Boot application.
Working with Multiple Query Windows by Hannes du Preez Language: SQL, Expertise: Beginner - Learn the best ways to work with multiple query windows in SQL.
Selecting All Columns, Separated with Commas by Hannes du Preez Language: SQL, Expertise: Beginner - See how to get a nicely comma-separated list of column names.
How to Pass Parameters in @Query by Octavia Anghel Language: Java, Expertise: Intermediate - Learn how to pass parameters to an SQL query written with @Query via @Param or positional parameters.
Object Explorer Details by Hannes du Preez Language: SQL, Expertise: Beginner - See how to use the Object Explorer feature in SQL to find a particular stored procedure from a long list of available options.
Using Multi Edit Mode by Hannes du Preez Language: SQL, Expertise: Beginner - 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.
Get All Columns in All Tables of a Specific Data Type by Hannes du Preez Language: SQL, Expertise: Beginner - See how to find a specific data type across all tables and columns in a database.
1-20 of 241 Previous Next