MFA Access to SQL Server from remote client
Dec 17, 2019 · Can I use "AAD - Universal with MFA", Password or Integrated, to access the database with azure credentials? (SQL is not Azure SQL instance, it is installed within the VM). Also the AD …
Public DNS Names for Azure SQL Database - social.msdn.microsoft.com
Oct 10, 2016 · Then you need to allow *.database.windows.net (on port 1433) on your internal firewall. Why you need to do so is question for your network admin or whoever is in charge of your firewall. …
Mapping Data Flow sink issue - collation
Jun 1, 2020 · This issue occurs because the collations of the catalog databases for Azure SQL Database differ from the collations of the replication databases at the publisher and the subscriber.
Ole DB Source slow while using parameter mapping on huge database
Sep 17, 2013 · Is the query against a SQL database or Access database? If you are querying a Access database, the issue seems to be the known issue Parameterized Queries with JET OLE DB Provider …
Database Connecting Issue - social.msdn.microsoft.com
Dec 5, 2015 · We are providing a portal for our customers to subscribe our services. We are having WebApp and SQL database which are running on Azure. We are using .Net API on WebAppto …
Azure - How does front-end / backend work
Nov 21, 2016 · 1) I wanted to use a .net backend but the lack of support/debug capabilities are surprising . For one , its not possible to view data in the database - so you can't really check if its …
EDW and ODS Getting Started - social.msdn.microsoft.com
May 10, 2021 · This is part of the ELT concept: Designing a PolyBase data loading strategy for Azure SQL Data Warehouse You would need to create the ODS and establish that source as the external …
Why is performance so slow reading binary data from a SQL Azure DB …
Aug 13, 2014 · I looked at the Query Performance page in the Azure portal, but it doesn't time stamp anything in there and you can't clear it, so I can't correlate what's running with the queries that show …
Import multiple xml files into SQL database from SSIS
Aug 19, 2011 · Did anyone ever try something like this? different XSD need to be generated for different XML files and to be used dynamically? different outputs from one single file need to be merged into …
SQL Server 2008 Error occurring when trying to attach database
Mar 12, 2014 · SQL Server should really not have rights to the whole disk, but only the locations needed. So, you can grant the SQL Server service account (Local System? , …