Introduction SQL is a widely used programming language for managing and manipulating relational databases. SQL statements are executed in a specific order to produce the desired results. Understanding the order of SQL execution is crucial for developing efficient and effective SQL queries. In this article, we will discuss the order of SQL execution with clear examples. SQL execution… READ MORE
Introduction SQL is a widely used programming language for managing and manipulating relational databases. SQL statements are executed in a specific order to produce the desired results. Understanding the order of SQL execution is crucial for developing efficient and effective SQL queries. In this article, we will discuss the order of SQL execution with clear examples. SQL execution… READ MORE
Download Chapter 4: The Security Model from Business Intelligence with Databricks SQL. In this rather dense chapter, we will learn how data assets in the data catalog are secured with the data security model. You will see how user-facing table access control allows for the fine-grained implementation of the data security model using familiar SQL… READ MORE
CSV data format is an old format and very common for data tasks, like import, export or storing. And when it comes performance of creating CSV file, reading and writing CSV files, how does it still stand against some other formats. We will be looking at benchmarking the CRUD operations with different data formats; from… READ MORE
Accessing data in different data sources is one of the main tasks in machine learning model development life cycle. Let’s discuss one of the most common data accessing scenarios. Scenario : We have to set of relational data points stored in a Azure SQL server to develop a machine learning model using Azure Machine Learning.… READ MORE
Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you’ve already spent on licensing SQL Server. New in this edition is a demonstration deploying a custom… READ MORE
Some days ago I discussed with some partners the architecture of a possible datawarehouse system for external BI analysis connected to Dynamics 365 Business Central data. They created an Azure SQL database where a “data sync” with Dynamics 365 Business Central was in place and they perform BI analysis on this external database. The raised… READ MORE
SQL Injection is one of the most dangerous attacks and we can exploit it in many Azure assets, App Services, APIs endpoints in general, Azure Functions, Logic App and more.We can conduct the attack using different tools, I tried some of the most used like OWASP ZAP, BurpSuite, SQLMap, I am not going into the… READ MORE
Instead of pure lift-and-shift migrations to the cloud, we often encounter lift-shift-tinker migrations. Azure AD Seamless Single Sign-On (Seamless SSO) automatically signs in users when they are on their PCs or devices that are connected to their organisation network. In such a migration, you modify some of the application components to take advantage of cloud… READ MORE
Migrating a dotnetcore 2-tier Application to Azure, using Different Architectures and DevOps Best Practices is a very practical hands-on guide to learn about Azure Infrastructure as a Service, Platform as a Service, Containers and DevOps. Interested in learning how to migrate your on-premises workloads to Azure, but don’t know what architecture to choose or how… READ MORE
