I finally had an opportunity to present at SQL Supper event in London on the 18th of April 2017. I have thoroughly enjoyed the event and the pub session that followed. I even managed to learn a few things myself! Thank you very much, James and other organisers for presenting me with this opportunity to share the knowledge and experience with others and contribute to the community. Many thanks for people attending the event and particularly those who participated in the discussions.
The talk I have presented was on BI ALM with TFS 2017 (DevOps for MS BI using TFS2017), please let me know any feedback on the session by commenting to this post, that will be very much appreciated. If you have any questions or if you want any part of the scripts I have used in demo – please let me know.
I have blogged previously about setting up service principal names for your architecture. To make it really easy to form a perfect SETSPN statement first time and every time, I put together this little spreadsheet that will build the statements for you. It will also help you plan your installation architecture and service accounts.
All you need to do is to carefully fill in all the fields that appear in yellow and your SPN statements will be done. Just make sure you copy both NetBIOS based and FQDN based columns to a batch file and run it as domain admin.
This spreadsheet was a result of many hours of research, so if you feel that it helped you save time and money, please donate any amount you see fit using the button on the right. I will be happy to answer any questions you may have on it, please feel free to comment.
I provide the spreadsheet on “as is” basis and reserve the right to withdraw it at any time. You are free to use it in any way you like, but not distribute it or any part of it without my explicit written permission.
You can download the spreadheet from here. Please leave comment to this post if you found it helpful or indeed otherwise.