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

15 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

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

7,234 reads

Identifying records with special characters (Unicode)

by ermrlehkara

SQLdose

Identifying records with special characters

2018-08-07

24 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

551 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,220 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

14 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

The fundamental requirements of a reporting system

Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management

Check Power BI report interactions with Semantic Link Labs

Forums

SQL MI Next-gen general purpose tier

Create an HTML Report on the Status of SQL Server Agent Jobs

The Last Good DBCC Run

Question of the Day

The Last Good DBCC Run