Viewing 15 posts - 1 through 15 (of 96 total)
Yeah, I have warned about the cost, we have around 120 servers, have been given a deal by MS, but its looking like a mixed bag of PaaS, MI and...
May 2, 2019 at 1:41 pm
Where I am at the moment has a project to move all the old 2008 servers into Azure, think they are being a bit ambitious though, especially with the amount...
May 2, 2019 at 12:38 pm
I totally agree with your viewpoint Steve. There is a lot to keep up with and outside of pushing yourself, no one is going to do it for you. The...
April 8, 2019 at 11:12 am
I am slowly getting used to the new design. I think my biggest issue with it is the font you are using, just makes it much harder to read and...
April 5, 2019 at 7:36 am
By settings, we mean what does sp_configure return. Post that here along with what memory you have in the server itself.
Sorry, just looked at first post, cost threshold...
February 5, 2019 at 4:40 am
I guess it depends where you are and the privacy laws, whether there is recognisable customer data etc. If you are in certain states or within the EU, quote the...
January 28, 2019 at 3:33 am
In AD, have you given rights from the cluster container to the nodes? If not, then you will not be able to find either node and therefore creating an availability...
January 16, 2019 at 5:17 am
Please expand on your questions, you may get more answers, if these are questions on a test, google is your friend. 🙂
January 16, 2019 at 5:09 am
I always store them as YYYYMMDD HH:MM:SS.MS (Or without time if Date), I should use UTC and have at a couple of places, but I think it is business dependent,...
January 16, 2019 at 5:03 am
Thanks Grant, that's helpful, but not in the way I hoped. 😉 I just can't get my head around what is occurring as log backups are frequent enough, but the...
January 8, 2019 at 8:40 am
At the moment it is, this is what I want to stop.
January 8, 2019 at 6:26 am
I don't think there is any best practice for this except better design. Why are you now changing a char(3) to a char(4)? Could you have anticipated this from the...
January 8, 2019 at 3:49 am
I have used them for the same reason as Jeff. I actually found the developers were the ones who didn't much like them strangely, couldn't work out why and didn't...
January 7, 2019 at 6:45 am
Thanks Chris, I have tried that with a domain admin account , still the same error, hence the confusion as with those rights it should just work regardless.
November 10, 2018 at 3:34 am
No, two separate accounts. Would it matter in this situation as it should be using the Agent account to run anything outside of SQL shouldn't it?
November 9, 2018 at 11:52 am