Resolutions found with SQL Server and other types of databases
Being new to the MongoDB database, only in my second week of training, I wanted to test the MongoVUE gui tool to see if it would help make my administration … Continue Reading →
This blog is about upgrading SQL Server 2012 Standard Edition to the Enterprise Edition. This issue has been written about a couple of times, but one more blog about this … Continue Reading →
Not exactly one character will produce a new line in Oracle’s SQLPlus. By piping the ASCII CHR(13) then piping the ASCII CHR(10) in that order ( || CHR(13) || CHR(10) … Continue Reading →
Question: What is the difference between sp_readerrorlog and xp_readerrorlog? Executive Summary Answer: ALMOST NOTHING The More Detailed Answer: under the covers sp_readerrorlog is a stored procedure in the master database … Continue Reading →
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 →