by XTIVIA | Jan 7, 2016 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
This discussion provides an understanding of what is included in a sound backup strategy for your Sql Server data warehouse application. Most data warehouse applications require a different backup and recovery strategy than a typical online transaction processing...
by XTIVIA | Jan 5, 2016 | Blog, Data Management, Databases
Tip # 8 – Default TempDB Settings Top 10 Tips for SQL Server Performance and Resiliency This article is part 8 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...
by XTIVIA | Oct 14, 2015 | Blog, Data Management, Databases
Keeping track of SQL Server Jobs is an important part of maintaining a database proactively. The below script pulls a quick list of all jobs, completion status, and date the job ran. Taking this a step further one could have the SQL Server email them a copy...
by XTIVIA | Oct 2, 2015 | Blog, Cloud, Databases, Enterprise Infrastructure, Enterprise Java, Portals
Microsoft recently updated the Azure SQL database to only allow encrypted communication. Now communication between Azure SQL Database and your application requires encryption (SSL) at all times. If your client application does not validate certificates upon...
by XTIVIA | Sep 17, 2015 | Blog, Data Management, Databases
Shortly after creating a database on your server you should be planning and scheduling your backup. Easy as it sounds it’s often approached incorrectly. Often the decision when to backup is based on when the server resource usage is low. Database Backup maintenance...
by Derek Nerenberg | Jul 31, 2015 | Blog, Databases, Portals
This post shows you how to query Liferay’s database and see which Documents and Media files are marked ‘searchable’. For these examples, I was using SQL Server and did not validate the queries work on other databases. They are...
by XTIVIA | Jul 19, 2015 | Blog, Business Intelligence, Data Warehousing, Databases
SQL Server Integration Services offers a useful tool to analyze data before you bring it into your Data Warehouse. The Profile Task will store the analysis in an XML file, which you can view using the Data Profile Viewer. Before we review how to use the...
by Anosh Wadia | Jun 24, 2015 | Blog, Customer Relationship Management
If you’ve worked with Infor CRM / SalesLogix for a while, you’ve probably run into the issue where you enter your username and password (correctly!) and all you get is an Unspecified error! Very descriptive, isn’t it? Cause: Essentially what the...
by Tori Aubé | Jun 23, 2015 | Blog, Databases
Are you noticing a drop in performance? Are you seeing a large percentage of index fragmentation? If your data page fill factor value set to a high number, page splits could be the culprit. We have helped many of our VDBA customers with these problems. What are Page...
by XTIVIA | May 28, 2015 | Blog, Data Management, Databases
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...
