List the name f full text index created in SQL

 Hi All,

Execute the below query to view the full text index details

SELECT 

    t.name AS TableName, 

    c.name AS FTCatalogName ,

    i.name AS UniqueIdxName,

    cl.name AS ColumnName,

    cdt.name AS DataTypeColumnName

FROM 

    sys.tables t 

INNER JOIN 

    sys.fulltext_indexes fi 

ON 

    t.[object_id] = fi.[object_id] 

INNER JOIN 

    sys.fulltext_index_columns ic

ON 

    ic.[object_id] = t.[object_id]

INNER JOIN

    sys.columns cl

ON 

    ic.column_id = cl.column_id

    AND ic.[object_id] = cl.[object_id]

INNER JOIN 

    sys.fulltext_catalogs c 

ON 

    fi.fulltext_catalog_id = c.fulltext_catalog_id

INNER JOIN 

    sys.indexes i

ON 

    fi.unique_index_id = i.index_id

    AND fi.[object_id] = i.[object_id]

LEFT JOIN 

    sys.columns cdt

ON 

    ic.type_column_id = cdt.column_id

    AND fi.object_id = cdt.object_id;

Make sure SQL Database firewall allows Integration runtime to access. Login failed for user

Issue - Make sure SQL Database firewall allows Integration runtime to access. Login failed for user <token-identified-principal>

Resolution  -

Step 1 -  Ensure that Allow Azure services are clicked as YES

Step 2 - 

CREATE USER [ADF Managed Identityname] FOR EXTERNAL PROVIDER;
GO

Managed ACl are not applid to child or sub folders in Azure

 Issue - Managed ACl are not applid to child or sub folders in Azure

Resolution - Follow below steps after connecting your storage account using STORAGE EXPLORER

Apply ACLs recursively

You can apply ACL entries recursively on the existing child items of a parent directory without having to make these changes individually for each child item.

To apply ACL entries recursively, Right-click the container or a directory, and then click Propagate Access Control Lists. The following screenshot shows the menu as it appears when you right-click a directory.

ADf - Column is duplicated in output column

 Issue - Aggregate throws error that 

Use Not in to resolve this issue

Azure Integration Runtime IP addresses - ADF cannot access ADLS storage folders

 Issue - Azure Integration Runtime IP addresses - ADF cannot access ADLS storage folders

Resolution - 

1. Ensure Your machine IP adress is whitelisted

2. Ensure the below is enabled

3. If issue still persists then Check the Manage ACL in each of the folders in which you are trying to put data. Add your ADF resurce group by clicking on Add principal and provide Read, Write and Execute access

4. Follow step 3 across all folders

A full-text search key must be a unique, non-nullable, single-column index which is not offline, is not defined on a non-deterministic or imprecise nonpersisted computed column, does not have a filter, and has maximum size of 900 bytes.

Hi All,

Issue -  A full-text search key must be a unique, non-nullable, single-column index which is not offline, is not defined on a non-deterministic or imprecise nonpersisted computed column, does not have a filter, and has maximum size of 900 bytes. Choose another index for the full-text key.

Resolution - After KEY INDEX, you need to specify the name of the index not the column. To find the name of the index on the column ID, type sp_help DomainName and there will be a list of indexes on that table. The pk will be named something like PK_xxxxx

Power BI Tree map conditional formating

 Hi All,

Power BI Tree map conditional formatting is not working as expected. 

Issue - Data colors were applied to different fields in power BI. And it did not remain constant when slicer selection was changes

Resolution - Scroll down and click on "Revert to defaults".

Bingo--now the default color scale that you have defined is working!!