Dynamic T-SQL Script Parameterization Using Python
Learn how dynamic SQL and sp_executeSQL can be used together from Python.
2025-03-24
3,458 reads
Articles
SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG
I need to construct JSON from data in our database, but I find the existing FOR JSON PATH limited when the data is not located in one single row but rather scattered over multiple rows. Is there another method on how to handle JSON data in SQL Server? Learn how to use the new SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG in this article.
2025-03-24
Fabric Analytics for SQL folks: Part 1 - Fabric demystified
Unlock new opportunities for data-driven decision-making by grasping the significance of SQL and structured data in current data and analytics ecosystems like Microsoft Fabric.
2025-03-21
6,423 reads
Crazy number of Parameters… and a challenge
The other day, my lovable coworker and frequent Simple Talk writer: Grant Fritchey, sent this post on X:
2025-03-21
AI Tools for Job Seekers – Salary
In our conversations with job seekers, a consistent theme has been HOW do you use AI tools. This can be used to get new ideas, improve and optimize resumes, understand trends/market data, determine new connections and networking avenues, save time, alleviate headaches and roadblocks, and be more efficient and effective overall. Well, say goodbye to the days where you need to start a cover letter or resume from scratch or feel isolated, alone, and anxious during the resume writing, interview prep, salary negotiation, and other parts of the job search process, as we all now have an incredibly powerful job searching tool and career coach at our disposal to help with any writer’s block and almost every challenge you may run into!
2025-03-19
Pitfalls to avoid while feeding events into CrowdStrike
Learn how you can integrate the SQL Server error logs into Crowdstrike for better analysis.
2025-03-17
1,135 reads
AI in SQL Server 2025: Embeddings
One of the cornerstones of AI is a concept called embeddings. Virtually every AI model, whether for text, video, or audio, uses something related to embeddings. Starting with SQL Server 2025, this is a term you’ll be hearing a lot, as its potential for applications is enormous!
2025-03-17
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,330 reads
Data Streaming Databricks in Azure
The core functionality of Apache Spark has support for structured streaming using either a batch or a continuous method. The two most popular sources of input data are data lake files and Kafka events. Check point files in the data lake are used to keep track of what data has been processed to date.
2025-03-14
How I Achieved Scalability in a. Amazon RDS Shared DB Connection Environment
This article shows a solution to the challenge of multiple databases on one RDS instance with different databases and the limitation of 5000 connections.
2025-03-12
731 reads
Blogs
Getting SQL Server 2025 RTM Running in Containers on macOS
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
The PASS Data Community Summit 2025 Recap
By Steve Jones
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...
Microsoft Post-Quantum Crypto APIs Are Now Generally Available
By Brian Kelley
I mentioned this in my talk on Quantum Computing at the PASS Data Community...
Forums
Find all the tables in a database containing particular column value
Hi, I want to find all the tables name under a database where tables...
The Ending Substring
Comments posted to this topic are about the item The Ending Substring
Done is Better than Good
Comments posted to this topic are about the item Done is Better than Good,...
Question of the Day
The Ending Substring
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers