XTIVIA BLOG
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...
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...
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...
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...
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...
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...
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...
SQL Server the Secret of the Resource Database
Beginning in SQL Server 2005 Microsoft introduced a hidden database called the Resource Database. While it is often referred to as the resource database the actual name is mssqlsystemresource. The database contains all the system objects that are included with SQL Server. The...
CPU Patches Merged with PSU Patches Starting With Oracle Database 12c
I'm not going to draw this out, though I just wanted to help make this information more widely known to the Oracle community as it was news to me when researching CPU patches for a 12c client of ours. Direct Quote from Oracle Docs: “2.1 Database Security Patching from 12.1.0.1...
Oracle Looping Chain of Synonyms. ORA-01775
So I encounter the looping chain of synonyms error every once in a while and it seems pretty simple to understand, though I thought I would take a minute to demonstrate how it works. ORA-01775: looping chain of synonyms - Basically means that you created a synonym that points...