I am a senior software programmer who is still working hard to get a DBA hat. I am in love with SQL Server. SQL Server for me is all about passion. I am MCSA in SQL Server. Through this blog I am giving myself an opportunity to learn more about SQL, as well as sharing my knowledge and expertise with the world.

Using RANKX in Computed Column and MEASURE

by ermrlehkara

SQLdose

This is my first blog for PBI – DAX. I lately started working on DAX and trying to understand it in...

2018-11-22

5,667 reads

Using RANKX in Computed Column and MEASURE

by ermrlehkara

SQLdose

This is my first blog for PBI – DAX. I lately started working on DAX and trying to understand it in depth. While looking for a DBA hat, getting...

2018-11-22

46 reads

Interview Query – 1

by ermrlehkara

SQLdose

Somewhere on internet i found this question. Thought to share it with you all.
We have two tables, school_students and Class_student.

...

2018-09-17 (first published: 2018-09-04)

2,502 reads

Interview Query – 1

by ermrlehkara

SQLdose

Somewhere on internet i found this question. Thought to share it with you all. We have two tables, school_students and Class_student. ...

2018-09-04

45 reads

Identifying records with special characters (Unicode)

by ermrlehkara

SQLdose

Occasionally Data analyst may fall in a situation, where they need to identify records holding special characters or only the...

2018-08-24 (first published: 2018-08-07)

8,123 reads

Identifying records with special characters (Unicode)

by ermrlehkara

SQLdose

Identifying records with special characters

2018-08-07

58 reads

Starting with MS SQL Server

by ermrlehkara

SQLdose

In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is...

2016-04-10

581 reads

Starting with MS SQL Server

by ermrlehkara

SQLdose

In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is SQL. Now let us start with basic of...

2016-04-10

49 reads

SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.

by ermrlehkara

SQLdose

Hi Guys,
When you generate a script to create a Stored Procedure, below three statements are generate by default.
SET ANSI_NULLS on
SET NOCOUNT on
SET...

2015-12-30 (first published: 2015-12-17)

10,288 reads

SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.

by ermrlehkara

SQLdose

Hi Guys, When you generate a script to create a Stored Procedure, below three statements are generate by default. SET ANSI_NULLS on SET NOCOUNT on SET QUOTED_IDENTIFIER on Why do we...

2015-12-17

40 reads

All authors

Using RANKX in Computed Column and MEASURE

Using RANKX in Computed Column and MEASURE

Interview Query – 1

Interview Query – 1

Identifying records with special characters (Unicode)

Identifying records with special characters (Unicode)

Starting with MS SQL Server

Starting with MS SQL Server

SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.

SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.

Blogs

Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?

Keeping Track of my ConEmu CLIs

10 Decisions to Make Before You Create A Fabric Workspace

Forums

A design question in a parent child relationship

Hyperscale Replicas III

Development Is Fun

Question of the Day

Hyperscale Replicas III