Useful tips for everyday
How do I fix no matching authentication protocol? In this tool, I used ojdbc14. jar to connect a 12c database, the error is the same,…
How do I duplicate a row in a table in SQL? How to Find Duplicate Values in SQL Using the GROUP BY clause to group…
Is linked server faster than SSIS? SSIS is typically faster using BULK INSERTS and has better security benefits. Linked Servers can create disaster recovery issues…
Can a table name start with number? A name must start with a letter or an underscore; the rest of the string can contain letters,…
What is the error code for MySQL error 1064? Resolve MySQL ERROR 1064 (42000): You have an error in your syntax? ERROR 1064 (42000): You…
Where I can see my pending friend requests that I have sent to others? Open Facebook and head to the “Friends” section. You can find…
Why does SQL Developer not show tables? The answer is simple – you can’t see any tables, because you don’t OWN any tables. In this…
Why should you split an Access database? Consider splitting any database that several people share over a network. Splitting a shared database can help improve…
How to find difference in columns in SQL Server? In this article we demonstrated that using SQL Server meta-data from INFORMATION_SCHEMA.COLUMNS view we can easily…
Can a database be audited without a trigger? As many of you have experienced, triggers can create issues with maintainability and performance. Therefore, Database Audit…