DROP IF EXISTS
SQL Server 2016 has released an optional IF EXISTS clause with DROP statement that can be used as DROP IF EXISTS. DROP IF EXITS verify… Read More »DROP IF EXISTS
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.
SQL Server Saving Changes is not permitted error
You might have faced an error as shown below, when you make some changes in table from design mode in SQL server management studio (SSMS).… Read More »SQL Server Saving Changes is not permitted error
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 a savepoint is specified, 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 is… Read More »Merge in Power BI