Category: SQL Server

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

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

Latest on the ESPC Community
Latest on the ESPC Community
Blog Posts

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