The Blog

How to regain space after dropping columns in SQL Server

I hit an annoying issue today. I wanted to regain space after I dropped several columns in a table. When I run the famous query from StackOverflow:

I got a set of numbers which were the same before and after the removal has

There is, however, a potential issue with this approach if

Continue Reading

Transaction log is full due to LOG_BACKUP

Yesterday, when I was building a large DB from scratch I got an error saying:

Running this simple query solved the issue:

Continue Reading

The ALTER TABLE statement conflicted with the FOREIGN KEY constrain

I've been trying to apply a new migration and I was getting the following error: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_dbo.Parent_dbo.Childs_ChildId". The conflict occurred in database "parents_db", table "dbo.Childs", column 'ChildId'. In my case, the table contained data. Therefore, either you have to assign a default value, set it as

Continue Reading

MediaElement Not Firing Events

Today, we encountered quite an interesting problem. MediaElement wasn't firing events. Using simple speech synthesis on Windows 8.1 using the speech synthesiser we tried:

None of the variations worked. The speech worked just the event wasn't getting fired. After a bit of digging it turned out that in order to fire events MediaElement must

Continue Reading

Implementation Overview in FHIR

Paradigms In order to make FHIR interoperable, it was based on 4 paradigms: RESTful API Documents Messages Services This is what's called an exchange framework. REST FHIR was primary designed to be used with Restful services which handle all requests. Restful service implies that we have a choice between using JSON or XML and it

Continue Reading

My Woes with Oracle Databases

I have been extensively working with the Oracle Database over the last couple of weeks. I thought I would share some of my experiences. The version I've been playing around isn't the newest, but, it roughly compares with the versions of MySQL and SQL Servers when I was learning databases. There is quite an interesting

Continue Reading

Architectural Views

Architectural views represent a perspective of looking at a particular problem solution. There are different standards. And different versions of diagrams. That is because one diagram rarely would give you everything you'd want. So you sort of mix and match. We have to recognize that there are many stakeholders in the system: from architects themselves,

Continue Reading

Databindings - small values treated as 0s

Today, I encountered an interesting problem with WinForms. In the application, NumericUpDowns (shown below) were used with small values e.g. 0.00001 etc. However, after we refreshed the panel, the value was being set to the default value. Digging further into the problem it turned out that the default Microsoft DataBinding converter was unable to convert

Continue Reading

How to use - (dash) in the ASP.NET MVC call?

ActionName attribute can be used:

 

Continue Reading

Undirected Graphs

Data structures capture relationship between the component values such as succession or relative magnitude. Graphs data structure is a very general representation of binary relations recorded as edges between a collection of vertices. There are many variations and extensions of graphs such as labelled vertices, labelled edges, root verities, multi-edges etc. However, in this article

Continue Reading