I work with a client in London who use Report Builder instead of BIDS (for a variety of different reasons). Funnily enough they went on the SSRS course provided...

I like this article a lot and you make the case very well. It would be interesting to see the balance of arguments if you look at the alternative options...

Thanks for the reply. The issue seems to be around the report rendering somehow (all I'm doing is running the report in report manager). I can use the...

Isn't it the case that most of this work is already there with the Log Reader Agent available for replication and change data capture. It really wouldn't take much...

Excellent article Andy! Very clearly laid out and makes a fairly advanced piece of report development appear straightforward.

Having gone through lots of painful conversations about kerberos authentication, how it works and how to set it up there are some things that get cemented in your brain.

This being...

It's one of those questions where you've got to re-read the answers several times before selecting. I've come a-cropper a couple of times this week by diving in too...

Well that's got the brain ticking over quite nicely now. Thanks Hugo!

An interesting observation there Steve. Unfortunately I've seen too many examples where bad managers are promoted to get them out of the...

Hi Basit,

You're right in that the issue with the Log Reader Agent will prevent the clear down of the TxLog. Howver, you've reinitialised the subscription and generated a new...

These transactions, such as uncommitted transactions, are not deleted after checkpoint or after you back up the transaction log until the log-reader task copies the transactions to the distribution database...

Having only one option that started with FROM made it very straightforward. Useful to still refresh the memory with the sequence so thanks for the question (and easy point!)...

Sorry I've just forgotten to mention something...

One of your steps is to clear the transaction log using BACKUP LOG ... WITH TRUNCATE_ONLY. That shouldn't be necessary as the committed...

It's one of those areas where you need to have extra vigilance over the management of your transaction logs. Change Data Capture can have the same effect as the...

Ah, the benefit of turning up to this party a bit late.

Turned out to be a nice question for me on a sunny Monday morning! 😀