Solving tech problems

25.04.2014

Fixing Iconia W700P WI-FI unstable connectivity (losing connection)

(source: menspsychology.com) After my laptop died I was forced to work on Acer Iconia W700P tablet which is great piece of hardware (I wrote about it here) and after fresh installation I come to the problem that WI-FI network adapter was losing connectivity every 10 minutes. It was a real frustration so I searched for solution and found in one forum that you should try to do these two things: Control Panel > Network and Sharing Center > Change adapter settings > Find your WI-Fi network adapter > Right click…read more

22.12.2013

Top 10 query optimizing tips for MS SQL Server

Databases

During my 15 years of experience and working on various projects that involved using MS SQL Server in combination with C# programming language, and also gathering knowledge from different conferences, especially from the last one that occured today at SQL Saturday by ApexSQL where Miloš Radivojević showed some tips, I tried to summarize this knowledge in a small list of recommendations that you should be aware of when writing the Transact SQL queries… 1. Using local defined variables When possible always try to use direct values instead of variables (this…read more

20.11.2013

How to create Linked MS SQL Server in Management Studio?

Databases

Creating MS SQL Linked Server means that you can access your remote MS SQL database (on other server) like it is local. Syntax to access some data is as simple as that: [linked server name].[database name].dbo.[table name] Official Microsoft documentation is really sometimes hard to use. A lot of information but none practical example of usage. Google search also didn’t helped much on the first try. After few tries I finally found out how you can add MS SQL Linked server to your existing database server. So, you need first…read more

When Microsoft make descriptive error message…

Technologies

We came to this error when rendering one ASP.NET MVC page: Only Content controls are allowed directly in a content page that contains Content controls. Very strange formulation butit means that you have some error in your View (maybe missing </asp:Content> or without its opening tag)

23.09.2013

MongoDB vs MS SQL Server Comparison

Databases

We are using both databases for our projects and we can finalize some thoughts on both of them… Mongo Facts Free – official website is here and you can download it here Because it is using NoSQL concept it is really extremely fast when it comes to the inserts into database. It is almost fast as writing directly into the disk. It is at least 10 times faster when doing inserts. Because is is using NoSQL there is no scheme, you just store your object into database (JSON serialization is…read more

31.05.2013

Windows 8 Annoyance

Systems

There were a lot of talks regarding the WIndows 8 first screen optimized for touch devices and yes, I don’t like it at all also. Just trying to skip it as soon as possible and come to the desktop. Touch devices with Windows 8… Anybody buying this? Satisfied? Personally it would be useful to have Surface PRO – thin as iPad with cover as a keyboard as a travelling machine from which you can do interesting work or system administration when you are out of the office. I don’t like…read more

25.03.2013