Click here to Skip to main content
15,435,745 members

Articles by Maciej Los (Tip/Tricks: 7)

Tip/Tricks: 7

RSS Feed

Average article rating:

No articles have been posted.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.39

Containers
Docker
17 Feb 2019   Updated: 17 Feb 2019   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 6,501     Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
This tip is for those who have installed PostgreSQL server on QNAP NAT server in Container Station (docker) and want to enable remote connection to that server. Note: NAT server is over the router!
Database Development
SQL Server
11 Feb 2013   Updated: 13 Feb 2013   Rating: 4.96/5    Votes: 9   Popularity: 4.74
Licence: CPOL    Views: 56,014     Bookmarked: 13   Downloaded: 2,487
Please Sign up or sign in to vote.
This tip is desired for those who want to list all available SQl Server instances that are in a network.
Productivity Apps and Services
Microsoft Office
27 Dec 2013   Updated: 3 Jan 2014   Rating: 4.65/5    Votes: 9   Popularity: 4.44
Licence: CPOL    Views: 37,618     Bookmarked: 9   Downloaded: 1,560
Please Sign up or sign in to vote.
This tip shows how to get data from multiple workbooks using one OledbConnection.
17 May 2017   Updated: 17 May 2017   Rating: 4.00/5    Votes: 5   Popularity: 2.80
Licence: CPOL    Views: 26,823     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
This is an alternative for "Copy Rows Within Excel Sheets via VBA"
Programming Languages
C#
6 Feb 2019   Updated: 6 Feb 2019   Rating: 3.55/5    Votes: 3   Popularity: 1.69
Licence: CPOL    Views: 6,004     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
C# helper class to convert date into words
SQL
6 Dec 2014   Updated: 9 Dec 2014   Rating: 4.15/5    Votes: 4   Popularity: 2.50
Licence: CPOL    Views: 41,070     Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
This tip shows how to use CTE to find character repeated in a string few times.
Visual Basic
19 Jun 2014   Updated: 19 Jun 2014   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 18,911     Bookmarked: 6   Downloaded: 251
Please Sign up or sign in to vote.
If you want to know the way you can serialize and deserialize custom class collection, this tip is for you.

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.
Team Leader
Poland Poland
I'm a lawyer, teacher/trainer and author of VBA programming book (only polish version). Programming is my hobby and the source of extra earnings!
  1. C#
  2. SQL
  3. Linq
  4. VB/VBA/VB.NET
  5. XML & XSL


If you want to contact me... find me on LinkedIn.