by XTIVIA | Feb 5, 2013 | Blog, Databases
Recently we migrated one of our client’s SQL Server instances to a new server. During the migration we had moved the storage to the new server so the old server didn’t have some of the disk drives that were previously mounted on it. After the migration the...
by XTIVIA | Jan 31, 2013 | Blog, Databases
Msg 1205, Level 13, State 68, Line 10 Transaction (Process ID 79) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Msg 5069, Level 16, State 1, Line 10 ALTER DATABASE statement...
by Kathleen Long | Jan 4, 2013 | Blog, Data Management, Databases
Every database holds different business data and has its own recovery needs. Unfortunately, there is not a single solution for all databases. There are many possibilities and solutions. For each database you are responsible for supporting you should be asking...
by Kathleen Long | Dec 20, 2012 | Blog, Data Management, Databases
This feature in the maintenance plans in SQL Server seems to be either ignored or over used. Either people do not put this step into any maintenance plan causing MSDB database to grow large over time. Or they have this step placed in every maintenance plan not fully...
by Kathleen Long | Dec 19, 2012 | Blog, Data Management, Databases
An interesting request came in the other day, is there a way to tell how much memory each database is using on an instance. You can always use properties to see how much memory is allocated to the SQL Server and there are performance counters available to track how...
by XTIVIA | Dec 11, 2012 | Blog, Databases
Seeing a database in any state other than “online” makes me a little nervous. For one thing, it’s one of those things I don’t see often, so I have to rub a few brain cells together to remember what I did the last time. For another,...
by XTIVIA | Oct 2, 2012 | Blog, Databases
I recently had a client ask me about how to use profiler. I looked online and did not find anything that was concise and to the point for what I wanted to show him so I decided to just make a quick tutorial which is listed below. This tutorial covers the usage...
by XTIVIA | Oct 1, 2012 | Blog, Databases
Quick, DBA with the sysadmin role in SQL Server: What’s your default database? I’ll bet you think it’s the master database. But, as I learned this weekend, that’s not something you can take for granted — especially if you didn’t...
by XTIVIA | Sep 28, 2012 | Blog, Databases
Given the general mayhem and wanton destruction database developers can inflict on an organization, you’d think there’d be a best-practices set of SQL Server permissions that DBAs should grant developers. Or better yet, a “dbdeveloper” server...
by Tony Salerno | Jul 25, 2012 | Blog, Databases, Perspectives
How do you know if you have the right number of database administrators (DBAs) on staff to properly take care of your environment? All your organization’s databases need to be kept operational and properly tuned, which probably requires around the clock...
