Tag: SQL

Order of SQL Execution
Order of SQL Execution
Blog Posts

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

Order of SQL Execution
Order of SQL Execution
Blog Posts

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

Business Intelligence with Databricks SQL
Business Intelligence with Databricks SQL
Ebooks

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

Connecting Azure SQL Server with Azure Machine Learning
Connecting Azure SQL Server with Azure Machine Learning
Blog Posts

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

Building Custom Tasks for SQL Server Integration Services
Building Custom Tasks for SQL Server Integration Services
Ebooks

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

Securing your Azure SQL Database with a private endpoint
Securing your Azure SQL Database with a private endpoint
Blog Posts

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

Azure SQL, Azure Active Directory and Seamless SSO: An Overview
Azure SQL, Azure Active Directory and Seamless SSO: An Overview
Blog Posts

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

Azure SQL vs NoSQL
Azure SQL vs NoSQL
Blog Posts

By reading this post, you will be able to compare and choose the right one service for our database deployments (SQL or NoSQL). Definition SQL: A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. NoSQL: NoSQL is a class of database management systems (DBMS) that do not… READ MORE