Viewing 15 posts - 1 through 15 (of 15 total)
You need to structure your folders into projects. See attached screenshot.
Derik Hammer
@SQLHammer
www.sqlhammer.com
November 17, 2015 at 9:06 am
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...
Derik Hammer
@SQLHammer
www.sqlhammer.com
November 16, 2015 at 3:46 pm
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...
Derik Hammer
@SQLHammer
www.sqlhammer.com
November 16, 2015 at 11:21 am
Mine are all in snippets.
;WITH rowCnts
AS (
-- Shows all user tables and row counts...
Derik Hammer
@SQLHammer
www.sqlhammer.com
September 2, 2015 at 7:42 am
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...
Derik Hammer
@SQLHammer
www.sqlhammer.com
August 31, 2015 at 11:39 am
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.
Derik Hammer
@SQLHammer
www.sqlhammer.com
August 6, 2015 at 10:51 am
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...
Derik Hammer
@SQLHammer
www.sqlhammer.com
April 29, 2015 at 12:47 pm
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....
Derik Hammer
@SQLHammer
www.sqlhammer.com
April 29, 2015 at 11:29 am
I found this while looking into the same issue.
Derik Hammer
@SQLHammer
www.sqlhammer.com
December 1, 2014 at 9:46 am
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...
Derik Hammer
@SQLHammer
www.sqlhammer.com
September 25, 2014 at 2:12 pm
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...
Derik Hammer
@SQLHammer
www.sqlhammer.com
September 25, 2014 at 1:05 pm
Thank you for this script. In my opinion, it hits the three qualities of a golden script.
1. Useful
2. Simple
3. Short
Derik Hammer
@SQLHammer
www.sqlhammer.com
August 21, 2014 at 7:19 am
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...
Derik Hammer
@SQLHammer
www.sqlhammer.com
August 1, 2014 at 6:37 am
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...
Derik Hammer
@SQLHammer
www.sqlhammer.com
August 9, 2012 at 12:16 pm
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...
Derik Hammer
@SQLHammer
www.sqlhammer.com
August 7, 2012 at 7:13 am
Viewing 15 posts - 1 through 15 (of 15 total)