Tag: SQL

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 Revealed
Azure SQL Revealed
Ebooks

Download Chapter 1: SQL Server Rises to the Clouds. Access detailed content and examples on Azure SQL, a set of cloud services that allows for SQL Server to be deployed in the cloud. This book teaches the fundamentals of deployment, configuration, security, performance, and availability of Azure SQL from the perspective of these same tasks… 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