Tag Archives: Beginner

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

How to Make Two Buttons Take 50% Width in Android Layout

If you are not just yet very familiar with Android SDK, how its components work and what properties mean – you may find yourself struggling trying to do very simple things like having two buttons on the screen, each taking … Read More »»»

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

How to Close Your Android Application on a Button Click

It’s a common thing to have a button in your application that will close and exit it, especially if you are used to Windows. In Android, however, it would normally be the operating system itself that takes care of such … Read More »»»

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

Writing Your First Android Application: A Hello World Example – Part 2 – Understand the Application File Structure

Now that you have a working application open in Eclipse, there are all these crazy-ass files under Package Explorer that were created by the plugin. So, what do they do and which ones will you be dealing on a daily … Read More »»»

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

Writing Your First Android Application: What Do You Need to Start Developing an Android App?

So you decided to play around with Android and write an application. Your starting point is, of course, what do you need to write an app, possibly what language is it written in, and is there an IDE that you … Read More »»»

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

Avoiding Deadlock Transaction Errors by Using ROWLOCK Hint in T-SQL

When updating a single row data in a table, it may take a nasty while if the table is big and you have a condition in a WHERE clause on a column that is not indexed. In this case SQL … Read More »»»

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

How to Use NOLOCK and ISOLATION LEVEL to Optimize T-SQL Query Performace

In this article, we will discuss how a NOLOCK hint can help improve performance of queries. Suppose you have a table: CREATE TABLE Users ( UserId INT PRIMARY KEY IDENTITY(1, 1) NOT NULL, FirstName NVARCHAR(50) NOT NULL, LastName NVARCHAR(50) NOT … Read More »»»

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

How to Access Your Model Data in .NET MVC With Razor Engine for Beginners

It may be a little frustrating to start your first MVC application using Razor engine, especially if you have never used it before. Here are some interesting pointers for beginners: First, when you created your first solution, Visual Studio will … 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