Azure Synapse Analytics Blog

Options
5,719
ryanmajidi on May 02 2023 08:00 AM
5,493
ryanmajidi on Apr 04 2023 09:00 AM
6,035
ryanmajidi on Mar 07 2023 09:00 AM
4,693
ryanmajidi on Feb 08 2023 08:00 AM
3,367
ryanmajidi on Dec 20 2022 08:00 AM
5,386
ryanmajidi on Nov 30 2022 08:00 AM
4,822
ryanmajidi on Oct 31 2022 09:30 AM
8,209
ryanmajidi on Sep 28 2022 08:00 AM
11K
ryanmajidi on Aug 30 2022 08:18 AM
6,963
ryanmajidi on Jul 28 2022 08:00 AM
7,628
ryanmajidi on Jun 29 2022 08:00 AM
18.2K
ryanmajidi on May 31 2022 08:00 AM
12.3K
ryanmajidi on Apr 27 2022 08:00 AM
15.3K
saveenr on Mar 31 2022 11:00 AM
9,742
saveenr on Feb 28 2022 03:15 PM
13.3K
saveenr on Jan 26 2022 02:39 PM
11.2K
saveenr on Dec 20 2021 01:59 PM
18K
saveenr on Nov 30 2021 06:31 PM
14.5K
saveenr on Oct 22 2021 03:57 PM

Latest Comments

Hi,I have found an alternative to the usage of OPENROWSET and the security breach that using such a functionality can create.The alternative is simply to create external table, and then create the secured views on top of these external tables.This is explained in this article: https://www.sqlshack.c...
0 Likes
Hi, great article, thank you for that! I am testing out this pattern and it happens that:1/ User must have permissions to use OPENROWSET2/ Credentials must be included in the DATA_SOURCEThis means that a malicious (and clever) user could bypass the whole RLS mechanism by creating a SELECT statement ...
0 Likes
Hi @RuiCunha, Thanks for writing this great article! After you define the SQLCMD variables, what are the steps do you follow that replaces the hardcoded values in the sql scripts with the SQLCMD variables? Is it required to define the "Local" value in SQLCMD Variables apart from the "Default" value ...
0 Likes
Yes receiving the same error message like @Brian Bagley one below during SchemaCompare. Any fix please? Error Unexpected exception caught during population of source model: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_100_CI_AS_SC_UTF8" in the UNIO...
0 Likes
@mdullerdtm, tks for the feedback. This was recently updated for Azure SQL DB in consequence for Former SQL DW. In Synapse as CX you do not directly manage the SQL Logical Server, but eventually it may go to Synapse I just do not have ETA on that. I suggest you to add your idea or vote on existing a...
0 Likes