(Pinal Dave) I have said this many time earlier at various forums and I can still say that – “with my current consulting work, I am learning at least one new thing every day.” This is one of the reason why I love my work!

(Simon Su) If you have encountered missing cached MSI/MSP issues during SQL server setup, you may have knew below article:

(Chris Webb) The Query Editor in Power BI/Excel Get&Transform/Power Query has a number of built-in ways to filter data in date columns relative to the current date, such as the “In the Previous” option.

(Jack Vamvas) Whether you’re troubleshooting sql server waiting tasks, sql server performance troubleshooting , optimization challenges, health check or just curious these links drill down into specifics of sql server waits

(Kenneth Fisher) TL;DR; SA, or if you are really paranoid then you can create a disabled SQL login with minimal permissions and use that.

(Manoj Pandey) Few days back I got this query from a developer who was trying to install SQL Server, it was not getting installed and was giving below error:

(Pinal Dave) Earlier I wrote a blog about DBA doing detective work. SQL SERVER – Why We have Audit Trace in DATA Folder? What are These Files?. Now today there is another similar situation where account is added automatically in SQL Server used by SharePoint.

(Jovan Popovic) IoT use cases commonly share some patterns in how they ingest, process, and store data. First, these systems need to ingest bursts of data from device sensors of various locales.

(Grant Fritchey) Query tuning ain’t easy.

(Michael J. Swart) So now for the nitty gritty. In my last post, Blue-Green Deployment, I talked about replacing old blue things with new green things as an alternative to altering things. But Blue-Green doesn’t work with databases, so I introduced the Blue-Aqua-Green method. This helps keep databas