Category: SQL Server

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 →

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 →

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 →

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 →

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 →