Regular expressions (REGEX) let you adaptively investigate, employ, and authenticate text data. This makes it easy to search for simple or complex string patters. There is no direct way to do this in SQL Server, but in this article we look at some SQL functions you can create to emulate regex like functionality.
2025-03-28
The digital landscape is rapidly evolving, and the question has progressed from whether to adopt cloud technology to how to effectively use it to drive business growth and innovation. Having recognized the power of the cloud in terms of agility, scalability and innovation, organizations are turning their focus to how to get more from their investment. One such consideration is multi-cloud.
2025-03-26
Learn how dynamic SQL and sp_executeSQL can be used together from Python.
2025-03-24
3,682 reads
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
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,493 reads
The other day, my lovable coworker and frequent Simple Talk writer: Grant Fritchey, sent this post on X:
2025-03-21
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
Learn how you can integrate the SQL Server error logs into Crowdstrike for better analysis.
2025-03-17
1,195 reads
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
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,379 reads
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Comments posted to this topic are about the item The Power of Data and...
Comments posted to this topic are about the item What's the Date?
Comments posted to this topic are about the item Two New Shortcuts for Fabric...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers