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 Recursive CTE, as shown in below T-SQL. Note that:  After…

 259 total views

Read More...

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 coded in pairs are correctly paired when you write any…

 253 total views,  3 views today

Read More...

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 any syntax errors. It was released in SQL Server 2012…

 498 total views,  1 views today

Read More...

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 if an object exists then drops an existing object and…

 329 total views

Read More...

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). ‘Saving changes is not permitted. The change you have made…

 283 total views,  4 views today

Read More...

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 a Script table as option. This option can be used…

 67 total views

Read More...

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), which generates a scripts for selected database. When you perform…

 315 total views,  3 views today

Read More...

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 the VALUES clause of an INSERT INTO VALUES statement, or…

 296 total views

Read More...

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 of a stored procedure. If you need to change the…

 450 total views,  2 views today

Read More...

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 row within a partition of a result set. To understand…

 196 total views,  3 views today

Read More...

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. This function is limited only to a specific table or…

 138 total views

Read More...

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 custom visual, that you can get from App source library…

 225 total views,  1 views today

Read More...

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 runs a scan directly on database, and follows base of…

 178 total views

Read More...

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 the transaction to a savepoint within the transaction. Basically, it…

 1,312 total views,  7 views today

Read More...

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 to cartesian charts (chart which includes horizontal and vertical axes)…

 1,270 total views,  15 views today

Read More...

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 create a relationship, Power BI suggest a many to many…

 149 total views

Read More...

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 previous year. It is specific to a year interval and…

 707 total views,  1 views today

Read More...

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 may includes numbers, letters, and special characters, or either numbers…

 227 total views,  1 views today

Read More...

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 a column data also decrypt the data. SQL Server encrypts data…

 439 total views,  1 views today

Read More...

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 requires two input parameters that is start date, and end…

 563 total views,  5 views today

Read More...