Additional Articles

Getting Started with mssql-python for Data Developers

by Additional Articles

MSSQLTips.com

Tools for development

rogrammatic interaction with SQL Server or Azure SQL from a Python script is possible using a driver. A popular driver has been pyodbc that can be used standalone or with a SQLAlchemy wrapper. SQLAlchemy on its own is the Python SQL toolkit and Object Relational Mapper for developers. In the end of 2025 Microsoft released v1 of their own Python SQL driver called mssql-python. How do you get started using mssql-python for programmatic access to your SQL Server?

2026-03-11

SQL Server Long-Running Query Detection: How to Find and Monitor Slow Queries

by Additional Articles

SimpleTalk

Performance and Tuning

Monitoring and alerting can be overwhelming tasks, especially for those new to the world of managing production data. One common challenge for any data professional is the identification and management of queries that run for longer than they should.

2026-03-09

How to Help Copilot Encourage Good Database Standards

by Additional Articles

Brent Ozar Blog

Uncategorized

I know a lot of y’all lag behind on upgrading SSMS, but v22.3 just introduced something that you need to be aware of. It’s going to impact any of your users who DO upgrade their SSMS, or who use Github Copilot. There’s something that you can do in order to improve Copilot’s code quality and make it match your preferred coding standards.

2026-03-06

Find Duplicate Rows in SQL Server with a CTE

by Additional Articles

MSSQLTips.com

T-SQL

This tip demonstrates how find and list allf duplicate rows in a dataset using a Common Table Expression (CTE).

2026-03-04

Python is good, but not perfect – here are 10 reasons to avoid it

by Additional Articles

SimpleTalk

Python

Four years ago I wrote a blog on this site explaining why Python is better than C# and, arguably, most other programming languages. To redress the balance, here are 10 reasons why you might want to avoid getting caught up in Python’s oh-so-tempting coils – particularly when building large, long-lived systems.

2026-03-02

SSMS 22 Offline Installation

by Additional Articles

MSSQLTips.com

Management Studio (SSMS)

Beginning with SQL Server Management Studio 21, Microsoft stopped providing the direct download package/binaries to install SSMS, instead it just downloads the SSMS installer. This installer then starts the installation of SSMS and downloads what is needed to install SSMS. Sometimes there may be a need to do an offline installation where you do not have access to the internet. In this article, we walk through the steps to do an offline install of SSMS.

2026-02-27

SQL Server 2025 CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS Commands Explained

by Additional Articles

SimpleTalk

Uncategorized

Now that SQL Server 2025 has finally been released to the public, I was finally able to test and learn a lot about this command (named CREATE EXTERNAL MODEL), and I want to share my knowledge with you here. If you’re new to the world of AI, don’t worry, we’ll start with the basics and evolve to where this command fits in!

2026-02-25

Microsoft Fabric and MQTT for Real-Time IoT Data Ingestion and Analytics

by Additional Articles

MSSQLTips.com

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

Microsoft Fabric is a unified platform for data integration, data engineering, real-time intelligence, and advanced analytics. Fabric is known for providing an integrated way of working with your data, connecting to many diverse types of sources and across the data landscape. How do we get started ingesting and analyzing real-time data streamed over the MQTT protocol?

2026-02-23

I Just Don’t Understand Why You Don’t Update SSMS.

by Additional Articles

Brent Ozar Blog

Uncategorized

A long time ago in a galaxy far, far away, SQL Server Management Studio was included as part of the SQL Server installer.

2026-02-20

Azure Functions: The Serverless Powerhouse

by Additional Articles

MSSQLTips.com

Azure

Today’s organization are faced with multiple conflicts for their current cloud infrastructures and which approach to go with either opting for a microservice or monolith applications. However, there are numerous difficulties with standard hosting methods.

2026-02-18

All authors

Additional Articles

Getting Started with mssql-python for Data Developers

SQL Server Long-Running Query Detection: How to Find and Monitor Slow Queries

How to Help Copilot Encourage Good Database Standards

Find Duplicate Rows in SQL Server with a CTE

Python is good, but not perfect – here are 10 reasons to avoid it

SSMS 22 Offline Installation

SQL Server 2025 CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS Commands Explained

Microsoft Fabric and MQTT for Real-Time IoT Data Ingestion and Analytics

I Just Don’t Understand Why You Don’t Update SSMS.

Azure Functions: The Serverless Powerhouse

Blogs

How Fabric Mirroring Transformed with SQL Server 2025

The DIY Cost of Masking Test Data For Smaller Organizations

T-SQL Tuesday #196 – Two risky career decisions I made

Forums

XACT_ABORT being set to ON by web services

OPENQUERY Flexibility

A Full Shutdown

Question of the Day

OPENQUERY Flexibility