DeepSeek: What is new with this AI technology?
Learn how the DeepSeek GenAI LLM works and see how it produces SQL code.
2025-03-31
Learn how the DeepSeek GenAI LLM works and see how it produces SQL code.
2025-03-31
Over the last several years, Microsoft has been putting less and less effort into Cumulative Update documentation. We used to get full-blown knowledge base articles about fixes, but these days, we get a collection of footnotes with deceiving hyperlinks that look like they’re going to lead to more information – but they simply lead back to themselves.
2025-03-31
Learn about the new string similarity functions in Azure SQL Database.
2025-03-28
3,515 reads
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
Learn how to optimize UPDATE performance in SQL Server by examining three different methods of making large updates.
2025-03-26
4,960 reads
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
2,216 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
5,385 reads
The other day, my lovable coworker and frequent Simple Talk writer: Grant Fritchey, sent this post on X:
2025-03-21
By Brian Kelley
Core skills depends on the position, but the point is that ensuring you have...
By Steve Jones
zverism – n. the wish that people could suspend their civility and indulge in...
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
Comments posted to this topic are about the item Is GenAI Coming Faster Than...
Comments posted to this topic are about the item Local Storage Options
Comments posted to this topic are about the item DeepSeek: What is new with...
I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?
See possible answers