Resolutions found with SQL Server and other types of databases
Today the question came up how do we find which DLL file that a program is calling. This is an older server that has had a couple of upgrades & … Continue Reading →
Recently I was asked for a DOS batch script, that a tech person could run, to give a stand-alone instance of SQL Server the new hostname of its server. This … Continue Reading →
This is an issue with an older version of Business Objects, version 6.5. In 2007, SAP purchased Business Object, and the current version is now called “SAP Business Objects XI … Continue Reading →
Many times I am challenged to move many similar files from one server to another. Either I have to remote-desktop on to the server (Windows), or have a session on … Continue Reading →
Once in while I am asked to troubleshoot a SQL Server database where my only connection is though a linked server. Because this database server is on protected network, I … Continue Reading →
Today, for the first time, I configured TDP (Tivoli Data Protect) for Oracle on Linux . I had already have done this many times before on AIX. The Linux version requires … Continue Reading →
Sometimes I am needed to do a little Operating System administration. I work with a couple of a databases that are on the IBM AIX operating system. Although I work … Continue Reading →
Problem: A SQL Server 2005 database’s transaction log file is growing. The transaction log file is originally 20 gigabytes in size. Over a three day period, the transaction log grow … Continue Reading →