The wide ecosystem of Python modules enables you get to work fast and effectively integrate your systems. You can use the CData Python Connector for MongoDB and the SQLAlchemy toolkit to build MongoDB-connected Python applications and scripts. This article details how to use SQLAlchemy to connect to MongoDB data to query, update, delete, and insert MongoDB data. Connecting to MongoDB Data Connecting to MongoDB data is similar to connecting to any other relational database. Create a […]

Real-Time Streaming using Power BI Streaming Dataset

by Additional Articles

MSSQLTips.com

Power BI

In this tip we will look at using a Streaming Dataset in Power BI to visualize real time data using the streaming service Azure Stream Analytics job.

What's the real story behind the explosive growth of data?

by Additional Articles

Redgate

Vendors/3rd-party Products

IDC’s recent Global DataSphere Forecast, 2021-2025 predicts that global data creation and replication will experience a compound annual growth rate of 23% over the forecast period. But what’s causing the growth? Where will all of that extra data be stored? And how should we, as data professionals, prepare for it? Read this blog to explore these important questions.

Author Power BI Reports on Real-Time ServiceNow Data

by JerodJ

SQLServerCentral

This article shows in detail how to use the Power BI Connector to create real-time visualizations of ServiceNow data in Microsoft Power BI Desktop.

Azure SQL Migrations using Azure Data Studio

by bake13

SQLServerCentral

This article looks at database migration with the Azure Data Studio extension, making it easy to move databases from an on premises SQL Server to one in Azure.

Poor Work Management

by Steve Jones

SQLServerCentral

Work environment

The future of work is uncertain, but not everyone is ready for remote work to continue.

The Azure SQL portfolio

by Additional Articles

SimpleTalk

Azure

Microsoft provides many ways to run SQL Server in Azure, but which do you choose? In this article, Robert Sheldon explains the Azure SQL options.

All the Tools in Your Toolbox

by Kathi Kellenberger

SQLServerCentral

Database Weekly

I recently began writing an article to compare the performance of several window functions to traditional query methods. I began with my favorite function, LAG, but soon found that there were so many other ways to write the query that the article never covered the additional window functions. The article was quite fun to write, […]

A Great Use for AI

by Steve Jones

SQLServerCentral

Steve found a great use for AI, and one many people might appreciate.

How to Flatten JSON in Azure Data Factory?

by diponkar.paul

SQLServerCentral

When you work with ETL and the source file is JSON, many documents may get nested attributes in the JSON file. Your requirements will often dictate that you flatten those nested attributes. There are many ways you can flatten the JSON hierarchy, however; I am going to share my experiences with Azure Data Factory (ADF) […]

Use SQLAlchemy ORMs to Access MongoDB Data in Python

Real-Time Streaming using Power BI Streaming Dataset

What's the real story behind the explosive growth of data?

Author Power BI Reports on Real-Time ServiceNow Data

Azure SQL Migrations using Azure Data Studio

Poor Work Management

The Azure SQL portfolio

All the Tools in Your Toolbox

A Great Use for AI

How to Flatten JSON in Azure Data Factory?

Blogs

The Book of Redgate: SQL Server Central

Git forked

Setting FK Constraints in Data Modeler

Forums

Microsoft Security Changes and SQL Server

Expanding into Print

Downtime Caused by the Postgres Transaction ID Wraparound Problem

Question of the Day

The String Distance I