Louis Davidson discovers the joy of using SQL Prompt code snippets to remove repetition from a variety of tasks, from inserting comment headers, to creating tables, to executing useful metadata queries.
Artificial Intelligence systems might dramatically change our world, but they need lots of help and work to get better.
Phil Factor shows you how to prevent constraint violations from ‘breaking the build’, during SQL Compare deployments, by ferreting out any conflicting rows in advance, and developing a script to fix the data.
In this article Aaron Bertrand looks at how to use SQL Server Extended Events to monitor performance of checkpoints for databases not using indirect checkpoints.
This article explains the T-SQL function STRING_SPLIT() and demonstrates a creative use for it.
For a time, it seemed that everyone wanted to build a Hadoop system. The world has changed, and that's not as popular an idea as it used to be. Today, Steve has a few thoughts.
Microsoft has added a group of features called Intelligent Query Processing to SQL Server 2017 and 2019. In this article, Greg Larsen explains one of the features, Scalar UDF Inlining.
In the latest version of Data Masker for SQL Server, it’s now much easier to rapidly identify sensitive data that needs masking, set up appropriate rules, see which masking rules are applied to which column, and locate what sensitive data you've yet to mask.
We’ve also improved the performance of commonly used masking rules, which lets you run masking operations 3 times faster.
Amazon is providing automatic redaction of PII data in there transcription service.
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
SQL Server 2025 introduces native support for vector data types and external AI models....
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
hi everyone I am getting an error when I add a variable to a...
Comments posted to this topic are about the item How to Use SQL Server...
Comments posted to this topic are about the item Choosing an AI in Sept...
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers