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
In this post I want to cover how you can create a dacpac for an Azure Synapse Analytics dedicated SQL Pool using GitHub Actions. By the end of this post, you will know how to create a dacpac for a dedicated SQL Pool within GitHub Actions for your CI/CD deployments. Creating database project for Azure Synapse dedicated SQL… 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
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
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
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
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
Join Mustafa Toroman, MVP, Lead System Engineer/Program Architect at Authority Partners, Bosnia and Herzegovina for this short video on How To add Dynamic Data Masking and Transparent Data Encryption in Azure SQL.
