Recent Blog ArticlesNewest TopicsMost LikesTagged:TagHow to copy Azure SQL database to a different subscription and different tenant Steps to copy a database from Azure SQL server to another one on a different subscription and different tenant (Microsoft Entra) . Usually, it is the best approach when you have different subscriptio...Large number of OR in predicate "IN Clause" SQL Server In some cases, like when customers use Object-relational Mapping tools (ORM) Like Entity framework or LINQ, part of the code at the end will be converted to a TSQL executable statement. For example...Use Azure SQL Audit policy to filter Audit data. The Azure SQL Auditing feature is used to track database events and writes them to an audit log in your Azure storage account, Log Analytics workspace, or Event Hubs. If you enable SQL Audit on you...Can we access Change Data Capture and Change Tracking on readable replica? In many cases, it is very useful to have the ability to use a readable secondary replica to offload read only workloads and gain more resources for your read queries. Like for example the queries tha...SQL Server Performance: Upper and Lower functions and Database collation. Issue: SQL Server performance issue: possible high CPU or other resources utilization and slow performance of a specific query, with execution time more than expected. Example of the Query: ...Azure SQL connectivity error 10060 example : a DNS resolution issue. Issue: When connecting from inside Azure (an Azure Virtual Machine) to Azure SQL Server. All connections failed with error: MSSQLSERVER_10060 - SQL Server | Microsoft Docs A network-related or ...How to create a Network trace from Azure WebApp PaaS The steps to follow if you want to create a Network trace from Azure WebApp PaaS resource: SQl Injection: example of SQL Injections and Recommendations to avoid it. I want to share with you here in this article an example of SQL Injection, how it can be used to access sensitive data and harm the database, and what are the recommendations and steps that can be do...Database Parameterization On SQL Server, there is a database setting called parameterization. Parametrization has two values, Simple (the default) or Forced. Importing bacpac failed to Azure SQL with User, group, or role ‘XXX’ already exists Export and Import Bacpac file is one of the options available to migrate your database or to create a copy of it, like when you move your data from Azure SQL or Azure managed instance to on prem serv...
MicrosoftMicrosoftMicrosoftMicrosoft
