Importing Excel files into SQL Server, Azure Edition
How to Use Azure Functions to insert Excel Files into an Azure SQL Database.
2026-11-04
1,601 reads
Python
Building a SQL Server Fleet Audit That Leadership Actually Reads
Learn how to build a report that shows the health of your database estate that your leadership will read and use.
2026-10-07
1,596 reads
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Learn how to automate OpenStreetMap data refresh on Power Bi's Azure Maps reference layer.
2026-08-17
1,826 reads
You Probably Don't Need a Vector Database
Introduction Conversations about RAG almost always start with a vector database. This article suggests you dig deeper before implementing one.
2026-06-19
1,419 reads
Vector DB implementation using FAISS
Searching for relevant information in vast repositories of unstructured text can be a challenge. This article explains a Python-based approach to implementing an efficient document search system using FAISS (Facebook AI Similarity Search) for Vector DB and sentence embeddings, which can be useful in applications like chatbots, document retrieval, and natural language understanding. In this […]
2025-01-17
4,289 reads
Connecting Streamlit to Upload Data to Snowflake
How to create a connection for StreamLit and Snowflake to upload data for visualization
2024-12-20
2,608 reads
Enhancing SQL Server Searches with Elasticsearch and Python
Learn how to get started with Elasticsearch with data in your SQL Server database.
2024-10-14
2,714 reads
Machine learning K-Means applied to SQL Server data
This article shows how to use Python to access data in SQL Server and produce a K-Means analysis with a chart.
2024-01-08
3,342 reads
SQL Server and Python Tutorial
This article will show the basic outline for how Python scripts can access and work with data in SQL Server.
2023-11-06
21,589 reads
Integrating Python with MongoDB
This article gives an overview of MongoDB and outlines steps to integrate python with MongoDB
2023-10-13
912 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers
