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

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

5,429 reads

Identifying records with special characters (Unicode)

by ermrlehkara

SQLdose

Identifying records with special characters

2018-08-07

22 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

545 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

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

9,922 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

11 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

T-SQL Tuesday #180: Good enough is perfect Roundup

Using SQL Compare with Read-only Access

Off to Live 360

Forums

how can i tell if our db2 driver is ms or ibm or other?

normal role member to be able to view list of other role members in his DB

Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code

Question of the Day

A Strange Result