Using RANKX in Computed Column and MEASURE
This is my first blog for PBI – DAX. I lately started working on DAX and trying to understand it in...
2018-11-22
5,594 reads
Using RANKX in Computed Column and MEASURE
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
17 reads
Interview Query – 1
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,470 reads
Interview Query – 1
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
19 reads
Identifying records with special characters (Unicode)
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,330 reads
2018-08-07
26 reads
Starting with MS SQL Server
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
552 reads
Starting with MS SQL Server
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
24 reads
SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.
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,221 reads
SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.
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
16 reads
Blogs
SQL Server 2025 Generally Available
By Brian Kelley
This was announced last week at Microsoft Ignite and it's been covered by others...
Chatting with Power BI: Who Benefits from This Conversation?
By Rayis Imayev
"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...
A Quick Look at Redgate Data Modeler
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Forums
SQL Server 2022 order by bug?
Hi, I was using order by on a column with characters and saw something...
SQL Server 2025 Build List
Comments posted to this topic are about the item SQL Server 2025 Build List
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers