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

4,426 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

5 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,462 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

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

2,704 reads

Identifying records with special characters (Unicode)

by ermrlehkara

SQLdose

Identifying records with special characters

2018-08-07

20 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

533 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

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

6,747 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

9 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

SQL Saturday Boston 2024 Slides

Small Data SF 2024

A New Word: Moledro

Forums

test new topic

New article

Monitoring Azure Blob Storage

Question of the Day

Azure Data Lake Storage Gen 2