In .NET, finding SQL instances in network is very simple, in fact it requires only to use an instance of SqlDataSourceEnumerator
Read more…

This is something that can be very helpful if you’re working with SQL Server Express (2005/2008). Other versions have a SQL Server Profiler where you can easily add trace without having to write code.
Read more…

This is very simple php WebService that returns data in JSON format. I have created it to test my jQuery component, especially features like pagination and sort which are taken on server side.
Read more…

I have always lacked group concat function in SQL Server. Fortunately since SQL Server 2005 there is a possibility to carry out that functionality.
Here’s how I do that:
Read more…

Since Linq has become very popular for .NET application I have less and less often chance to write something in SQL on Ms Sql Server. Last time I had that chance when i needed to write function for extracting number parts from string.
Read more…

For my last project I needed to create wizard application using c#. Sadly differently than in VC++, Visual Studio doesn’t have an appropriate project type for .NET platform so I had to write it from scratch.
Read more…

When i was working on recent project (HR system) I had to implement the functionality of a Gantt chart. I found very cool, lightweight, jquery plugin jQuery.ganttView which is easy to use and fast. Currently it was working in our first version of system.
Read more…

Some time ago I had FreeBSD disk from which I needed to copy some data. It was system disk from our old product server. Current server runs the 64 bit version of CentOS 5.5, so there was no straight method to just plug & mount it without additional configuration.
Read more…

I was developing ASP.NET application recently which one of basic functionality was sending emails to its users.
I decided that sending html emails will be much more cool then just in plain text.
Below is an example, how this can be done. This code sends email both in HTML and plain text. Read more…