(Chris Webb) A few months ago my esteemed colleague Patrick LeBlanc published a great video showing how you could use Power Automate (formerly known as Microsoft Flow) to send an email when a Power BI alert is triggered.

(Pinal Dave) My biggest pleasure for my job is meeting new people every day while doing a Comprehensive Database Performance Health Check. Recently, one of the clients asked me if I have a Script to Find All Columns with a Specific Name in Database.

(Gareth Newman) When you attempt to configure a SQL Server distributor or create a publication in SQL Server Replication, an issue you can come across, is that the SQL Server Replication feature it is not installed!

(Pinal Dave) In the past, I have written a few blogs where I explained a few issues about the failure of listener creation in the cluster. In this blog, we would see another cause of listener creation failure.

(Kenneth Fisher) This is one of those things that probably doesn’t happen all that often, but bit me in the … elbow … to the tune of ~10 hours recently.

(Pablo Echeverria) SQL Server on Linux only allows creating linked servers to another SQL Server, so what options do you have when you want to consume data from an Oracle database table inside a SQL Server query when working on Linux?

(Jason Brimhall) Working through some security modernization recently with a client I ran into a fun little nugget. What we were trying to accomplish was to make the service accounts being used more secure through the use of Managed Service Accounts.

(James Serra) With Power BI real-time streaming, you can stream data and update dashboards in real-time. Any visual or dashboard that can be created in Power BI can also be created to display and update real-time data and visuals.

(Pinal Dave) There are multiple ways by which we can take a backup of the SQL Server database. One of the methods used by 3rd party providers is using VSS (Volume Shadow Copy Service). One of my clients contacted me that 3rd party backup is failing.

(Grant Fritchey) Query tuning is not easy. In fact, for a lot of people, you shouldn’t even try. It’s much easier to buy more, bigger, better hardware. Yeah, the query is still slow on newer, faster hardware, but not as a slow as it was.