How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or any string that is part of the code?

Limits, Not Goals

by Grant Fritchey

SQLServerCentral

Uncategorized

I just saw one of "those" questions. You know the ones: 'We're hitting an error with a stored procedure. What is the maximum number of parameters you can have?" <sigh> Look, I get it. Breaking the land speed record is cool. Getting the most people into a phone booth (look it up), also cool. Fastest, […]

How Much Linux Do You Need?

by Steve Jones

SQLServerCentral

With SQL Server on Linux becoming more popular, Steve asks if you think you need to know much about that OS.

Implementing Vector Datatype with Azure SQL Server

by Utsav Verma

SQLServerCentral

This article shows how to insert data into a database, create embeddings, and then use this data to search the data with a natural language interface.

The End of Azure Data Studio

by Steve Jones

SQLServerCentral

Azure Data Studio is being retired.

Fun with PowerShell Asynchronous

by Additional Articles

SQLServerCentral

PowerShell

Imagine a candle that is lit and takes 1 hour to burn out. Now imagine one hundred candles. How many hours will it last? That depends. If they are lit simultaneously, it will take 1 hour. That is the basic idea of running in the background or asynchronously. Of course, the 100 candles can execute independently of one another, unlike if you try to run 100 processes on a computer with 2 cores. PowerShell has some ways to manage that, as PowerShell job – which we will see in this article – runspaces – needs to add programmable using .net.