SQL Server Migration and Upgrade Strategies

SQL Server Migration and Upgrade Strategies

Abstract Upgrading or migrating your SQL Server can seem like a very daunting task. And it certainly can be especially when we start to look at hardware requirements, size and space needs, time constraints, and the numerous impacts to the the users and applications...
SQL Server 2005 End of Support

SQL Server 2005 End of Support

SQL Server 2005 extended support ends April 12, 2016. What this means to SQL 2005 users is no more security updates or hotfixes. What it means to us as DBA’s is we’re in a situation we never want to be in, where our database platform is down or compromised...
Create a Zoomable Image Portlet for Liferay

Create a Zoomable Image Portlet for Liferay

This blog shows you how to create a portlet to be able to zoom in and out of an image. This portlet is web content driven using Liferay 6.2, jquery and animate.css. I have included all the source code for this project at the bottom of this page. How it Looks: When you...
DB2 LUW Error Message: SQL1024N

DB2 LUW Error Message: SQL1024N

Error Message SQL1024N A database connection does not exist. SQLSTATE=08003 or sometimes: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL1024N A database...
Allocation of Primary Logs in DB2

Allocation of Primary Logs in DB2

Recently, we noticed on a staging environment that the LOGPRIMARY setting was set to 35, yet the number of logs on the log path was only 21. Number of primary log files (LOGPRIMARY) = 35 35 Number of secondary log files (LOGSECOND) = 45 45 db2inst1# ls -ltr total...
Understanding DB2 LUW Error Messages

Understanding DB2 LUW Error Messages

DB2 LUW Error Messages are some of the more descriptive ones I have seen in the computing world, but maybe everyone thinks that about their chosen specialty. Truly understanding error messages can take a bit of practice and knowledge, so I thought I would share a few...