Skip to content

Silviu Ardelean

Getting Table’s indexes experiences – workaround

Trying to get table indexes information in SQL Server 2012 I identified a strange situation within a specific method that I was using so long but it was not acting as expected in one situation.

Usually, I got the right information about indexes but in one situation I encounter a strange behavior. It’s about having a clustered index into a scenario.

I have a table that contains two indexes referenced to some fields: IndexField_1 and IndexField_3 mapped over int, NULL fields. When IndexField_1 is Non-Unique, Non-Clustered and IndexField_3 is Clustered index I get the right information.
But if the index IndexField_1 is Clustered and the IndexField_3 is Non-Unique, Non-Clustered I get no information about IndexField_1 index (eg. szIdxName and szIdxColName are “” and their length is -1 that means SQL_NULL_DATA). Within while loop, with the next iteration I get correct information about the second index IndexField_3.

Ubuntu – How to fix update errors for a server behind of a proxy

If you’re behind of a proxy server and the IP address has changed (or proxy it’s a new node in your network topology) then probably when you’re trying to update your binaries then you’ll get a list of errors.
[bash]
W: Failed to fetch http://security.ubuntu.com/ubuntu/dists/oneiric-security/multiverse/i18n/Translation-en_US Unable to connect to 192.168.120.240:3128:
W: Failed to fetch http://security.ubuntu.com/ubuntu/dists/oneiric-security/multiverse/i18n/Translation-en Unable to connect to 192.168.120.240:3128:
[/bash]
This happens because you’re unable to connect to Ubuntu mirrors. In order to fix this issue you have to edit apt.conf file settings.
[bash]
root@my-server:~# vi /etc/apt/apt.conf
Acquire::http::Proxy “http://192.168.230.99:3128”;
[/bash]

Happy Birthday, Romania!

Today it’s the Nation Day of my country!

La Mulţi Ani, România!
Happy Birthday, Romania!
Joyeux Anniversaire, Roumanie!
Alles Gute zum Geburtstag, Rumänien!

Fun IT – 2011 Collection

Here it is a collection of funny topics that I met this year in my daily activities. In case I will get new info, the topic will be updated!

Nobody is perfect and especially the software! 🙂 But it’s nice to immortalize funny things.

Simple Pictures Unifier 1.1 application is up!

At the beginning of this year I launched an application that helps you to organize the pictures of your important moments. The application helps you specially if you have photos from different sources (different cameras of friends) and you want to have a fluent images story.

From the moment I have launched the first release until now I made up to 12GB pictures (3200+ pictures of 10 MB) and honestly I never found time in order to organize the pictures. Always I rescheduled the application improvements and finally I found time to implement export by date time folders and so on.

Simple Pictures Unifier 1.1 allows merging and exporting pictures in one folder or in date time folders. Simple Pictures Unifier 1.1 comes with a better user friendly experience and few internal improvements.