[HU]/[EN] Reminiscence Boulevard: Lengyel, magyar – két jó barát

Lengyel-magyar két jó barát
Együtt harcol s issza borát
Vitéz s bátor mindkettője
Áldás szálljon mindkettőre

This short and old story is about friendship between peoples from Poland and Hungary. Few months ago I meet in Budapest two new hungarian friends: Zoltán Horváth {TWITTER} and Janos Berke {TWITTER}. We talked about community, knowledge, experience, user groups… and I have been invited for Hungarian User Group for Microsoft SQL Server Meetup. In November I had chance for organizing my trips together and found the solution. In fact I should say: I maintained MeetUp Speech.

November végén két SQL Server MVP-től lesz
meghallgatható egy-egy előadás.
A magyar SQL Server MVP-k korlátozott száma
okán ennek a felét importból oldjuk meg

LOGO__HUH-MSSQLOn Wednesday 27th in LogMeIn HQ over forty Hungarian SQL Folks came for listening two sessions at MeetUp. Location is amazing, especially 5th floor, with big kitchen, open space with pool table, flippers, kinnect and beautiful terrace. Pleace where You want to work. Zoltán opening speech was in Hungarian, and I don’t understand anything except SQL Saturday. They have a plan (and formally started to executing this plan) for SQL Saturday in Budapest – this event will be held at 1st March 2014. Next I had a great honour to presenting session about Ad-Hoc Maintenance Plans for Beginners. Session based on Brad McGehee book (link for free ebook here) Brad’ Sure Guide to SQL Server Maintenance Plans published by RedGate. In one moment I recognized that something is wrong with me or audience. Asked and got answer: for forty attendees just obly TWO have been DBA! All athers (almost)… DEV. Yeah. Simple. But I tried to talk with them, and discovered that they are interesting in this subject, and having partial knowledge about administration od SQL Server databases. And they started to be more active (mayby by the swags from RedGate…).

All break we spend on discussions, some peoples were very focused for maintaining, especially for SHRINK (!sic) data and files. The conclusion is simple: bad architecture of environment, default installation and very, very limited space. Bad, bad patterns.

After break I take a part with second session provided by only one SQL Server MVP form Hungary Kővári Attila {TWITTER}. He presenting BI stack: Excel, PowerView, PowerMap and few other features. All in Hungarian: sessions, questions, answers, office, windows, maps, views. Interesting experiment for me. But I saw that audience like it. They have many questions, they were very active.  And Kővári is really good speaker. Wishing to know Hungarian in “understandable mode” for his next session.

At the end I want to say Köszönöm for organizers: Zoltán & Janos & magic girl from LogMeIn HQ, and for all attendees. Hope the new comers (about five peoples) will back in futures meetups. On my Facebook page You can see some Pictures at an Exhibiton and on my SlideShare profile You can download my slidedeck.


PS: See You in March in Budapest! HERE

[EN] New instalation versus existing feature: SQL Connect in VS2012

sql_connect_270x220My environment is not very complicated: just windows platform, some sql server instances, recording stuff, bloggers kit, visual studio installation and some third party (vendors) tools. One of them, installed ‘by default’ in my Visual Studio 2012 instance is SQL Connect by RedGate {LINK}.  Ingeniously simple database development in Visual Studio.  Connected, source-controlled database development in Visual Studio:

  • Develop databases in Visual Studio alongside application code
  • Query databases and execute stored procedures directly from Visual Studio
  • Track and share changes using your source control system

Very useful tool, especially when You think abou controlling your code, and data. I had installed, and fully updated Visual Studio 2012 environment, and tried install my RedGate’s SQL Developer Bundle (more about this ingeniously awesome pack in next posts). And I got an error:


Pict. 1 | in the process of installing full package, received error from SQL Connect 1.1 (MSI Error 1603)

On Microsoft Support page we can find information about cause of this error – KB834484:

You may receive this error message if any one of the following conditions is true:

  • The folder that you are trying to install the Windows Installer package to is encrypted.
  • The drive that contains the folder that you are trying to install the Windows Installer package to is accessed as a substitute drive.
  • The SYSTEM account does not have Full Control permissions on the folder that you are trying to install the Windows Installer package to. You notice the error message because the Windows Installer service uses the SYSTEM account to install software.

Because nothing of that is my cause I decided to skip this software in installation process, and installing all others software.


Pict.2 | result is green for me.

Next I back to problematic package, using both paths with installation: default by vendor (c:\… I never use partition C for any of files if I really needn’t it), and default by me (somewhere else).


Pict.3 | installation folder by default for this installation…


Pict.4 | cannot help me. Still got an error.

I checked my Visual Studio 2012 installation and I discovered that SQL Connect 1.1. has been installed. Hmmm.. maybe conflict? I de-istalled this feature from my Visual Studio {Menu/Tools/Extentions and Updates}. And run RedGate setup again.


Pict.5 | Got You. Finally green light.


It is a little strange for me. just installer crashed – better solution should be show me my mistake, like: “You have installed version. please delete other versions before you install this software”. Well, maybe Redgater’s could repair this installer, because this dependiences are important.

[EN] Visual Studio 2012 Cumulative Update 4 is available

LOGO__VisualStudio2012One week ago Microsoft published newest Cumulative Update Pack No 4 for Visual Studio 2012. When You download web installer file (VS2012.4 build no 11.0.61030.0) You should be ready for decreasing free space on your disk with amout of 660 MB for this update. Microsoft fixed several bugs (over eighty) submitted through connect site as follow:

  • Team Foundation Server
  • Windows Forms
  • LightSwitch
  • Debugger
  • Visual Studio IDE
  • Windows Development
  • Profiler
  • C++
  • IntelliTrace
  • .NET Framework Core
  • Entity Framework Tools
  • Phone tools
  • Localization
  • Visual Studio Test
  • Graphics Diagnostics
  • Web Tools
  • Diagnostic Tools

More information, with list of all fixes, and links You can find here on Microsoft Visual Studio 2012 Update 4 site. You can download installer directly from HERE, or just run Your Visual Studio and follow menu/Tools/Extentions and Updates…

This update could be applied for: Visual Studio 2012, when used with:

  • Microsoft Visual Studio Premium 2012
  • Microsoft Visual Studio Professional 2012
  • Microsoft Visual Studio Express 2012 for Web
  • Microsoft Visual Studio Express 2012 for Windows 8
  • Microsoft Visual Studio Express 2012 for Windows Desktop
  • Microsoft Visual Studio Express 2012 for Windows Phone
  • IntelliTrace Collector for Visual Studio
  • Microsoft Visual Studio 2012 Remote Tools
  • Microsoft Visual Studio Team Foundation Server 2012
  • Microsoft Visual Studio Ultimate 2012


PS > here is the site with all descriptions for all updates for Visual Studio 2012