Script table in SQL Server

You can script a table from database using a SQL Server Management Studio. SQL Server Management allows you to script out tables from database using… Read More »Script table in SQL Server

Generate Database Scripts With Data in SQL Server

You can generate a database scripts including the schema and the data by using the Generate Scripts option available in SQL Server Management Studio (SSMS),… Read More »Generate Database Scripts With Data in SQL Server

Table Value Constructor

Table Value Constructor (TVC) allows to group multiple rows of data in a single DML statement. It can be used as a part of either… Read More »Table Value Constructor

Change the column name and data type of result set of stored procedure

SQL Server 2012 has released a new feature WITH RESULT SETS, which allows column names and their data types to be changed in the result set… Read More »Change the column name and data type of result set of stored procedure

How to get TOP N records for each category

Selecting a top n records for each category from any table, can be done easily using row_number function which generates a sequential integer to each… Read More »How to get TOP N records for each category

IDENT_CURRENT Function

The IDENT_CURRENT function returns the last IDENTITY value generated for any specific table or view on an identity column in any session and any scope.… Read More »IDENT_CURRENT Function

Calendar By Tallan Power BI Custom Visual

This Calendar visual enables you to view the aggregation of data across a range of dates in a standard calendar layout. This is microsoft certified… Read More »Calendar By Tallan Power BI Custom Visual

SQL Vulnerability Assessment

SQL Vulnerability Assessment (VA) is an easy to use tool that you can use to identify, track, and remediate potential database vulnerabilities. The VA service… Read More »SQL Vulnerability Assessment

SQL ROLLBACK Transactions

SQL ROLLBACK transaction statement rolls back an explicit or implicit transaction to the beginning of the transaction. If savepoint is specified then it rolls back… Read More »SQL ROLLBACK Transactions

Visual zoom slider feature in Power BI

Recently Power BI has released November 2020 update, in this update one of the coolest feature is that now you can add a zoom sliders… Read More »Visual zoom slider feature in Power BI

Create Relationship between tables when both tables having duplicate values

Sometime you are required to create a relationship between tables when both tables are having a duplicate values. In this case, If you try to… Read More »Create Relationship between tables when both tables having duplicate values

SAMEPERIODLASTYEAR Function DAX

SAMEPERIODLASTYEAR is a Power BI time intelligence function in DAX which returns a table that contains a column of dates in the current selection of… Read More »SAMEPERIODLASTYEAR Function DAX

Separate numbers, letters and special characters from string

How to find and separate the numbers, letters and special characters from string? Suppose you a column in table which contains a mix words which… Read More »Separate numbers, letters and special characters from string

Column Level Encryption Decryption using Symmetric Keys

SQL Server allows several options to protect sensitive data, and one of them is specifying a column level encryption. Using this option you can encrypt… Read More »Column Level Encryption Decryption using Symmetric Keys

Create a calendar table in Power BI

In Power BI there are two DAX functions that you can use to generate a date series that is CALENDAR and CALENDARAUTO. The CALENDAR function… Read More »Create a calendar table in Power BI

TOPN Function DAX

TOPN function is a Power BI table manipulation function in DAX which returns the top n records from table. If you specify the number 0… Read More »TOPN Function DAX

FILTER Function DAX

Filter is a Power BI filter functions in DAX which returns a table that represents a subset of another table or expression. It filter the… Read More »FILTER Function DAX

Merge in Power BI

Merge Queries in Power BI allows you to join two existing tables together based on matching values from one or multiple columns. Basically, it it… Read More »Merge in Power BI

SQL QUOTENAME Function

SQL QUOTENAME function is a string function which returns a Unicode string with the delimiters added to make the input string a valid SQL Server… Read More »SQL QUOTENAME Function