I recently had someone ask me this question, and I didn’t know the answer. Yes, SSRS keeps track of this information in the ReportServer database, I just had to look around a little bit. Here are some quick queries to let you know what reports are in your SSRS instance and what users are running… Continue reading Who is executing my SSRS Reports?
Maybe this title is a bit misleading…another title might be “how are you monitoring your SQL Servers?” There are many ways for a DBA to keep tabs on his/her servers; I have many different T-SQL scripts to grab info when I need it. However, I frequently run into the same issue; I can run these… Continue reading Are you using SSRS?
One of my SQL Agent jobs recently started throwing the following error: Failed to initialize sqlcmd library with error number -2147467259. [SQLSTATE 42000] (Error 22050). This job has run successfully for years…Why the sudden error? I searched the web for answers and found articles that told me that my SQL Agent service account wasn’t setup… Continue reading Sp_Send_dbmail error
What is a SQL Server execution plan? Big topic: I suggest grabbing Grant Fritchey’s book SQL Server Execution Plans (A free eBook at the time of this post); 332 pages of good stuff on execution plans. You can get it here: Redgate link to Fritchey’s eBook So you don’t want to read a whole book… Continue reading Execution Plan Basics
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