SQL Random Number

SQL RAND function is a mathematical function which returns a pseudo-random float value from 0 through 1, exclusive or a random value within any range.… Read More »SQL Random Number

 978 total views,  1 views today

How to insert the result of a stored procedure into table

Sometimes, you want to store the result of a stored procedure into table or temp table instead of returning the output. Storing output of stored… Read More »How to insert the result of a stored procedure into table

 2,190 total views

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

 1,530 total views

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

 653 total views,  1 views today

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

 2,785 total views,  1 views today

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

 621 total views

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

 253 total views,  1 views today

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

 1,047 total views,  1 views today

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

 576 total views,  1 views today

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

 478 total views

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

 1,296 total views,  1 views today

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

 4,130 total views,  1 views today