You need to structure your folders into projects. See attached screenshot.

I've never used TFS online. Here are the steps to do it if you used VS / TFS on-prem, maybe it is similar.

1. Start by creating a directory to hold...

A limitation of SSRS... you have to make each folder equate to a single project. You can then wrap multiple projects into a single solution but you can't make sub-folders...

Mine are all in snippets.

;WITH rowCnts

AS (

-- Shows all user tables and row counts...

Your transaction isolation level might be the issue here. When reading from an Availability Group secondary, you will be using SNAPSHOT isolation. Nothing you do can change this fact. Query...

Have you granted SeServiceLogonRight?

https://msdn.microsoft.com/en-us/library/ms191543.aspx

Updated: I just noticed that you already answered my question in the affirmative. Please disregard.

I worked in a custom development shop for a few years and we, almost, never used a server name for anything. It was amazing to be able to create, let...

If your end goal is, only, to have a seamless roll-over for applications or processes trying to use the old connection string, then you can make this easier with DNS....

I found this while looking into the same issue.

http://blogs.msdn.com/b/sqlblog/archive/2014/11/13/timeout-expired-while-publishing-to-sql-database-via-ssdt.aspx

Thanks for your replies.

The DENY theory could have been a factor. When this happened I ran into the problem and then my priorities were switched around on me and I...

Can you explain this scenario? (this is a true story).

DOMAIN\User1 is a member of DOMAIN\Group1 and DOMAIN\Group2.

DOMAIN\Group1 has SELECT permissions to Database1.Table1.

At the moment the user can successfully select from...

Thank you for this script. In my opinion, it hits the three qualities of a golden script.

1. Useful

2. Simple

3. Short

I personally embrace project based deployment methods such as the use of SSDT and dacpacs. I think that this method would prove a challenge in that environment because you'd have...

I attempted the fix that was suggested but unfortunately it did not solve my problem.

I used this script:

use msdb

go

-- Backup the Agent certificate from the remote server to a...

They are not identical the cert_serial_number, sid, string_sid, expiry_date, start_date, and thumbprint are different.

I will look into that link you sent me and let you know how it goes.

Thank you,

Derik...