Build Chatbot with Large Language Model (LLM) and Azure SQL Database
In this article, we look at how to enable a large language model (LLM) to answer questions based on data stored in Azure SQL Database.
2024-06-28
In this article, we look at how to enable a large language model (LLM) to answer questions based on data stored in Azure SQL Database.
2024-06-28
In this new article, we examine how to work with OneLake storage.
2024-06-26
1,547 reads
Ola Hallengren’s free maintenance solution is widely used as a replacement for SQL Server maintenance plans. It’s a more powerful, flexible tool for backups, corruption checking, and index & statistics updates. If you’re using it for backups, there are two quick, easy changes that can dramatically reduce your nightly job runtimes.
2024-06-26
Learn how to effectively rename columns in SQL Server using our comprehensive guide. Explore the use of sp_rename, limitations, and best practices
2024-06-24
6,997 reads
XML is a common storage format for data, metadata, parameters, or other semi-structured data. Because of this, it often finds its way into SQL Server databases and needs to be managed alongside other data types.
2024-06-24
This article discusses how one person implemented Row Level Security in PostgreSQL to help with a data migration from a single tenant to a multi-tenant database structure.
2024-06-21
1,203 reads
What are the best days of the week and times of the day to post a question at StackOverflow.com?
2024-06-21
2024-06-19
3,229 reads
Learn about SQL Server error handling using TRY CATCH, RAISERROR, and THROW for stored procedures, triggers, and user-defined functions.
2024-06-19
2024-06-17
14,133 reads
The honeymoon is over, and macOS 26 Tahoe broke the Rosetta 2 emulation layer...
By Chris Yates
There are moments in technology when the ground shifts beneath our feet. Moments when...
Why Developers Shouldn’t Have sysadmin access in SQL Server 7 reasons—and exactly what to do instead It...
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Comments posted to this topic are about the item Find Invalid Objects in SQL...
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer @customername varchar(200) AS BEGIN DECLARE @added VARCHAR(100) SELECT @added = xxx IF @customername IS NOT NULL INSERT dbo.Customer ( CustomerName, AddedBy ) VALUES (@customername, @added) ENDSee possible answers