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...
by XTIVIA | May 15, 2015 | Blog, Data Management, Databases
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:...
by XTIVIA | May 6, 2015 | Blog, Data Management, Databases
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...
by XTIVIA | Mar 4, 2015 | Blog, Data Management, Databases
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...
by Kathleen Long | Feb 27, 2015 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
SUMMARY: This guide details the technical process for establishing connections between SQL Server Reporting Services (SSRS) and non-SQL data sources by installing the Microsoft Access Database Engine and configuring specific OLE DB or ODBC connection strings....
by XTIVIA | Feb 11, 2015 | Blog, Data Management, Databases
The sys.database_role_members view contains two columns one for the role id and one for the member id creating a relationship between the role and the user. When we join this data to the sys.database_principals view we can retrieve the friendly name of the role and...
by XTIVIA | Feb 3, 2015 | Blog, Data Management, Databases
Tip # 4 – Not having a Baseline Top 10 Tips for SQL Server Performance and Resiliency This article is part 4 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is related to the most common errors...
by XTIVIA | Jan 26, 2015 | Blog, Data Management, Databases
Tip # 3 – Maintain your SQL Server Top 10 Tips for SQL Server Performance and Resiliency This article is part 3 of 10 in a series on the most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is related to the most common...
by XTIVIA | Jan 20, 2015 | Blog, Data Management, Databases
Tip # 2 – Check your Security Top 10 Tips for SQL Server Performance and Resiliency This article is part 2 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is related to the most common errors I...
by XTIVIA | Jan 12, 2015 | Blog, Data Management, Databases
Tip Number 1 – Check your Backups Top 10 Tips for SQL Server Performance and Resiliency I have been a consultant for a number of years and lost track of how many different servers I have worked on a long time ago. However, today as sit down and think, it...
