XTIVIA BLOG
Tip #7 – Disaster Recovery Plans – Top 10 Tips for SQL Server Performance and Resiliency
This article is part 7 of a 10 part series explaining the most common mistakes that I have seen in reference to SQL Server Performance and Resiliency. However, this post is not all-inclusive. Most common mistake #7: Disaster Recovery Plans Often when people hear “disaster...
DBCC CHECKDB() Error 17053
During routine integrity checks one of our Virtual-DBA customers encountered an error 17053 was encountered causing the job performing these tasks to fail. Investigating the problem further this information was also included with the error in the SQL Error Log: Operating system...
Remotely Accessing Liferay Documents
This blog post explains using HTTP to remotely get and add documents to Liferay’s Document and Media Library. Since documents may require authentication for access, this post explains how to use basic authentication to achieve that. It will also cover accessing documents in a...
Informix onclean – Rescue command for Informix DBAs
The Informix “onclean” command was introduced in Informix 11. I am sure that most Informix DBAs have occasionally faced a situation where the Informix instance won’t come online due to an improper shutdown, killed process, interrupted restore, or an instance crash. In...
Why AngularJS? Why now?
Should we use AngularJS? Should we use it now? In light of the announcement by the AngularJS team to release AngularJS 2.0 as a total rewrite, it is a valid question to ask: Should we build new applications on AngularJS 1.x? And given that 2.x is not available...
Tip #6 – Change History – Top 10 Tips for SQL Server Performance and Resiliency
Tip # 6 – Change History, Top 10 Tips for SQL Server Performance and Resiliency This article is part 6 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive. Most common mistake #6: Not...
Infor CRM Cross domain SData requests
For Infor CRM / Saleslogix SData is the key technology on the server side that enables us to build rich client side applications. Single-page applications are all the rage now and with sdata they can communicate with the Saleslogix database without the need to build a custom...
The Impact of Scopes in AngularJS
Scopes in AngularJS define where every variable is visible and where it's not. Scopes are hierarchical, where every parent scope is visible in the child scope but not the other way around. $rootscope is the highest scope that is seen by all the controllers. Be careful when...
How to find your unused documents and media files in Liferay
Introduction The Unused Documents and Media portlet is a Liferay Control Panel portlet. This portlet allows site administrators to see documents and media that are not used in any web content. The site administrator can take action on each document or media by either...
Tip #5 – Not Setting a Maximum Memory – Top 10 Tips for SQL Server Performance and Resiliency
This article is part 5 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive. Most common mistake #5: Not Setting a Maximum Memory Default configurations are not always the best...