As someone who has mastered GIS (Geographic Information Systems) and can do all facets blindfolded, BUT has only just begun my deep journey into the SQL Server world 2 years ago I found this article comforting. The SQL world is deep and complex and in the GIS world we have people called SDE Admins (Spatial Data Admins) who's job is to be SQL gurus as well as GIS Data gurus and make them sing and dance together. Not an easy task.
I started as a cartographer just reading the data and making maps. I have now worked my way "backwards" towards enterprise solutions with GIS as my strong point. I took notes on all those rare GIS things for installation and how I had to configure that on top of SQL Server 2012.
I now am moving towards ArcServer 10.3 & Spotfire Server 7.0 all built on a SQL Server 2014 R2 & Windows Server 2012 R2. I am hoping my notes from 2 years ago doing ArcServer 10.1, SQL 2012, and Windows 2008 R2 serve me well, but I am sure there will be new hurdles and software changes that will just stump me and make me feel all alone as I get these software's to talk properly. I'll keep this article in mind that even well versed SQL gurus have the same hurdles that "newbies" like me have when setting up systems every once in a blue moon.