Delete Horizontal White Space in SQL Serve
When you are required to import data received from different different file format such as .txt, .csv., or excel files, sometimes you see a white… Read More »Delete Horizontal White Space in SQL Serve
Home » Archives for Pradeep Raturi »
Pradeep Raturi
I have 11+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.
Sort By Months Name in Power BI
When you perform sorting on months name, you will see that months name are sorted alphabetically as text, strings are sorted alphabetically by default. While… Read More »Sort By Months Name in Power BI
EOMONTH Function DAX
EOMONTH function is a Power BI Date and time function in DAX which returns the date in datetime format of the last day of the… Read More »EOMONTH Function DAX
Date and Time Conversions in SQL Server
Sometimes you need to format a date in specific format such as format a date time string YYYY-MM-DD hh:mm:ss. mmm to date MM:DD:YY. SQL Server… Read More »Date and Time Conversions in SQL Server
Get Row Counts for all tables in SQL Server
Sometime you are required to validate the row counts for each tables in database. So getting a row counts for each tables either through using… Read More »Get Row Counts for all tables in SQL Server
Implementing a Table Heat Map in Power BI
A Heat map is used to visualize the density of data using colors where highest data value is displayed through dark heated color, and same… Read More »Implementing a Table Heat Map in Power BI
Object_Id Metadata Function
Object_ID is a SQL Server Metadata function which returns the database object identification number of a schema-scoped object. It can not be used for object… Read More »Object_Id Metadata Function
Dynamic Data Masking in SQL Server
Dynamic data masking also known as DDM is a security feature in SQL Server which helps you to prevent the access of unauthorize users to… Read More »Dynamic Data Masking in SQL Server
REPT Function DAX
REPT functions is a Power BI text function in DAX which repeats text a given number of times. SYNTAX REPT(<text>, <num_times>) text is the text… Read More »REPT Function DAX
View Collation Information in SQL Server
Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data. You can easily find SQL collation at the server, database… Read More »View Collation Information in SQL Server
PARSENAME Function
PARSENAME function is a SQL Server Metadata function which returns the specified part of an object name. The parts of an object that can be… Read More »PARSENAME Function
Import text using examples feature Power BI
Power BI August 2020 update has released a new feature Import text using examples, which allows you to import text/csv file which allows you to… Read More »Import text using examples feature Power BI
Introduction to Workspace in Power BI, Assign Roles and Permission
In Power BI service a workspaces are places to collaborate with colleagues to create collections of dashboards, reports, datasets, and paginated reports. You can add… Read More »Introduction to Workspace in Power BI, Assign Roles and Permission
SQL SELECT TOP
SQL SELECT TOP statement is used to retrieve records from tables and limit the number of rows or percentage of rows returned based on a… Read More »SQL SELECT TOP
Rename a Dataset in Power BI Service
Power BI allows you to rename a datasets in Power BI service. You can rename the dataset in workspace, if you are either a report… Read More »Rename a Dataset in Power BI Service
How to get Ordinal Number in SQL
If any number that is written like as 1st, 2nd, 3rd and so on.. is called an ordinal number, and it is read as 1st(… Read More »How to get Ordinal Number in SQL
Check if column Exists or not in SQL Server Table
There are various in-built system catalog views, or metadata functions that you can use to check the existence of column in SQL Server tables. To… Read More »Check if column Exists or not in SQL Server Table
Print Christmas tree in SQL Server
Lets see how to print a Xmas or Christmas Tree in SQL Server. The best way of implementing a Xmas tree pattern you can use a… Read More »Print Christmas tree in SQL Server
Change the color of Automatic Matching of Syntax Pairs in SQL Server Management Studio
Automatic matching of syntax pairs is a feature of SQL Server Management Studio which gives you immediate feedback on whether syntax elements that must be… Read More »Change the color of Automatic Matching of Syntax Pairs in SQL Server Management Studio
SQL Code Snippets
SQL code snippet is a template which contains the basic structure of a Transact-SQL statement or block, so that you can quickly write queries without… Read More »SQL Code Snippets