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 Kathleen Long | Dec 15, 2014 | Blog, Data Management, Databases
A while back, I was tasked with using extended events to see what information could be captured to help a customer out with troubleshooting a performance issue. My first step was to see which SQL Server extended events were available on the server. With each version...
by XTIVIA | Nov 25, 2014 | Blog, Data Management, Databases
Beginning in SQL Server 2005 Microsoft introduced a hidden database called the Resource Database. While it is often referred to as the resource database the actual name is mssqlsystemresource. The database contains all the system objects that are included with SQL...
by XTIVIA | Jul 30, 2013 | Blog, Databases
In recent times, database migrations have become a way of life for most database administrators. Whether moving to new hardware or into the world of virtual machines, what once was a rare project is becoming an almost everyday concern for database environments...