New year started few weeks ago. For me one of my personal goals is to be more active blogger than last year. Especially with this interesting (in my – ond not only – opinion) special series: The Sunday Market. Name (genesis is too big word) of this series is simple. In many countries You cannot buy something interesting for Your environment, because Financial Department are close in Your company. But You always can get something for free from the web. Get-Test-Check > put into your budget.
Last Wednesday I presented short (introduction type) session at my local SQL User Group (Polish SQL Server User Group in Wrocław LINK) about free tools from ApexSQL. Some of my folks talked about it few times on previous meetings. It was first session, second will be presented soon with more funny experiments. In this blog series I want show few moments from “dating with Apex”. In this post I will just introduce about installation of three tools. All are free:
ApexSQL Complete | LINK http://bit.ly/1i3IeV3 | size 7MB | in few words: SSMS and VS integration, SQL syntax checking, SQL object descriptions, SQL code completion, SQL code visualization, Snippet management
ApexSQL Refactor | LINK http://bit.ly/1i3IjrC | size 8MB | in few words: SQL parameter management, SQL formatting, Consistent code layout, Database object refactoring, Batch formatting, One-to-many relationship replacement
ApexSQL Search | LINK http://bit.ly/MkFvvR | size 7MB | in few words: Smart renaming, Text search, Database object search, Easy SSMS tab navigation, SQL code cleaning, Graphical dependencies
Phase one: installation
Pic.01 | Three tools, same installation interface – I really LOVE it. Ordnung muß sein!
All screenshots below (till phase two) are the same for all tools.
Pic.02 | Reading – yes read it – and accepting license.
Pic.03 | Choosing installation folder – for me as alway it is ‘non default folder’ *
Pic.04 | We can integrate these tools with all part of environment which is installed on machine: in this case I have SSMS for SQL 2008 & 2012, anf VisualStudio for 2005, 2008, 2010 & 2012 versions. It’s interesting because I don’t heve Visual Studio 2013 and installer is prepared for instalaltion (suppose that last row will be un-grayed when I install VS2013). But I have SQL Server 2014 on my miachine and this installer is not ready for this version.
Pic.05 | Choosing (or not) selected Start Menu – even on Windows 8.1 **
Pic.06 | Ready to install with summary.
Pic.07 | installation in progress.
* in this case I got several problems with using non defaul folders, but not only – I had not vell functional addins from other software vendor – these addins figting for place and acces for dll’s.
** definitely too much, really too much links in start menu by default:
Phase two: result
Pic.08 | First execution of SQL Server management Studio 2012 and I got this error, next: SSMS crash. I tried again and again and again.
Pic.09 | More interesting error I got when I run Visual Studio 2012 (of course add-ons hasn’t been installed).
I didn’t enought time for full investigation, becaus it happener just few hours befor my user group meeting. So I executed my disaster repair (not recovery) procedure in few steps:
deinstallation al ApexSQL addins
deinstallation all other vendor add-ons
cleaning reistry (by wise registry cleaner)
cleaning folders (by wise dick cleaner)
restart physical machine
installation all three ApexSQL tools again
Phase three: final result
Finally I got all tools in my SQL Server Management Studio:
Pic.10 | ApexSQL Complete integrated with SSMS 2012.
Pic.11 | ApexSQL Refactor integrated with SSMS 2012.
Pic.12 | ApexSQL Search integrated with SSMS 2012.
Next date with Apex on Sunday.
ps: to kill or to be killed…