1-20 of 234
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 234
Previous
Next |