Rss Feed

Announcement

Friday, 22 April 2016

Chrome Developer Tools




CHROME DEVELOPER TOOLS

Hi Geeks! How are you? Hope you all are doing well, rather I should say you all are coding well! Anyways, just to help you out, writing this post to make coding experience much easier and less time consuming. There are lots of tools available for the developers to code while having a cup of coffee! Some of the tools that might help you during development are available as Google Chrome Extensions that you can directly add to your Google Chrome browser.

Some of them are as:

Don't want to miss any post? Just

Subscribe to our posts

Monday, 18 April 2016

SQL SERVER – SQL Server Encryption and Decryption with Script


Encrypt and Decrypt in SQL Server


Steps for encryption and decryption cell values in SQL Server.


Step 1: Create table and populate data.
Create a Master key(DMK-Database Master Key)

CREATE TABLE TestTable (Id INT, TextValue VARCHAR(50))
GO

INSERT INTO TestTable (Id, TextValue)
SELECT 1,'First'
UNION ALL
SELECT 2,'Second'
UNION ALL
SELECT 3,'Third'
UNION ALL
SELECT 4,'Fourth'
UNION ALL
SELECT 5,'Fifth'
GO

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Teciners#123'
GO
The master key (DMK) in a database is encrypted by SQL server using its service master key (SMK).
SMK is created by a SQL Server instance when it starts up the very first time after installation. For any set of instances of SQL server, the SMK will always be different. So, the DMK in the database will be encrypted differently on each server.

Don't want to miss any post? Just

Subscribe to our posts

Sunday, 31 January 2016

THE SCRUM FRAMEWORK - PART 3


This is in continuation with The Scrum Framework Part 2. Please read Part 2 before proceeding with this post. This is the last post in the series THE SCRUM FRAMEWORK. So let us begin with the last part of the series.

SPRINT REVIEW 


A Sprint Review is held at the end of the Sprint to inspect the Increment and adapt the Product Backlog if needed. During the Sprint Review, the Scrum Team and stakeholders collaborate about what was done in the Sprint. Based on that and any changes to the Product Backlog during the Sprint, attendees collaborate on the next things that could be done to optimize value. This is an informal meeting, not a status meeting, and the presentation of the Increment is intended to

Don't want to miss any post? Just

Subscribe to our posts

Friday, 11 December 2015

THE SCRUM FRAMEWORK - PART 2


Hey Guys, this is the second post in continuation with previous one THE SCRUM FRAMEWORK. If you are reading this post first time, I strongly recommend to go through the previous post: The Scrum Framework, for better understanding of this post. As we promised in our previous post, in this post we will discuss the following points related to SCRUM Framework:


SCRUM EVENTS

THE SPRINT

CANCELLING A SPRINT

SPRINT PLANNING

SPRINT GOAL

DAILY SCRUM

So, lets begin our journey to The Scrum Framework. . .

Don't want to miss any post? Just

Subscribe to our posts

Monday, 30 November 2015

THE SCRUM FRAMEWORK

THE SCRUM FRAMEWORK IN 30 SECONDS


After reading this post we must be able to understand what exactly is SCRUM framework? and what it is used for? When and where to use SCRUM?

WHO CREATED SCRUM?

Jeff Sutherland Created the SCRUM Process in 1993 and used the term SCRUM for comparing high-performing, cross-functional teams similar to that in a RUGBY Game.

What is a SCRUM?

SCRUM is a term used for a team that forms a ring of people with their hands interlocked around each others shoulders and the team march forwards to pull the ball towards their side. It's a term used to describe a circle formed in a RUGBY Game by the players.

SCRUM is the leading agile development methodology, used by Fortune 500 companies around the world. SCRUM is an Agile Framework for completing complex projects. SCRUM was originally formalized for software development projects, but it works well for any complex, innovative scope of work. The possibilities are endless. The SCRUM Framework is deceptively simple.

It is lightweight, Simple to understand, Difficult to master. Actually, SCRUM is not a process or a technique for building products; rather,

Don't want to miss any post? Just

Subscribe to our posts

Monday, 14 September 2015

TVF Pitchers


TVF- THE VIRAL FEVER

Before I begin with the Web Series, Let me introduce about TVF. What is TVF? TVF-ONE : India's Premium Online Entertainment Network, owned and operated by 'The Viral Fever Group'. TVF-ONE is India's first and biggest Organized OnlineTV, where you can watch regular shows and content, created especially for the young audience, across genres like Humor/Drama/Trends etc. on its channels 'TVF-Qtiyapa' & 'TVF-RecycleBin'. The Viral Fever or (TVF), Founded by Arunabh Kumar, is a new age Media Brand, driven by the spirit of "Lights...Camera...Experiment !" with businesses in Branded Content, Live Events, TV Shows, Production Services and Youth Entertainment.

Don't want to miss any post? Just

Subscribe to our posts

Saturday, 9 May 2015

Fetch one or all record from table conditionally.

Retrieve single or all recordsWHAT WE WILL WE LEARN IN THIS POST?

After reading this post we must be able to fetch one or all record from the table conditionally. We will fetch one record based on the condition mentioned in where clause or all records when a particular value is to be retrieved. i.e., we can either select one record of our choice or all records when we choose some particular value. This is useful when we need to fetch single record or to display all records to the user. Either show selected record or all records.

HOW WE ARE GOING TO ACHIEVE THIS?

We will use most common, simple select statement and some variables along with Boolean Logic. Why Boolean Logic? Because we won't use case or if else statement.

Lets begin our excursion...

Don't want to miss any post? Just

Subscribe to our posts

Saturday, 21 March 2015

Split function in SQL

Split() function in SQL

Unlike Split() function in C#, we don't have any pre-defined in SQL, that splits the string containing the delimiter. While during development, it is sometimes required the functionality of split function similar to that of C# in SQL too.

After a very long time, techiners back again with a new post that will explain the process of creating a function that split the string containing the delimiter, which accepts two parameters- one string and other delimiter.

The first parameter is the string that contains the delimiter and needs to be split across it.

So without much ado, lets start...

Don't want to miss any post? Just

Subscribe to our posts

Thursday, 4 December 2014

Json Size Limit

json size limit techiners
This post will highlight a very common error that comes often when we visit a webpage/website that uses AJAX. We know that in AJAX we have anonymous functions like: success, error etc. success gets called when our ajax request gets successfully completed and it returns a response whereas error gets called when ajax encounters a problem in processing a request.

Don't want to miss any post? Just

Subscribe to our posts

Thursday, 6 November 2014

How to create a pop up window

Create a pop up window

create a pop up window using jquery in mvc4 techiners.in
Sometimes in our application we need to take input dynamically from the user such as when a user tries to submit a form which contains a drop down for selecting a Country that is mandatory, but the Country is not present in the drop down list which the user wants to select. If this is the case, than probably user will select any country in order to get rid of the error message of selecting mandatory country. There must be a way to dynamically add new country. So, In this post we will learn how to create a pop up window using jquery that will allow the user to add new country simultaneously loading it into drop down and make available for selection.

So, let us begin our step-by-step procedure to add a pop-up so that the user need

Don't want to miss any post? Just

Subscribe to our posts