I have learned what I was doing wrong. I was attempting to connect using the standard Windows Authentication. In order to connect to an Azure SQL server with an Active...

Based on Brent Ozar's sp_Blitz I've become convinced that running CheckDB on TempDB is a good idea. You can read his posts on the subject. The problem I ran into...

The most gratifying job I had was for a registered non-profit that provided IT services to other non-profits and charities, mostly in Homelessness and Domestic Abuse. The least gratifying was...

I've run into this problem too. The only thing that comes to mind is that tables with LOB data types could be the problem. I know that for index REBUILD...

Hi all, Thanks for all the help. Apologies to Jack because although I had read Kendall'sblog post I glossed over the hosts file suggestion. This is what...

Hi Perry,

Thanks for your response. Although the steps in the article you referred to were pretty much what I had done before, I started from scratch and followed the instructions...

Thanks Jack,

I should have mentioned that I have read that post and tried what was suggested to no avail.

Tom

I realise that this question was raised a long time ago, but I thought I'd address it.

In my experience the .TUF file is put into the same directory as...

Thanks for the link.

TheSQLGuru (9/26/2013)

It has been my experience consulting with numerous clients that deadlocks and blocking are most often rather easily addressed by proper indexing and it usually isn't very hard to...

Thanks for the article Steve.

I had heard about the difficulty of removing TDE but not the resolution. I have mirroring setup so it's not that easy to set the principal...

Thanks for the directory security tip. Saved me lots of frustration.

Thanks for that. Something similar occurred to me this morning. I was hoping there would be something a little simpler. But I have quite a few similar ftp jobs so...

Thank you SSChasing Mays. I've got this working properly now. I seemed to have had a block as to how this all worked. The crux of my problem was that...

Does anyone have any experience with data driven subscriptions in SQL Server 2005 Reporting services (SSRS)?

I've found some documentation online, but it's all been rather basic. Does this mean...