ZealUps
Menu Close
  • Home

Month: January 2016

0

Podcasts for Improving English

Posted on January 26, 2016 by shiljo
podcast

Chinese/Mandarin holds the most widely spoken language in the world and English trails in third place. In the below tabular you can find Hindi, Bengali & Punjabi which are Indian languages. This figure is based on NationalEncyklopedin So here is the… Continue Reading →

Language English, Podcast

Validating Models with Fluent Validation

Posted on January 24, 2016 by shiljo
Fluent Validation

If you have model class and if that needs to be validated we need to explicitly write logic so initial days we were using Data Annotations and this is how code looked like   This way programming is good if… Continue Reading →

Programming .Net, C#, Validation
0

Query to know Process, Connection & Session of a DB

Posted on January 23, 2016 by shiljo
SQL Connections & Sessions

Every support team may come across once in their career to know about how many connections/sessions are in use. I have compiled the list queries which are specific a database. Microsoft SQL In this sysprocesses is a system table The following… Continue Reading →

Programming Microsoft SQL, Oracle, SQL
0

Alternate ways to Count the Number of Records in SQL

Posted on January 20, 2016 by shiljo
Count(*) Alternates

In SQL the generic way to count the number records in any SQL database is This works on all the databases but there are other alternates ways to find the number records of a table. Some are much more efficient… Continue Reading →

Programming SQL
0

SQL Puzzle – 1

Posted on January 20, 2016 by shiljo
SQL Problem

What are the various ways of retrieving the shaded part from the below diagram So here are the various of ways of retrieving the result. Every solution mentioned below has its own advantage and disadvantages. Here I have assumed both tables has a… Continue Reading →

Programming SQL, SQL Joins
0

SQL Joins

Posted on January 20, 2016 by shiljo

The following are the most commonly used joins Inner Joins Right Outer Joins Left Outer Joins Full Outer Joins Before going deeper into the topic For example two table Employee & Department table. So based on this I will explain… Continue Reading →

Programming SQL, SQL Joins

Categories

  • Language (2)
  • Mathematics (5)
  • Nutrition (6)
  • Programming (34)
  • Software (2)
  • Travel (1)

Archives

© 2021 ZealUps. All rights reserved.
Hiero by aThemes