This is the story of my saga to get DTC working in a clustered environment. It’s a bit different from other postings that I read and tried so I thought it was worth posting… We have a “test” SQL Server instance and it was noted that DTC (Distributed Transaction Coordinator) was throwing errors. The users… Continue reading DTC – Why Doesn’t it work?
Tracking your backups…one of the most basic/mundane/important functions for which a DBA is usually responsible. How do you know that your databases are being successfully backed up? What about your transaction logs? If you don’t have a current backup (even for a development database!), you and your users could be “up the creek without a… Continue reading Tracking your Backups
I’m not a big Powershell user, but sometimes it is useful. Recently I decided to setup a SQL Agent Job to execute all .SQL script files found in a particular folder. I used a Powershell step and it seemed pretty easy. However, I noticed that when I used the out-File parameter that I only got… Continue reading Invoke-SQLCMD lesson learned
I know…there has been a lot written about this subject. What I’m trying to do here is to summarize first the methods I use to find dependencies in SQL Server, and second to tell you why I don’t use other methods. There are third party tools out there, and some are very good at finding/displaying… Continue reading Finding Dependencies
Here’s today’s issue; how do I monitor/capture information about query timeouts on my production server? This issue crops up from time to time and I never seem to have the time or energy to devote to it. We don’t have many problems with timeouts on our production servers, but when we do the DBA should… Continue reading Capturing Timeouts using Extended Events
Can you perform a SQL Server filegroup restore using a full backup file as input? I couldn’t find anything that specifically stated that in documentation, so I tried it. YES you can! It worked great! I wanted to use this technique to create a testing database without copying the data from a particular set of… Continue reading Filegroup Restore from a Full Backup?
When many DBAs talk about index maintenance they are referring to the process of rebuilding or reorganizing indexes to reduce fragmentation. Many use a script much like I do to determine the set of indexes to defragment based on the size of the table and the percent of fragmentation, etc. I don’t want to talk… Continue reading Proactive Index Maintenance