by XTIVIA | Mar 29, 2023 | Azure, Blog, Database
Top 10 Things to Investigate for Optimum Azure SQL Performance: 1. Query Optimization 2. Index Fragmentation 3. Resource Constraints 4. Blocking and Deadlocks 5. Network Latency 6. Insufficient Memory 7. Storage Latency 8. Outdated & Duplicated Statistics 9....
by XTIVIA | Mar 14, 2023 | Blog, Database
As a database administrator (DBA), maintaining the security of your organization’s data is one of your most important responsibilities. Unfortunately, data breaches and other security incidents are too common in today’s digital age, and the consequences...
by XTIVIA | Mar 7, 2023 | Blog, Database
What Is Zero Trust Security? Zero Trust security is a high-standard security model designed to address today’s cyber concerns. This model focuses on verifying the identity of users and devices before granting access to sensitive data and systems rather than...
by XTIVIA | Nov 16, 2022 | Blog, SQL Server
With the release of SQL Server 2022 for mainstream, we checked in with our DBAs to see what they are most excited about in the new version. We have all been waiting patiently for this release and are really happy to see it drop for mainstream support. Parameter...
by XTIVIA | Apr 12, 2021 | Blog, Oracle
The Oracle error ORA-04031: unable to allocate nn bytes of shared memory is telling us that Oracle tried to allocate a specific amount of memory for a process and it was unable to do so. I see this more often with legacy or very large and complex ETL processes. The...
by XTIVIA | Mar 25, 2021 | Blog, Oracle
This post has been updated from the original content here. When getting an ORA-12560 for an Oracle database on windows, there are a couple of things we should check before doing anything else. The error is telling us that we are trying to connect to the wrong...