Scaleway’s Post

🤓 Making progress with my #book on MariaDB for #Developers. Chapter 5 covers advanced #SQL techniques without overwhelming the reader with theory but showing real-life challenges when using relational #databases. 👉https://lnkd.in/dCUhFCvD

#CockroachLabs offers free "Self Paced" #training... This course introduces the core concepts behind #distributed #SQL #databases and describes how #CockroachDB fits into this landscape. By the time you finish the course, you'll be able to describe the key functionality that brings people to #CockroachDB: You'll learn about #CockroachDB's seamless horizontal #scalability. You'll learn about #CockroachDB's distributed transactions with strict #ACID guarantees. https://lnkd.in/gDP9difU

Two kinds of SQL pool that are based on the SQL Server relational database engine: > A built-in serverless pool that is optimized for using relational SQL semantics to query file-based data in a data lake. > Custom dedicated SQL pools that host relational data warehouses. #Synapse #Azure #SqlPools

Public Preview: #JSON Native Data Type & Aggregates in #Azure #SQL #Database https://buff.ly/4czTZmw #Microsoft #AzureSQL #SQLServer #MadeiraData

https://zurl.co/iXoI Runbook for Loading and Managing Data with Composable JSON Tags in SQL Server #Microsoft #Azure #SQLServer #MinervaDB #DBA #SQL #AzureSQL

https://zurl.co/iXoI Runbook for Loading and Managing Data with Composable JSON Tags in SQL Server #Microsoft #Azure #SQLServer #MinervaDB #DBA #SQL #AzureSQL

❄ Did you know Snowflake has duplicated functions?   There are for example: - RLIKE & REGEXP - NVL & IFNULL - CAST & TO_<EVERY_TYPE> … and some other different use cases like "::" to also cast data types   Even tho their output is exactly the same, there is a reason behind why they are still here.   And the answer is….   Compatibility with different SQL dialects!   Imagine migration from Oracle (or some other DB) to Snowflake without knowing all of these new & fancy functions.   You would need to go through your SQL very carefully (I still recommend to do that) and change most of the Oracle's not-ANSI functions for a Snowflake ones.   Which sometimes can be challenging.   Snowflake simplify this process with the support of "legacy" functions so there is no need to do that.   It can also help with code readability, so you don't need to instantly switch to a brand-new different functions and patterns.   Do you know some other examples?     #Snowflake #dataengineering

I am thrilled to share my recent accomplishment: completing the “SQL 50 Questions” challenge hosted by LeetCode. #sql #database #microsoft #leetcode #dataengineering #dataengineer #datamodeling #dataanalysis #azure #azuredataengineer #datawarehouse #mcit #depi

I'm excited to share my latest video on "Data Migration from Local Systems to Azure SQL Database Using Bacpac Method". 🎥✨ In this tutorial, I cover the step-by-step process of migrating your database using the Bacpac method: 1. Export Database to Bacpac File: Learn how to export your local SQL Server database into a Bacpac file using SQL Server Management Studio (SSMS). 2. Upload Bacpac to Azure Blob Storage: Discover how to upload the Bacpac file to Azure Blob Storage for easy access and transfer. 3. Import Bacpac File to Azure SQL Database: Follow along as I guide you through importing the Bacpac file into Azure SQL Database and configuring your settings. 4. Verify the Imported Database: Ensure your data has been accurately imported and is ready for use in Azure. This method is simple, portable, and compatible with various SQL Server versions and Azure SQL Database, making it a powerful tool for your data migration needs. https://lnkd.in/gk_q9hRB Watch now to streamline your data migration process and take full advantage of Azure's robust capabilities. #Azure #DataMigration #SQLDatabase #TechTutorial #AzureSQL #Bacpac #CloudComputing #DataManagement #SQL #YouTubeTutorials #TechSkills

🚀 Day 2: Demystifying SQL Execution! 💻 🎈 Process of SQL: When we are executing the command of SQL on any Relational database management system, then the system automatically finds the best routine to carry out our request, and the SQL engine determines how to interpret that particular command. 🎈 Structured Query Language contains the following four components in its process: 🎐 Query Dispatcher 🎐Optimization Engines 🎐Classic Query Engine 🎐SQL Query Engine, etc. see more: https://lnkd.in/dywYnmx7 #DataEngineering #DataAnalytics #sql #sqllearning #aws #azure #databricks Mode for better reach: Sumit Mittal Darshil Parmar Sagar Prajapati