Environment -> Create a Job called “SQL Server Agent Job Synchronization” on all the Database Servers as part of your Alwayson Availability group. In my Environment, the Job will be created on Database Server JBSERVER1, JBSERVER2 and JBSERVER3. The Job “SQL Server Agent Job Synchronization” will have the below script executed as part of it. -> Create ..read more

Access storage account from Azure databricks using Storage account key. Access storage account from Azure databricks with Access keys placed in Azure key vault Regards;Vivek Janakiraman Disclaimer:The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS ..read more

Access storage account from Azure databricks using Storage account key. Access storage account from Azure databricks using Azure AD Authentication. Regards;Vivek Janakiraman Disclaimer:The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties ..read more

When working with Azure Data Factory (ADF) pipelines, secure communication between various Azure services is crucial, especially when accessing sensitive data stored in resources like Azure Key Vault. Recently, while executing an ADF pipeline, I encountered the following error message: Operation on target Web URLToken TenantId failed: {“error”:{“code”:”Forbidden”,”message”:”Client address is not authorized and caller is ..read more

Scripts used in Azure databricks delta tables demo, Regards;Vivek Janakiraman Disclaimer:The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights ..read more

Code and CSV file used in Azure databricks delta tables demo, Regards;Vivek Janakiraman Disclaimer:The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights ..read more

?SQL Server 2022 introduces several new and exciting features, and one of the standout additions is the DATE_BUCKET function. This function allows you to group dates into fixed intervals, making it easier to analyze time-based data. In this blog, we’ll dive into how DATE_BUCKET works, using the JBDB database for our demonstrations. We’ll also explore ..read more

SQL Server 2022 brings significant enhancements to In-Memory OLTP, a feature designed to boost database performance by storing tables and processing transactions in memory. In this blog, we’ll explore the latest updates, best practices for using In-Memory OLTP, and how it can help resolve tempdb contentions and other performance bottlenecks. We’ll also provide example T-SQL ..read more

Introduction Azure SQL Managed Instance (MI) is a powerful cloud-based database service that provides near-complete compatibility with SQL Server, along with the benefits of a managed platform. However, while working with SQL Managed Instances, you may occasionally encounter errors due to differences between on-premises SQL Server and Azure SQL environments. In this blog post, we’ll ..read more

In the world of data management and analysis, SQL Server 2022 has brought numerous improvements and enhancements, one of the most notable being the advancements to the dynamic management view (DMV) sys.dm_exec_query_statistics_xml. This DMV provides detailed runtime statistics about query execution, which is invaluable for performance tuning and query optimization. In this blog, we will ..read more