Viewing 15 posts - 1 through 15 (of 89 total)
This looks super-handy, thanks for sharing.
Note the small typo on the web site though: EnterpriCe instead of EnterpriSe. Unless this was intentional, given the price for Enterprise Edition 🙂
August 6, 2021 at 7:27 am
hey doesn't work in SSMS, you need to use Azure Data Studio
April 1, 2021 at 8:05 am
I think this is something every DBA needs to know about, so thanks for sharing!
I have a small note though... I have restored master a few times on an...
October 31, 2020 at 7:00 pm
Hmm, no comments yet? Curious.
I'm that type of person who really likes to know how something works. I just love all the fantastic info coming from you and guys/girls like...
August 6, 2020 at 2:41 pm
Thanks for the feedback Luke, much appreciated!
June 29, 2020 at 2:04 pm
facing the same kind of issues (intermittent connection issues) on a comparable environment.
Found this https://support.microsoft.com/en-us/help/4557473/errors-when-applications-try-to-connect-to-sql-server-in-windows
Haven't checked yet though because of project and other constraints but maybe you'll find...
June 29, 2020 at 12:32 pm
December 18, 2018 at 2:15 am
I like CLR! Imagine all the possibilities...I don't like CLR! Imagine all the possibilities...
December 18, 2018 at 1:21 am
I agree with Andreas. Make sure you have a backup first 🙂Depends on a number of things but some quick ideas that come to mind.If you're on VM,...
December 7, 2018 at 1:44 am
Thanks for sharing. I tend to be on KenpoDBA's side though... don't like xp_logininfo either.Btw, did a little test: created a plain login and granted it CONTROL SERVER. It...
August 3, 2018 at 1:54 am
April 17, 2018 at 8:23 am
Thanks for sharing. I may be wrong but I don't think any of the SqlConnection constructors throws exceptions (cfr https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.sqlconnection(v=vs.110).aspx) So the try/catch shouldn't be...
April 17, 2018 at 6:18 am
Thanks for sharing. You might also make a note about permissions. If the service account doesn't have appropriate permissions on the new path then SQL won't start.I'd also stress...
December 14, 2017 at 1:35 am
Very interesting approach! Thanks for sharing.One remark though: declare @value should probably read declare @val (in the first code fragment)RegardsThierry
November 17, 2017 at 1:23 am
October 10, 2017 at 9:35 am