Tag Archives: Examples

How To Programmatically Flush log4net Message Buffer

If you have set a buffer size on one or more of your log4net appenders, the logger will buffer the messages before dumping them, for instance, into a file or a database. That optimizes the performance but what if you … Read More »»»

Posted in C# | Tagged , , , , , , , , | Leave a comment

Calculating Statistical Values in T-SQL: Mean (Average), Median, Mode and Range

Sometimes you may need to calculate statistical values based on a set of values you have in a table. Let’s start with explaining what these values represent, in case you don’t already know. For the purposes of this post, we … Read More »»»

Posted in MSSQL | Tagged , , , , , , , | Leave a comment

How To Change A Bootstrap Popover Title And Content Dynamically

Typically, when creating a bootstrap popover, you would declare, initialize and call it like this: Do Something $(function() { $(‘[data-toggle=”popover”]’)({ trigger: ‘manual’, placement: ‘auto top’, delay: { show: 500, hide: 500 } }); }); function doSomething() { $(‘#do-something-popover’).popover(‘show’); } However, … Read More »»»

Posted in Bootstrap | Tagged , , , , , , , , , | Leave a comment

New Features of C# 6 You May Find Quite Useful

C# version 6 came out with the release of Visual Studio 2015. It includes quite a few useful features for the developers. Here is a list of the ones that will make a day for any developer who has been writing … Read More »»»

Posted in C# | Tagged , , , , , , , | Leave a comment

How To Flush PRINT Buffer in T-SQL, Or Output Messages In Real Time

When debugging SQL scripts, oftentimes the developer or DBA would want to see what is happening as the script executes. While it is possible to set up breakpoints in SSMS and step-into/-over code, sometimes all that one wants is to … Read More »»»

Posted in MSSQL | Tagged , , , , , , , , , , | Leave a comment

Cool Multi-Colored Blur Effect With Multiple Shadows Using CSS3

With CSS3 and HTML5 getting widespread and most of the browsers supporting their major features, you can code a lot of things right there and then, as opposed to having to have to fire up Photoshop or another image editing … Read More »»»

Posted in CSS | Tagged , , , , , , , , , | Leave a comment

C# Yield Statement Demystified With Examples

The yield statement has been released with .NET 2.0 framework, but many still do not know what it does. In a nutshell, it does transformations – obtaining a result dataset given an input dataset. Since the time yield has seen … Read More »»»

Posted in .NET | Tagged , , , , , , , , | Leave a comment

How To “Take Ownership” Of A File Or A Folder And Add It To Right-Click Context Menu Of Windows File Explorer

At some point in time you may come across a file or a folder that Windows denies you access to, even though your account belongs to the Administrator group. If this is the case, you would want to see if … Read More »»»

Posted in Windows | Tagged , , , , , , , , | Leave a comment

Creating A Phone Number Input Control With Javascript

In this article I am going to show you how to create a cool phone number control in HTML using Javascript. Surely you have seen forms where you are asked to enter a phone number in three boxes – one … Read More »»»

Posted in Javascript | Tagged , , , , , , , , , , | Leave a comment

Find a String Value in the Whole Database: Searching for Text in Tables and Columns

Once in a while you may come across a problem when you are not familiar with the database structure you are dealing with. You may have to deal with the front end only and values that are only presented to … Read More »»»

Posted in MSSQL | Tagged , , , , , , , , , , , , , | Leave a comment