Question and Answer #5

Question – Out of below 2 servers, We need to find which one is 'Microsoft Azure Synapse Analytics'? Other might be 'SQL Database'.1️⃣ "s1.database.windows.net"2️⃣ "s2.database.windows.net" How to find? 💡 For "Dedicated SQL pool (formerly SQL DW)" , the endpoint would be same as SQL Database ".database.windows.net" [Still pricing tier is different: cDWU vs DTU/vCore]Under "Azure Synapse Workspace"…

Advertisement

Azure Batch Data Process – Covid Dataset

In this blogpost, we would see how to create Batch data process through Azure Data Engineering with covid dataset as sample. This post will give you all, the high level idea regarding Batch data process in Azure, if you are the beginner. Prerequisite Active Azure Subscription. If you don’t have, create a free account.Subscription Level Contributor access or Owner access. we can…

T-SQL way to ADD and EDIT Client IP Address in Azure SQL DB

Introduction In this Article, we will see how to Add, Edit (and Delete) Client IP Addresses/Firewall in Microsoft Azure through Transact SQL(T-SQL) in SQL Server Management(SSMS) for Azure SQL DB. To know what is Azure Firewall and how to Add, Edit (and Delete) Client IP Addresses in Microsoft Azure Portal step by step, check -…

Hyperlink a value in SQL Server

Introduction In this blog post, we will see how to hyperlink a value in SQL Server. Additionally, we see how to interchange the value as normal link-text and hyperlinks. Hyperlink a value SQL Script IF OBJECT_ID('Tempdb..#Temp') IS NOT NULL DROP TABLE #Temp; GO CREATE TABLE #Temp (NORMAL_LINK VARCHAR(200),HYPERLINK XML); GO INSERT INTO #Temp SELECT 'https://arulmouzhi.wordpress.com/','https://arulmouzhi.wordpress.com/';…

Methods to Show Rupee Symbol in SQL Server

In this blog post, we will see some of the methods to Show Rupee Symbol in SQL Server by using On-Premises DB and Azure SQL DB in SSMS ( SQL Server Management Studio ) and Azure Data Studio. Methods to Show Rupee Symbol Using FORMAT ( ) FunctionUsing NCHAR ( ) Function SQL Script DECLARE…

CONCAT_NULL_YIELDS_NULL in SQL Server

Introduction In this blog post, we will see What is CONCAT_NULL_YIELDS_NULL and what's the syntax to use and what are default settings of it in both Azure SQL Db and On-Premises DB. Also we will see what are the important things to know about it and how to handle our codes irrespective of CONCAT_NULL_YIELDS_NULL setting…

Which Data Types has Non Nullable Default Values

I will be Happy to Convey that I have reached Half-Century in blog posts! Many more are yet to come...!

To Identify Available SQL Data Types

Introduction In this blog post, we are going to see what are the available datatypes in SQL and how to identify it. What are Available SQL Data Types Available SQL Datatypes To Identify Available SQL Data Types We can use sys.types ( System Catalog View) to identify both System and User-Defined Datatypes. SQL Script to…

How to Know the Datatype and Properties of a Variable and Columns of a Table

Introduction In this blog post, we will see How to find the Datatype and Properties of a Variable and Columns of a Table. The Easy method for this Question is, using SQL_VARIANT_PROPERTY Function. SQL_VARIANT_PROPERTY The SQL_VARIANT_PROPERTY Function returns the base datatype and other basic information like Precision, Scale, Total bytes, Collation and Maximum Length. SYNTAX…

Easy Like Search to find Table, View, Stored Procedure and Function Names in SQL Server

Introduction In this blog post, will see how can we easily find or search Table, View and Stored Procedure, Function names in SQL Server. SQL Script for Sample Table, View, SP, Function Creation -- Sample Table Creation CREATE TABLE TestTable ( TestTable_key INT IDENTITY(1,1) NOT NULL, TestTable_Name VARCHAR(100) NOT NULL ); GO -- Sample View…