[EN] First date with Killer ApexSQL Tools

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

Captura_ApexSQL_Complete01 Captura_ApexSQL_Refactor08 Captura_ApexSQL_Search08

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:

  1. deinstallation al ApexSQL addins
  2. deinstallation all other vendor add-ons
  3. cleaning reistry (by wise registry cleaner)
  4. cleaning folders (by wise dick cleaner)
  5. restart physical machine
  6. 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…

[EN] MDX Technical Review Project is finished

IMG_2500It is really great present for me, for last X-mass and for New 2013 Year. Three days ago I received special package from Dallas. This package has been send by Ashim Mazumder and inside it  I found very long awaited book about MDX. I wrote a simple post in last September about his book (HERE). NOW – I’ve got it! YAY!!!!

I spend few days in the middle of last year on working with one of the chapter and part of introduction and I’m very proud that this book is now in my library (with special dedication of course).

Ten chapters with special introduction: how prepare testing enwironment for excersises. Yes, In average: five excersises on each chapter. Ater this book You will know more about MDX, alpecially in SQL Server 2012. Price is not very high (less than fifty bucks), so You can order it at Amazon. Of course I will write full review about this book soon. Now I’m enjoying.

Thank You Ashim for this great opportunity.

[EN] A Review: SharePoint 2013 Developer Machine

I’m hungry. Not angry, just hungry. Why? I finished new book by Sahil Malik and Srini Sistla (is a book or not a book? Later). Last sentence:

From here, you can either take the IT pro route, the developer route, or the SharePoint designer route. But before we dive into any of those, let’s get some basic familiarization with, well – what the hell is using SharePoint like? In other words, let’s examine some of interesting SharePoint features, at least as far as the end user is concerned

Where the hell is next part? SharePoint 2013 Developer Machine is a Kindle book, not very big (just 81 pages) but very, very important for all SharePoint freaks. It’s does not matter: either You are newbie, admin, developer, expert – You not only should, but You must have knowledge about Developer Machine (in fact You must have The Machine) – especially for SharePoint (2010 or 2013).

BOOKLET__WS_SharePoint2013DevelopmentMachineFor less than 7 dollars You get chapters:

· Introduction and Credits,

· Virtualization Choice

· Local Development Environment

· Preparing A Single Machine Setup

· Setting Up Office Web Apps

· Installing Office Web Apps Server

· Summary

readable on any Kindle devices – in fact I have no one (all my Kindles are Kinndle App).


Is a book or not a book? Is a part of bigger project, 80 pages oriented for most important part for any SharePoint Administrators: The Development Environment. I still remember many of problems with my first SharePoint Production Environment without Development part (Yes, It sounds weird). Now the world has changed. We have…

Virtualization Choice – which is too productive to ignore. Now on one physical laptop, or servers or servers with storage, or network storage – in many ways we can use virtualization: VirtualBox, Boot to VHD, VMWare, Hyper-V, and The Cloud. Of course Physical Site Development Machine sound really good, but… You can’t get it with You, and You can’t work with them with Your favourite music (even is Rammstein, Gershwin, Karsh Kale or DJ Cheb I Sabbah). When You choose right option You should focus to…

Development Choice – depends of our business (and skills) You can use web browser, command line, SharePoint Designer and Visual Studio to developing Your solutions. As always different methods give You similar or different results, but You should know as much as possible about…

possibility of choosing right machine. First – You should think about disk: better SDD than SATA, memory: better 12GB than 8GB (but not always) and processor: better newest than older. Second – You should thing about performance: like mSATA SSD and speed: like single file and security: like RAID. Third – remember about anemia. And not fight with that: “Your Anemic Domain Controller with 20GB HDD and 768 K RAM” is enough.

Prerequisities is a huge list: Windows Server 2008 R2 x64, SQL Server 2008 R2 x64, plus service packs, plus cumulative updates, plus security updates and before SharePoint 2013 x64: ,BET Framework 4.5, IIS Role, Application Role, WCF 5.0, MSIPC, PowerShell, AppFabric, WIF, Azure, Excel, MDS, RBS, Office, Silverlight, popular browsers. And when You collect everything You can…

Prepare Single Machine Setup where You spend one day. With many advices from Sahil Malik You will do it quick, but remember about documenting Your environment from the beginning. Which advices? dcpromo, fqdn, dns, designer, sql server instance features and shared features, preparation tool, port 40000, web server extension 15 and many, many more. For SharePoint 2010 Installation and configuration was enough. For SharePoint 2013 we have something special called…

Office Web Apps which is something new, something interesting, something administrator’s time consuming, something users experience improving (hope You’ll understanding me). In this part You can learn how install second machine, office web apps, prerequisites and (!!!) PowerShell. Questions? Get-Help. After that, after meeting WOPI, after SSL with FQDN and simple configuration

You will be hungry. Like me.


Product Details

  • File Size: 1767 KB
  • Print Length: 81 pages
  • Publisher: Winsmarts, LLC (October 27, 2012)
  • Sold by: Amazon Digital Services, Inc.
  • Language: English
  • ASIN: B009Y4QZT8
  • Text-to-Speech: Enabled
  • X-Ray: Not Enabled