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,549 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

14 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,469 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

15 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)

6,838 reads

Identifying records with special characters (Unicode)

by ermrlehkara

SQLdose

Identifying records with special characters

2018-08-07

23 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

549 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

22 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,157 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

12 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

Azure Cloud Chronicles with Microsoft MVPs YouTube Channel

T-SQL Tuesday #188: Growing the Community

Unveiling the Legacy: POSTGRES to Modern Open-Source Powerhouse

Forums

Report Table/view or SP in SQL to handle various reports

Each database having its own disk?

the value of the effectiveusername xml for analysis property is not valid

Question of the Day

Independence Day