Agoda started utilizing ChatGPT to optimize SQL stored procedures (SP) as part of their CI/CD process. After introducing the ...

I'm developing a SQL Server database management tool that focuses on database version control and schema synchronization. I'd like the language server to parse these files and expose symbol ...

This GitHub repository was created for the blog post "What is stored procedure?" in Medium, and this repository contains two tables named User and UserBankAccount. The structure of the tables are ...

SQL Server is one of the best products to come out of Microsoft, but not every professional knows how to use it effectively. For example, some might find it difficult to create a stored procedure but ...

Microsoft only just officially released SQL Server 2019 at its Ignite conference in Orlando, Fla., but it announced some key changes to licensing a little bit earlier. Don't worry -- they're all ...

Many times during SQL server development we need to search for a stored procedure containing a specific text. This helps in checking for dependencies for objects in stored procedures or sometimes we ...

In this blog we illustrate how to get the pagination data from SQL server stored procedure. To create a such type of a stored procedure, we need to send a minimum ...

Recently, there has been a lot of buzz about “No SQL” databases. In fact there are at least two conferences on the topic in 2009, one on each coast. Seemingly this buzz comes from people who are ...