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
Since SQL Server 2012 SP1 you’ve been able to backup and restore SQL Server using Azure Blob storage. This can be useful to have offsite replicated backups or if you need to move data securely between sites, and now with Azure hosted SQL Server (of various stripes) it makes it easy to get data into… READ MORE
Grow and enhance your skills with the European SharePoint, Office 365 & Azure Community. Joining the ESPC Community, gives you access to the online resource centre at sharepointeurope.com, providing the best, free content on SharePoint, Azure and Office 365. Topics covered include Microsoft Teams, SharePoint, SharePoint Framework, Office 365 Groups, OneDrive, PowerApps & Flow, Security,… READ MORE
Microsoft has a great solution for persisting your local data collected by the IoT Edge. It’s up to you to get the data in and out of your database. But you have a convenient way of storing your precious information into some kind of persistent storage. As seen in my previous blog, it’s not that hard to deploy… READ MORE
In my last post I have shown you how to create and configure the Analysis services in Azure. Today I will show you how to connect to the Analysis Services from Visual Studio SSDT (SQL Server Data Tools). In my lab environment the initial Architecture was as follows. Fig: Azure Analysis Service Initial Architecture. The steps to… READ MORE
This post I have targeted to the BI developers and system admins who are interested to configure and work with the SQL Server Analysis Services in Azure (Called Analysis Services in Azure) What is SQL Server Analysis Services? SQL Analysis Service is the PaaS instance of SQL Server Analysis Services. It’s an analytical data engine… READ MORE
Interested in attending ESPC16 but need to convince your boss? Here is a short template which may be of some help to convince your boss.
