by XTIVIA | Sep 19, 2013 | Blog, Business Intelligence
Combining different chart types and adding a secondary vertical axis in SSRS can enhance data visualization significantly. This guide explains how to achieve these features, focusing on the steps to implement a client-side solution for creating complex charts. By...
by XTIVIA | Jul 30, 2013 | Blog, Databases
In recent times, database migrations have become a way of life for most database administrators. Whether moving to new hardware or into the world of virtual machines, what once was a rare project is becoming an almost everyday concern for database environments...
by Derek Nerenberg | Jul 12, 2013 | Blog, Databases, Enterprise Java, Portals
Set the transaction isolation level to READ_COMMITTED with READ_COMMITTED_SNAPSHOT turned ON. Yay! When I mention the words “transaction isolation level” to SQL Server DBAs, the first words out of their mouths are almost always “READ...
by XTIVIA | Jun 26, 2013 | Blog, Databases
At XTIVIA, we often perform health checks and performance tuning for clients that have issues with the CPU utilization or memory usage periodically maxing out in the middle of production by the execution of a job or report that consumes much of the available resources...
by XTIVIA | Mar 27, 2013 | Blog, Databases
Error: 9002, Severity: 17, State: 2 The transaction log for database ‘mydatabase’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases Very often clients come to us requesting assistance because...
by XTIVIA | Mar 27, 2013 | Blog, Databases
SQL Server 2005/2008: Find backup and restore status/progress Ever wondered how long it would take to complete a backup or restore that is running in the background. I, for one, do not want to keep looking at the job or TSQL that is taking the backup or doing the...
by XTIVIA | Feb 26, 2013 | Blog, Data Management, Databases
Often I am asked about the importance of a security audit, with the majority of these questions being asked by representatives of smaller organizations. The questions are centered around if there is a need to perform a security audit when the organization has taken...
by XTIVIA | Feb 22, 2013 | Blog, Databases
One of the important performance metrics we monitor for our Virtual-DBA and consulting customers is Page Life Expectancy (PLE). We look for low values as well as values that are trending lower over time. A drop in PLE is a prime indicator of memory pressure. PLE is...
by XTIVIA | Feb 13, 2013 | Blog, Databases
Introduction A question we are often asked by both our Virtual-DBA and Consulting customers is: Why do I have to update statistics if auto-update statistics is turned on? The short answer is that your data changes, and even if you have auto-update statistics...
by XTIVIA | Feb 12, 2013 | Blog, Databases
Started: 1:03:12 PM Progress: 2012-02-08 13:03:15.24 Source: Data Flow Task Validating: 0% complete End Progress Error: 2012-02-08 13:03:16.15 Code: 0xC0047062 Source: Data Flow Task V91MOD APIMAG [1] Description: System.Data.Odbc.OdbcException: ERROR [IM002]...
