(Michael J. Swart) In 2015, Postgres added support for ON CONFLICT DO UPDATE to their INSERT statements. Their docs say that using this syntax guarantees an atomic INSERT or UPDATE outcome; one of those two outcomes is guaranteed, even under high concurrency.

(Pinal Dave) Recently, one of my clients reported a weird issue to me. They explained that when they right click on the database, and try to read its properties they were getting the following error message. Let us learn about error related to could not load file or assembly.

(Raymond Chen) A customer was looking for a way to determine programmatically how many threads are active in the CLR thread pool.

(Vikram Pendse) This article covers some common scenarios for designing Azure based applications and workloads where you can save costs by following best practices.

(Eli Leiba) You want a T-SQL tool that will check my SQL Server database for non-clustered indexes that are not being used and disable these indexes automatically. The tool will find all of these indexes and document them in an output T-SQL script with an “ALTER INDEX…ON…DISABLE;” statement for

(Pinal Dave) Received an email “Need your urgent help On Demand, our MSDB Database has grown too big and we need help to check our MSDB.” I have been an independent consultant for a while and one of the services I provide is “On Demand (50 minutes)” service.

(Aaron Nelson) You need to deploy a large number of reports to an instance of SQL Server Reporting Services (SSRS), be it a new install of SSRS or you just want to automate deploying updates of reports you have developed.

(Jason Thomas) Over the last couple of years, I have been actively involved in doing Power BI trainings for my clients. Because of that, I am always looking for new and easier ways to explain Power BI concepts to my attendees.

(Kenneth Fisher) It’s the second Tuesday of the month, and as I’m sure you remember that means it’s time for T-SQL Tuesday! This month we are hosted by Raul Gonzalez (b/t) and the topic is Lessons learned the hard way.

(Pinal Dave) The blog topic might seem controversial and doesn’t go well with definition of log shipping features. Read it again. The blog has an alternative way to set up something “similar” to log-shipping. If the database is in simple recovery model, then we can’t take transaction log backups and