Monthly Archives: April 2014

Atlassian JIRA on Ubuntu

Some notes for installing and upgrading Atlassian JIRA on Ubuntu LTS (12.04 tested for these notes). For production use, install the MySQL Server package with “apt-get install mysql-server” (can be verified with “dpkg –list mysql-server“). I recommend creating a database … Continue reading

Posted in Linux, System Administration | Tagged , | Leave a comment

TSQL View with ORDER BY Clause

Views in Microsoft SQL Server are generally not permitted to have an ORDER BY clause. This is a good default behavior because it can negatively impact the view performance and the order should be specified when the final result set … Continue reading

Posted in Database | Tagged | Leave a comment