Request More Information

We are hiring!

Xtivia, Inc.
2013 North America Liferay Partner of the Year

Join our top-notch team of Enterprise Java and Liferay Portal professionals in our Austin, TX office or work remotely! Please check out our current Dice listings.

Recent Bloggers

Bob Dietrich
Posts: 8
Stars: 0
Date: 12/18/14
Tony Salerno
Posts: 2
Stars: 0
Date: 12/18/14
Chetan Chadalavada
Posts: 3
Stars: 0
Date: 12/17/14
Chris Provolt
Posts: 3
Stars: 0
Date: 12/16/14
Kat Meadows
Posts: 7
Stars: 0
Date: 12/16/14
Godwin Anasigre
Posts: 1
Stars: 0
Date: 12/12/14
Sonu Verghese
Posts: 9
Stars: 0
Date: 12/12/14
Nick Ortman
Posts: 2
Stars: 0
Date: 12/12/14
Chris Shaw
Posts: 9
Stars: 0
Date: 12/9/14
Kaushik Nagaraj
Posts: 9
Stars: 0
Date: 12/9/14

Xtivia Dynamic Data List Visualization Portlet

Introduction A picture is worth a thousand words! This popular adage refers to the notion that a complex idea or dataset can be conveyed with just a single image. It has been observed that people relate to images quicker than just looking at tabular data. Effective visualization helps users in analyzing and reasoning about data and the correlation in the data for one or more variables....
Read More About Xtivia Dynamic Data List Visualization Portlet »

Using Extended Events to pinpoint performance issues in SQL Server

A while back, I was tasked with using extended events to see what information could be captured to help a customer out with troubleshooting a performance issue. My first step was to see which SQL Server extended events were available on the server. With each version of SQL Server, more extended events become available. I issued the following query to determine the packages available: ...
Read More About Using Extended Events to pinpoint performance issues in SQL Server »

Jasperserver Scheduled Reports Not Running

You may run into an issue where several reports scheduled at the same time do not kick off. One cause for this is that the server does not have enough time to kick off all the reports before the expiry of the cut off time. A remedy for this issue is to increase the number of reports that run concurrently and increase the cut off time. These settings can be changed in the...
Read More About Jasperserver Scheduled Reports Not Running »

Select * from yourtable… How bad is it?

Have you heard and understand why processing a 'select * from any table' can be negative on the performance impact?  While I was doing some demo prep for my upcoming PASS Summit Pre-Conference I saw this behavior at its worst. Before we jump into why this is such a negative impact on your performance I should tell you about my test environment. I have a table with 4.6 million...
Read More About Select * from yourtable… How bad is it? »

How to connect SQL Server to an IBM UDB DB2 data source

SQL Server 2005/2008/2012: How to connect to a IBM UDB DB2 data source and query it? You will need the following to install the drivers and connect to the IBM UDB DB2 data source: Hostname of the DB2 server. Port number where the DB2 instance is listening. You can ask for the SVCENAME Database manager parameter for the particular instance. Sometimes you might have to...
Read More About How to connect SQL Server to an IBM UDB DB2 data source »

Executing SQL Queries Based on Time

Sometimes things should only happen at certain times. Not long ago I was asked to create a script that is triggered by an event, however, would only execute certain commands if the event occurred during a single specific time range.  Creating an alert to handle the event trigger is the first step and that alert should execute the code below to determine the time window and perform any...
Read More About Executing SQL Queries Based on Time »

Removing Oracle Registry Keys from a Windows Server

Recently for a client I had to manually remove a few failed database software installations and a couple of failed client installs from a Windows 2008R2 server. Attempts were made to try and force a 10.2.0.1 Oracle Database and client install on the server. They were able to follow some hacks on the internet that let them install the software though it wasn't working at all and they couldn't...
Read More About Removing Oracle Registry Keys from a Windows Server »

Oracle Automatic statspack snapshot purge

So we have several Virtual-DBA clients that come to us that either had previous DBAs onsite or previous remote DBA services. Everyone has different ways of setting up performance monitoring of databases, though a potentional problem that I see a lot is the installation of statspack without some kind of automated snapshot purge job. The reason this is an issue is due to the fact that...
Read More About Oracle Automatic statspack snapshot purge »

Oracle Enterprise Manager 11g Agent Connection to Instance Unavailable

I encountered an issue today with an instance that was showing up in OEM 11g though you couldn't get to the database instance management page as the Agent Connection to Instance was reporting Unavailable. I came up with nothing after a few hours of checking logs, monitoring configuration, restarting agent/oms, etc. Everything was correctly configured and there were no errors to point me in...
Read More About Oracle Enterprise Manager 11g Agent Connection to Instance Unavailable »

SQL Server Reporting Service Memory Settings

While doing research for an upcoming add on to our standard Health Checks , I have been reviewing the different option to set in the configuration file for SQL Server Reporting Services. There are memory settings which should be addressed, especially if you are running Reporting Service on the same server as your Database Engine. Reporting Service; just like the Database Engine can use...
Read More About SQL Server Reporting Service Memory Settings »
Showing 1 - 10 of 251 results.
Items per Page 10
of 26

Request More Information