Python

SQLServerCentral Article

Use SQLAlchemy ORMs to Access MongoDB Data in Python

  • Article

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 […]

2021-09-22

1,184 reads

External Article

SQL Server Machine Learning 2019: Working with Security Changes

  • Article

SQL Server Machine Learning allows you to run R and Python scripts from SQL Server. When SQL Server 2019 was released, Microsoft enhanced the security for this functionality, but it caused some existing code writing to the file system to to break. In this article, Dennes Torres explains the security enhancement and describes three ways to work with it.

2020-03-11

SQLServerCentral Article

Managing SQL Server containers using Docker SDK for Python - Part 2

  • Article

There are multiple ways to interact with the Docker daemon, as command line client API or GUI based tools like Kitematic. Docker also provides a SDK for Go and Python,  this SDK can be used to create and manage Docker containers the same way it works with the Docker engine API.

2019-09-16 (first published: )

1,722 reads

Blogs

Daily Coping 3 Feb 2023

By

Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Read the latest Blogs

Forums

Extended Events to capture query causing tempdb log to get full

By PJ_SQL

Hi! Query store provides information on workloads on tempdb How\Steps to setup Extended events...

How to append data to the previous row

By jay-125866

Hi, I have a table that stores event transactions, the sample data see the...

Replacement for char and ascii functions in natively compiled stored procedures

By MullerN

I am trying to create a natively compiled stored procedure where I need to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers