5 Things You Didn’t Know About SQL Agent
Many DBAs use jobs running inside the SQL Server SQL Agent to perform routine tasks such as backups, updating statistics, and rebuilding indexes as needed. Learn 5 key things about SQL Agent.
Read MoreMost Popular
What happens if I shrink a database in Windows Azure?
Learn what SQL Server database fragmentation looks like for databases running on Windows Azure.
Read MoreEfficiently Calculate Running Sums in SQL Server 2012
Learn the options available in SQL Server 2012 to calculate running sums and evaluate the performance metrics of each.
Read MoreNew Security Features in Oracle Database 12cR1
Three new sets of user privileges in Oracle 12c can dramatically reduce the need for the SYSDBA privilege for day-to-day DBA administrative activities. Learn more.
Read MoreAbout SQL Server Extended Events Targets
Learn more about SQL Server Extended Events targets, and which targets are best suited for different purposes.
Read MoreWhy and When You Should Use SQL Server Extended Events
Learn three primary reasons why you should use SQL Server Extended Events, and some ideal use cases.
Read MoreImprove SQL Server Performance by Looking at Plan Cache (Part 3)
Starting in SQL Server 2008, you can examine the plan cache to quickly identify plans that are similar and may be optimized. Learn how.
Read MoreImprove SQL Server Performance by Looking at Plan Cache (Part 2)
Examining the SQL Server plan cache can help you to quickly identify plans that need tuning, including: plans that have missing indexes, plans that are performing key lookup and plans with implicit conversion warnings.
Read MoreImprove SQL Server Performance by Looking at Plan Cache (Part 1)
The SQL Server plan cache stores details on statements that are being executed over time, and you can use it to investigate performance issues and look for opportunities to improve performance. Learn how.
Read MoreAbout the Oracle Grid Control Architecture
Oracle Grid Control 11g Release 1 comprises three components: the Oracle Management Service (OMS), the Oracle Management Repository, and the Oracle Management Agent. Learn more.
Read MoreWhat is Oracle Grid Control?
Oracle Enterprise Manager (OEM) Grid Control 11g enables centralized administration and monitoring of “the grid” with end-to-end monitoring and administration of the Oracle Database, Oracle Clusterware and more.
Read MoreEnhance Availability with Oracle Fast Application Notification and Role-based Services
In Oracle 11gR2, the Oracle Data Guard Broker publishes Fast Application Notification (FAN) events (via Oracle Notification Service, or ONS), allowing for clients to be notified in the event of a failover. Learn more.
Read More