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. …
Ever building a code, which you would like to have in every program you make? Most probably. So, if you are coding in C#, this is the way to do it – through libraries. So, these are the steps: In …
This Wednesday I have not participated in the CodeForces competition – I was either too tired on Wednesday or I had something better to do. 🙂 Anyhow, I have just taken a quick look at the first two problems of …
Coding in C# is always fun, when you come from the VBA Excel world. There is much cool stuff, which you see and then you start wondering – why is this not implemented in VBA and why should I write …
Some time has passed after I have received the JavaScript Object Programming for a review from Apress.com. Actually, much more than expected, considering the size of the book of only 95 pages (w/o appendices). Let’s write something about the book …
In Part 1 here I have shown the code that gives full points in the interactive CodeForces.Com problem for Bear And Prime.The trick is that writing hard-coded values in a code is really far away from a good practice in …
C# – Algorithm – Bear And Prime, Interactive Problem in CodeForces – Part 2 Read more →