Viewing 15 posts - 1 through 15 (of 36 total)
Are you allowed to modify the underlying procedure?
If you aren't allowed to modify it and you have Enterprise edition you can use sys.sp_create_plan_guide to start changing things. But it has...
November 26, 2015 at 2:19 am
I started getting lot of work and I started spending a lot of my personal time outside working hours to resolve issues and to implement new projects.
In the modern business...
October 21, 2015 at 10:24 pm
I'm going to read between the lines on the source article.
> Until 2013, the agency had no internal IT staff with "professional IT security experience and certifications."
The scenario you'd...
October 21, 2015 at 8:58 pm
Don't forget that your applications should support Availability Groups before you start using it.
They can't use MSDTC or cross database transactions. They should prefix agent jobs and copy them across...
October 21, 2015 at 8:05 pm
There are two ways I can think of to address this aside from hiding the URL which would be a spectacularly bad idea.
SSRS has a web services with APIs you...
October 21, 2015 at 7:56 pm
That's how you'd do it. But your process is a bit off.
Any time someone asks you to do something like this the first thing you should be doing is creating...
October 21, 2015 at 7:46 pm
Great question! I've also been interested in this divide especially as BI becomes more commonplace.
As operational DBAs (looking after a few hundred instances) we consider our role to be the...
September 3, 2015 at 10:03 pm
I don't think this is part of SSRS. It seems like it's done by whatever monitoring software you use.
September 2, 2015 at 11:00 pm
I'm not the original poster and haven't done this, but if you have no other luck you could try changing the domain name on the ReportServer.dbo.Users table UserName column.
Other...
September 2, 2015 at 10:59 pm
I think you should ask for more detail. It may not be supported but does it work? The only way to know the latter for sure is to set up...
September 1, 2015 at 10:29 pm
We call "Production Support/Admin" simply Operations.
September 1, 2015 at 10:24 pm
So was it an in-place upgrade or a new installation? It's important to know if the instance-level settings were retained or reset to defaults.
Either way it could be instance level...
September 1, 2015 at 10:21 pm
* Make sure that all apps and people who connect to the instances are configured to use the port number. They cannot continue to use the instance name without the...
September 1, 2015 at 10:16 pm
IMHO yes. Let others know what you're doing first so they have the right of refusal, but otherwise while other DBAs will tell you to test thoroughly first, this is...
August 27, 2015 at 8:36 pm
Brian Davis?
I swear I tried to contact him 3-6 months ago on twitter or email about it - but I looked and couldn't find any record. I'll try again.
August 6, 2015 at 8:11 pm
Viewing 15 posts - 1 through 15 (of 36 total)