Profile cover photo
Profile photo
Tejas Shah
231 followers
231 followers
About
Posts

Post has attachment
SQL Server, T-SQL create Linked Server with Azure SQL Database
Today, we got a requirement to connect our Azure VM SQL (Report server) instance to access the Azure Database. Let me show you how create linked server for SQL Database on Azure from Azure VM SQL instance. Please follow the mentioned steps to create a Linke...
Add a comment...

Post has attachment
SQL Server Reporting Services, List out all the data sources with Report Name and Path
In Enterprise application, we can have many reports hosted. Sometimes there are few customized reports too. Over period of time, there may be many Data Sources used by the different reports. To find out Report and its data source, we can use the following q...
Add a comment...

Post has attachment

Post has attachment
SQL Server: Use of Recursive Query with example
One of the most benefit of CTE (Common Table Expressions) is that we can create recursive queries with them. Recursive query is the efficient way to display hierarchy setup (Parent child relation
ship in the same table). e.g. Grand Parent, Paren...
Add a comment...

Post has attachment
SQL Server, avoid encoding special character when using FOR XML PATH
From SQL 2005, we are using FOR XML PATH('') for the string concatenation. I have also mentioned the same in very old blog: Generate Comma Separated List with SELECT statement .  Today, we face an issue when special character gets encoded and we hate to hav...
Add a comment...

Post has attachment
T-SQL to find out Space by File Group
T-SQL script to find out SQL SERVER FileGroup space details: SELECT
fg.groupname AS 'File Group',
Name,
CONVERT (Decimal(15,2),ROUND(f.Size/128.000,2))
[Currently Allocated Space (MB)],
CONVERT (Decimal(15,2),
ROUND(FILEPROPERTY(f.Name,'SpaceUsed')...
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...
Wait while more posts are being loaded