Upgrades happen. Sometimes because business needs dictate them. Sometimes because IT requirements force them. Whether the SQL Server upgrade is just a patch or a full on major upgrade, the risk involved can strike fear into the heart of the database team. The fear even causes some to hold off on upgrades, which can deprive […]
Read More
Working with SQL Server is always a challenge. As developers try to troubleshoot SQL Server performance problems, the first step that take is to look at the queries. This is the most basic step and most important step for most developers. Developers love these challenges of optimization because they can get the maximum visible performance improvements in their […]
Read More
Keep a watchful eye on two key configuration parameters to maintain consistent performance. Server virtualization for Oracle databases is here–and it works, so it will be staying. As database administrators, we must adapt to the new architecture, while ensuring database performance and resiliency. A recent client problem involving a handful of critical applications revealed two […]
Read More
Cloud is the next buzz word in the industry. If we were to quiz any CIO on what are some of the big bets they want to make in the next 6-12 months–using cloud will surely be one of them. Why has this new concept has caught on like forest fire? Why are organizations exploring […]
Read More
TNS:could not resolve service name This error, seen as ORA-12154, means SQL*Net could not find the database alias specified for a database connection in the TNSNAMES.ORA file or other naming adapter. The database alias is specified after the “@” character in a database connection string. For example, if the connect string “SYSTEM/MANAGER@PROD” is used, “PROD” […]
Read More
Learn about Oracle database maintenance, including best practices recommended by Oracle ACE and performance experts.
Read More
Learn what SQL Server experts know about database maintenance, including how and when to use plans or scripts, and the importance of a robust recovery strategy.
Read More
Learn from Oracle experts about the myths and realities of what causes poor Oracle database performance and tips for improving it.
Read More
SQL Server and database experts share insights on features of SQL Server 2014 that promise significant performance potential.
Read More
SQL Server and database experts share insights on how to assess performance issues, including closely examining wait types to determine root cause.
Read More
SQL Server and database experts share insights on how hardware does and does not impact performance.
Read More
Learn how to check query performance to see if partitioned tables have made SQL Server faster.
Read More