Let’s state it straight every VBA developer is happy, when he can protect his own code. The VBE password is not secure protection, everyone with a few free hours and a good internet access can go around it. Thus, I was …
VBA – Protect your code – Unviewable+ and the Ribbon Commander Read more →
After writing the simple part here I think that it is a really good idea to introduce IntelliSense as well 🙂 Something like this in the code: And like this is in the library: The question is always one …
VBA – Add a C# library to a VBA project – Part 2 Read more →
For today I was thinking to present an algorithmic problem, but somehow I have decided to show something more useful. It is a Step-by-step instruction for the creation of a C# object in VBA. You know, that references, which you …
As mentioned some times ago, whenever I am looking for a subject to post, the easiest way is to go to Codeforces.com and simply take a problem from the second division. If I manage to solve it from the first …
C# – Algorithms – Arpa’s hard exam and Mehrdad’s naive cheat Read more →
CodeForces.com is really a nice place you can learn stuff. Learning by doing is probably what man actually needs in programming. Thus, I have taken the 2. Problem of the 2. Division in CodeForces, as far as it seemed interesting …
After some months, the time for the book review of “Pro SQL Server Administration” has come. I have always wanted to have a good, big Bible-like book for SQL Server (it’s a weird dream), and finally I have obtained one …
Its Friday, the week is finally over and as far as I was planning to write an article per week or so, I have decided to write something. In these cases, when I do not have something prepared, I simply …
C# – Algorithms – Grasshopper And the String – CodeForces.com Read more →
Imagine you have a spreadsheet with some numbers in it. And you need to read the first 130 numbers in the first 7 columns and save them in a list. Or something similar. Quite a strange task, but it happens …
Sometimes with Excel you receive an error message, saying “Too Many Different Cell Formats”. This is really hard to believe, because you have not done something bad or strange and yet you cannot finish your action. Still, Microsoft knows about …
On the 9.August I have published an article, announcing that I am a MTA in C# development. Now, some 2.5 months later, I am a Microsoft Certified Professional in Querying SQL Server 2012. Unbelievable! That’s why I was lately reviewing …
News – The owner of VitoshAcademy is a Microsoft Certified Professional (MCP) Read more →
Today I have not been very productive, after all it is Sunday and a person should relax. However, I have noticed the Intel Code Challenge in CodeForces, thus I have decided just to try the first problem. The problem seemed trivial, …
Some days ago, I was informed by Mrs. Poleg, that she has had published a new book concerning VBA and Excel. As far as VBA is the tool, that gives me bread and butter on the table, I was willing to …
Some time ago I have decided to go a little deeper into SQL. And by some time ago I probably mean some years. Anyhow, in this article I will present the ways I know to make XML out of SQL …
Creating triggers in SQL Server with T-SQL is both easy to be done and efficient 🙂 Thus, sometimes DB developers tend to write more triggers than needed and the efficiency sinks a bit. In this article I will simply write …
Today I have finished the reading of Relational Database Programming, brought to me kindly by Apress.com Thus the review is now here: The author is a SQL developer. He was “laughed” for being a not a “real developer” from some developers, …
Lately I have decided to put some more attention into SQL Server. Thus, I have kindly asked Apress.Com to provide me with some SQL books for review. The first one I have just finished reading was the book Beginning SQL …
Book Review – Beginning SQL Queries – From Novice to Professional Read more →
I have not been blogging for a while, because I got a little deeper into reading the SQL books, which are waiting for review and thus I have decided to blog about something today. Initially, the idea was to write …
You read it correctly. After the posts from this week, here and here announcing two new books for review, now I am announcing 3 more. This time, there is no book of 1000+ pages thus it looks doable. Hopefully I will …
The summer is slowly going away. And the new targets for the end of the year are set. Program minimum is the Microsoft MCP Exam in the Databases track. 🙂 In order to achieve it, I have asked Apress.com to …
Book Review – SQL Server Query Performance Tuning – Coming Soon Read more →
After becoming MTA (MS Technology Associate), I have decided to continue with the Microsoft Certification (MCP and MCSA) in the DB area. For this, I need to study a little more than for the MTA exam, so lets see what …
Book Review – Pro SQL Server Administration – Coming Soon Read more →
Everyone using google chrome browser probably uses some extensions as well. I personally use mail checker, Hola and ad-blocker. To be honest, I have never been never thinking how these extensions were made, until I have noticed the book “Creating …
Today, on this sunny Saturday I have decided to code a bit in order not to feel guilty in the evening, when I go out. Or something like this. 🙂 I came across of probably the hardest problem, given in …
Although I do not blog a lot about subjects outside programming and book reviews, I have decided that this one deserves a separate blog post. 🙂 Today I have passed the 91-361 – Software Development Fundamentals of Microsoft and I am …
News – The owner of VitoshAcademy is a Microsoft Technology Associate (MTA) Read more →
In this article I will simply let you know, that vitoshacademy.com has its own google extension now – it simply shows you the last 10 articles in the site and it lets you know if there is a new one. …
Google Chrome Extension – Building a simple extension for VitoshAcademy.Com Read more →
VBA tools are important for any vba developer – today I was thinking to summarize the tools I am using daily and to update the list of them with the time. The order of the tools is pretty much random. …
So, its time to review the “Databases for Small Business” – a book from Anna Manning, nicely provided to me by Apress.com for a review. Well, after reading it, I may say one thing – it is an interesting book, …
Today I was looking a bit over SQL Server and Visual Studio and I have somehow liked the nice cooperation between these two. Thus, I have come up with the idea to build a simple application, just to demonstrate how …
C# – Datagrid View – C# connect application to DB in Visual Studio Read more →
A week ago I was willing to find a way to unlock easily *.xlsb files. Thus, I have found the software of VbaDiff and I have kindly asked Mr. Chris Spicer for a review copy. It turned out that VbaDiff …
VBA – 5 questions to the VbaDiff developer Chris Spicer Read more →
Some time ago I had to open a VBA file saved as *.xlsb. The password protection for this was a little more difficult than the one for *.xlsm, thus after some research I have found a tool called VbaDiff, which claimed …
VbaDiff Review – VBA Software for source control with additional features Read more →
The last few weeks I was busy, enjoying the nice landscapes of Bavaria and reading Learn PHP 7. The first one was more interesting than the second one definitely, but still reading the book was nice in its own way. …