Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions
Learn about the new string similarity functions in Azure SQL Database.
2025-03-28
4,234 reads
Articles
Basic Regex Emulator for SQL Server
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
Improving the Performance of UPDATE Statements in SQL Server
Learn how to optimize UPDATE performance in SQL Server by examining three different methods of making large updates.
2025-03-26
5,437 reads
Beyond Single-Cloud: A Peek into Multi-Cloud
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
Dynamic T-SQL Script Parameterization Using Python
Learn how dynamic SQL and sp_executeSQL can be used together from Python.
2025-03-24
2,451 reads
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
5,583 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
Understanding SQL Server LEFT_SHIFT and RIGHT_SHIFT Functions
Learn how to use the LEFT_SHIFT and RIGHT_SHIFT bitwise functions in SQL Server 2022.
2025-03-19
4,296 reads
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
Blogs
Secret management using Pulumi ESC SDK and Azure Key Vault
This is a submission for the Pulumi Deploy and Document Challenge: Shhh, It’s a Secret!What...
The Book of Redgate–Being Reasonable
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
Azure Data Factory Pipeline Debugging Fails with BadRequest
I recently had a new pipeline fail. It was actually a copy of an...
Forums
The User Login
Comments posted to this topic are about the item The User Login
Using Feature Flags
Comments posted to this topic are about the item Using Feature Flags
Understanding UNION and UNION ALL in SQL Server
Comments posted to this topic are about the item Understanding UNION and UNION ALL...
Question of the Day
The User Login
When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?
See possible answers