Using the Union Operator in KQL

Sometimes it is difficult to use and remember operators in KQL. Today we're going to look at using the "union" operator to combine tables into one space.

by Joseph Dutton Feb 20, 2023

KQL Query to track your higher cost Azure Sentinel Tables

A quick article with an easy KQL query to monitor your higher cost Azure Sentinel Tables.

by Joseph Dutton Feb 7, 2023

How to Secure a Synapse Workspace with Active Directory groups 

Azure Synapse is an enterprise analytics service that accelerates time to insight across data warehouses and big data systems. Azure Synapse brings together the best of SQL technologies used in enterprise data warehousing, Spark technologies used for big data, Pipelines for data integration and ETL/ELT, and deep integration with other Azure services such as Power BI, Cosmos DB, and Azure ML.  

In this blog we will show how we can use Active Directory Groups to secure Synapse

by Jeff Lipkowitz May 27, 2021

The Data Lake vs. The Data Warehouse

Both a Data Lake and a Data Warehouse are options for storing data. While traditionally data warehouses have been the preferred storage method of organizations, recent advancements and cloud computing have seen a rise in data lakes. While both storage systems, one is not a replacement of the other, and both have their place in the modern data framework. 

by Steve Campbell Nov 23, 2020

Managed Services Evolved with Concurrency Digital Operations

Now more than ever, the opportunity to automate, digitize and mobilize the workforce is critical to business growth and survival across industries. Implementing new technology and transformative change within your organization does not stop on "go live day", rather it evolves as your team and organization work to embrace the new technology in new ways over the weeks, months and years following a successful launch or implementation.  

by Kurt Spitzner Oct 12, 2020

Azure Kubernetes and Containers

Concurrency's CTO Nathan Lasnoski was recently joined by Managing Architect Brian Haydin and Senior Systems Engineer John Hubert to discuss the advantages of Azure Kubernetes and Containers. Running your organization's applications are just as important as streamlining your workflows and protecting your data.

by Stephanie Siewert Sep 28, 2020

Running the Data Migration Assistant - Part Three - Jupyter Notebook

This is the third in a series of blog posts on Microsoft's Data Migration Assistant.  It covers running the DMA using PowerShell from a Jupyter Notebook.

by Frank Gill Sep 3, 2020

Running the Data Migration Assistant - Part One - The GUI

This is the first in a series of three posts about the Data Migration Assistant (DMA).  It describes what the DMA is, how to get it, and how to use the GUI to run an assessment of SQL Server databases for upgrade or migration. 

by Frank Gill Sep 1, 2020

Firewall Settings for Connecting to Azure SQL Databases from an Azure VM

This post describes an issue a client experienced connecting to an Azure SQL Database from an Azure VM through a third-party firewall.

by Frank Gill Jun 26, 2020

Why Migrate SQL Server to Azure

When making the decision to move SQL Server workloads to Azure, there are a series of questions that need to be answered.

• Why are you migrating to Azure?
• What are you going to migrate to Azure?
• Where will you migrate in Azure?
• How will migrate to Azure?
• When will you migrate to Azure?

The answer to the first of these questions is extremely important to answering the others.  In my experience, it is often neglected.

by Frank Gill Jan 3, 2020

Using the Union Operator in KQL

Sometimes it is difficult to use and remember operators in KQL. Today we're going to look at using the "union" operator to combine tables into one space.

by Joseph Dutton Feb 20, 2023

KQL Query to track your higher cost Azure Sentinel Tables

A quick article with an easy KQL query to monitor your higher cost Azure Sentinel Tables.

by Joseph Dutton Feb 7, 2023