(Bojan Petrovic) A SQL Join clause is put within a Select statement and at the end, it’s given a join condition, which tells the database how to fetch your data.

(Kenneth Fisher) A while back I wrote about how to find where your backups are. And I’ve also written about I use a solution in SSMS to hold a bunch of my scripts. I was using this again today (I use it a lot!) and thought I would bring it back up with some additional detail.

(Pinal Dave) The other day during Comprehensive Database Performance Health Check, I was asked if there is a way to store results of dynamic SQL into a variable. This is a very popular question and let us see the answer to this question in this blog post.

(Allan Hirt) A question came across my inbox this week which I decided to investigate: what happens if you have read only filegroups as part of your database, and you want to use Always On Availability Groups? Let’s find out.

(Itzik Ben-Gan) Karen Ly, a Jr. Fixed Income Analyst at RBC, gave me a T-SQL challenge that involves finding the closest match, as opposed to finding an exact match.

(Yujin Hong) Azure Event Hubs is a managed Data streaming and Event Ingestion platform, capable of processing millions of events per second.

(Daniel Farina) You work as a SQL Server Database Administrator at a company that is starting to use Linux as its platform to run SQL Server. You need to automatize some tasks which we covered in the previous tip. You know that you can set the MAILTO variable to send the execution results of Cron to

(Pinal Dave) One of the most popular questions I often receive is why do I like to do consultation – my answer is very simple – it gives me an opportunity to learn continuously learn new things from my clients. Here is a script which I have built during my recent Comprehensive Database Performance H

(Mohammed Moinudheen) We heard in the news about disruptions to Azure services in certain global locations. Recently, there was news reported regarding a cloud service outage in a Microsoft US data center location. Is it possible to get information about any Azure service issues that may be affectin

(Chris Webb) One of the most common issues faced when calling web services in M is that the the easiest way of doing so – creating a function that calls the web service, then calling the function once per row in a table using the Invoke Custom Function button – is very inefficient.