Adding Users in SQL Server after Moving a Database

Adding Users in SQL Server after Moving a Database

When a database is moved to a new server, existing database users will not have access to the database on the new server. Attempting to add the users to the database on the new server results in an error message saying the user already exists in the database. To fix...
SQL Server Buffer

SQL Server Buffer

Have you ever noticed when you are working on a query for SQL Server and the second time you execute the query it runs much faster than the first time you had executed it?  There is a reason for this and most likely it is caused by your buffer. When your SQL...

2014 Liferay Community Excellence Award

Liferay Community Excellence The Community Excellence Award was awarded to XTIVIA for demonstrating a unique and valuable dedication to Liferay’s open-source community. This award is given to companies that have spent their own time and resources to make the Liferay...
Working with SQL Server Error Log

Working with SQL Server Error Log

Often when I am requested to look at an issue with SQL Server I have to spend some time in the error log. On a side note, I think the log itself is a commonly overlooked tool for troubleshooting. Often it can be a bit cumbersome to work with if the default settings...

CIO Review 2014 Top 100 Promising Technology Companies

Colorado Springs, CO, August 20, 2014 — XTIVIA, Inc., a technology services & solutions leader, has been chosen, one of the Top 100 Most Promising Technology Companies for 2014 by CIO Review. Read the full article about XTIVIA on page 108 here – CIO...

Query your SQL Server Error Log

Often the things I post about are the items that I am using that day, or recently. Many of the topics, are simply based on how I may have made using SQL Server a bit easier for me to use one way or another. In another SQL Server Error Log post I had mentioned a few of...