There is a simple way in VBA and in Python to create tables in the database you need, giving the tables a name of a variable and the type of a variable. In SQL Server, we also have a way …
SQL Server – Create two tables with primary and foreign key with SQL code Read more »
I have started to explain tricks with SQL Server in a series of articles about a week or two ago. Today I will use a database, mentioned in a previous article. Get data below average The task is to get top …
Some two weeks ago, I was coding in Python with Notepad++ as a text editor and I was getting really tired, because the program was not running the way I wanted it and I had to print a lot of …
As I have already started some time ago with SQL Server, in this article I will present the way to write a if-else case in sql query. The database is available here, I have used a sample DB for one …
SQL Server – Conditional Query And Multiple Tables Join (Many to Many Query) Read more »
So, after starting with SQL Server custom views, SQL Server Triggers, SQL Server Procedures and Functions, now it is time to pay some attention to SQL Transaction as well. What are transactions? Microsoft says the following: A transaction is a single …
So, continuing from yesterday with the SQL Server subject, it is time to introduce some nice ways of writing functions and procedures in SQL. What is the idea, behind the functions and the procedures in SQL? Pretty much, I would …
About 6 months ago I wrote about the way to create a log sheet in Excel with VBA. Nowadays, as far as I am doing a small upgrade from MS Excel to MS SQL Server 🙂 , I was interested …
SQL Server – create trigger to log changes in DB Read more »
Speaking about SQL, I have noted something really interesting in MS SQL Server Management Studio, which would probably be of use in MS Access as well. This is the saved custom view. It is not present in MS Access, but …
SQL Server – Create Custom View in Microsoft SQL Server Management Studio Read more »
The legend says that when the chess was invented, the inventor was asked to pick a price from the local king. Thus, he asked for one grain for the first cell of the chess board, 2 for the second, 4 …
SQL Server – Generate data in Microsoft SQL Server Management Studio Read more »
If you are interested in DB development, then most probably you have tried to generate a sql script from your database. In this article I will show you how to do it with Microsoft SQL Server Management Studio. So, lets …
SQL Server – How to generate sql script from a db Read more »
Yesterday, I have started to solve problems from a challenging Russian site for programming competitions. Today, I have decided to spend about 30 minutes on another problem, which seemed easy, but I am already spending hours on it, without being able …
Python – Algorithm Challenge – First Day At School Read more »
About 3 weeks ago, I have enlisted myself in some course for algorithms. There, one of the guys mentioned a web site for web contests and I have decided to take a look. The site is called Timus.ru and the …
The last week I was fighting with algorithms again. 🙂 Thus, I had to implement the mighty heap sort in C# and here is what I came up with. The idea of the code below is the following: In line 68 …
The Ultimate Review Team has been summoned today to make reviews of Sony Z2 and SWR30. Take a look at our epic selfie: The Beauty, the Geek and the Mighty Pig made 4 terrific video reviews (in their own opinion!) which …
News – The Ultimate Review Team has been summoned for first video review Read more »
Today, after playing some interesting board games, I was wondering about some probabilities with dice. As far as I did not want to calculate them with statistics methods (and it is always funnier to make a simulation), I have …
Python – Times the dice is same as previous or next Read more »
Today I had to write a solution of the following problem – imagine you have two lists like this: var liPhoneBook = new List<tuple<int,string>>(); liPhoneBook.Add(Tuple.Create(100, “Pesho”)); liPhoneBook.Add(Tuple.Create(200, “Gosho”)); liPhoneBook.Add(Tuple.Create(300, “Atanas”)); liPhoneBook.Add(Tuple.Create(400, “Az”)); liPhoneBook.Add(Tuple.Create(500, “Ivan”)); liPhoneBook.Add(Tuple.Create(600, “Ivan Petrov”)); liPhoneBook.Add(Tuple.Create(900, “Vitosh”)); List …
C# Algorithms – Phone Book Implementation – List of int and string with a tuple Read more »
Binary sorting is something trivial in algorithms – it is trivial, because a lot of people know how to do it, but because even those who claim to be the professors in algorithms and be the wise guys in the area …
C# Algorithms – Calculation of Squared Root with Binary Search Read more »
Since the beginning of the month, I am visiting a course called Algorithms. As far as I have to work with one of the following languages – C#, C++, Java or Python and somehow Python is rather slow for such …
C# Algorithms – Usage of Nested Lists and TryGetValue of Dictionary Read more »
After working out Selection Sort, Count Sort and Insertion Sort, I have decided to continue with the last easy sorting method – Bubble Sort in C#. The other advanced sorting, using recursion can also be found here, but I am …
How did it all start? When I was a student at the University of Sofia, I had to translate about 100 pages of the Greek Military Codex, which was quite an unpleasant task (if someone claims the opposite – run away from …
After writing yesterday about the insertion sort algorithm with Python here, today I have decided to continue with the algorithms. Thus, I have decided to take a look at two other simple sorting algorithms – Count Sort and Selection Sort. …
This is probably the shortest article I have written. After some time trying to install an environment for C# in my Mint and my Ubuntu systems, I found out the following: the name of the environment is MonoDevelop. the installation …
As I have already mentioned, the following 2 months I will be dealing with algorithms! Thus, I have enlisted myself in a course for them and I will be spamming my site constantly with some useful (mainly for me) stuff …
About 15 weeks ago, I was making my first steps in Python (sometimes it is a pity that I do not have dates on my articles, but I like it this way). During my first steps, once I had the …
This month I have finished with my Python course in HackBulgaria, thus I have decided to continue with a course, called Algorithms. The course had a requirement of three tasks, which should be resolved in a reasonable time. The first one …
Some time ago I started to interest myself in algorithms. Thus, I bought 2 books about them and I started to read 🙂 The first problem in the first book was explaining the Stable Matching Problem. The essence of the problem is that …
Some days ago, I have received the book Excel VBA 24-Hour Trainer for a review, upon a request from my site. After all, as far as it has all started with VBA for me, I am always interested in the latest trends on …
As you have probably noticed, I have reviewed quite a few books during the last two years in which I have started the site. The number of Amazon reviews is about 16 and currently there are two books waiting for a review. …
News – Strategic partnership with hategame.com for reviews of gadgets Read more »
So, some time ago I have started to create apps in Django with Python. It is really fun and amazing, what one can achieve with this package 🙂 E.g., I have generated a small app, counting words and analyzing their repeatability, …
Python Django – How to add css to django application Read more »
Packt Publishing, one of the publishing houses, which kindly provides me books for reviews and personal needs, has decided to present anyone with a different free e-book every day. This means, that if you go to this link, every day, …
Books – Free IT book from Pack Publishing Every day Read more »