Tag Archives: Microsoft

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

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

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

How to Calculate the Number of Seconds Since Last Epoch (1/1/1970) in T-SQL

In certain situations, you may need to calculate the number of seconds that have passed since the start of the epoch. In computer world, the start of the epoch most often refers to the Unix epoch, also known as Unix … Read More »»»

Posted in Quick Tips | Tagged , , , , , , , , , , | Leave a comment

Create a SQL CLR Stored Procedure Using .NET (C# Example)

T-SQL is limited in its functions and getting the results you need sometimes becomes very complex and the statements used consequently hard to decipher. With SQL Server 2005, Microsoft introduced CLR (Common Language Runtime) technology which allows you to use … Read More »»»

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

What is CLR, How to Check If It is Enabled and How to Enable It

CLR stands for Common Language Runtime and is a technology developed by Microsoft that allows you to use managed .NET code in SQL Server environment. In other words, you can write your stored procedures, triggers and user-defined functions, aggregates and … Read More »»»

Posted in MSSQL | Tagged , , , , , , | 1 Comment

Microsoft .NET MVC Framework: How to Use Named Anchors (URL Hash Links) in Html.ActionLink

In HTML you can specify which part of the page you want to scroll to if a user clicks on a page using the hash symbol (#) like this: My Topic … Given how MVC works differently and the URL … Read More »»»

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

Microsoft .NET MVC 4 Framework: How to Add a Custom Attribute to <%@ Page %> Directive of a Generic ViewPage Class

In Windows Forms .NET projects, adding a custom attribute to the <%@ Page %> directive is easy – all you have to do is simply create your base class that inherits from the System.Web.UI.Page class and add a public property … Read More »»»

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

Tutorial: Microsoft .NET MVC Framework, Part 1: Building You First Page

While you may know what a Model-View-Controller architecture is (if you don’t I suggest you learn it first), you probably could use some tips and guidance on how to create your first page using Microsoft’s .NET MVC Framework if you … Read More »»»

Posted in MVC | Tagged , , , , , , , , , | 1 Comment

Standard OpenXML Cell Numbering Formats

When working with OpenXML documents, you can always specify a numbering format implicitly in the stylesheet and then set it on a desired cell or cells. If you choose to use those, your custom numbering formats are going to start … Read More »»»

Posted in Microsoft Excel | Tagged , , , , , , , , , | 1 Comment