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...
by XTIVIA | Jan 5, 2015 | Blog, Data Management, Databases
Often the first stop in troubleshooting is taking a peek at those logs. SQL Server Error logs can provide a lot of useful information and when it comes down to troubleshooting a SQL Server problem one cannot go wrong by cracking open the log files. The SQL Server...