If you’re a SQL Server DBA or developer looking to harness AI for your everyday scripting workflows, this article will walk you through building an AI-powered T-SQL assistant using Python and SQL Server.
2025-11-19
2025-11-17
3,169 reads
Learn how you can create a logging module in Python that can be used to insert real-time records in a PostgreSQL database and display them on a dashboard.
2025-11-12
1,443 reads
Multivariate analysis in data science is a type of analysis that tackles multiple input/predictor and output/predicted variables. This tip explores the problem of predicting air pollution measured in particulate matter (PM) concentration based on ambient temperature, humidity, and pressure using a Bayesian Model.
2025-09-19
This article looks at using the FP-Growth algorithm from Python to mine data in SQL Server.
2025-09-08
2,633 reads
Learn how to connect to a PostgreSQL database from Python with this popular library.
2025-09-02 (first published: 2025-08-25)
1,834 reads
Loading data into Snowflake is a common need. Using Python and pandas is a common go-to solution for data professionals
2025-04-21
Learn how dynamic SQL and sp_executeSQL can be used together from Python.
2025-03-24
3,446 reads
Learn how you can call stored procedures in the Django ORM, which lets you encapsulate more complex queries inside the database.
2025-03-14
1,318 reads
This tutorial will show how to use an AI model with Python to respond to queries.
2024-11-04
5,899 reads
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
By Steve Jones
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...
By alevyinroc
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...
Comments posted to this topic are about the item Personal Contact Is Vital
Comments posted to this topic are about the item Getting the Schema for Tables
Comments posted to this topic are about the item An Unexciting Exciting Release
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers