Apr 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Enumerations in Relational Database – Best Practice

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, Database, DBA, Software Development, SQL Documentation
Marko Parkkola This article has been submitted by Marko Parkkola, Data systems designer at Saarionen Oy, Finland. Marko is excellent developer and always thinking at next level. You can read his earlier comment which created very interesting discussion here: SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1…
Read More

SQL SERVER – Differences in Vulnerability between Oracle and SQL Server

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Business Intelligence, Database, DBA, MySQL, Oracle, SQL Documentation, SQL Download
In the IT world, but not among experienced DBAs, there has been a long-standing myth that the Oracle database platform is more stable and more secure than SQL Server from Microsoft. This is due to a variety of reasons; but in my opinion, the main ones are listed below: A.…
Read More