Load Data into Snowflake Using Python with Pandas
Loading data into Snowflake is a common need. Using Python and pandas is a common go-to solution for data professionals
2025-04-21
Python
Dynamic T-SQL Script Parameterization Using Python
Learn how dynamic SQL and sp_executeSQL can be used together from Python.
2025-03-24
3,092 reads
Using SQL Server Stored Procedures with the Django ORM
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,137 reads
Your Personal ChatGPT Tutorial
This tutorial will show how to use an AI model with Python to respond to queries.
2024-11-04
5,814 reads
A Guide to SQL Security in Django
If you encounter Django in your environment, are you thinking about SQL Injection and security? If not, read this article and learn how to protect your data.
2024-11-01
1,005 reads
Leveraging SQL Transaction Control in Python Applications
Explore the fundamentals of Python's SQL transaction control, demonstrating how to control and enhance database operations for improved data integrity. The best practices and real-world examples for integrating strong transaction management in Python applications are covered in this article.
2024-10-28
1,537 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,337 reads
Data Prediction with SQL Server Machine Learning Services, Python, and Linear Regression
Lean how to implement linear regression in SQL Server by running Python code on your data in SQL Server using Machine Learning Services.
2024-08-19
3,093 reads
Exploring Generative Adversarial Networks (GANs) for Butterfly Image Generation
Exploring Generative Adversarial Networks (GANs) for Butterfly Image Generation to gain some understanding of how this class of Artificial Intelligence technologies work.
2024-07-15
30,827 reads
Ingest and Retrieve data from an ADX Cluster Using Python
Learn how to query data in Azure Data Explorer using Python.
2024-05-06
1,245 reads
Blogs
Terraform Commands
I realized I never created a post to show how to deploy Terraform from...
T-SQL Tuesday #189–AI and your Career
By Steve Jones
I’m late to the party this month. Taiob Ali has a great invite for...
TSQL Tuesday #189: How is AI changing our careers
This month’s TSQL Tuesday invite is from my good friend, long standing MVP and...
Forums
Building a Database Dashboard with SSRS
Comments posted to this topic are about the item Building a Database Dashboard with...
CDC job running for 17 days?
Good morning, I've noticed my CDC job running for 17 days. I've noticed it...
Database growth events for unidentified databases
We have recently upgraded from SQL Server 2016 to 2022 Standard Edition. Our nightly...
Question of the Day
Determining the Updated Columns
I am creating a trigger in SQL Server 2022 and want to detect a change in a table. Here is my table DDL:
CREATE TABLE CustomerLarge ( CustomerID INT NOT NULL IDENTITY(1,1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) , creditlimit INT , discount numeric(4,2) , lastorderdate DATETIME , lastorderamount NUMERIC(10,2) , lastordercontact VARCHAR(20) , created DATETIME , modified DATETIME , modifiedby VARCHAR(20) , statusid INT , active BIT , customersize INT , primarysalesid INT) GOIf I want to detect that the creditlimit was updated, what IF statements should I use? See possible answers