(Hannes du Preez) We can get all columns in all tables of a specific data type.

(Tim Smith) In this tip we’ll look at getting started using PowerShell with SQL Server stored procedures. We’ll look at getting data from stored procedures to files or PowerShell objects that we can use further. We’ll also look at passing in parameters to stored procedures that we may use in write o

(Bojan Petrovic) This article is the sequel in a series about SQL Server monitoring tools and common performance issues.

(Chris Webb) I’m one of those people who can’t resist peeking behind the scenes, and so when the Key Influencers visual appeared in Power BI I couldn’t help wondering how it worked its machine learning magic.

(blobeater) Quite a significant change has taken place within the Azure SQL Database space, more specifically the development of Azure SQL Database Serverless.

(Pinal Dave) During my consultancy engagement, my client’s DBA team was checked ERRORLOG and asked me the possible cause of below error about service broker.

(Kenneth Fisher) The first thing I want to do is say thank you to Michael Crump (b/t). He tweeted out this:

(Denny Cherry) Monitoring SQL Server Performance Monitor objects (Perf Mon for those in the know) can be an important part of monitoring your SQL Server instance.

(Greg Robidoux) Have you ever had the need to replace multiple words in a data column with a new word or a new phrase for an entire table? A good example would be to update a product catalog with new words either for standardization or just to reflect a new name for the product.

(Rajendra Gupta) In this article, we will review the new SQL TRIM function in SQL Server 2017 onwards as well as providing some information on strings functions that pre-date it like LTRIM AND RTRIM.